Spreadsheet Formulas Marvel Style

What is the formula to work out the MIN of the highlighted cells?

• =MIN(C1:Q1)

• =MIN(C15:Q15)

• =C15:Q15

• +MIN(E15:15)

Who is this?

• Robbie

• Rocket

• Ralph

• Ronldo

What is the formula to work out the MAX of the highlighted cells?

• =MAX(C1:Q1)

• =MAX(C15:Q15

• =(C15:Q15)

• =MAX(D2:D9)

Who is this?

• Captain America

• Captain Australia

• Captain Awesome

• Captain Marvel

What is the formula to work out the AVERAGE of the highlighted cells?

• =AVERAGE(C1:Q1)

• =AVERAGE(C2:C8)

• =AVERAGE(C15:Q15)

• =C15:Q15

What is average also known as in Mathematics?

• Mode

• Mean

• Median

• Many

Have you learnt something new in this lesson?

• Yes

• No

Is Captain America the best Avenger?

• Yes

• No