To combine cells A1:F1 into one centred cell for a title you use:

  1. Wrap Text
  2. Merge & Center
  3. Freeze Panes
  4. AutoFill
Answer

B) Merge & Center

Home → Alignment.

Computer Science MCQ · More Lab: MS Excel MCQs · Practise