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 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 on the Formatting toolbar twice, then click in each cell you want to copy the formatting to.

  4. All of the above
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Format Painter copies formatting from one cell to others. Double-clicking Format Painter keeps it active for multiple cells. Clicking once applies it once; double-clicking allows applying to multiple cells sequentially.

Keep practicing — related questions