Exam 8: Insert Summary Functions and Create Charts

The Insert WordArt button is on the ________ tab of the Ribbon.

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

A chart type can be changed after a chart is created.

In the Move Chart dialog box, the default name for a new worksheet is ________.

A cell displays a series of ________ when the numeric value displayed is longer than the column width.

#DIV/0! is an example of a(n) ________.

Each cell in the blue range finder is represented by a ________, which can be a column, a bar, a dot, a slice of pie, or other appropriate symbol.

Normal View does NOT display ________.

When there is a change in a cell value in a function argument, the function display value is automatically updated to reflect that change.

When a section of a worksheet displaying numeric values is selected, the ________ appears; this is used to apply conditional formatting or to insert a chart or table based on the selected content.

When a chart layout is changed, placeholders appear for the elements that have no content.

Cells containing a sum or average are usually included in the MAX and MIN function argument.

The ________ dialog box is used to relocate a chart to another worksheet.

In a function, the range in parentheses is the ________.

The Chart Elements button displays options for all of these EXCEPT ________.

When a fill option is set in the Format Chart Area pane, the fill color is applied to the ________.

The range finder uses different colors to identify sections of a selected range that are used to create different chart elements.

Rows and columns of totals are usually included in a column chart.

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

Which symbol is the error indicator that appears in a cell having a formula that has broken a rule?