Test Y10: Spreadsheets

What is a data model? (1 mark)

What is a 'what if' modelling? (1 mark)

Give an example or a scenario when creating a data modelling would be beneficial? (1 mark)

Below is an example of contents of a spreadsheet, except

• number

• video

• text

• formula

You are instructed to calculate the multiplication of the content in cell A1 and A2. What is the formula should you use in cell A3? (1 mark)

Complete the arithmetic operators based on the operation in the picture. (5 marks)

What is relative cell referencing? (1 mark)

What is absolute cell referencing? (1 mark)

Sometimes individual cell or an area in spreadsheet is given a name. How can named cell benefit the overall spreadsheet? Give two reasons. (2 marks)

What are formulae in spreadsheet? (1 mark)