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.

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