Microsoft Excel Excel MCQ 5

Question 1

What is the result of =ROUND(3.567, 2)?

Accepted Answer

3.57

Answer

ROUND(3.567, 2) rounds 3.567 to 2 decimal places, resulting in 3.57.

Question 2

Which of the following is NOT a valid cell reference style in Excel?

Accepted Answer

1A

Answer

Cell references in the A1 style must begin with the column letter(s) followed by the row number.

Question 3

What is the purpose of Data Validation in Excel?

Accepted Answer

To restrict the type or range of data entered into a cell

Answer

Data Validation restricts what users can enter into a cell, such as only allowing numbers within a specific range.

Question 4

Which keyboard shortcut selects an entire row in Excel?

Accepted Answer

Shift + Space

Answer

Shift + Space selects the entire row of the currently active cell.

Question 5

What does the NOW() function return in Excel?

Accepted Answer

The current date and time

Answer

NOW() returns the current date and time as a serial number that updates whenever the worksheet is recalculated.

Excel Practice Test