Functions Flashcards

What does the CHOOSE function do?

Answer: Returns a value from a list based on an index number

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

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

Answer: SLN

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

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

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

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

What does the NETWORKDAYS function calculate?

Answer: The number of working days between two dates, excluding weekends

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

Which function returns the logical AND of multiple conditions?

Answer: AND

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

What does =TEXT(1234.5, "$#,##0.00") return?

Answer: $1,234.50

TEXT formats a number as text using the specified format code, so 1234.5 becomes "$1,234.50" with thousands separator and two decimal places.

Which function returns the number of characters in a text string?

Answer: LEN

LEN returns the length of a text string, counting every character including spaces.