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

Settings

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.

• 1.

### Which Chart can be created in Excel?

• A.

Area

• B.

Line

• C.

Pie

• D.

All of the above

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

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 ()

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 ()

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

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

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

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.

&

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

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

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

Related Topics