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 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 permanently delete rows or columns
✓
B.
To format the appearance of cells
✓
C.
To temporarily hide certain data based on specific criteria
✓
