29 Right click on the button below and select “open link…
29 Right click on the button below and select “open link in a new tab” to view the table which represents a spreadsheet, answer all of the questions below. 29.1 Using a formula (unit price x quantity) to calculate the subtotal of each of the actual purchases. Place your answer in D6 (2) 29.2 Using a formula calculate the totals of the each of the food items (place your answers in F6. (1) 29.3 Calculate the total shopping bill (place your answer in F15) (2) 29.4 Using a function determine the quantity of different items in the cart. Place your answer in F16 (2) 29.5 Using a function to determine what the price of the most expensive item. Place your answer in F17. Use the unit price. (2) 29.6 Using a function to add in today’s date. Place your answer in F2. (2)