Could You Pass The MS Excel Assessment Trivia Quiz?

10 Questions

Settings
Please wait...
Excel Quizzes & Trivia

Microsoft Excel is a spreadsheet software program provided by Microsoft Office suite, used for creating spreadsheets in the form of rows and columns like a big table. It is the most popular program used since 1985 for calculation, pivot tables, and numerous graphing tools. This quiz has been designed to test your knowledge about the shortcuts and functions used in Excel. Lets' start off! All the best!


Questions and Answers
  • 1. 
    • A. 

      Under the Tools menu, click Spelling.

    • B. 

      Press F7.

    • C. 

      Click the button with ABC Check Mark icon.

    • D. 

      Any of the above will perform a spell check.

  • 2. 
    What is the keyboard shortcut key to lock cell references in a formula?
    • A. 

      CTRL

    • B. 

      ALT

    • C. 

      F2

    • D. 

      F4

  • 3. 
    What are the shortcut keys for AutoSum?
    • A. 

      ALT and S

    • B. 

      CTRL and S

    • C. 

      ALT and =

    • D. 

      CTRL and = 

  • 4. 
     What are the shortcut keys to insert a new row in an Excel spreadsheet?
    • A. 

      ALT + H + I + R

    • B. 

      ALT + H + I + C

    • C. 

      ALT + H + I + I

    • D. 

      ALT + H + I + S

  • 5. 
    What are the shortcut keys to group rows so you can expand/contract a section of data?
    • A. 

      ALT + A + U + U

    • B. 

      ALT + A + W + G

    • C. 

      ALT + A + G + G 

    • D. 

      ALT + A + B

  • 6. 
    What formula should be entered in cell A3 to display the results as shown below?
    • A. 

      ="Income Statement"&A1

    • B. 

      ="Income Statement "&A1 

    • C. 

      ="Income Statement "+A1

    • D. 

      ="Income Statement "&"A1"

  • 7. 
    What are the keyboard shortcut keys to paste special?
    • A. 

      ALT + H + V + F

    • B. 

      ALT + H + V + P

    • C. 

      ALT + H + V + O

    • D. 

      ALT + H + V + S

  • 8. 
    What are the keyboard shortcut keys to edit the formula in a cell?
    • A. 

      F2

    • B. 

      F4

    • C. 

      CTRL + 1

    • D. 

      CTRL + F

  • 9. 
    Which of the following features cannot be found in the Data ribbon?
    • A. 

      What-If Analysis

    • B. 

      PivotTable

    • C. 

      Data Validation

    • D. 

      Text to Columns

  • 10. 
    What are the shortcut keys to open up the Find and Replace window?
    • A. 

      ALT + H + FD + R

    • B. 

      CTRL + F

    • C. 

      ALT + H + R 

    • D. 

      ALT + H + FD + F