Microsoft Excel Pre-test For Secondary One

1. Is it possible to insert an image from a file into an Excel spreadsheet ?

Yes

No

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.

Explanation

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.

2. A user wishes to remove a spreadsheet from a workbook. Which is the correct sequence of events that will do this?

Go to FILE - SAVE AS - SAVE AS TYPE - Excel 4.0 Work Sheet

Right click on the spreadsheet tab and select DELETE

Right click on the spreadsheet and select INSERT - ENTIRE COLUMN

not-available-via-ai

Explanation

not-available-via-ai

3. 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?

Count

Average

Sum

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.

Explanation

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.

4. Which of the following will NOT set text in selected cells to ITALICS ?

Pressing CTRL + I on the keyboard

Using the Tools - Wizard - Web Form menu item

Using the Format - Cells - Font menu item

not-available-via-ai

Explanation

not-available-via-ai

5. Which of these will NOT select all the cells in a document?

Clicking three times with the right mouse button in the spreadsheet

Using the Edit - Select All menu item

Pressing CTRL + A on the keyboard

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.

Explanation

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.

6. On an Excel sheet the active cell is indicated by ____.

A dark wide border

A dotted border

A blinking border

None of the above

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.

Explanation

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.

7. 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 _____.

B1-G10

B1.G10

B1;G10

B1:G10

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.

Explanation

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.

8. 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

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.

Explanation

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.

9. When you see a cell with a red triangle in the top right corner, what does this signify?

There is an error in the cell

There is a comment associated with the cell

The font colour for text in the cell is red

A formula cannot be entered into the cell

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.

Explanation

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.

10. If you press _____, the cell accepts your typing as its contents but the focus stays in the cell.

ENTER

CTRL + ENTER

TAB

INSERT

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.

Explanation

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.