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

It prevents formulas from being edited

Answer

It highlights error cells in red

Answer

It deletes rows that contain errors

Question 2

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

Accepted Answer

Ctrl+;

Answer

Ctrl+Shift+T

Answer

Ctrl+D

Answer

Ctrl+Shift+:

Question 3

What does the SUMPRODUCT function do?

Accepted Answer

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

Answer

Sums numbers then multiplies by a constant

Answer

Finds the product of a range of numbers

Answer

Sums only positive numbers in a range

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

Home tab → Freeze Panes → Freeze First Row

Answer

Page Layout tab → Freeze Panes → Freeze First Row

Answer

Data tab → Freeze Row

Question 5

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

Accepted Answer

Conditional Formatting

Answer

Data Validation

Answer

Cell Styles

Answer

Format Painter

Question 6

What does the INDEX function return when given an array, a row number, and an optional column number?

Accepted Answer

The value at the specified row and column intersection

Answer

The position of a value in the array

Answer

The count of values in the range

Answer

The largest value in the row

Question 7

Which function finds the position of the first occurrence of a substring within a text string and is case-sensitive?

Accepted Answer

FIND

Answer

SEARCH

Answer

MATCH

Answer

LOCATE