MCQs
11212 questions found
A.
To combine multiple text strings into one.
✓
B.
To split the contents of one cell into separate columns.
✓
C.
To change the font color of text.
✓
D.
To wrap text within a cell.
✓
A.
It changes when a formula is copied to another cell.
✓
B.
It remains constant when a formula is copied to another cell.
✓
C.
It refers to a cell on another worksheet.
✓
D.
It refers to a cell in a different workbook.
✓
B.
Conditional Formatting
✓
A.
To combine cells and align text to the left.
✓
B.
To combine cells and center the content in the new, larger cell.
✓
C.
To separate merged cells.
✓
D.
To apply a border to cells.
✓
A.
Counts the number of empty cells.
✓
B.
Counts the number of cells that contain any type of data (non-empty).
✓
C.
Counts the number of cells that contain only text.
✓
D.
Counts the number of columns.
✓
A.
Counts the number of cells that contain numbers.
✓
B.
Counts the number of cells that are not empty.
✓
C.
Counts the number of cells that contain text.
✓
D.
Counts the number of rows.
✓
D.
Conditional Formatting
✓
