please answer as quickly as possible. in 20 mins time.

Use a new workbook and save it as your student 10=(eg.20201234) \& then construct a worksheet with the data given \& save it as LYONS, (5 marks) LYONS INC Orange JUiCE sales INSTRUCTIONS - Markup Cost price / Litre x35% 1. The MAPKUP s. 13535 trust be a separate cetll under the hesding. USE It as an abiolute cell feferene to ealculate the markup per itemi. (b marks) 2. Calculate the inark up for each item 15 marks] 3. Calculate the seang price for each item, 15 maris] 4. Caiculate the Total incomme for each isem. [5 marks) 5. Calculate the proflit for each item. (s marks! 6. Format the column UTRES SOta to display the number of lites as integers. The fest of the workbeet must be formathed to display two decimals. [4 marks] 7. Within the Product Column, lype Orange fuice belween Xtra and Sun Splash with the font bold, italic and the colour orange [4 maiks) 8. Use statistical functions to ealculatie the of AVERAGE Selling Price io HiStiest Profis (3) LBNEST cost Pice per Litre. [G marks] 19. Using the Products column, determine how many products ane laged? [2 matiat. 10. After the Prant column add a Status column. Once the selling price is greater than ot equal to the average sefling price, she status thould show 'Good Sales"; otherwise it should show, "Bad Sales'. [7 marks] 11. Use conditional formatting for the: o Litres Sold between $150 and $350 with a Veflow fid with Dark Yellow text. I4 marko! o. Frotit below anerige, cuntomized with a Black fill with Derk Yellow text. It marks] 12 Sort by the Mark-tap per tem in ascending oeder [2 marks] 13. Put borders neatly on the work theet [2 marki] 14. Under the workshet create a propely labelles 30 pie chat teled PFDDUCT PAR PROHT for Procuct a Prodit columnt Oata labe's indicating pertentaget should be displayed with the iegend to the ieft. 5 marki] 15. Show all formulai you have used in a new theet. Adgiat the colkimn wigth so that the formidae ae diaployed an hat and the stoects tits into one piofe of A4 landscape format and ave it as formulas [10 mackil Remember to save your workbook as your student 10 in (e.g. 20201234 ) and ensure that you upload it befare your Use a new workbook and save it as your student 10=(eg.20201234) \& then construct a worksheet with the data given \& save it as LYONS, (5 marks) LYONS INC Orange JUiCE sales INSTRUCTIONS - Markup Cost price / Litre x35% 1. The MAPKUP s. 13535 trust be a separate cetll under the hesding. USE It as an abiolute cell feferene to ealculate the markup per itemi. (b marks) 2. Calculate the inark up for each item 15 marks] 3. Calculate the seang price for each item, 15 maris] 4. Caiculate the Total incomme for each isem. [5 marks) 5. Calculate the proflit for each item. (s marks! 6. Format the column UTRES SOta to display the number of lites as integers. The fest of the workbeet must be formathed to display two decimals. [4 marks] 7. Within the Product Column, lype Orange fuice belween Xtra and Sun Splash with the font bold, italic and the colour orange [4 maiks) 8. Use statistical functions to ealculatie the of AVERAGE Selling Price io HiStiest Profis (3) LBNEST cost Pice per Litre. [G marks] 19. Using the Products column, determine how many products ane laged? [2 matiat. 10. After the Prant column add a Status column. Once the selling price is greater than ot equal to the average sefling price, she status thould show 'Good Sales"; otherwise it should show, "Bad Sales'. [7 marks] 11. Use conditional formatting for the: o Litres Sold between $150 and $350 with a Veflow fid with Dark Yellow text. I4 marko! o. Frotit below anerige, cuntomized with a Black fill with Derk Yellow text. It marks] 12 Sort by the Mark-tap per tem in ascending oeder [2 marks] 13. Put borders neatly on the work theet [2 marki] 14. Under the workshet create a propely labelles 30 pie chat teled PFDDUCT PAR PROHT for Procuct a Prodit columnt Oata labe's indicating pertentaget should be displayed with the iegend to the ieft. 5 marki] 15. Show all formulai you have used in a new theet. Adgiat the colkimn wigth so that the formidae ae diaployed an hat and the stoects tits into one piofe of A4 landscape format and ave it as formulas [10 mackil Remember to save your workbook as your student 10 in (e.g. 20201234 ) and ensure that you upload it befare your