Microsoft Excel Functions 4

Question 1

Which function returns a value from a specific row and column within a given range?

Accepted Answer

INDEX

Answer

MATCH

Answer

OFFSET

Answer

CHOOSE

Question 2

What does =SUMIF(A1:A10, ">100", B1:B10) calculate?

Accepted Answer

Sum of B1:B10 where corresponding A values are greater than 100

Answer

Sum of B1:B10 where corresponding A values equal 100

Answer

Sum of A1:A10 values greater than 100

Answer

Count of A1:A10 values greater than 100

Question 3

Which function converts a number into text formatted as currency?

Accepted Answer

DOLLAR

Answer

CURRENCY

Answer

FORMAT

Answer

TEXT

Question 4

What does the EXACT function do?

Accepted Answer

Compares two text strings and returns TRUE if they are identical (case-sensitive)

Answer

Rounds a number to exact decimal places

Answer

Finds exact text matches in a range

Answer

Returns the exact position of a substring

Question 5

Which function returns the nth largest value in a data set?

Accepted Answer

LARGE

Answer

MAX

Answer

MAXIFS

Answer

RANK

Question 6

What does the YEARFRAC function calculate?

Accepted Answer

The fraction of the year represented by the number of days between two dates

Answer

The number of years between two dates

Answer

The year portion of a date value

Answer

The number of workdays in a year

Question 7

Which function replaces all occurrences of a substring within a text string?

Accepted Answer

SUBSTITUTE

Answer

FIND

Answer

SEARCH

Answer

REPLACE