MS Excel
You can select a single range of cells by

Pressing the Shift key and an arrow key
Dragging over the desired cells
Clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells
Pressing the Ctrl key while dragging over the desired cells

ANSWER DOWNLOAD EXAMIANS APP

MS Excel
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 Format Painter button on the standard toolbar
There is no way to copy and apply formatting in Excel – You have to do it manually
The Copy and Apply Formatting dialog box, located under the Format > Copy and Apply menu

ANSWER DOWNLOAD EXAMIANS APP