To copy formatting from one area in a worksheet and apply it to another area you
Home | Discussion ForumFree Online Test
To copy formatting from one area in a 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
Answer : D
Free Online Test
View More Related Question
1) All worksheet formula
2) What is the short cut key to replace a data with another in sheet?
3) Data can be arranged in a worksheet in a easy to understand manner using
4) Which of the following will not cut information?
Pressing Ctrl + C
Selecting Edit>Cut from the menu
Clicking the Cut button on the standard
Pressing Ctrl+X
View Answer
5) To convert a column of data into row, which command will you choose
