Excel 2007 Layout
Settings
Short Test to check your knowledge
- 1.A worksheet is..
- A.
A symbol that represents a specific action
- B.
Refers to the change a formula makes when it is moved or copied to other cells with different data
- C.
A table of data that is organized into rows and columns
- D.
No ne of the above
- 2.Pressing ENTER moves the selection one cell to the right.
- A.
True
- B.
False
- 3.The Name Box shows you the contents of the active cell.
- A.
True
- B.
False
- 4.On an Excel spreadsheet the active cell is indicated by
- A.
A dark wide border
- B.
A dotted border
- C.
A blinking border
- D.
None of the above
- 5.To select a column the easiest method is to:
- A.
Double-click any cell in the column
- B.
Drag from the top cell in the column to the last cell in the column
- C.
Click the column heading
- D.
Click the column label
- 6.To select several cells or ranges that are not touching each other, you would _____ while selecting
- A.
Hold down the CTRL key
- B.
Hold down the SHIFT key
- C.
Hold down the ALT key
- D.
Hold down CTRL + SHIFT
- 7.Once data is entered into a cell, can it be edited?
- A.
Yes, but it has to be saved as a different file name.
- B.
No, once it is saved it cannot be changed.
- C.
Yes, even after saving the file, double click on the cell where data is to be changed to edit
- D.
A and C
- 8.What do you type into an empty cell to start a formula?
- A.
*
- B.
(
- C.
=
- D.
$
- 9.Ctrl+B key makes the shortcut for making font in selected cell bold.
- A.
True
- B.
False
- 10.Which is the part of the Excel screen where you can find all the commands or buttons, depending on the tab you selected before?
- A.
Ribbon
- B.
Formula Bar
- C.
Tab
- D.
Name Box
- E.
Sheet Tab
Back to top