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.
✓
