EXCEL Practice Test: Video 3 Answers (23 Questions) — Questions and Answers

Question 1: Which Excel chart type is best suited for showing the proportion of parts to a whole?

Line chart
Pie chart (Correct answer)
Bar chart
Scatter chart

Correct answer: Pie chart

A pie chart displays each category as a slice of the whole circle, making part-to-whole relationships immediately visible.

Question 2: What are the AutoSum shortcut keys?

CTRL and =
ALT and = (Correct answer)
CTRL and S
ALT and S

Correct answer: ALT and =

The keyboard shortcut ALT + = is the quickest way to activate Excel's AutoSum feature. When you select an empty cell adjacent to a range of numbers and press this combination, Excel automatically detects the contiguous numbers and inserts the `SUM` function with the correct range, significantly speeding up data aggregation.

Question 3: What is the purpose of the Name Manager in Excel?

To manage worksheet tab names
To rename files in the current folder
To organize chart titles
To create, edit, and manage named ranges and defined names (Correct answer)

Correct answer: To create, edit, and manage named ranges and defined names

The Name Manager (Ctrl+F3) provides a central location to create, edit, delete, and manage all named ranges and defined names in a workbook.

Question 4: In a PivotTable, which area determines what values are calculated and displayed in the data cells?

Filters area
Values area (Correct answer)
Rows area
Columns area

Correct answer: Values area

The Values area contains the fields that are summarized (summed, averaged, counted, etc.) and shown in the body of the PivotTable.

Question 5: What does the CONCATENATE function (or & operator) do in Excel?

Converts numbers to text
Counts characters in a cell
Joins two or more text strings into one (Correct answer)
Adds numbers together

Correct answer: Joins two or more text strings into one

CONCATENATE (or &) combines multiple text values into a single string.

Question 6: Which tab in Excel's ribbon is used to insert a PivotTable?

Formulas
Data
Insert (Correct answer)
Home

Correct answer: Insert

PivotTables are inserted from the Insert tab by clicking the PivotTable button in the Tables group.

Question 7: New records were added to the source table of a PivotChart, but the chart has not changed. What should you do?

Create a new PivotChart
Click Refresh on the PivotChart Analyze tab (Correct answer)
Change the chart type
Reapply the chart style

Correct answer: Click Refresh on the PivotChart Analyze tab

PivotCharts do not update until the PivotTable cache is refreshed.

Question 8: What default summary function does the Values area use for numeric fields in a PivotTable?

COUNT
SUM (Correct answer)
AVERAGE
MAX

Correct answer: SUM

Excel defaults to SUM when a numeric field is placed in the Values area of a PivotTable.

Question 9: Which feature adds interactive date-based filtering with a draggable time range to a PivotChart?

Timeline (Correct answer)
Watch Window
Scroll bar
Form control spinner

Correct answer: Timeline

A Timeline slicer filters PivotTables and PivotCharts by date periods.

Question 10: To display Sales by Region as separate lines over Month on a PivotChart, where should the Region field be placed?

Legend (Series) (Correct answer)
Axis (Categories)
Filters
Values

Correct answer: Legend (Series)

Each series in a chart comes from the Legend area, which maps to Columns.

Question 11: To change the chart type for a single data series in an existing chart, effectively creating a combination chart, what is the first step?

Select the entire chart area.
Right-click the specific data series you want to change. (Correct answer)
Go to the 'Insert' tab and select a new chart type.
Double-click the horizontal axis.

Correct answer: Right-click the specific data series you want to change.

To change the chart type of just one data series, you must first select that series. Right-clicking the selected series will bring up a context menu that includes the 'Change Series Chart Type...' option, allowing you to create a combination chart.

Question 12: Which chart type best shows composition of a whole at a single point in time?

Line chart
Scatter plot
Pie chart (Correct answer)
Histogram

Correct answer: Pie chart

Pie charts show how parts contribute to a whole using proportional slices.

Question 13: Which of the following chart elements provides a key to identify the different data series represented by colors, patterns, or symbols in a chart?

Axis Titles
Data Labels
Legend (Correct answer)
Chart Title

Correct answer: Legend

The legend is a key component of a chart that explains what the different colors, patterns, or symbols used for the data series represent, making the chart easier to understand.

Question 14: How can you recover an unsaved workbook?

File > Info > Manage Workbook > Recover Unsaved Workbooks (Correct answer)
Permanently lost
Only with manual backup
Auto-recovery on restart

Correct answer: File > Info > Manage Workbook > Recover Unsaved Workbooks

AutoRecover saves backup copies that can be recovered through File > Info.

Question 15: What does Print Titles do?

Prints only title cells
Changes title font
Repeats specified rows/columns on every printed page (Correct answer)
Adds title page

Correct answer: Repeats specified rows/columns on every printed page

Print Titles repeats header rows and label columns on every printed page.

Question 16: Which of the following actions is prevented when you use the 'Protect Workbook' feature with the 'Structure' option selected?

Formatting cell borders
Editing cell contents
Changing the font color of data
Adding a new worksheet (Correct answer)

Correct answer: Adding a new worksheet

Protecting a workbook's structure specifically prevents users from making changes to the workbook's layout, which includes adding, deleting, renaming, moving, hiding, or unhiding worksheets. Protecting the worksheet, not the workbook, controls cell editing and formatting.

Question 17: To compare data from two different worksheets within the same workbook side-by-side, which sequence of commands on the 'View' tab is correct?

Freeze Panes > View Side-by-Side
New Window > Arrange All > Vertical (Correct answer)
Arrange All > Vertical
Split > Arrange All

Correct answer: New Window > Arrange All > Vertical

To view two sheets from the same workbook, you first need to open a second window of the current workbook using 'New Window'. Then, you can use 'Arrange All' and select an option like 'Vertical' to display both windows (and thus, different sheets) side-by-side.

Question 18: What is a macro-enabled workbook (.xlsm)?

Enhanced security workbook
Any workbook with formulas
Compressed format
A workbook that stores and runs VBA macros (Correct answer)

Correct answer: A workbook that stores and runs VBA macros

.xlsm supports VBA macros; needed when workbook contains macro code.

Question 19: What is a sunburst chart best used for?

Cyclical time data
Sunrise/sunset times
Hierarchical data as concentric rings from center outward (Correct answer)
Circular progress indicators

Correct answer: Hierarchical data as concentric rings from center outward

Sunburst charts display multi-level hierarchical data using concentric rings.

Question 20: What chart type is best for showing trends over continuous time?

Pie chart
Line chart (Correct answer)
Doughnut chart
Treemap

Correct answer: Line chart

Line charts connect data points across time intervals to show trends.

Question 21: What visualization shows distribution of a single continuous variable?

Bubble chart
Radar chart
Histogram (Correct answer)
Scatter chart

Correct answer: Histogram

Histograms group continuous data into bins and show frequency as bar height.

Question 22: When should you use a treemap instead of a pie chart?

Comparing exactly two values
Hierarchical data with many categories (Correct answer)
Data has negative values
Time-based trends

Correct answer: Hierarchical data with many categories

Treemaps use nested rectangles to show hierarchy and proportion with many categories.

Question 23: How do you create in-cell data bars?

View > Data Bar toggle
Home > Conditional Formatting > Data Bars (Correct answer)
Format Cells > Data Bars
Insert > Charts > Data Bar

Correct answer: Home > Conditional Formatting > Data Bars

Data Bars are a conditional formatting option that adds proportional bars inside cells.

EXCEL Practice Test: Video 3 Answers (23 Questions)

Which Excel chart type is best suited for showing the proportion of parts to a whole?

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