4e Absolute and relative cell referencing ***

Question 0

Using examples related to the landscape gardening business, describe how Miss Jones could use absolute and relative cell references.

Answer 0

2 marks for each eg:

Absolute:
Store pay per hour (1) for each of the employees (1)
Store VAT rate (1) to apply to all bills (1)

Relative:
Adding numbers of hours worked in a week (1) for each employee (1)
Adding sales of each plant (1) for a given week (1).

Question 1

Describe absolute and relative referencing and give examples of each relating to the wages spreadsheet.

Answer 1

2 marks for absolute, 2 marks for relative.
1 mark for description, 1 for example.

Absolute
When cell is copied absolute reference remains the same (1) Calculating pay per day using amount per hour as absolute reference (1)

Relative
When cell is copied relative reference changes (1)
Adding up hours worked for a week relative is days (1)