USING MICROSOFT EXCEL
HOW TO INSERT HEADERS FOOTERS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which of these is a quick way to copy formatting from a selected cell to two other cells on the same worksheet?
|
|
Use Ctrl to select all three cells, then click the paste button on the standard toolbar
|
|
|
Copy the selected cell, then select the other two cells, click style on the Format menu, then click Modify
|
|
|
Click format painter on the Formatting toolbar twice then click in each cell you want to copy the formatting to
|
|
|
All of above
|
Explanation:
Detailed explanation-1: -Use Format Painter to quickly apply the same formatting, such as color, font style and size, or border style, to multiple pieces of text or graphics. With format painter, you can copy all of the formatting from one object and apply it to another one-think of it as copying and pasting for formatting.
Detailed explanation-2: -Click in text that has the formatting to replicate, and press CTRL-SHIFT-C. It’ll copy the formatting, but not the text itself. Highlight the target text and press CTRL-SHIFT-V to paste the formatting.
There is 1 question to complete.