Microsoft Excel Functions 5 — Questions and Answers
Question 1: What does the CHOOSE function do?
- Selects the largest value from a list
- Returns a value from a list based on an index number (Correct answer)
- Finds a specific value in a range
- Randomly selects a cell value
Correct 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.
Question 2: Which function calculates the straight-line depreciation of an asset for one period?
- DB
- DDB
- SLN (Correct answer)
- SYD
Correct 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.
Question 3: What is the correct syntax for a nested IF that returns "High" if A1>90, "Mid" if A1>50, else "Low"?
- =IF(A1>90,"High",IF(A1>50,"Mid","Low")) (Correct answer)
- =IF(A1>90,"High"):IF(A1>50,"Mid":"Low")
- =IFS(A1>90,"High",A1>50,"Mid","Low")
- =IF(A1>90,"High")ELSE IF(A1>50,"Mid")ELSE "Low"
Correct 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.
Question 4: What does the NETWORKDAYS function calculate?
- Total calendar days between two dates
- The number of working days between two dates, excluding weekends (Correct answer)
- Network latency in milliseconds
- Days remaining in the current month
Correct 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.
Question 5: Which function returns the logical AND of multiple conditions?
- ALL
- AND (Correct answer)
- BOTH
- EVERY
Correct answer: AND
AND returns TRUE only if all its arguments evaluate to TRUE, otherwise it returns FALSE.
Question 6: What does =TEXT(1234.5, "$#,##0.00") return?
- 1234.5
- $1,234.50 (Correct answer)
- 1,234.50
- $1234.5
Correct 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.
Question 7: Which function returns the number of characters in a text string?
- COUNT
- SIZE
- LEN (Correct answer)
- CHARS
Correct answer: LEN
LEN returns the length of a text string, counting every character including spaces.
Microsoft Excel Functions 5
What does the CHOOSE function do?