Spreadsheet revision

What is a fast way to add up the column of numbers?

• Click Subtotals on the Data menu.

• Click the AutoSum button on the Standard toolbar, then press ENTER.

• View the sum in the formula bar.

###### means:

• You've entered a number wrong.

• You've misspelled something.

• The cell is not wide enough.

A formula and function are the same thing

• True

• False

How do you change the column width to fit the contents?

• Single-click the boundary to the left of the column heading.

• Double-click the boundary to the right of the column heading.

• Press ALT and single-click anywhere in the column

Which formula can add all the numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell?

• Count

• Average

• Sum

In order to multiply items in Excel you would use:

• ^

• @

• *

• #

The formula = ((A2+B5)*5% is valid.

• True

• False

To return the remainder after a number is divided by a divisor in EXCEL we use the function?

• ROUND()

• FACT()

• MOD()

• DIV()

Which formula below will add the value of B2 to the value of C3

• =B2+C3

• =C3+B

• =6+4

• =B+C

A selection of multiple cells is called a

• GROUP

• REFERENCE

• RANGE

• PACKAGE