Spreadsheet Revision | Baamboozle - Baamboozle | The Most Fun Classroom Games!

Team 1
0

Team 2
0

Teams

Name

Score

Loading

A cell contains the function =COUNTIF($F$16:$F$26,"Master craftsman") Using cell references, explain what this function does.

It counts the number of times the text “Master craftsman” is stored in the cells between F16 and F26.

Oops!

Check

Okay!

Check

Give me one formatting that had been applied in this spreadsheet model.

Any reasonable answer!

Oops!

Check

Okay!

Check

trap

No points!

Oops!

rocket

Go to first place!

Okay!

gift

Win 25 points!

Okay!

baam

Lose 20 points!

Oops!

What would be displayed in cell A1 if it was formatted:

to 1 decimal place

Oops!

Check

Okay!

Check

Explain, when using a spreadsheet, the term ‘function’.

A function has a pre-defined name which performs a calculation/operation.

Oops!

Check

Okay!

Check

Explain this formula! "=IF(A1=5,A2*0.05,"No discount")".

Any relevant answer is acceptable.

Oops!

Check

Okay!

Check

Explain why you would create a data model.

to explore different possible answers

Oops!

Check

Okay!

Check

seesaw

Swap points!

Oops!

seesaw

Swap points!

Okay!

gift

Win 20 points!

Okay!

thief

Give points!

Explain the difference between absolute and relative cell references.

Absolute referencing for a cell will fix that cell name/address and Relative referencing will allow cell names/addresses to be changed when formula is copied.

Oops!

Check

Okay!

Check

Describe how you would display the formulae used in a spreadsheet rather than the values.

Select the Formulas tab. In the Formula auditing section. Click on the Show Formulas icon.

Oops!

Check

Okay!

Check

baam

Lose 10 points!

Oops!

rocket

Go to first place!

Okay!

gift

Win 5 points!

Okay!

banana

Go to last place!

Oops!

Cell C3 contains the formula =SUMIF($F$3:$F$23,A3,$G$3:$G$23) Using cell references explain what this formula does.

Oops!

Check

Okay!

Check

Restart Join for Free

;

Your experience on this site will be improved by allowing cookies.