Take Another Quiz

Microsoft Excel Quiz

20 Questions
Microsoft Excel Quizzes & Trivia

MULTIPLE CHOICE QUESTIONS AND TRUE/FALSE Put your answers to the left of the numberaNS

Questions and Answers
  • 1. 
    Tutorial 1Excel is an electronic version of a(n)
    • A. 

      Database

    • B. 

      Spreadsheet

    • C. 

      Expression

    • D. 

      Formula

  • 2. 
    Tutorial 1Excel stores its documents as files called
    • A. 

      Worksheets

    • B. 

      Sheet tabs

    • C. 

      Workbooks

    • D. 

      Books

  • 3. 
    Tutorial 1A(n) ____ is a group of cells.
    • A. 

      Cluster

    • B. 

      Adjunct

    • C. 

      Selection

    • D. 

      Range

  • 4. 
    Tutorial 1The characters +, -, *, and / are examples of
    • A. 

      Formulas

    • B. 

      Values

    • C. 

      Arithmetic operators

    • D. 

      Calculations

  • 5. 
    Tutorial 1The formula used to multiply cell A1 by cell C1 is ____.
    • A. 

      =A1*C1

    • B. 

      C1*A1

    • C. 

      =A1/C1

    • D. 

      A1*C1

  • 6. 
              Tutorial 2 TRUE/FALSE          Formatting changes only the appearance of data - it does not affect the data itself.
    • A. 

      True

    • B. 

      False

  • 7. 
              Tutorial 2 TRUE/FALSE                    You can use a picture or image as the background for all the cells in a worksheet.
    • A. 

      True

    • B. 

      False

  • 8. 
    • A. 

      True

    • B. 

      False

  • 9. 
    • A. 

      True

    • B. 

      False

  • 10. 
    Tutorial 2 TRUE/FALSEIn Excel, if the built-in styles don’t meet your needs, you can modify an existing style or create a new one.
    • A. 

      True

    • B. 

      False

  • 11. 
    Tutorial 3The PMT function is a(n) ____ function.
    • A. 

      Date

    • B. 

      IF

    • C. 

      Financial

    • D. 

      Statistical

  • 12. 
    Tutorial 3 The F  FV function stands for ____.
    • A. 

      Function value

    • B. 

      Future value

    • C. 

      Financial value

    • D. 

      Formulated value

  • 13. 
    Tutorial 3  Abs     Abolute references are marked with a ____.
    • A. 

      <

    • B. 

      :

    • C. 

      $

    • D. 

      !

  • 14. 
    Tutorial 3           When  you copy a formula that contains an absolute reference to a new location, the reference ____.
    • A. 

      Is updated automatically

    • B. 

      Does not change

    • C. 

      Becomes bold

    • D. 

      Has a dotted outline in its cell

  • 15. 
    Tutorial 3Which function counts how many cells in a range contain numbers, where value1, value2, and so forth are text, numbers, or cell references?
    • A. 

      SUM

    • B. 

      COUNT

    • C. 

      COUNTA

    • D. 

      AUTOSUM

  • 16. 
    Tutorial 4Every chart must have a data source.
    • A. 

      True

    • B. 

      False

  • 17. 
    Tutorial 4 For     For  which of the following reasons would you choose to use a chart or graph?
    • A. 

      To organize information in columns and rows

    • B. 

      To show trends or relationships across data

    • C. 

      To present data using text only

    • D. 

      To add color to a report

  • 18. 
    Tutorial 4To move or resize an embedded chart, ____.
    • A. 

      Select the chart and drag the selection box

    • B. 

      Drag the resize handle on the selection box

    • C. 

      Select the chart and press Tab

    • D. 

      Both a and b

  • 19. 
    • A. 

      Chart

    • B. 

      Graph

  • 20. 
    Tutorial 4Excel supports ____________________ built-in charts.
    • A. 

      73

    • B. 

      75