Exam 2: Creating a Worksheet and a Chart

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Selects the cell at the beginning of the row that contains the active cell.

____________________ cells involves creating a single cell by combining two or more selected cells.

To use the AutoCalculate area, select the range of cells containing the numbers for a calculation you want to verify and then press and hold or double-click the AutoCalculate area to display the Customize Status Bar shortcut menu.

With Excel in Edit mode, you can edit cell contents directly in the cell.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Should not be used to clear a cell.

Careful ____________________ can reduce your effort significantly and result in a worksheet that is accurate, easy to read, flexible, and useful.

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

A character with a point size of 10 is about 10/72 of one inch in height.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Moves the insertion point to the end of data in a cell.

Excel's ____________________ function, which adds all of the numbers in a range of cells, provides a convenient means to calculate a total.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Deletes characters to the left of the insertion point.

Discuss how to correct errors after entering data into a cell using in-cell editing.

You can click the ____________________ button arrow (HOME tab | Editing group) to view a list of often-used functions.

Modifying the column widths usually is done last because other formatting changes may affect the size of data in the cells in the column.

You can turn off the Bold formatting for selected text by clicking the Roman button (Home tab | Font group).

When text is longer than the width of a column, Excel displays the overflow characters in adjacent cells to the right as long as those adjacent cells contain no data.

You can enter the correct range in a function by typing the beginning and ending cell references separated by a ____.

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

You can apply the Bold font style by pressing the ____ keyboard shortcut keys.