Multiple choice technology

To repeat the same work in all the sheets of a Excel Workbook

  1. Type it one sheet and Copy Paste in all the sheets

  2. Select all the sheets and type in one sheet, which will reflect in all the sheets

  3. No option

  4. None

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

By selecting multiple sheets (hold Ctrl/Cmd and click sheet tabs), you group them together. Any data entry or formatting applied to one sheet in the group automatically applies to all selected sheets simultaneously. This is more efficient than copying and pasting individually.