[Solved] To copy formatting from one area in a worksheet and apply it to another area you would use:

McqMate

Q.	To copy formatting from one area in a worksheet and apply it to another area you would use:
A.	The Edit>Copy Format and Edit>Paste Format commands form the menu.
B.	The Copy and Apply Formatting dialog box, located under the Format>Copy and Apply menu.
C.	There is no way to copy and apply formatting in Excel – You have to do it manually
D.	The Format Painter button on the standard toolbar
Answer» D. The Format Painter button on the standard toolbar

3.6k

0

Do you find this helpful?

40

View all MCQs in

Microsoft Excel (MS Excel)

Discussion

No comments yet

Related MCQs

To copy formatting from one area in a worksheet and apply it to another area you would use
In Excel say that you want to paste a formula result – but not the underlying formula – to another cell. In excel 2002, you would copy the cell with the formula, then place the insertion point in the cell you want to copy to what next?
You are editing an worksheet that you had previously saveIf you want to save the edited sheet without losing the original one, which command should you use?
In Excel which of these is a quick way to copy formatting from a selected cell to two other cells on the same worksheet?
Which of these is a quick way to copy formatting from a selected cell to two other cells on the same worksheet?
How should you print a selected area of a worksheet, if you’ll want to print a different area next time?
If you need to remove only the formatting done in a range (numbers and formula typed there should not be removed), you must
In Excel to drag a selected range of data to another worksheet in the same workbook, use the
To drag a selected range of data to another worksheet in the same workbook, use the
In Excel you can copy cell formats from one cell to another by using the