Microsoft Excel Quiz Test: MCQ!

1. Which Chart can be created in Excel?

Area

Line

Pie

All of the above

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.

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.

2. How do you wrap the text in a cell?

Format, cells, font

Format, cells, protection

Format, cells, number

Format, cells, alignment

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.

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.

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

$

*

%

&

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.

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.

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

5,430.00

5,436.80

5,436.8

6.8

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.

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.

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

Ctrl+C

Ctrl+Enter

Ctrl+Page Up

Ctrl+Space Bar

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.

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.

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

Date ()

Today ()

Now ()

Time ()

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.

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.

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

Date ()

Today ()

Now ()

Time ()

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.

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.

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

Sheet3!A10

Sheet1!A10

Sheet3.A10

A10

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.

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.

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

Formula bar

Status Bar

Name Box

Title Bar

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.

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.

10. What does COUNTA () function do?

Counts cells having alphabets

Counts empty cells

Counts cells having number

Counts non-empty cells

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

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