Functions Questions and Answers Flashcards
6 cards from real Microsoft Excel practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 6 Functions Questions and Answers flashcards as text
What does the COUNTIF function do in Excel?
Answer: Counts the number of cells in a range that meet a single condition
COUNTIF(range, criteria) counts cells that match a specified condition, such as counting how many cells contain a value greater than 100 or matching a specific text.
Which function would you use to find the largest value in a range of cells?
Answer: MAX
MAX returns the largest numeric value in a range. For example, =MAX(A1:A100) returns the highest value from that range.
What does the VLOOKUP function's fourth argument (range_lookup) control?
Answer: Whether to find an exact match or an approximate match
The fourth argument controls match type: FALSE (or 0) requires an exact match, while TRUE (or 1) allows an approximate match using a sorted lookup column.
Which function calculates the average of cells that meet a specific condition?
Answer: AVERAGEIF
AVERAGEIF(range, criteria, [average_range]) calculates the arithmetic mean of cells that satisfy the specified condition.
What does the CONCATENATE function do in Excel?
Answer: Joins two or more text strings into one string
CONCATENATE joins multiple text strings into a single string. It has been largely replaced by CONCAT and TEXTJOIN in newer Excel versions.
Which Excel function removes leading and trailing spaces from a text string?
Answer: TRIM
TRIM removes all leading spaces, trailing spaces, and reduces multiple consecutive spaces between words to a single space.