# Microsoft Excel Pre-test For Secondary One

Approved & Edited by ProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
| By Skyline_vspecii
S
Skyline_vspecii
Community Contributor
Quizzes Created: 2 | Total Attempts: 998
Questions: 10 | Attempts: 760

Settings

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

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

C. Sum
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.

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

A. Clicking three times with the right mouse button in the spreadsheet
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.

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

A. There is an error in the 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.

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

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

A. Yes
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.

Rate this question:

• 7.

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

• A.

A dark wide border

• B.

A dotted border

• C.

• D.

None of the above

A. A dark wide border
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.

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.

• D.

Click the column label

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.

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

B. CTRL + ENTER
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.

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

D. B1: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.

Rate this question:

Quiz Review Timeline +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

• Current Version
• Mar 22, 2023
Quiz Edited by
ProProfs Editorial Team
• Dec 28, 2009
Quiz Created by
Skyline_vspecii

Related Topics