A.
To permanently delete rows or columns
✓
B.
To format the appearance of cells
✓
C.
To temporarily hide certain data based on specific criteria
✓
A.
VLOOKUP retrieve data base on specified criteria from the most left column of the table, searching vertically down for a specified value.
✓
B.
VLOOKUP stands for “Value Lookup,” which searches horizontally across the top row of a table for a specified value.
✓
C.
VLOOKUP returns a value from the same row as the lookup value, but from a column specified by the user.
✓
D.
VLOOKUP scans the entire table and returns the first value found that matches the lookup criteria.
✓
B.
=LARGE(UNIQUE(A:A), 2)
✓
C.
=INDEX(SORT(UNIQUE(A:A), , -1), 2)
✓
D.
=SMALL(UNIQUE(A:A), 2)
✓
