Excel Basics

5 Questions | Total Attempts: 236

Settings
Please wait...
Microsoft Excel Quizzes & Trivia

Quiz for HK Excel Basics class


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 a column D?
    • A. 

      ADD

    • B. 

      VLOOKUP

    • C. 

      AVG

    • D. 

      COUNT