Exam 10: Excel : Creating a Worksheet and an Embedded Chart

_________________________ indicates how text characters are emphasized.

You can insert a function in a cell by _____.

When entering dollar values in cells, you also must type the dollar sign ($), commas, and any trailing zeros.

Excel recognizes the following as text: 401AX21, 921-231, 619 321, 883XTY.

Combining two or more selected cells into one cell is called _____ cells.

If each cell in a selected range is next to a row of numbers, Excel assigns the SUM function to each cell in the selected range when the Sum button is clicked.

Which of the following keys toggles between Insert mode and Overtype mode?

An Excel _____ allows data easily to be summarized and charted.

The automatically adjusted cell reference in a pasted formula is called a(n)_________________________.

You can press the RIGHT ARROW or LEFT ARROW keys to position the insertion point during in-cell editing.

_____ is/are used to add worksheet, column, and row titles on a worksheet.

A single point is about 1/32 of one inch in height.

The cell into which data is being entered is referred to as the _________________________ cell.

What effect does the Comma Style format have on the selected cells?

To draw a Clustered Cylinder chart, first select the data to be charted and then click the Column button (Insert tab | Charts group).

The person or persons requesting the worksheet should supply their requirements in a _____ document.