Neco 2023 Data Processing Question 28

In a spreadsheet, column A lists items, column B the quantity, column C the unit price (in Naira). Cells B2‑B6 contain the quantities 3, 5, 2, 4, 6 respectively and cells C2‑C6 contain the unit prices 200, 150, 120, 180, 210 respectively. Cell D2 originally contains the formula =B2*C2 to compute the total price for the first item, and this formula is copied down to D6. The user inserts a new blank row between rows 3 and 4 (i.e., after the original row 3) and copies the formula from D3 into the new row 4, then drags the fill handle down to D7. a) After the insertion, what is the cell reference used in the formula now located in cell D5 (which corresponds to the original row 4 data)? b) Calculate the grand total of all items after the insertion (the sum of D2 through D7).