Exam 3: Excel 1 Creating a Worksheet and a Chart

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

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

In a worksheet, columns typically contain information that is similar to a list. _________________________

The active cell reference appears in the ____________________ on the left side of the formula bar.

What effect does the Accounting Number Format have on the selected cells?

The ____ area on the status bar includes six commands as well as the result of the associated calculation on the right side of the menu.

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

____ is/are used to place worksheet, column, and row titles on a worksheet.

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

A(n) ____________________ conveys a visual representation of data.

While typing in a cell, you can press the ____________________ key to erase all the characters back to and including the incorrect character you just typed.

To enter data in a cell, you must first select the ____.

The range of cells receiving copied content is called the ____ area.

Which of the following is the Ribbon path to the Cell Styles button?

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

The ____________________ button allows you to choose whether you want to copy the values from the source area to the destination area with or without formatting.

The ____ button allows you to erase recent cell entries.

Clicking the ____ box completes an entry.

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

The range of cells receiving the content of copied cells is called the ____.