Excel Basics Ultimate Quiz! Trivia

8 Questions | Total Attempts: 239

SettingsSettingsSettings
Please wait...
Excel Basics Ultimate Quiz! Trivia

.


Questions and Answers
  • 1. 
    What is the keyboard shortcut for copying data in Excel?
    • A. 

      Ctrl / X

    • B. 

      Ctrl / C

    • C. 

      Ctrl / V

    • D. 

      Ctrl / I

  • 2. 
    The Format Painter icon in Excel looks like a
  • 3. 
    What is the formula for adding all numbers in column A?
    • A. 

      =sum(A1:A2000)

    • B. 

      +sum(A1:A2000)

    • C. 

      =sum(A1-A2000)

    • D. 

      =sum(A1+A2000)

  • 4. 
    Which Excel function should be used if you need to sort that data alphabetically?
    • A. 

      Filter

    • B. 

      Function

    • C. 

      Sort

    • D. 

      Organize

  • 5. 
    Which function should be used to count the number of values in column D?
    • A. 

      ADD

    • B. 

      VLOOKUP

    • C. 

      AVG

    • D. 

      COUNT

  • 6. 
    Name the area within a worksheet that is current, or ready to receive information?
    • A. 

      Worksheet

    • B. 

      Cell

    • C. 

      Active Cell

    • D. 

      Office Assistant

  • 7. 
    Which one of the following is a spreadsheet application?
    • A. 

      Microsoft Access

    • B. 

      Microsoft Powerpoint

    • C. 

      Microsoft Word

    • D. 

      Microsoft Excel

  • 8. 
    In a spreadsheet formula which symbol is used to multiply?
    • A. 

      +

    • B. 

      -

    • C. 

      X

    • D. 

      *