MS Excel
You can select a single range of cells by

Pressing the Shift key and an arrow key
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
Dragging over the desired cells
Pressing the Ctrl key while dragging over the desired cells

ANSWER DOWNLOAD EXAMIANS APP

MS Excel
Where can you set the shading color for a range of cells in Excel?

Choose required color on Fill Color tool in Formatting toolbar
All of above
Choose required color form Patterns tab of Format Cells dialog box
Choose required color on Fill Color tool in Drawing toolbar

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 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 Edit > Copy Format and Edit>Paste Format commands form the menu
The Format Painter button on the standard toolbar

ANSWER DOWNLOAD EXAMIANS APP