City Guilds Model Questions Vol1 2018 Information Technology Question 11

A spreadsheet contains the following data (columns A to E): - Row 2: Item = Pen, Quantity = 8, Unit Price = 120, Discount % = (determined by rule), Total = ? - Row 3: Item = Notebook, Quantity = 15, Unit Price = 250, Discount % = (determined by rule), Total = ? - Row 4: Item = Eraser, Quantity = 12, Unit Price = 50, Discount % = (determined by rule), Total = ? - Row 5: Item = Marker, Quantity = 5, Unit Price = 300, Discount % = (determined by rule), Total = ? The discount rule is: if the Quantity is greater than 10, a discount of 5 % is applied; otherwise no discount is given. The Total for each row is calculated as (\text{Total}=\text{Quantity}\times\text{Unit Price}\times(1-\text{Discount})\). What is the sum of the Total values for rows 2 to 5?