MS Excel
Which button do you click to add up a series of numbers?

The quicktotal button
The Formula button
The autosum button
The total button

ANSWER DOWNLOAD EXAMIANS APP

MS Excel
You can select a single range of cells by

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

ANSWER DOWNLOAD EXAMIANS APP

MS Excel
Which of the following is a correct order of precedence in formula calculation?

Multiplication and division exponentiation positive and negative values
Multiplication and division, positive and negative values, addition and subtraction
None of the listed here
Addition and subtraction, positive and negative values, exponentiation

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 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 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

ANSWER DOWNLOAD EXAMIANS APP