Exam 8: Insert Summary Functions and Create Charts

Excel uses rules to check for formula errors.

The Quick Analysis Lens button appears to the right of ________.

A function argument is the cell range that appears in ________.

Select the description that best matches the chart type. -Pie chart

Select the description that best matches the chart type. -Area chart

A(n) ________ image has the spatial dimensions of length, width, and depth.

When an embedded chart is selected and the worksheet is printed, ________.

The Wrap Text button is in the Alignment group on the ________ tab.

Press the ________ key to insert text from a Chart Title or Axis Title placeholder into the formula bar.

Text created in WordArt is an object, which can be resized and relocated in the worksheet.

A(n) ________ chart is best used to illustrate trends over time.

Chart styles and chart layouts affect the same chart elements and features.

All data labels in a chart can be selected by clicking on one of the data labels.

When a chart is selected, the ________ contextual tab appears on the Ribbon.

The ________ format does not display commas or trailing zeros to the right of a decimal point.

If 17.8 is the displayed value in the active cell when the Decrease Decimal button is clicked, the displayed value changes to ________.

Select the description that best matches the chart type. -Line chart

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

Press the ________ key to close the range finder.

When the Function AutoComplete list is used to enter the MAX function into an active cell, ________.