Microsoft Excel Formulas and Functions Application 2

Question 1

What is the difference between relative and absolute cell references?

Accepted Answer

Relative adjust when copied, absolute (with $) stay fixed

Answer

Relative references adjust when copied; absolute references ($A$1) remain fixed.

Question 2

What does COUNTIFS do that COUNTIF cannot?

Accepted Answer

Apply multiple criteria across different ranges simultaneously

Answer

COUNTIFS evaluates multiple criteria across multiple ranges, counting only when ALL are met.

Question 3

How does ROUND differ from TRUNC?

Accepted Answer

ROUND applies mathematical rounding, TRUNC removes decimals without rounding

Answer

ROUND follows rounding rules (5 rounds up); TRUNC simply cuts off digits.

Question 4

What does the TEXT function do?

Accepted Answer

Formats a number as text using a format code

Answer

TEXT converts a numeric value to text with a specific format.

Question 5

How does AVERAGEIFS calculate its result?

Accepted Answer

Averages values where all corresponding criteria are met

Answer

AVERAGEIFS averages values in a range only where ALL corresponding criteria are satisfied.

Excel Practice Test