To copy formatting from one area in an Excel worksheet and apply it to another area, you would use
The Edit > Copy Format and Edit>Paste Format commands form the menu
The Copy and Apply Formatting dialog box, located under the Format > Copy and Apply menu
There is no way to copy and apply formatting in Excel – You have to do it manually
The Format Painter button on the standard toolbar
Correct answer is D
No explanation has been provided for this answer.