KS3 Spreadsheets 2 - Formulas and functions

What formula should be used in cell D4?

• =B4+C4

• =B4*C4

• =B4/C4

• =B4-C4

Type the formula that should appear in cell D4.

What is happening in this spreadsheet?

• A formula is being replicated

• A formula is being duplicated

• A formula is being copied

• A formula is being moved

What formula should be used in cell D8?

• =SUM(D4+D7)

• =SUM(D4:D7)

• =SUM(D4+D5+D6+D7)

• =SUM(D4:D8)

What is missing from the formula for cell D8?

=___(D4:D7)

Cell D8 should contain a function. What kind?

• =SUM

• =AVERAGE

• =MIN

• =MAX

Which month is the wettest?

• January

• February

• March

• April

• May

Which month is the least windy?

• January

• February

• March

• April

• May

Which month is the least windy?

• January

• February

• March

• April

• May

What function should be used in the cells in row 17?

• =SUM

• =AVERAGE

• =MAX

• =MIN