Excel 2007 Layout
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
Correct Answer
C. A table of data that is organized into rows and columns -
- 2.
Pressing ENTER moves the selection one cell to the right.
- A.
True
- B.
False
Correct Answer
B. False -
- 3.
The Name Box shows you the contents of the active cell.
- A.
True
- B.
False
Correct Answer
A. True -
- 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
Correct Answer
A. A dark wide border -
- 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
Correct Answer
C. Click the column heading -
- 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
Correct Answer
A. Hold down the CTRL key -
- 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
Correct Answer
C. Yes, even after saving the file, double click on the cell where data is to be changed to edit -
- 8.
What do you type into an empty cell to start a formula?
- A.
*
- B.
(
- C.
=
- D.
$
Correct Answer
C. = -
- 9.
Ctrl+B key makes the shortcut for making font in selected cell bold.
- A.
True
- B.
False
Correct Answer
A. True -
- 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
Correct Answer
A. Ribbon -
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Jan 07, 2013Quiz Edited by
ProProfs Editorial Team -
Oct 18, 2009Quiz Created by
Oflodac
Back to top