EXCEL Practice Test: Video 3 Answers (23 Questions)

Question 1

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

Accepted Answer

Pie chart

Answer

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?

Accepted Answer

ALT and =

Answer

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?

Accepted Answer

To create, edit, and manage named ranges and defined names

Answer

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?

Accepted Answer

Values area

Answer

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?

Accepted Answer

Joins two or more text strings into one

Answer

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

Excel Practice Test

Excel Practice Test

EXCEL Practice Test: Video 3 Answers (23 Questions)