Multiple choice technology

Which of these is a quick way to copy formatting from a selected cell to two other cells on the same worksheet?

  1. Use CTRL to select all three cells, then click the Paste Button image button on the Standard toolbar.

  2. Copy the selected cell, then select the other two cells, click Style on the Format menu, then click Modify.

  3. Click Format Painter Button image on the Formatting toolbar twice, then click in each cell you want to copy the formatting to.

  4. Noneofthese
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The Format Painter tool copies formatting from a selected cell or range. Single-clicking Format Painter allows you to paint formatting once, while double-clicking keeps it active so you can apply the same formatting to multiple cells or ranges. This is exactly what the question requires for copying to two other cells.

Keep practicing — related questions