Microsoft Excel Excel MCQ 2

Question 1

Which Excel function returns the position of a value within a range?

Accepted Answer

MATCH

Answer

MATCH returns the relative position of a lookup value within a range.

Question 2

What does the $ symbol do when placed before a column letter in a cell reference (e.g., $A1)?

Accepted Answer

Locks only the column

Answer

A $ before the column letter (e.g., $A1) locks the column while allowing the row to change when copied.

Question 3

Which keyboard shortcut inserts the current date in Excel?

Accepted Answer

Ctrl + ;

Answer

Ctrl + ; inserts the current static date into the selected cell.

Question 4

What is the result of =MOD(17, 5)?

Accepted Answer

2

Answer

MOD(17, 5) returns 2 because 17 divided by 5 equals 3 with a remainder of 2.

Question 5

Which chart type is best suited for showing the proportion of parts to a whole?

Accepted Answer

Pie chart

Answer

Pie charts are designed to show how individual parts contribute to a total whole.

Excel Practice Test