D.
A unit of formatting
✓
A.
To perform a vertical lookup and return a value based on a specified criteria
✓
B.
To perform a horizontal lookup and return a value based on a specified criteria
✓
C.
To add up a range of cells
✓
D.
To find the average of a range of cells
✓
A.
To perform a logical test and return a value based on the result
✓
B.
To add up a range of cells
✓
C.
To find the average of a range of cells
✓
D.
To count the number of cells in a range
✓
A.
To add up a range of cells
✓
B.
To find the average of a range of cells
✓
C.
To count the number of cells in a range
✓
D.
To find the maximum value in a range of cells
✓