Exam 8: Insert Summary Functions and Create Charts

Another way to select a range of cells is to use the arrow keys while holding down the [Ctrl] key.

A ________ is a prebuilt chart format that applies an overall visual look to a chart.

A chart can be sized by clicking and dragging on its sizing handles.

When the function argument is automatically entered by Excel, the argument is ________.

The Excel feature used to automatically adjust column width to the longest column entry is ________.

The number of decimals places and the appearance commas, dollar signs, or other symbols are features of number ________.

Print is an option on the ________ tab.

When options are moused over in the Quick Layout gallery, the preview is displayed on the actual chart in the worksheet.

The ________ button on the Design tab displays the locations where a title and a legend can be positioned in a chart.

Design and Layout are the only two tabs on the Chart Tools contextual tab.

The ________ function evaluates all values in a range and returns the largest value.

When the data cells are below and to the right of the cell containing a function, the function argument is automatically entered.

The ________ suggests functions that match the initial characters being entered by a user.

Moving between worksheets in a workbook is done by clicking on ________.

Numbers, text, cell references, and range names are common examples of a function ________.

Percentages displayed with data labels on a pie chart are NEVER rounded.

Selecting a chart from the Quick Analysis gallery inserts the chart into the active worksheet.

Clicking the ________ button displays additional decimal values in the active cell.

If Quarter 1 is the label in cell B2 and the AutoFill handle is used to copy the content of cell B2 through the range C2:E2, what is the content in cell E2 after copying?

Chart buttons are displayed when the ________ of the chart is clicked.