Microsoft Excel Quiz Test: MCQ!

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 Mcqquestions
M
Mcqquestions
Community Contributor
Quizzes Created: 23 | Total Attempts: 616,153
Questions: 10 | Attempts: 25,759

SettingsSettingsSettings
Microsoft Excel Quiz Test: MCQ! - Quiz

Are you familiar with Microsoft Excel, and do you think you can pass this quiz? Microsoft Excel helps you to be productive because of its multi-purpose spreadsheet. Teachers, employers, and scientists all make use of this convenient software feature. It may be intimidating at first, but you can learn how to navigate through Microsoft Excel. If you want to learn more about Microsoft Excel and find out how to use its spreadsheet, try this quiz.


Questions and Answers
  • 1. 

    Which Chart can be created in Excel?

    • A.

      Area

    • B.

      Line

    • C.

      Pie

    • D.

      All of the above

    Correct Answer
    D. All of the above
    Explanation
    All of the above is the correct answer because Excel allows users to create various types of charts, including area charts, line charts, and pie charts. These charts are commonly used to visually represent data and make it easier to understand and analyze. By selecting "All of the above," it implies that all the mentioned chart types can be created in Excel.

    Rate this question:

  • 2. 

    What will be the output if you format the cell containing 5436.8 as ‘#,##0.00′?

    • A.

      5,430.00

    • B.

      5,436.80

    • C.

      5,436.8

    • D.

      6.8

    Correct Answer
    B. 5,436.80
    Explanation
    When the cell containing the number 5436.8 is formatted as '#,##0.00', it means that the number will be displayed with a comma as a thousand separator and two decimal places. Therefore, the correct answer is 5,436.80.

    Rate this question:

  • 3. 

    How do you display the current date and time in MS Excel?

    • A.

      Date ()

    • B.

      Today ()

    • C.

      Now ()

    • D.

      Time ()

    Correct Answer
    C. Now ()
    Explanation
    The correct answer is "now ()". In MS Excel, the "now()" function is used to display the current date and time. This function updates automatically whenever the worksheet is recalculated or opened.

    Rate this question:

  • 4. 

    How do you display the current date only in MS Excel?

    • A.

      Date ()

    • B.

      Today ()

    • C.

      Now ()

    • D.

      Time ()

    Correct Answer
    B. Today ()
    Explanation
    The correct answer is "Today ()". In MS Excel, the "Today()" function is used to display the current date. It automatically updates the date whenever the spreadsheet is opened or recalculated.

    Rate this question:

  • 5. 

    How do you wrap the text in a cell?

    • A.

      Format, cells, font

    • B.

      Format, cells, protection

    • C.

      Format, cells, number

    • D.

      Format, cells, alignment

    Correct Answer
    D. Format, cells, alignment
    Explanation
    To wrap text in a cell, you need to use the "Format" option in the toolbar. Within the "Format" option, select "Cells" and then choose "Alignment". This will allow you to adjust the alignment settings for the cell, including wrapping the text within the cell.

    Rate this question:

  • 6. 

    What does COUNTA () function do?

    • A.

      Counts cells having alphabets

    • B.

      Counts empty cells

    • C.

      Counts cells having number

    • D.

      Counts non-empty cells

    Correct Answer
    D. Counts non-empty cells
    Explanation
    The COUNTA() function is used to count the number of non-empty cells in a range. It includes cells that contain text, numbers, logical values, and errors. It does not count empty cells or cells that contain only spaces. Therefore, the correct answer is "counts non-empty cells."

    Rate this question:

  • 7. 

    What is the short cut key to highlight the entire column?

    • A.

      Ctrl+C

    • B.

      Ctrl+Enter

    • C.

      Ctrl+Page Up

    • D.

      Ctrl+Space Bar

    Correct Answer
    D. Ctrl+Space Bar
    Explanation
    The shortcut key Ctrl+Space Bar is used to highlight the entire column in Excel. This shortcut selects all the cells in the current column, making it easier to apply formatting or perform operations on the selected data.

    Rate this question:

  • 8. 

    In the formula, which symbol specifies the fixed columns or rows?

    • A.

      $

    • B.

      *

    • C.

      %

    • D.

      &

    Correct Answer
    A. $
    Explanation
    The symbol "$" specifies the fixed columns or rows in a formula. When a "$" is placed before the column letter or row number in a cell reference, it indicates that the column or row should remain fixed when the formula is copied or filled to other cells. This is known as an absolute reference.

    Rate this question:

  • 9. 

    Excel displays the current cell address in the ……….

    • A.

      Formula bar

    • B.

      Status Bar

    • C.

      Name Box

    • D.

      Title Bar

    Correct Answer
    C. Name Box
    Explanation
    The Name Box in Excel displays the current cell address. It is located next to the formula bar and can be used to quickly navigate to a specific cell by typing in the cell reference. The formula bar displays the contents of the selected cell or the formula being entered, while the status bar shows information about the current state of Excel, such as the sum of selected cells. The title bar displays the name of the workbook.

    Rate this question:

  • 10. 

    What is the correct way to refer the cell A10 on sheet3 from sheet1?

    • A.

      Sheet3!A10

    • B.

      Sheet1!A10

    • C.

      Sheet3.A10

    • D.

      A10

    Correct Answer
    A. Sheet3!A10
    Explanation
    To refer to cell A10 on sheet3 from sheet1, the correct way is to use the notation "sheet3!A10". This notation specifies the sheet name followed by an exclamation mark, and then the cell reference. This ensures that the correct cell on the specified sheet is being referred to.

    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
  • Mar 20, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Oct 24, 2010
    Quiz Created by
    Mcqquestions
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.