Excel Basics Ultimate Quiz! Trivia

8 Questions | Attempts: 244
Share
SettingsSettings
Please wait...
  • 1/8 Questions

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

    • Worksheet
    • Cell
    • Active Cell
    • Office Assistant
Please wait...
About This Quiz

.

Excel Basics Ultimate Quiz! Trivia - Quiz

Quiz Preview

  • 2. 

    Which one of the following is a spreadsheet application?

    • Microsoft Access

    • Microsoft Powerpoint

    • Microsoft Word

    • Microsoft Excel

    Correct Answer
    A. Microsoft Excel
  • 3. 

    In a spreadsheet formula which symbol is used to multiply?

    • +

    • -

    • X

    • *

    Correct Answer
    A. *
  • 4. 

    What is the keyboard shortcut for copying data in Excel?

    • Ctrl / X

    • Ctrl / C

    • Ctrl / V

    • Ctrl / I

    Correct Answer
    A. Ctrl / C
  • 5. 

    The Format Painter icon in Excel looks like a

    Correct Answer
    paint brush
  • 6. 

    Which Excel function should be used if you need to sort that data alphabetically?

    • Filter

    • Function

    • Sort

    • Organize

    Correct Answer
    A. Sort
  • 7. 

    What is the formula for adding all numbers in column A?

    • =sum(A1:A2000)

    • +sum(A1:A2000)

    • =sum(A1-A2000)

    • =sum(A1+A2000)

    Correct Answer
    A. =sum(A1:A2000)
  • 8. 

    Which function should be used to count the number of values in column D?

    • ADD

    • VLOOKUP

    • AVG

    • COUNT

    Correct Answer
    A. COUNT

Quiz Review Timeline (Updated): Mar 21, 2022 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Mar 21, 2022
    Quiz Edited by
    ProProfs Editorial Team
  • Mar 16, 2010
    Quiz Created by
    Kathierotz
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.