MS EXCEL QUIZ

none of above

255

8

3

Complex Formulas

Array formula

Smart Formula

Standard Formulas

Double clicking on the column name on column header

Double clicking on column right border on column header

Double click on the cell pointer in worksheet

Double clicking on the column left border of column header

To add borders

To add shading or color to a cell range

To select a distribution of figures

To insert a background

Statistical

Logical

Math & Trigonometry

Financial

Nothing the right mouse button is there for left handed people

Opens a shortcut menu listing everything you can do to the object

Selects the object

Deletes the object

Is defined by a bold border around the cell

Only A and B

Receives the data the user enters

It is the formula bar

Create and edit formula containing functions

Copy a range of cells

Enter assumptions data

Format cells containing numbers

Pressing the Tab key

Clicking on the formula bar

Pressing the Esc key

Pressing an arrow key

Enter the formula using any input values and the appropriate mathematical operators that make up your formula

Choose the new command from the file menu

Select the cell you want to place the formula into

Type the equals sign (=) to tell Excel that you’re about to enter a formula