Formulas and Functions Application 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 Formulas and Functions Application flashcards as text
What is the difference between relative and absolute cell references?
Answer: Relative adjust when copied, absolute (with $) stay fixed
Relative references adjust when copied; absolute references ($A$1) remain fixed.
What does COUNTIFS do that COUNTIF cannot?
Answer: Apply multiple criteria across different ranges simultaneously
COUNTIFS evaluates multiple criteria across multiple ranges, counting only when ALL are met.
How does ROUND differ from TRUNC?
Answer: ROUND applies mathematical rounding, TRUNC removes decimals without rounding
ROUND follows rounding rules (5 rounds up); TRUNC simply cuts off digits.
What does the TEXT function do?
Answer: Formats a number as text using a format code
TEXT converts a numeric value to text with a specific format.
How does AVERAGEIFS calculate its result?
Answer: Averages values where all corresponding criteria are met
AVERAGEIFS averages values in a range only where ALL corresponding criteria are satisfied.
What does the UNIQUE function do in Excel 365?
Answer: Extracts distinct values from a range as a dynamic array
UNIQUE returns a dynamic array of distinct values, removing duplicates.
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