Microsoft Excel Pre-test For Secondary One

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By Skyline_vspecii
S
Skyline_vspecii
Community Contributor
Quizzes Created: 2 | Total Attempts: 1,014
| Attempts: 776 | Questions: 10
Please wait...
Question 1 / 10
0 %
0/100
Score 0/100
1. Is it possible to insert an image from a file into an Excel 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.

Submit
Please wait...
About This Quiz
Microsoft Excel Pre-test For Secondary One - Quiz

This pre-test for Secondary One assesses basic Microsoft Excel skills. It covers deleting spreadsheets, using formulas, selecting cells, identifying cell errors, formatting text, and inserting images. Essential for beginners to validate their Excel proficiency.

Personalize your quiz and earn a certificate with your name on it!
2. A user wishes to remove a spreadsheet from a workbook. Which is the correct sequence of events that will do this?

Explanation

not-available-via-ai

Submit
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?

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.

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

Explanation

not-available-via-ai

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

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.

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

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.

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

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.

Submit
8. To select a column the easiest method is to _____.

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.

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

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.

Submit
10. If you press _____, the cell accepts your typing as its contents but the focus stays in the 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.

Submit
View My Results

Quiz Review Timeline (Updated): Mar 22, 2023 +

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
Cancel
  • All
    All (10)
  • Unanswered
    Unanswered ()
  • Answered
    Answered ()
Is ...
A ...
Which ...
Which ...
Which of these will NOT select all the cells in a document?
On an Excel sheet the active cell is indicated by ____.
The cell reference for a range of cells that ...
To select a column the easiest method is to _____.
When you see a cell with a red triangle in the ...
If you press _____, the cell accepts your typing as its ...
Alert!

Advertisement