Excel Certification Practice Exam

These questions are part of the practice quiz. Start practicing

• How can you calculate the total sum of a column in Excel?
• How do you quickly fill a series of dates in a column?
• What does data validation do in Excel?
• How can you display the formulas used in cells instead of the results?
• To sum using destination cells in Excel, what is the correct first step?
• How can you quickly fill the cells below with the same value?
• When reviewing comments, which command would you use to add a new comment?
• Which key combination is useful for quickly summing cells in Excel?
• What function would you use to count the number of cells that contain numbers?
• Which of the following actions will allow you to display a list of all sheets in an Excel workbook?
• What feature allows you to quickly find data in a worksheet?
• What does the IF function do?
• What Excel tool helps in creating a budget or financial plan?
• What feature allows you to snap objects to a grid in Excel?
• What does the SUM function do in Excel?
• How can you remove a filter from a dataset?
• What does the VLOOKUP function do in Excel?
• What is the method to create an exploding pie chart in Excel?
• How do you protect a worksheet from editing?
• How can you create a chart from a data range?
• Which option in Excel is used to alter the scaling of a page for printing?
• In which menu can you specify column formats when importing data?
• What is the difference between relative and absolute cell references?
• What does the REPLACE function do in Excel?
• What is the purpose of the AVERAGEIF function?
• Which process is used to create different charts in Excel?
• Which of the following functions returns the median of a given range in Excel?
• What is the function of the Print Titles feature in Excel?
• To create a chart from selected data, which Excel tab should you use?
• What does creating a backup copy of data entail in Excel?
• What is the function of the 'Name Box' in Excel?
• What does a cell reference like B2 mean?
• What does the AND function return in Excel?
• What does the CountIF function do in Excel?
• What keyboard shortcut can be used to insert a column between existing columns?
• What does the PMT function calculate?
• What does the IF function help you to do in Excel?
• What is the first step to move a chart to a new sheet in Excel?
• What does the DATEDIF function calculate in Excel?
• What is the primary purpose of the HLOOKUP function in Excel?
• Which Excel feature allows you to filter results in a total row?
• How can you create a primary key in Excel?
• How do you create a combination chart in Excel?
• What is the effect of using the PROPER function in Excel?
• What should be done before writing a nested IF function?
• What menu option allows you to convert a table back to a cell range?
• What is the default file extension for an Excel workbook?
• What is the default file format for saving files in Excel 2019?
• How can you find the maximum value in a range of cells?
• In Excel, how can you format a cell to display currency?
• To create a total row in an Excel table, what action should you take?
• What does the CONCATENATE function do in Excel?
• What is a pivot table used for in Excel?
• How can you quickly insert an image within an Excel worksheet?
• What is the purpose of the COUNT function in Excel?
• What function would you use to calculate the sum of numbers in a range?
• How can you quickly navigate to the last cell with data in a column?
• What does the MODE.MULT function do in Excel?
• What type of value does the VLOOKUP function return?
• What function would you use to find the maximum value in a range?
• In Excel, what does the term "cell reference" refer to?
• What is the purpose of the FILTER function in Excel?
• How do you add a cell reference in a formula?
• In which tab can you find the 'Sort and Filter' option?
• Which menu option should you select to change page margins in Excel?
• How do you use a defined name in a formula?
• What is the correct process to export a worksheet to PDF?
• What is the output when the AND function is tested with one true and one false?
• Which of the following actions can you perform using Excel's AutoSum feature?
• What is the shortcut for copying selected cells?
• How can you remove duplicate entries from a selected table in Excel?
• Which function can you use to find the minimum value in a range?
• What is the correct syntax for using the AVERAGE function?
• Which function would you use to calculate the average of a range of numbers?
• How do you change the format of a number to currency format?
• Which option allows you to remove all document properties from a worksheet?
• To sort data in ascending order based on a specific column, what is the correct method?
• What is the main benefit of using named ranges in Excel?
• What command path leads to adjusting the column width in Excel?
• How can you manually adjust the height of a row in Excel?
• Which function would you use to count only the cells that meet a specific condition?
• How do you sort data in Excel?
• How does the SUMIF function operate in Excel?
• How do you create a dropdown list in Excel?
• How do you apply conditional formatting in Excel?
• What feature would you use to quickly analyze data trends in Excel?
• What does the LEN function return?
• How can you link data from one worksheet to another?
• How can you inspect a worksheet for personal information?
• In which type of cell referencing is either the row or the column an absolute reference?
• If you want to find the maximum value in a set of cells, which function would you use?
• How can you apply conditional formatting in Excel?
• How can you change the width of a column?
• Which Excel feature allows you to automatically fill cells with a series of values?
• What must you ensure before inserting subtotals in a data set?
• How do you merge cells in Excel?
• Which of the following is correct regarding the SUMIF function?
• What tool would you use to create a visual representation of data in Excel?
• What does the VLOOKUP function do in Excel?
• Which function can you use to lookup a value in a vertical range?
• To format cell borders in Excel, which tab do you need to access?
• What can advanced filters in a data table help achieve?
• What is the purpose of the PMT function in Excel?
• How can you wrap text in a cell in Excel?
• How do you display the current time in a cell?
• What is the purpose of changing a chart to 3D in Excel?
• Which chart type is suitable for showing trends over time?
• Which function would you use to determine how many cells contain numbers in Excel?
• Which operation allows you to find the maximum value in a range?
• Which Excel function is used to count the number of cells that meet a specific condition?
• What is the shortcut for opening the 'Format Cells' dialog box?
• What is the function of the Format Painter in Excel?
• How do you insert slicers in a data table in Excel?
• What is the primary use of the AVERAGE function in Excel?
• Which command can be used to check a worksheet for compatibility?
• How can you secure a worksheet from being edited?
• What is one method to create advanced filters in a data table?
• What Excel feature helps you analyze data trends over time?
• What can you use to highlight important information in your Excel worksheet?
• What is the purpose of the LEFT function in Excel?
• What type of cell referencing changes automatically when the formula is moved to a different location?
• Which function returns the current date in Excel?
• What is the primary function of the LOWER function in Excel?
• Which formula would you use to calculate the average of a range of cells?
• Which option should be selected to insert sparklines in an Excel worksheet?
• What keys can be used to stop a process after initiating the Format Painter?
• What does the CONCATENATE function do?
• Which type of chart is best used to display proportions of a whole?
• Which feature allows you to see the effects of changing one or more variable inputs on the result of a formula in Excel?
• Which option would you use to remove duplicates from a dataset?
• What is the keyboard shortcut for saving a workbook in Excel?
• What does the VLOOKUP function do?
• What will the COUNTIF function do?
• To apply text wrapping to a cell, you need to access which menu?
• What does the UPPER function do in Excel?
• Which function would you use to summarize a range of data by its most frequently occurring value?
• How can you adjust page breaks in Excel?
• What is the result of using the MIN function on a set of cells?
• What is the purpose of the DISTINCT function in Excel?
• How do you obtain the current date and time in Excel?
• To utilize the CountIF function, which argument must be specified?
• What is the first step to import external data into an Excel file?
• What feature in Excel allows you to highlight specific cells based on conditions?
• Which type of cell reference will NOT change when the formula is moved to a different cell?
• What steps are necessary to change series names in an Excel chart?
• Which function would you use to count all non-empty cells in a range?
• What does the VLOOKUP function do?
• What is the keyboard shortcut to undo an action in Excel?
• How can you freeze panes in an Excel worksheet?
• What function would you use to round a number to a specified number of digits?
• Which function do you use to find the number of items in a list, including blank cells?
• What is the first step to create an outline in Excel?
• How do you find the standard deviation of a set of values in Excel?
• What does the ABS function return in Excel?
• What is the shortcut for saving a workbook?
• When applying Conditional Formatting, what is the purpose of "icon sets"?
• How can you quickly insert the current date into a cell in Excel?
• What is the function of the CONCAT function in Excel?
• Which function is used to find the average of a series of numbers?
• How can you highlight cells that contain errors in Excel?
• How do you convert text that is in uppercase to lowercase in Excel?
• What is the main function of a slicer in Excel data tables?
• What is the first step to insert data bars using conditional formatting?
• What is the first step to sum using source cells in Excel?
• What feature can be used to center text across a selection of cells?
• Which function is commonly used for financial calculations, such as loan payments?
• What does the CONCATENATE function do in Excel?
• Which function would you use to find the maximum value in a range of cells?
• How can you apply a table style to a range of cells in Excel?
• How do you create a new worksheet in Excel?
• How do you display a formula result as a percentage?
• What is the purpose of the Excel 'Data Table' feature?
• Which function looks for a specific character within a text string?
• How can you apply a custom filter to a dataset?
• Which function would you use to calculate the average of a dataset?
• How can you insert an object into a chart in Excel?
• Which Excel option allows you to arrange and align images?
• What does the TRIM function do in Excel?
• What is the function of the IF statement in Excel?
• What is the purpose of the 'Watch Window' in Excel?
• What does the INT function do in Excel?
• Which function would you use to find the smallest number in a set of values in Excel?
• How do you insert a comment in a cell?
• How do you select a specific chart type from Excel's chart options?
• What is a key step in writing a nested IF function?
• How can you freeze the top row of your spreadsheet?