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

0%

0 0 0

Back Restart

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

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.

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

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.

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

to 1 decimal place

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

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

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

Any relevant answer is acceptable.

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.