Spreadsheet modelling 4

Name two formatting features used in ROW 1

• Border

• Font colour

• Merge & Center

• Italics

Write out the formula used in B14

• =AVERAGE(B3:B13)

• Sorting

• =MIN(B3:B13)

• =MAX(B3:B13)

• Filter

Write out the formula used in B15

• =AVERAGE(B3:B13)

• Sorting

• =MIN(B3:B13)

• =MAX(B3:B13)

• Filter

Write out the formula used in B16

• =AVERAGE(B3:B13)

• Sorting

• =MIN(B3:B13)

• =MAX(B3:B13)

• Filter

What is the name of the tool used to put students name in ascending or descending order?

• =AVERAGE(B3:B13)

• Sorting

• =MIN(B3:B13)

• =MAX(B3:B13)

• Filter

What is the name of the tool used to place student’s grades in order of position?

• =AVERAGE(B3:B13)

• Sorting

• =MIN(B3:B13)

• =MAX(B3:B13)

• Filter

What is the name of the function used in column C to check if a student has passed or failed?

• a.

  VLOOKUP

• b.

  SUMIF

• c.

  COUNTIF

• d.

  IF