🧮

Quiz: Spreadsheet Modelling

What-if analysis and absolute references

Practice mode — answer at your own pace. Your teacher may also set this quiz as an assignment.

0 / 5 answered

Q1.What does an absolute reference like $B$2 do when copied?

Q2.What does a relative reference do when copied down a column?

Q3.What is the correct structure of an IF statement?

Q4.What is an input cell in a model?

Q5.What is "what-if analysis"?

Answer all questions to finish.