EXCEL Practice Test: Video 3 Answers (23 Questions) Flashcards

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

Answer: Pie chart

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

What are the AutoSum shortcut keys?

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.

What is the purpose of the Name Manager in Excel?

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.

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

Answer: Values area

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

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

Answer: Joins two or more text strings into one

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

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

Answer: Insert

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

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

Answer: Click Refresh on the PivotChart Analyze tab

PivotCharts do not update until the PivotTable cache is refreshed.

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

Answer: SUM

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

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

Answer: Timeline

A Timeline slicer filters PivotTables and PivotCharts by date periods.

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

Answer: Legend (Series)

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

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

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.

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

Answer: Pie chart

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

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

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.

How can you recover an unsaved workbook?

Answer: File > Info > Manage Workbook > Recover Unsaved Workbooks

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

What does Print Titles do?

Answer: Repeats specified rows/columns on every printed page

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

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

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.

To compare data from two different worksheets within the same workbook side-by-side, which sequence of commands on the 'View' tab is 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.

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

Answer: A workbook that stores and runs VBA macros

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

What is a sunburst chart best used for?

Answer: Hierarchical data as concentric rings from center outward

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

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

Answer: Line chart

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