MCQs
11262 questions found
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
✓
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)
✓
