Excel Assessment - Level 1

8 Questions | Total Attempts: 1032

Settings
Please wait...
Excel Quizzes & Trivia

This assessment will be used to measure your knowledge of Excel.


Questions and Answers
  • 1. 
    C4:D11 is an example of a            .
    • A. 

      Formula

    • B. 

      Range

    • C. 

      Column

    • D. 

      Cell

  • 2. 
    What symbol is missing in the beginning of this formula?       SUM(B2:B11)
    • A. 

      ;

    • B. 

      *

    • C. 

      =

    • D. 

      /

    • E. 

      //

  • 3. 
    There are multiple ways to insert a hyperlink into a cell.
    • A. 

      True

    • B. 

      False

  • 4. 
    Data can be sorted by ____________ ? (Please check all answers that apply)
    • A. 

      Font type

    • B. 

      Value

    • C. 

      Cell Color

    • D. 

      Alphabetically

    • E. 

      All of the above

  • 5. 
    The two orientation styles of a page layout are landscape and             .
  • 6. 
    If you need a total of C1:D2, which of the following would you use? (Check all answers that apply)
    • A. 

      Sum(C1:D2)

    • B. 

      Total(C1:D2)

    • C. 

      C1+D2

    • D. 

      C1+C2+D1+D2

  • 7. 
    Select the best description(s) for applying a macro to a sheet.
    • A. 

      Insert -> Sheet Options -> Insert Macro

    • B. 

      View -> Record Macro -> Stop Recording

    • C. 

      Developer -> Design Mode -> Run Macro -> Stop Macro

    • D. 

      Developer -> Record Macro -> Stop Recording

    • E. 

      Both B and D