Exam 8: Insert Summary Functions and Create Charts

Once inserted into a worksheet, a chart CANNOT be relocated.

The displayed value of a cell is replaced with a series of # symbols when ________.

When a cell formula is being edited, pressing the ________ key changes the selected cell reference from relative to absolute.

The ________ is a statistical function that adds a group of values and then divides the result by the number of values in the group.

The labels and data series of a chart are linked to the worksheet cells referred to as the ________.

In a worksheet, each cell in the blue range finder is a(n) ________.

Data points related to one another (e.g., first-quarter sales from each region) create a(n)________.

A ________ is a group of numbers, text, dates, or time periods that come in succession.

A green triangle in the upper left corner of a cell is a(n) ________.

When there is a change in the worksheet data, the corresponding chart is updated automatically.

Select the description that best matches the chart element. -y-axis

A(n) ________ chart is a chart that is displayed with its source data.

By default, Excel displays numbers in General format.

A cell that remains the same when it is copied or filled to other cells is a(n) ________.

Headers and footers CANNOT be inserted into a chart sheet.

A ________ chart is used to illustrate comparisons of related numbers.

What are the small squares that appear in all four corners of the range finder?

Select the description that best matches the chart element. -Value axis

When the AVERAGE function is used, the division operation is NOT visible in the formula bar, as it is part of the predefined function.

The AutoSum button is in the ________ group on the Home tab.