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) Which of the following is the oldest spreadsheet package?
2) Which of following is Not one of Excel’s what-if function?
3) How many characters can be typed in a single cell in Excel?
4) How we can view a cell comment ?
position the mouse pointer over the cell
click the comment command on the view menu
click the edit comment commands on the Insert menu
click the Display comment command on the window menu
View Answer
5) When creating a vertical page break ?
The active cell must be in row 1
The active cell must be A1
The active cell must be in row 10
The active cell must be in column A
View Answer