Could You Pass The MS Excel Assessment Trivia Quiz?

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By Nwhitehe
N
Nwhitehe
Community Contributor
Quizzes Created: 1 | Total Attempts: 5,427
| Attempts: 5,435
SettingsSettings
Please wait...
  • 1/10 Questions

     What are the shortcut keys to insert a new row in an Excel spreadsheet?

    • ALT + H + I + R
    • ALT + H + I + C
    • ALT + H + I + I
    • ALT + H + I + S
Please wait...
About This 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!

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

Quiz Preview

  • 2. 

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

    • F2

    • F4

    • CTRL + 1

    • CTRL + F

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

    Rate this question:

  • 3. 

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

    • CTRL

    • ALT

    • F2

    • F4

    Correct Answer
    A. 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:

  • 4. 

    What are the shortcut keys for AutoSum?

    • ALT and S

    • CTRL and S

    • ALT and =

    • CTRL and = 

    Correct Answer
    A. 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:

  • 5. 

    How do you spell check an Excel worksheet?

    • Under the Tools menu, click Spelling.

    • Press F7.

    • Click the button with ABC Check Mark icon.

    • Any of the above will perform a spell check.

    Correct Answer
    A. 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:

  • 6. 

    What are the keyboard shortcut keys to paste special?

    • ALT + H + V + F

    • ALT + H + V + P

    • ALT + H + V + O

    • ALT + H + V + S

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

    Rate this question:

  • 7. 

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

    • ALT + A + U + U

    • ALT + A + W + G

    • ALT + A + G + G 

    • ALT + A + B

    Correct Answer
    A. 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:

  • 8. 

    Which of the following features cannot be found in the Data ribbon?

    • What-If Analysis

    • PivotTable

    • Data Validation

    • Text to Columns

    Correct Answer
    A. 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:

  • 9. 

    What are the shortcut keys to open up the Find and Replace window?

    • ALT + H + FD + R

    • CTRL + F

    • ALT + H + R 

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

  • 10. 

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

    • ="Income Statement"&A1

    • ="Income Statement "&A1 

    • ="Income Statement "+A1

    • ="Income Statement "&"A1"

    Correct Answer
    A. ="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:

Quiz Review Timeline (Updated): Aug 17, 2023 +

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.