Microsoft Excel Quiz

20 Questions  I  By Pragin
Please take the quiz to rate it.

Microsoft Excel Quizzes & Trivia
MULTIPLE CHOICE QUESTIONS AND TRUE/FALSE Put your answers to the left of the numberaNS

  
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. 
    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. 
    Tutorial 2 TRUE/FALSEBackground images do not print in Excel.
    • A. 

      True

    • B. 

      False


  • 9. 
    Tutorial 2 TRUE/FALSEWhen using a data bar, changing the value of one cell in the range will not affect the size of all the other cells’ data bars.
    • 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. 
    Tutorial 4A(n) ____________________ is a visual representation of a set of data.
    • A. 

      Chart

    • B. 

      Graph


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

      73

    • B. 

      75


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.