Take Another Quiz

Excel 2010 Test

25 Questions
Excel 2010 Test

A test for students beginning a unit on Excel 2010 to baseline their current knowledge of Excel and to determine their learning by comparing the results against a Post test to be given at the end of the unit of instruction.

Questions and Answers
  • 1. 
    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

    • D. 

      Add

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

      Series

    • B. 

      Function

    • C. 

      Formula

    • D. 

      Syntax

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

      P72

    • B. 

      G$9

    • C. 

      $K356

    • D. 

      $F$8

  • 11. 
    • A. 

      P72

    • B. 

      G$9

    • C. 

      $K356

    • D. 

      $F$8

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

      Freeze panes

    • B. 

      Split

    • C. 

      View side by side

    • D. 

      Mirror

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

      Function

    • B. 

      Cell

    • C. 

      Formula

    • D. 

      Range