Microsoft Excel Pre-test For Secondary One

10 Questions  I  By Skyline_vspecii
Please take the quiz to rate it.

Microsoft Excel Quizzes & Trivia
Answer the question by selecting the correct selection

  
Changes are done, please start the quiz.


Questions and Answers

Removing question excerpt is a premium feature

Upgrade and get a lot more done!
  • 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


  • 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


  • 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


  • 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


  • 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


  • 6. 
    Is it possible to insert an image from a file into an Excel spreadsheet ?
    • A. 

      Yes

    • B. 

      No


  • 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


  • 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


  • 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


  • 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


Back to top

Removing ad is a premium feature

Upgrade and get a lot more done!
Take Another Quiz
We have sent an email with your new password.