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) To save a workbook, you:
Click the save button on the standard toolbar from the menu
Press Ctrl+F5
Click Save on the Windows Start button
Select Edit>Save
View Answer
2) What will be the output if you format the cell containing 5436.8 as '#,##0.00' ?
3) The default style for new data keyed in a new workbook is ?
4) To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the
Unfreeze panes command on the window menu
Freeze panes command on the window menu
Hold titles command on the edit menu
Split command on the window menu
View Answer
5) All worksheet formula
