Exam 7: Excel: Creating a Worksheet and a Chart

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

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

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

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

When you tap or click the Enter box to complete an entry in a cell,the active cell moves down to the next cell in the same column.

-A ____ is a series of two or more adjacent cells in a column or row or a rectangular group of cells,as shown in the accompanying figure.

You can double-tap or double-click the ____________________ tab of the worksheet whose name you want to change.

The AutoCorrect feature can automatically capitalize the first letter in the names of days.

MATCHING Identify the letter of the choice that best matches the phrase or definition. a.ALT+PAGE DOWN f.END b.ARROW g.INSERT c.CTRL+HOME h.SHIFT+RIGHT ARROW d.HOME i.BACKSPACE e.CTRL+F j.SPACEBAR -Selects the adjacent cell in the direction of the arrow on the key.

The group of adjacent cells beginning with B4 and ending with B8,written as B4:B8,is called a(n)range._________________________

In Excel,a number can contain the characters ____.

MATCHING Identify the letter of the choice that best matches the phrase or definition. a.ALT+PAGE DOWN f.END b.ARROW g.INSERT c.CTRL+HOME h.SHIFT+RIGHT ARROW d.HOME i.BACKSPACE e.CTRL+F j.SPACEBAR -Displays the Find dialog box.

____________________ indicates how characters are emphasized.

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.

A ____ reference is an adjusted cell reference in a copied and pasted formula.

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

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

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

The easiest way to select a cell is to move the block _______________________ pointer to the cell and then click.