USING MICROSOFT EXCEL
HOW TO INSERT HEADERS FOOTERS IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
True
|
|
False
|
|
Either A or B
|
|
None of the above
|
Detailed explanation-1: -Copy Conditional Formatting Using Format Painter Format painter is a tool that allows you to copy the format from a cell (or range of cells) and paste it. And since conditional formatting is also a part of the formatting, you can also use format painter to copy and then paste it.
Detailed explanation-2: -Select the cell with the formatting you want to copy. Select Home > Format Painter. Drag to select the cell or range you want to apply the formatting to. Release the mouse button and the formatting should now be applied.
Detailed explanation-3: -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-4: -The Format Painter allows you to copy formulas from one cell to another cell or group of cells.