MCQs
11212 questions found
A.
Looks for a value in the leftmost column of a table, and returns a value in the same row from a column you specify.
✓
B.
Looks for a value in the top row of a table, and returns a value in the same column from a row you specify.
✓
C.
Adds values vertically.
✓
D.
Validates data entry.
✓
C.
Ctrl + Shift + + (plus)
✓
D.
Ctrl + Shift + - (minus)
✓
C.
Ctrl + Shift + + (plus)
✓
D.
Ctrl + Shift + - (minus)
✓
C.
Conditional Formatting
✓
A.
To color-code cells.
✓
B.
To restrict the type of data or values that users enter into a cell.
✓
C.
To automatically correct spelling errors.
✓
D.
To analyze large datasets.
✓
A.
It adjusts the column width to fit the text.
✓
B.
It allows text to extend beyond the cell boundary.
✓
C.
It wraps long text within a cell so that it appears on multiple lines.
✓
D.
It rotates the text within the cell.
✓
