To create the series 5, 10, 15 … 100 you can use:

  1. Wrap Text
  2. Fill → Series with step value 5 and stop value 100
  3. Merge & Center
  4. Sort A to Z
Answer

B) Fill → Series with step value 5 and stop value 100

Linear series with a step.

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