MS Excel Test: Trivia Quiz! MCQ

25 Questions | Total Attempts: 70

SettingsSettingsSettings
MS Excel Test: Trivia Quiz! MCQ - Quiz

Check out our MS Excel online quiz that necessitates you to grasp certain concepts like what is the tag given to a value that does not alter when used within a formula, what Chart tool commands are found in these three tabs, what is mixed cell reference with a fixed row address, and with what do formulas in the cell start. This stupendous quiz will tell you all about MS Excel. Give it a shot.


Questions and Answers
  • 1. 
    Which formula 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?
    • A. 

      Count

    • B. 

      Average

    • C. 

      Sum

    • D. 

      Add

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

      Yes

    • B. 

      No

  • 3. 
    The cell range that starts in cell A1 and goes over to column J and down to row 15 is _____
    • A. 

      A1-J15

    • B. 

      A1.J15

    • C. 

      A1;J15

    • D. 

      A1:J15

  • 4. 
    “Month 1, Month 2, Month 3” is an example of what?
    • A. 

      Series

    • B. 

      Function

    • C. 

      Formula

    • D. 

      Syntax

  • 5. 
    What is the name given to a value that does NOT change when used within a formula?
    • A. 

      Reference

    • B. 

      Constant

    • C. 

      Function

    • D. 

      Address

  • 6. 
    The Chart Tools commands are found in these three tabs? 
    • A. 

      Design, Shape, Layout

    • B. 

      Layout, Format, Type

    • C. 

      Design, Layout, Format

    • D. 

      Styles, Shapes, Effects

  • 7. 
    Which of the following is mixed cell reference with a fixed row address?
    • A. 

      P72

    • B. 

      G$9

    • C. 

      $K356

    • D. 

      $F$8

  • 8. 
    Formulas in a cell start with a _______.
    • A. 

      :

    • B. 

      {

    • C. 

      =

    • D. 

      /

  • 9. 
    What is a worksheet tab in Excel 2010?
    • A. 

      A worksheet tab is used to access tools associated with the worksheet

    • B. 

      A worksheet tab is used to move from one cell to the next cell in a worksheet

    • C. 

      A worksheet tab is used to activate a worksheet by clicking on its sheet tab found at the bottom of the worksheet

    • D. 

      A worksheet tab is used to get help when working with Microsoft Excel 2010.

  • 10. 
    Once data is entered into a cell, can it be edited?
    • A. 

      Yes, even after saving a file, double-clicking on a cell where data is to be changed allows editing

    • B. 

      No, data in a cell can only be changed by creating a copy of the original spreadsheet into a new spreadsheet

    • C. 

      No, once a file is saved, cell data cannot be changed

    • D. 

      Yes, but the file must be saved with a different file name

  • 11. 
    Which feature in Excel allows you to view two spreadsheets in one window?
    • A. 

      Freeze panes

    • B. 

      Split

    • C. 

      View side by side

    • D. 

      Mirror

  • 12. 
    Which of the following buttons on the Excel toolbar will format selected cells so that they appear as currency values?  
    • A. 

      #

    • B. 

      %

    • C. 

      &

    • D. 

      $

  • 13. 
    When number signs (#####) are displayed in the cell, it means:  
    • A. 

      The formula in the cell is wrong

    • B. 

      There are too many characters in the cell to be displayed with the current cell width

    • C. 

      The decimal point placement in the cell is wrong

    • D. 

      All of the above

  • 14. 
    When changing the margins on your spreadsheet does not solve the problem with the printout width, what do you need to do?  
    • A. 

      Seperate the page into two for easier printing

    • B. 

      Use the Fit to Page option

    • C. 

      Highlight all cells to print and print selection

    • D. 

      None of the above

  • 15. 
    What does the following error mean - #REF!?  
    • A. 

      The #REF! error value occurs when a cell reference is not valid.

    • B. 

      The #REF! error value occurs when a cell has been formatted as a currency but contains text.

    • C. 

      The #REF! error value occurs when a cell contains a number with two decimal separators (points) present.

    • D. 

      None of the above

  • 16. 
    How do you select noncontiguous cells?
    • A. 

      Click a cell, then hold down SHIFT on the keyboard and select the other cells

    • B. 

      Click in a cell, then hold down ALT on the keyboard as you select the other cells

    • C. 

      Click in a cell, hold down CTRL on the keyboard and then select the other cells

    • D. 

      Click in a cell, then hold down SHIFT as you move from cell to cell using the Arrow keys on the keyboard

  • 17. 
    Which function would you use to find the largest number of a selected range?
    • A. 

      MAXIMUM

    • B. 

      MAX

    • C. 

      LARGE

    • D. 

      LARGEST

  • 18. 
    According to the picture the selected cell in yellow corresponds to:
    • A. 

      Column A, Row A11, Cell 11

    • B. 

      Column 11, Row A, Cell 11A

    • C. 

      Column 11, Row A, Cell A11

    • D. 

      Column A, Row 11, Cell A11

  • 19. 
    Inserting Page Number is in Header and Footer.
    • A. 

      True

    • B. 

      False

  • 20. 
    A_________ is a built in mathematical formula included in excel.
    • A. 

      Function

    • B. 

      Cell

    • C. 

      Formula

    • D. 

      Range

  • 21. 
    What  is the keyboard Short Cut to insert the current Time ____
  • 22. 
    Keyboard Shortcut to Edit the active Cell?
    • A. 

      F2

    • B. 

      Ctrl + E

    • C. 

      Alt + F4

    • D. 

      Alt + E

  • 23. 
    If you select a range of cells with Value, (without using any formula) the answer (average, sum etc) will appear at the status bar
    • A. 

      True

    • B. 

      False

  • 24. 
    Where you can find the Sort & Filter option in Excel?
  • 25. 
    Which of following options are not available in Conditional Formatting?
    • A. 

      New table format

    • B. 

      Tab Color

    • C. 

      Data Bars

    • D. 

      Icon Sets

Back to Top Back to top