Excel Quiz 2 On Functions And Graphing

13 Questions | Total Attempts: 522

SettingsSettingsSettings
Please wait...
Microsoft Excel Quizzes & Trivia

Small excel quiz on functions and graphing


Questions and Answers
  • 1. 
    When selecting data in a spreadsheet to be used in a graph or chart, one should never choose blank columns or rows.
    • A. 

      True

    • B. 

      False

  • 2. 
    When one wishes to select the largest number from a set of data, one should use which function?
    • A. 

      Count

    • B. 

      Max

    • C. 

      Min

    • D. 

      If

  • 3. 
    Which of the following chart types would be used if one wanted to compare an individual contribution to the whole?
    • A. 

      Column

    • B. 

      Stacked column

    • C. 

      Line

  • 4. 
    Linking means that the destination file will update everytime the source file is saved.
    • A. 

      True

    • B. 

      False

  • 5. 
    The second part of the "If" statement represents what happens if the condition is ......
  • 6. 
    The first part of the "If" statement is often referred to as the "condition" or the "logic statement".
    • A. 

      True

    • B. 

      False

  • 7. 
    The easiest way to get started doing an "If" statement is to click the Fx  on your toolbar.
    • A. 

      True

    • B. 

      False

  • 8. 
    One is given three tabs when they open a workbook.  If you use these three tabs, then you must open another workbook because you cannot add anymore tabs.
    • A. 

      True

    • B. 

      False

  • 9. 
    It is not possible to edit a graph/chart once it has been finished.
    • A. 

      True

    • B. 

      False

  • 10. 
    To do a sort or a filter, one could go to "Data" on the menu toolbar.
    • A. 

      True

    • B. 

      False

  • 11. 
    Using a gradebook spreadsheet, if Mrs. Skipper wishes to print out only those students who are in the 9th grade, she is using which feature?
    • A. 

      If statements

    • B. 

      Sorting

    • C. 

      Filtering

  • 12. 
    One should highlight or select any or all data to be used, before using a function.
    • A. 

      True

    • B. 

      False

  • 13. 
    (b5:g5)  is often referred to as the _______________________________  part of a function.
    • A. 

      Condition

    • B. 

      Range

    • C. 

      Selection