TGT1

Find the youngest age from participant number 8 to 15.

• =YOUNGEST(C8:C15)

• =MIN(C9:C16)

• =YOUNGEST(C9-C16)

• =MIN(C8-C15)

Find the total age of Daisy, Gwen, and Stephanie.

• =C5+C6+C7

• =SUM(C5:C7)

• =14+10+4

• All answers are correct

Find the average age from participant 1 to 10.

• =AVERAGE(C2,C11)

• =AVERAGE(C2:C3:C4:C5:C6:C7:C8:C9:C10:C11)

• =AVERAGE(C2:C11)

• =AVERAGE(C2-C11)

Find the oldest age from participant number 3 to 8.

• =OLDEST(C3:C8)

• =MAX(C4:C9)

• =OLDEST(C4-C9)

• =MAX(C3-C8)

Find the age gap between the first participant and the last participant.

• =B15-B1

• =B16-B2

• =C15-C1

• =C16-C2

To count cells with numbers.

• SUM

• MIN

• MAX

• COUNT

Math operator to do division in a spreadsheet.

• *

• :

• ÷

• /

=B4 will results …

• 23

• 14

• Marty

• Daisy

=COUNT(B2:B16) will results …

• 15

• 0

• 14

• #ERROR!

=C6*5 will results …

• 50

• 30

• 20

• 10