Excel Essential Training Practice Test

These questions are part of the practice quiz. Start practicing

• What is the function of the REPLACE function?
• What is the purpose of the VLOOKUP function?
• When entering times in Excel, which symbol is recommended to separate hours and minutes?
• How can you save a workbook as a PDF in Excel?
• What tool in Excel helps to evaluate and summarize data efficiently?
• What is the Fill Handle in Excel?
• Which Excel feature allows you to check the spelling in your worksheet?
• How do most users commonly view Excel?
• Which option allows you to create a pivot table?
• Which option allows you to add a comment to a cell in Excel?
• How can you protect a worksheet in Excel?
• Which feature is a command line above the worksheet for entering data?
• If you click Switch Row/Column in a bar chart, what will occur?
• What is the keyboard shortcut to open the Help box in Excel?
• How can a pivot table recognize changes made to its source data?
• What action can display the contents of combined rows in a table view?
• How can you efficiently test layout adjustments before printing?
• What should you do if you find that an old worksheet is missing some information needed for your current work?
• What function would you use to find the maximum value in a numeric dataset in Excel?
• What is the first step in creating a chart in Excel Office 365?
• What is a worksheet in Excel?
• Which of the following keyboard shortcuts will save a file?
• In Excel, which format can be used to display dates?
• How can you create a dynamic summary of your data in Excel?
• What is conditional formatting in Excel?
• How do you use the MATCH function in Excel?
• What does the CHAR function do?
• How do you convert text to a number in Excel?
• What distinguishes a workbook from a worksheet in Excel?
• What is the keyboard shortcut for the Redo command?
• After making changes to a worksheet, what should you do to ensure all users can access updated information?
• If you want to subtract costs in D6 from selling price in D5, which formula should you use?
• How can you remove a split in a worksheet other than clicking the Split button?
• What indicates that a workbook is saved successfully in Excel?
• When should you use the "Sort" feature in Excel?
• What defines a toggle button in Excel?
• How do you freeze panes in Excel?
• What must you do before sorting a worksheet if some data should remain unchanged?
• What is a pivot table used for in Excel?
• What distinguishes a bar chart from a column chart in Excel?
• How do you determine the average of a set of numbers in Excel?
• What is the purpose of using comments in an Excel worksheet?
• How can you add comments to a cell in Excel?
• Which keyboard shortcut is used to save a workbook in Excel?
• Which action cannot be undone using the Undo command in Excel?
• How do you insert a hyperlink in a cell in Excel?
• How can you apply conditional formatting to a range of cells?
• What does the SUMIF function do?
• What is the best method for generating a report of full-time employees earning over $45,000 using Excel's filter function?
• Which of the following functions can concatenate text in Excel?
• What does the COUNTIF function do?
• What happens to a new worksheet when you add it to an existing workbook with specific formatting?
• What does the function =SUMPRODUCT() do?
• Which keyboard shortcut is used to copy selected data and move it to a new location on a worksheet?
• How can you quickly sum a range of cells in Excel?
• What is the keyboard shortcut for inserting the current date in a cell?
• How can you apply a filter to a dataset in Excel?
• What does the function =RAND() do in Excel?
• What is the keyboard shortcut to undo the previous action in Excel?
• Which feature allows you to group and summarize data in Excel?
• Why might you want to set up a workbook as shared if you are the only user?
• When creating a chart, what type of data is typically excluded?
• The Autosum function typically looks in which direction?
• What is the best chart type to emphasize an upward sales trend?
• What is the purpose of the ROUND function in Excel?
• What does it mean when a number cell shows as ###?
• Which symbol does the autosum formula use?
• What function would you use to find the average of a set of numbers?
• Which dialog would help set specific cell formats such as date or currency?
• What is the reason for the alignment difference between the work order/status columns and the cost column?
• What is the outcome of using the SUM function?
• How do you create a new sheet in an Excel workbook?
• Which keyboard shortcut would you use to save an Excel workbook?
• In a Pivot Table, which field would you find in the Fields list?
• When you copy a formula from cell C8 to D8, what change occurs?
• Where can you access the Format Cells dialog box?
• What does the PMT function calculate in Excel?
• How can you quickly enter all 12 months in columns for Sales data?
• Which of the following is NOT a valid format for entering time in Excel?
• What is the easiest method to sort an employee list in Excel without affecting the associated data?
• What keyboard shortcut is used to initiate printing in Excel?
• What is the maximum number of rows in an Excel worksheet (Excel 2016 and later)?
• Which cell was selected when the split feature was activated in the worksheet?
• What is the difference between relative and absolute cell references?
• When sharing workbooks in Excel, which statement is true?
• What happens when you use the "Undo" function in Excel?
• What is the small black square in the lower right corner of a selected cell called?
• What does a circular reference mean in Excel?
• How do you access the “Sort” feature in Excel?
• Which feature is used to ensure data entry consistency across a worksheet?
• Which of the following best describes what a pivot table does in Excel?
• What type of chart is most suitable for representing data over a timeframe?
• Which of the following Excel functions will summarize data to show averages, sums, or counts?
• What is the fastest way to move the ID column in front of the Employee column?
• What is the purpose of the COUNT function?
• In Excel, what is the shortcut for copying selected cells?
• How can you add a border around a set of cells?
• Which option should you use to save your workbook with a different name?
• To view and unhide all hidden columns in a worksheet, what is the best method?
• How can you freeze both column A and the header row in a worksheet for better data viewing?
• What is the purpose of using the FILTER function?
• Which option allows you to format cells in a specific way quickly?
• How do you create a chart from a range of data in Excel?
• In Excel, what is a recommended practice for ensuring data consistency for dates entered in a spreadsheet?
• Which of the following is a valid way to insert a new row in an Excel worksheet?
• What is the purpose of the HLOOKUP function?
• Which function would you use to find the total of a range in Excel?
• When is it appropriate to use Excel for a specific task?
• What is the purpose of the TEXT function?
• What function can be used to quickly summarize a range of numbers?
• What does the function =TODAY() return in Excel?
• If you want to learn about the average function in Excel, how can you access training?
• What does the term 'cell reference' mean in Excel?
• How can you capitalize all instances of "IT" in your worksheet efficiently?
• Which function is used to reconcile information from multiple lists to a single list?
• How can you quickly format a cell as currency in Excel?
• What does the CONCATENATE function do?
• What keyboard shortcut can be used to create a table in Excel?
• Which feature would you use to visually represent your data in a chart format in Excel?
• What will Excel do if you enter the date 6/31/2019?
• If you accidentally delete a sheet that you wanted to keep, what should you do?
• What is a dynamic chart in Excel?
• What feature in Excel allows you to quickly make changes to your cells without navigating through various menus?
• How can you add frequently used buttons to the Quick Access Toolbar in Excel?
• What is the result of using the SUM function on a range of empty cells?
• What happens if you don’t adjust column widths when data exceeds cell limits?
• How do you create a drop-down list in Excel?
• How do you insert a footer in an Excel worksheet?
• To quickly copy a format from one cell to another, which feature should you use?
• Which keyboard shortcut takes you to the bottom of a column in Excel?
• What feature in Excel automatically identifies and adds ranges of cells?
• How can you access Excel's Help feature quickly?
• How can you allow editing only in column B while protecting other cells in a worksheet?
• What is the best practice for entering dates in Excel?
• What does the LEFT function do in Excel?
• What is the shortcut to open the 'Format Cells' dialog in Excel?
• To change the color of a cell's border in Excel, what feature would be used?
• What is the primary purpose of using the "Filter" feature in Excel?
• What keyboard shortcut can be used to create a new workbook in Excel?
• How can you group rows in Excel?
• What is the primary use of the CONCATENATE function?
• What is the primary function of the Filter option in Excel?
• In Excel, what does it mean to freeze panes?
• What does it mean when the right mouse button is described as "context-sensitive" in Excel?
• Which function would you use to find the average of a range of cells?
• What function would you use for finding the maximum value in a range?
• Which keyboard shortcut is used to select all data in a worksheet?
• What is the name of the bar located at the bottom of an Excel worksheet that displays page layout options?
• How can you check spelling in Excel?
• What is an example of a function that can perform calculations in Excel?
• Which Excel tool allows you to quickly format a cell with commonly used features?
• What is the quickest method to adjust column widths to fit data?
• What is the primary function of the VLOOKUP function in Excel?
• How do you create a scatter plot in Excel?
• Which of the following actions can the CTRL + Z shortcut perform?
• Which function would be most appropriate for counting the number of cells that contain numbers?
• What shortcut key combination can be used to quickly copy data in Excel?
• What does the COUNTA function do in Excel?
• What command would you use to reverse the last action taken in Excel?
• What is the result of using the Fill Handle feature?
• Which feature can only be accessed from the Format Cells dialog box?
• What does the IF function do in Excel?
• To freeze the top two rows and the first three columns, which cell should you select before using Freeze Panes?
• To create an embedded chart of the data in the current range, which keyboard shortcut should be used?
• When using AutoSum on a row of values, where should the cursor be positioned?
• How can you duplicate a worksheet within the same workbook?
• In Excel, how can you quickly compare two different values in adjacent cells?
• What is the purpose of using cell references in formulas?
• What is a recommended guideline for using color backgrounds in a worksheet?
• How do you change the orientation of a page to landscape in Excel?
• What is one function of the Quick Access Toolbar in Excel?
• Which feature would you use to quickly access different ways to present your data visually?
• How do you adjust the width of a column in Excel?
• How can you ensure that your formatting remains the same across multiple worksheets?
• What does the IF function do in Excel?
• What does the INDEX function do in Excel?
• What action must be taken before filtering a large worksheet by specific data, like sales from January?
• What tool is utilized in Excel to create a summary table?
• What feature would you use to change the layout of your data in Excel?
• What is the keyboard shortcut to quickly move to the end of a row?
• In Excel, what does selecting 'Insert' and then 'Chart' allow you to do?
• What primary function does the Excel Ideas feature serve?
• Where can you find the Track Changes feature in Microsoft Excel Office 365?
• In Excel, which feature is best for adding data from different lists to create a consolidated view?
• Which of the following options can be used to apply a filter in Excel?
• What shortcut can be used to rename a worksheet in Excel?
• When using the Find tool, what options should you check to ensure correct searches?
• What is a named range used for in Excel?
• What must you do to be able to track changes in a workbook?
• What tool would you use to find a specific badge number in a worksheet?
• What keyboard shortcut takes you to the upper left corner of a worksheet?
• Why would you need to use the Save as type pull-down menu when saving your file?
• How can you hide a row in Excel?
• How can you sort a table of data in Excel?
• What is the simplest way to view how a worksheet will print?
• How can you insert a function in a cell?
• Excel equations that perform various calculations and manipulations are known as?
• How can you find out more about the functionality of a ribbon button in Excel?
• How can you remove duplicates from a dataset in Excel?
• What function evaluates multiple conditions in Excel?
• In Excel, what feature allows you to view multiple sheets in a single workbook at the same time?
• Which approach will allow you to quickly check the layout and print settings of your worksheet?
• What should you do if you are uncertain how a page will print, even after previewing?
• What is a slicer in Excel?
• What key allows you to quickly refresh a pivot table?
• What does the 'Best Fit' function do in Excel?
• Which two keys are commonly used to move or insert data in Excel?
• How do you add a border around a cell in Excel?
• Which action allows you to edit locked cells in a protected worksheet?
• How can you create a macro in Excel?
• To edit multiple sheets at the same time in Excel, what must you do first?
• When using data validation in Excel, what is the purpose of creating rules?
• What could be the reason a pivot table does not reflect updated sales data in an Excel workbook?
• What feature allows users to see different views of their data simultaneously in Excel?
• Which function can be used in Excel to quickly insert the current date into a cell?
• How can you find and replace text in an Excel worksheet?