9th Grade Excel Test

9 Questions | Total Attempts: 599

SettingsSettingsSettings
Please wait...
9th Grade Quizzes & Trivia

Questions and Answers
  • 1. 
    Which of the following accurately describes a RANGE?
    • A. 

      (A1:A5)

    • B. 

      A1;A5

    • C. 

      A1:A5

    • D. 

      A1, A2,A3, A4, A5

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

      True

    • B. 

      False

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

      Average

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

      Column

    • B. 

      Bar

    • C. 

      Line

    • D. 

      Pie

  • 5. 
    Numbers are aligned on which side of the cell?
    • A. 

      Left

    • B. 

      Right

    • C. 

      Center

  • 6. 
    Microsoft Excel can be used to do any type of calculation but also may be used just to create tables and organize data. 
    • A. 

      True

    • B. 

      False

  • 7. 
    When entering formulas in Microsoft Excel, one should use the actual cell references (names) instead of the actual numbers in the cell. 
    • A. 

      True

    • B. 

      False

  • 8. 
    There are multiples pages in a workbook. 
    • A. 

      True

    • B. 

      False

Back to Top Back to top