MS Excel
To copy formatting from one area in a worksheet and apply it to another area you would use:

The Copy and Apply Formatting dialog box, located under the Format > Copy and Apply menu
The Edit > Copy Format and Edit>Paste Format commands form the menu
The Format Painter button on the standard toolbar
There is no way to copy and apply formatting in Excel – You have to do it manually

ANSWER DOWNLOAD EXAMIANS APP

MS Excel
How do you insert a row?

All of the listed here
Select the row heading where you want to insert the new row and select Edit >Row from the menu
Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar
Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu

ANSWER DOWNLOAD EXAMIANS APP