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 use letters, absolute use numbers

Answer

Absolute are faster

Answer

No functional difference

Question 2

What does COUNTIFS do that COUNTIF cannot?

Accepted Answer

Apply multiple criteria across different ranges simultaneously

Answer

Count text cells

Answer

Count in multiple worksheets

Answer

Count unique values

Question 3

How does ROUND differ from TRUNC?

Accepted Answer

ROUND applies mathematical rounding, TRUNC removes decimals without rounding

Answer

ROUND works with negatives, TRUNC does not

Answer

They produce identical results

Answer

TRUNC is more precise

Question 4

What does the TEXT function do?

Accepted Answer

Formats a number as text using a format code

Answer

Converts text to numbers

Answer

Finds text in a cell

Answer

Compares text strings

Question 5

How does AVERAGEIFS calculate its result?

Accepted Answer

Averages values where all corresponding criteria are met

Answer

Averages all criteria values

Answer

Returns average of COUNTIFS and SUMIFS

Answer

Averages top and bottom only

Question 6

What does the UNIQUE function do in Excel 365?

Accepted Answer

Extracts distinct values from a range as a dynamic array

Answer

Removes duplicate formatting

Answer

Counts unique values

Answer

Merges duplicate rows