Exam 1: Creating a Worksheet and a Chart

As you type,Excel displays the entry (and the Cancel box and Enter box)in the ____________________.

The first step in creating an effective worksheet is to make sure you ____.

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

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

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

Press ____ to select the entire worksheet.

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

Excel can display characters in only three font colors: black,red,and blue.

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

The default font for a new workbook is ____________________ 11-point regular black.

Which of the following keys moves the insertion point to the end of data in a cell?

A thin red border indicates the active cell.

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

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

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.

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

The ____ feature works behind the scenes,fixing common typing or spelling mistakes when you complete a text entry.

____________________ indicates how characters are emphasized.

____ properties are associated with all Microsoft Office files and include author,title,and subject.

Excel remembers the last ____ actions you have completed.