Microsoft Excel Formulas 4

Question 1

What does =TRIM(" Hello World ") return?

Accepted Answer

Hello World

Answer

TRIM removes leading and trailing spaces and collapses multiple internal spaces to a single space.

Question 2

Which function returns the largest value in a range?

Accepted Answer

Both A and C

Answer

Both MAX(range) and LARGE(range,1) return the largest value; MAX is the direct function while LARGE(range,1) specifies the 1st largest.

Question 3

What is the result of =TEXT(1234.5, "$#,##0.00")?

Accepted Answer

$1,234.50

Answer

TEXT converts a number to a formatted text string; the format code "$#,##0.00" produces "$1,234.50".

Question 4

How do you reference the entire column B in a formula?

Accepted Answer

B:B

Answer

Using B:B selects all cells in column B as a dynamic range reference.

Question 5

Which formula counts cells in A1:A20 that contain values greater than 50?

Accepted Answer

=COUNTIF(A1:A20,">50")

Answer

COUNTIF counts cells matching a single criterion; ">50" selects cells with values greater than 50.

Excel Practice Test