Test Y10: Spreadsheets

What is a data model? (1 mark)

Evaluate responses using AI:

OFF

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

Evaluate responses using AI:

OFF

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

Evaluate responses using AI:

OFF

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)

Evaluate responses using AI:

OFF

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

Evaluate responses using AI:

OFF

What is relative cell referencing? (1 mark)

Evaluate responses using AI:

OFF

What is absolute cell referencing? (1 mark)

Evaluate responses using AI:

OFF

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)

Evaluate responses using AI:

OFF

What are formulae in spreadsheet? (1 mark)

Evaluate responses using AI:

OFF