Choose the correct answer

The intersection of a row and a column is called:

• Row

• Cell

• Column

When you are typing an equation into a cell the first thing that must be entered is:

• a) the first cell referenced

• b) quotation marks

• c) an equal sign

• d) parenthesis

The cell labeled F5 refers to:

• a) row F column 5

• b) column F row 5

• c) functions available in cells

• d) Function key F4

Labels are used in a spreadsheet to:

• a) tell the computer what we are doing.

• b) help us identify the information.

• c) do the calculations.

• d) set up the equations.

In a spreadsheet, to multiply 10 by 4 you would use:

• =10*4

• =10x4

• 10*4

• =10/4

To divide cell C5 by cell D2 you would use:

• =C5*D2

• =C5/D5

• C5/D5

• C5*D5

To find average of B2, C2 and D2 you would use:

• =B2+C2+D2/3

• =SUM(B2+C2+D2)/3

• =AVERAGE(B2:D2)

• =(B2:D2)/3

To add together B2, C2, D2 and E2 you would use:

• =SUM(B2:E2)

• B2+E2

• =B2-E2

• =B2*E2

All formulas must start with:

• &

• =

• (

• ?

To find Maximum of B2, C2 and D2 you would use

• =B2+C2+D2

• =Sum(B2:E2)

• Min(B2:E2)

• =Max(B2:D2)