Formulas Flashcards

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

Answer: Hello World

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

Which function returns the largest value in a range?

Answer: Both A and C

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

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

Answer: $1,234.50

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

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

Answer: B:B

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

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

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

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

What does the TRANSPOSE function do when entered as an array formula?

Answer: Converts rows to columns and columns to rows

TRANSPOSE swaps the orientation of a range, turning rows into columns and vice versa.

Which formula returns the number of characters in the text string in cell A1?

Answer: =LEN(A1)

LEN returns the number of characters in a text string, including spaces.