Excel 2007 Layout

1. What do you type into an empty cell to start a formula?

*

(

=

$

2. Ctrl+B key makes the shortcut for making font in selected cell bold.

True

False

3. A worksheet is..

A symbol that represents a specific action

Refers to the change a formula makes when it is moved or copied to other cells with different data

A table of data that is organized into rows and columns

No ne of the above

4. Which is the part of the Excel screen where you can find all the commands or buttons, depending on the tab you selected before?

Ribbon

Formula Bar

Tab

Name Box

Sheet Tab

5. On an Excel spreadsheet the active cell is indicated by

A dark wide border

A dotted border

A blinking border

None of the above

6. Pressing ENTER moves the selection one cell to the right.

True

False

7. Once data is entered into a cell, can it be edited?

Yes, but it has to be saved as a different file name.

No, once it is saved it cannot be changed.

Yes, even after saving the file, double click on the cell where data is to be changed to edit

A and C

8. The Name Box shows you the contents of the active cell.

True

False

9. To select several cells or ranges that are not touching each other, you would _____ while selecting

Hold down the CTRL key

Hold down the SHIFT key

Hold down the ALT key

Hold down CTRL + SHIFT

10. To select a column the easiest method is to:

Double-click any cell in the column

Drag from the top cell in the column to the last cell in the column

Click the column heading

Click the column label