Microsoft Excel Functions 5

Question 1

What does the CHOOSE function do?

Accepted Answer

Returns a value from a list based on an index number

Answer

CHOOSE uses an index number to return a value from a list of up to 254 values.

Question 2

Which function calculates the straight-line depreciation of an asset for one period?

Accepted Answer

SLN

Answer

SLN calculates the straight-line depreciation of an asset by subtracting salvage value from cost and dividing by the asset's useful life.

Question 3

What is the correct syntax for a nested IF that returns "High" if A1>90, "Mid" if A1>50, else "Low"?

Accepted Answer

=IF(A1>90,"High",IF(A1>50,"Mid","Low"))

Answer

Nested IFs place a second IF as the false-result of the first, allowing multiple conditions to be checked in sequence.

Question 4

What does the NETWORKDAYS function calculate?

Accepted Answer

The number of working days between two dates, excluding weekends

Answer

NETWORKDAYS calculates the number of working days between a start and end date, automatically excluding Saturdays and Sundays.

Question 5

Which function returns the logical AND of multiple conditions?

Accepted Answer

AND

Answer

AND returns TRUE only if all its arguments evaluate to TRUE, otherwise it returns FALSE.

Excel Practice Test