Which of the following functions are text functions that convert the case of text? Select all the options that apply.

A) UPPER
B) LEN
C) LOWER
D) PROPER

To find the largest value in a cell range, use the MIN function.

Stephanie added data validation to a worksheet column after entering a few records of data.Which Excel feature can she use to locate data that doesn't satisfy the data validation criteria?

A) Tracer Arrows
B) Error Check
C) Watch Window
D) Circle Invalid Data

Which of the following is the newline character?

A) \r
B) \n
C) \l
D) \b