Browse all practice questions for the Excel Essential Training Practice Test. Search by topic, open any question and review its full explanation, then test yourself in the practice quiz.

Excel Essential Training Practice Test course image
More practice questions

These questions are part of the practice quiz. Start practicing

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

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy