Microsoft Excel Basic and Advance 4

Question 1

What is the purpose of the IFERROR function in Excel?

Accepted Answer

It returns a custom value when a formula produces an error

Answer

IFERROR(value, value_if_error) evaluates an expression and returns a specified result if any error occurs, keeping the spreadsheet clean.

Question 2

Which keyboard shortcut inserts the current date as a static value in a cell?

Accepted Answer

Ctrl+;

Answer

Ctrl+; inserts today's date as a fixed value that does not change when the workbook is recalculated.

Question 3

What does the SUMPRODUCT function do?

Accepted Answer

Multiplies corresponding elements of arrays and returns the sum of those products

Answer

SUMPRODUCT multiplies corresponding values in two or more arrays and then sums all those products in a single step.

Question 4

How do you freeze the top row in Excel so it remains visible while scrolling down?

Accepted Answer

View tab → Freeze Panes → Freeze Top Row

Answer

On the View tab, clicking Freeze Panes and then Freeze Top Row locks row 1 in place during vertical scrolling.

Question 5

Which Excel tool applies different formatting to cells automatically based on the values they contain?

Accepted Answer

Conditional Formatting

Answer

Conditional Formatting changes a cell's appearance (color, font, borders) dynamically based on rules tied to the cell's value.

Excel Practice Test