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
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