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

0%

0 0 0

Back Restart

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

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

Any reasonable answer!

Explain why you would create a data model.

to explore different possible answers

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.

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

Any relevant answer is acceptable.

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

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

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.

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.

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

to 1 decimal place