Microsoft Excel Pre-test For Secondary One
Settings
Answer the question by selecting the correct selection
- 1.
- A.
Go to FILE - SAVE AS - SAVE AS TYPE - Excel 4.0 Work Sheet
- B.
Right click on the spreadsheet tab and select DELETE
- C.
Right click on the spreadsheet and select INSERT - ENTIRE COLUMN
- 2.Which formula can add the all the numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell?
- A.
Count
- B.
Average
- C.
Sum
- 3.Which of these will NOT select all the cells in a document?
- A.
Clicking three times with the right mouse button in the spreadsheet
- B.
Using the Edit - Select All menu item
- C.
Pressing CTRL + A on the keyboard
- 4.When you see a cell with a red triangle in the top right corner, what does this signify?
- A.
There is an error in the cell
- B.
There is a comment associated with the cell
- C.
The font colour for text in the cell is red
- D.
A formula cannot be entered into the cell
- 5.Which of the following will NOT set text in selected cells to ITALICS ?
- A.
Pressing CTRL + I on the keyboard
- B.
Using the Tools - Wizard - Web Form menu item
- C.
Using the Format - Cells - Font menu item
- 6.Is it possible to insert an image from a file into an Excel spreadsheet ?
- A.
Yes
- B.
No
- 7.On an Excel sheet the active cell is indicated by ____.
- A.
A dark wide border
- B.
A dotted border
- C.
A blinking border
- D.
None of the above
- 8.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
- 9.If you press _____, the cell accepts your typing as its contents but the focus stays in the cell.
- A.
ENTER
- B.
CTRL + ENTER
- C.
TAB
- D.
INSERT
- 10.The cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is _____.
- A.
B1-G10
- B.
B1.G10
- C.
B1;G10
- D.
B1:G10
Back to top