MS Excel
What does COUNTA () function do?

Counts empty cells
Counts cells having alphabets
Counts cells having number
Counts non-empty 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:

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

ANSWER DOWNLOAD EXAMIANS APP

MS Excel
You can select a single range of cells by

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

ANSWER DOWNLOAD EXAMIANS APP

MS Excel
How do you select an entire column?

Hold down the shift key as you click anywhere in the column
Hold down the Ctrl key as you click anywhere in the column
Click the column heading letter
Select Edit > Select > Column from the menu

ANSWER DOWNLOAD EXAMIANS APP