Microsoft Excel 2010 Test : Trivia Questions! Quiz

25 Questions | Total Attempts: 20249

SettingsSettingsSettings
Please wait...
Microsoft Excel 2010 Test : Trivia Questions! Quiz

How well do you know Microsoft Excel 2010? Would you guess if you could pass this quiz? With this quiz, it is necessary to learn things such as which formula can add the numeric values in a range of cells, put cells in a different cell, and incorporate an image from a file into the spreadsheet. This excellent quiz will show you why Microsoft Excel 2010 still has value.


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. 
    How does a relative reference differ from an absolute reference?
    • A. 

      A relative reference specifies column and row references.

    • B. 

      A relative reference adjusts to its location on the worksheet.

    • C. 

      A relative reference refers to an existing cell reference.

    • D. 

      A relative reference refers to an original value.

  • 6. 
    Which of the following is an absolute cell reference?
    • A. 

      P72

    • B. 

      G$9

    • C. 

      $K356

    • D. 

      $F$8

  • 7. 
    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

  • 8. 
    What name is given to the chart background?
    • A. 

      Chart area

    • B. 

      Background area

    • C. 

      Legend area

    • D. 

      Plot area

  • 9. 
    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

  • 10. 
    Which of the following is an mixed cell reference with a fixed column address?
    • A. 

      P72

    • B. 

      G$9

    • C. 

      $K356

    • D. 

      $F$8

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

      P72

    • B. 

      G$9

    • C. 

      $K356

    • D. 

      $F$8

  • 12. 
    Which of the following is a relative cell reference?
    • A. 

      P72

    • B. 

      G$9

    • C. 

      $K356

    • D. 

      $F$8

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

      :

    • B. 

      {

    • C. 

      =

    • D. 

      /

  • 14. 
    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.

  • 15. 
    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.

  • 16. 
    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

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

      #

    • B. 

      %

    • C. 

      &

    • D. 

      $

  • 18. 
    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.

  • 19. 
    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.

  • 20. 
    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

  • 21. 
    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.

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

      MAXIMUM

    • B. 

      MAX

    • C. 

      LARGE

    • D. 

      LARGEST

  • 23. 
    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

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

      True

    • B. 

      False

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

      Function

    • B. 

      Cell

    • C. 

      Formula

    • D. 

      Range

Back to Top Back to top