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.
Written and edited by Nathan Beja, founder of Practice Test Geeks, with AI assistance. Exam facts are checked against the official sources linked below. Editorial policy
Sources & references
Exam facts on this page (fees, format, dates, passing scores) are checked against these official sources; the date is our last check. Editorial policy
- store.certiport.com — Fees, retake fee · verified Nov 2026
- certiport.pearsonvue.com — Renewal, score validity, score release, exam format · verified Nov 2026
- learn.microsoft.com — Test delivery, time limit, eligibility · verified Nov 2026