EXCEL Practice Test: Video 4 Answers (24 Questions) Flashcards
24 cards from real Microsoft Excel practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 20 EXCEL Practice Test: Video 4 Answers (24 Questions) flashcards as text
Which function returns the number of cells in a range that meet a given condition?
Answer: COUNTIF
COUNTIF counts cells within a range that satisfy a single specified criterion.
How do you switch Workbook Views to Page Break Preview on the ribbon?
Answer: View
The 'Page Break Preview' option, along with other workbook views like Normal and Page Layout, is located under the 'View' tab on the Excel ribbon. This view is essential for preparing worksheets for printing, as it visually displays where page breaks will occur and allows for easy adjustment.
What does VLOOKUP's fourth argument (range_lookup) do when set to FALSE?
Answer: Returns an exact match only
Setting range_lookup to FALSE forces VLOOKUP to find an exact match and return #N/A if none exists.
What are the shortcut keys on the keyboard for inserting a table?
Answer: ALT + N + T
The shortcut keys ALT + N + T are used to insert a table in Excel. ALT activates the ribbon, N goes to the Insert tab, and T specifically selects 'Table'. Excel tables provide enhanced functionality for data management, including automatic filtering, structured references, and easy formatting.
What is the result of =MOD(17, 5)?
Answer: 2
MOD returns the remainder after division; 17 divided by 5 is 3 remainder 2.
Which chart type is NOT available for a PivotChart?
Answer: XY Scatter
Scatter, bubble, and stock charts cannot be created as PivotCharts.
You want to show only the five best-selling products on a PivotChart. Which filter should you apply to the Product field?
Answer: Value Filter > Top 10 set to 5 items
Top 10 value filters can be adjusted to any number of items by sum of a value field.
What do the gray buttons displayed on a PivotChart allow you to do?
Answer: Filter, sort, and expand fields directly on the chart
Field buttons provide interactive filtering and sorting without touching the PivotTable.
Which of the following is NOT one of the four field areas in the PivotTable Fields pane?
Answer: Headers
The four PivotTable field areas are Rows, Columns, Values, and Filters — Headers is not a PivotTable field area.
In the PivotChart Fields pane, fields placed in the Axis (Categories) area correspond to which PivotTable area?
Answer: Rows
Axis categories map to Row fields in the underlying PivotTable.
What does Freeze Panes do?
Answer: Locks rows/columns visible while scrolling the rest
Freeze Panes keeps specified rows and columns visible while scrolling.
How do you move a worksheet to another workbook?
Answer: Right-click tab > Move or Copy, select destination workbook
Right-click > Move or Copy lets you choose destination workbook and position.
How do you link data between worksheets?
Answer: Type = then click cell on another sheet, creating =Sheet2!A1
Reference another sheet's cell with =SheetName!CellAddress syntax.
What is the maximum number of worksheets in a workbook?
Answer: Limited only by available memory
The number of worksheets is limited only by computer memory.
A column contains full names like Smith, John. Which Text to Columns option best splits them into last and first name columns?
Answer: Delimited with comma as the delimiter
The comma consistently separates the two parts, making a delimited split ideal.
Which Data tab command removes rows that are exact duplicates based on selected columns?
Answer: Remove Duplicates
Remove Duplicates deletes repeated rows using the columns you check.
Which formula converts the text in A1 to have only the first letter of each word capitalized?
Answer: =PROPER(A1)
PROPER capitalizes the first letter of each word and lowercases the rest.
Which Excel feature automatically fills a column by detecting a pattern from examples you type, such as extracting first names?
Answer: Flash Fill
Flash Fill recognizes patterns and completes the column with Ctrl+E.
On which Excel ribbon tab is the Text to Columns command located?
Answer: Data
Text to Columns sits in the Data Tools group of the Data tab.
How do you name a range of cells?
Answer: Select range, type name in Name Box, press Enter
Select cells, click the Name Box (left of formula bar), type the name, press Enter.
Written and edited by Nathan Beja, founder of Practice Test Geeks, with AI assistance. Exam facts are checked against the official sources linked below. Editorial policy
Sources & references
Exam facts on this page (fees, format, dates, passing scores) are checked against these official sources; the date is our last check. Editorial policy
- store.certiport.com — Fees, retake fee · verified Nov 2026
- certiport.pearsonvue.com — Renewal, score validity, score release, exam format · verified Nov 2026
- learn.microsoft.com — Test delivery, time limit, eligibility · verified Nov 2026