Could You Pass The MS Excel Assessment Trivia Quiz?

Approved & Edited by ProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
Learn about Our Editorial Process
| By Nwhitehe
N
Nwhitehe
Community Contributor
Quizzes Created: 1 | Total Attempts: 5,377
Questions: 10 | Attempts: 5,380

SettingsSettingsSettings
Could You Pass The MS Excel Assessment Trivia Quiz? - Quiz

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. 

    How do you spell check an Excel worksheet?

    • 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.

    Correct Answer
    D. Any of the above will perform a spell check.
    Explanation
    The question asks for the method to spell check an Excel worksheet. The correct answer states that any of the options provided will perform a spell check. This means that the user can either go to the Tools menu and click on Spelling, press F7 on the keyboard, or click on the button with the ABC Check Mark icon to initiate the spell check process. All three options will achieve the same result of spell checking the worksheet.

    Rate this question:

  • 2. 

    What is the keyboard shortcut key to lock cell references in a formula?

    • A.

      CTRL

    • B.

      ALT

    • C.

      F2

    • D.

      F4

    Correct Answer
    D. F4
    Explanation
    The keyboard shortcut key to lock cell references in a formula is F4. Pressing F4 toggles between different types of cell references, such as absolute, relative, and mixed references. This allows users to easily adjust and fix the references in their formulas without manually typing the dollar sign ($) or selecting the cells.

    Rate this question:

  • 3. 

    What are the shortcut keys for AutoSum?

    • A.

      ALT and S

    • B.

      CTRL and S

    • C.

      ALT and =

    • D.

      CTRL and = 

    Correct Answer
    C. ALT and =
    Explanation
    The shortcut keys for AutoSum are ALT and =. This combination allows users to quickly insert the AutoSum function in a selected range of cells in Microsoft Excel. By pressing ALT and = together, Excel automatically selects the adjacent range of cells and inserts the SUM function, saving time and effort for users.

    Rate this question:

  • 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

    Correct Answer
    A. ALT + H + I + R
    Explanation
    The correct answer is ALT + H + I + R. This key combination is used to insert a new row in an Excel spreadsheet.

    Rate this question:

  • 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

    Correct Answer
    C. ALT + A + G + G 
    Explanation
    The correct answer is ALT + A + G + G. This shortcut is used to group rows in order to expand or contract a section of data. By selecting the desired rows and pressing these keys, the rows will be grouped together and can be easily expanded or collapsed.

    Rate this question:

  • 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"

    Correct Answer
    B. ="Income Statement "&A1 
    Explanation
    The correct formula to display the results as shown below is "= "Income Statement" & A1". This formula uses the ampersand (&) operator to concatenate the text "Income Statement" with the content of cell A1. The result will be "Income Statement" followed by the value in cell A1.

    Rate this question:

  • 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

    Correct Answer
    D. ALT + H + V + S
    Explanation
    The keyboard shortcut keys to paste special are ALT + H + V + S.

    Rate this question:

  • 8. 

    What are the keyboard shortcut keys to edit the formula in a cell?

    • A.

      F2

    • B.

      F4

    • C.

      CTRL + 1

    • D.

      CTRL + F

    Correct Answer
    A. F2
    Explanation
    The keyboard shortcut key "F2" is used to edit the formula in a cell.

    Rate this question:

  • 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

    Correct Answer
    B. PivotTable
    Explanation
    The PivotTable feature cannot be found in the Data ribbon. PivotTable is a powerful data analysis tool that allows users to summarize and analyze large amounts of data in a flexible and interactive way. It is typically found in the Insert tab or in the Analyze tab of the Excel ribbon.

    Rate this question:

  • 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

    Correct Answer
    A. ALT + H + FD + R
    Explanation
    The shortcut keys to open up the Find and Replace window are ALT + H + FD + R.

    Rate this question:

Quiz Review Timeline +

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

  • Current Version
  • Aug 17, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Oct 06, 2008
    Quiz Created by
    Nwhitehe
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.