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,010
| Attempts: 772
SettingsSettings
Please wait...
  • 1/10 Questions

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

    • Yes
    • No
Please wait...
About This 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.

Microsoft Excel Pre-test For Secondary One - Quiz

Quiz Preview

  • 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

    Correct Answer
    A. Right click on the spreadsheet tab and select DELETE
  • 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

    Correct Answer
    A. 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:

  • 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

    Correct Answer
    A. Using the Tools - Wizard - Web Form menu item
  • 5. 

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

    • A dark wide border

    • A dotted border

    • A blinking border

    • None of the above

    Correct Answer
    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:

  • 6. 

    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

    Correct Answer
    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:

  • 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

    Correct Answer
    A. 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:

  • 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

    Correct Answer
    A. Click the column heading
    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. 

    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

    Correct Answer
    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:

  • 10. 

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

    • ENTER

    • CTRL + ENTER

    • TAB

    • INSERT

    Correct Answer
    A. 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:

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
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.