Microsoft Excel Pre-test For Secondary One
Answer the question by selecting the correct selection
- 1.
A user wishes to remove a spreadsheet from a workbook. Which is the correct sequence of events that will do this?
- 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
Correct Answer
B. Right click on the spreadsheet tab and select DELETE -
- 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
Correct Answer
C. SumExplanation
The formula that can add all the numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell is the "Sum" formula. This formula calculates the sum of all the numbers in the specified range and ignores any non-numeric values.Rate this question:
-
- 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
Correct Answer
A. Clicking three times with the right mouse button in the spreadsheetExplanation
Clicking three times with the right mouse button in the spreadsheet does not select all the cells in a document. This action typically activates the context menu for the spreadsheet, rather than selecting cells.Rate this question:
-
- 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
Correct Answer
A. There is an error in the cellExplanation
The presence of a red triangle in the top right corner of a cell signifies that there is an error in that particular cell. This error could be due to various reasons such as incorrect formula, invalid data entry, or a broken link. The red triangle serves as a visual indicator to alert the user that there is an issue that needs to be addressed in that specific cell.Rate this question:
-
- 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
Correct Answer
B. Using the Tools - Wizard - Web Form menu item -
- 6.
Is it possible to insert an image from a file into an Excel spreadsheet ?
- A.
Yes
- B.
No
Correct Answer
A. YesExplanation
Yes, it is possible to insert an image from a file into an Excel spreadsheet. This can be done by selecting the cell where the image is to be inserted, then going to the Insert tab and selecting the "Pictures" option. From there, the user can browse their computer for the desired image file and insert it into the spreadsheet.Rate this question:
-
- 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
Correct Answer
A. A dark wide borderExplanation
The active cell on an Excel sheet is indicated by a dark wide border. This border helps to visually distinguish the currently selected cell from the others on the sheet. It is used to show which cell is currently active and ready for data entry or manipulation. The dark wide border is a common feature in spreadsheet software like Excel and is designed to make it easier for users to navigate and work with their data effectively.Rate this question:
-
- 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
Correct Answer
C. Click the column headingExplanation
The correct answer is to click the column heading. This is the easiest method because the column heading is the label at the top of the column, which is specifically designed to be clicked and selected. By clicking the column heading, the entire column will be selected, allowing the user to perform actions such as formatting, sorting, or filtering on the selected column.Rate this question:
-
- 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
Correct Answer
B. CTRL + ENTERExplanation
Pressing CTRL + ENTER allows you to input your typing into the cell, but the focus remains in the same cell. This means that after pressing CTRL + ENTER, you can continue editing or formatting the content in the cell without having to move to another cell.Rate this question:
-
- 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
Correct Answer
D. B1:G10Explanation
The correct answer is B1:G10. This is the correct cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10. The colon (:) is used to indicate a range of cells between B1 and G10.Rate this question:
-
Back to top