EXCEL Practice Test: Video 4 Answers (24 Questions) — Questions and Answers

Question 1: Which function returns the number of cells in a range that meet a given condition?

COUNT
COUNTA
SUMIF
COUNTIF (Correct answer)

Correct answer: COUNTIF

COUNTIF counts cells within a range that satisfy a single specified criterion.

Question 2: How do you switch Workbook Views to Page Break Preview on the ribbon?

Data
View (Correct answer)
Review
Page Layout

Correct 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.

Question 3: What does VLOOKUP's fourth argument (range_lookup) do when set to FALSE?

Returns an approximate match
Searches from right to left
Returns an exact match only (Correct answer)
Ignores case sensitivity

Correct 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.

Question 4: What are the shortcut keys on the keyboard for inserting a table?

ALT + N + C
ALT + N + V
ALT + N + T (Correct answer)
ALT + N + R

Correct 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.

Question 5: What is the result of =MOD(17, 5)?

12
3.4
2 (Correct answer)
3

Correct answer: 2

MOD returns the remainder after division; 17 divided by 5 is 3 remainder 2.

Question 6: Which chart type is NOT available for a PivotChart?

Column
Line
Pie
XY Scatter (Correct answer)

Correct answer: XY Scatter

Scatter, bubble, and stock charts cannot be created as PivotCharts.

Question 7: You want to show only the five best-selling products on a PivotChart. Which filter should you apply to the Product field?

Value Filter > Top 10 set to 5 items (Correct answer)
Clear Filter
Label Filter > Begins With
Date Filter > This Year

Correct 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.

Question 8: What do the gray buttons displayed on a PivotChart allow you to do?

Print the chart
Filter, sort, and expand fields directly on the chart (Correct answer)
Convert the chart to an image
Change the chart's color theme

Correct answer: Filter, sort, and expand fields directly on the chart

Field buttons provide interactive filtering and sorting without touching the PivotTable.

Question 9: Which of the following is NOT one of the four field areas in the PivotTable Fields pane?

Filters
Headers (Correct answer)
Values
Rows

Correct answer: Headers

The four PivotTable field areas are Rows, Columns, Values, and Filters — Headers is not a PivotTable field area.

Question 10: In the PivotChart Fields pane, fields placed in the Axis (Categories) area correspond to which PivotTable area?

Values
Columns
Filters
Rows (Correct answer)

Correct answer: Rows

Axis categories map to Row fields in the underlying PivotTable.

Question 11: What does Freeze Panes do?

Prevents editing
Locks rows/columns visible while scrolling the rest (Correct answer)
Saves current view
Prevents deletion

Correct answer: Locks rows/columns visible while scrolling the rest

Freeze Panes keeps specified rows and columns visible while scrolling.

Question 12: How do you move a worksheet to another workbook?

Right-click tab > Move or Copy, select destination workbook (Correct answer)
Cannot move between workbooks
File > Export > Move Sheet
Drag tab to other window

Correct answer: Right-click tab > Move or Copy, select destination workbook

Right-click > Move or Copy lets you choose destination workbook and position.

Question 13: How do you link data between worksheets?

Requires VBA
Use LINK function
Type = then click cell on another sheet, creating =Sheet2!A1 (Correct answer)
Copy and paste values

Correct answer: Type = then click cell on another sheet, creating =Sheet2!A1

Reference another sheet's cell with =SheetName!CellAddress syntax.

Question 14: What is the maximum number of worksheets in a workbook?

65,536
Limited only by available memory (Correct answer)
1,000
255

Correct answer: Limited only by available memory

The number of worksheets is limited only by computer memory.

Question 15: A column contains full names like Smith, John. Which Text to Columns option best splits them into last and first name columns?

Fixed width
Fixed width with a break at position 5
Delimited with comma as the delimiter (Correct answer)
Delimited with tab as the delimiter

Correct answer: Delimited with comma as the delimiter

The comma consistently separates the two parts, making a delimited split ideal.

Question 16: Which Data tab command removes rows that are exact duplicates based on selected columns?

Subtotal
Group
Remove Duplicates (Correct answer)
Consolidate

Correct answer: Remove Duplicates

Remove Duplicates deletes repeated rows using the columns you check.

Question 17: Which formula converts the text in A1 to have only the first letter of each word capitalized?

=CAPITAL(A1)
=PROPER(A1) (Correct answer)
=LOWER(A1)
=UPPER(A1)

Correct answer: =PROPER(A1)

PROPER capitalizes the first letter of each word and lowercases the rest.

Question 18: Which Excel feature automatically fills a column by detecting a pattern from examples you type, such as extracting first names?

Data Validation
Goal Seek
Flash Fill (Correct answer)
AutoSum

Correct answer: Flash Fill

Flash Fill recognizes patterns and completes the column with Ctrl+E.

Question 19: On which Excel ribbon tab is the Text to Columns command located?

View
Data (Correct answer)
Review
Home

Correct answer: Data

Text to Columns sits in the Data Tools group of the Data tab.

Question 20: How do you name a range of cells?

Right-click > Name Range
Select range, type name in Name Box, press Enter (Correct answer)
Names assigned automatically
Home tab Name button

Correct 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.

Question 21: How does Remove Duplicates work?

Counts duplicates
Moves duplicates to new sheet
Permanently deletes duplicate rows, keeping first occurrence (Correct answer)
Highlights duplicates

Correct answer: Permanently deletes duplicate rows, keeping first occurrence

Remove Duplicates permanently deletes rows with duplicate values in selected columns.

Question 22: What is Group and Outline used for?

Creating named ranges
Grouping cells for formatting
Collapsing and expanding sections of rows or columns (Correct answer)
Creating chart groups

Correct answer: Collapsing and expanding sections of rows or columns

Creates collapsible sections with +/- buttons for hiding or showing detail data.

Question 23: Which of the following is an invalid character for use within a named range in Excel?

Period (.)
Underscore (_)
Space ( ) (Correct answer)
Backslash (\)

Correct answer: Space ( )

Named ranges in Excel cannot contain spaces. While underscores, periods, and backslashes are permissible as part of a name, spaces will result in an error when trying to create the named range.

Question 24: What does the Transpose paste option do?

Switches rows and columns (Correct answer)
Translates data
Reverses data order
Converts text to numbers

Correct answer: Switches rows and columns

Transpose switches orientation — rows become columns and vice versa.

EXCEL Practice Test: Video 4 Answers (24 Questions)

Which function returns the number of cells in a range that meet a given condition?

What Practice Test Geeks adds beyond an AI chat for Excel

An AI chatbot can quiz you, but it can't reproduce the exam conditions or keep your record. Here you get:

A timed, full-length Excel mock exam — 35 questions in 50 minutes with a 70% pass mark, modeled on the official exam's question count and time limit, followed by a score report broken down by exam domain.
A fixed Excel question bank: the same test every attempt, so your score is comparable from one try to the next instead of changing with every regenerated quiz.
Progress saved on your device: completed tests, scores and missed questions stay in My Progress, so you can retake only what you got wrong.
A printable Excel cheat sheet you can print or save as a PDF.
Excel flashcards built from the same question bank.

Start the Timed Excel Mock Exam →

These practice questions were written with AI tools. They are not real exam questions. Exam facts are checked against the official sources listed below. Not reviewed by a subject-matter expert. 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

learn.microsoft.com — Retake policy, test delivery, time limit, eligibility · verified Oct 2026
certiport.pearsonvue.com — Exam format, score validity, passing score, score release, exam information · verified Oct 2026