Microsoft Excel Formulas 5

Question 1

What does =INDEX(A1:C5, 3, 2) return?

Accepted Answer

The value in row 3, column 2

Answer

INDEX returns the value at the intersection of the specified row and column within the range; row 3, column 2 here.

Question 2

Which operator is used to raise a number to a power in an Excel formula?

Accepted Answer

^

Answer

The caret (^) is Excel's exponentiation operator; =2^10 returns 1024.

Question 3

What does =AVERAGEIF(B1:B10, ">0", C1:C10) calculate?

Accepted Answer

Average of C1:C10 where the corresponding B value is greater than 0

Answer

AVERAGEIF averages the values in the average_range (C1:C10) where corresponding cells in the criteria range (B1:B10) meet the condition.

Question 4

In Excel, what does the formula =DATEIF(A1, B1, "M") calculate? (Note: DATEDIF)

Accepted Answer

The difference in months between two dates

Answer

DATEDIF with "M" as the unit returns the number of complete months between the start and end dates.

Question 5

Which function extracts a substring from the middle of a text string given a start position and length?

Accepted Answer

MID

Answer

MID returns a specified number of characters from a text string, starting at a given position.

Excel Practice Test