Excel 2010 Test

25 Questions  I  By Rpolete
Please take the quiz to rate it.

 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.

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

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.