Spreadsheets – Assignment V2 Instructions 1. Download and open the…
Question Answered step-by-step Spreadsheets – Assignment V2 Instructions 1. Download and open the… Spreadsheets – Assignment V2Instructions1. Download and open the data file provided and Save the workbookas First Name Last Name Student # – Assignment in our course folder. (1mark)2. Change the theme of the workbook to Ion. (2 Marks)3. In the Documentation sheet, enter your name in cell B3 and date in B4. (2Marks)4. Go to Order Form worksheet. In G31, calculate the sum of the item chargesfrom all possible orders. (2 Marks)5. In G32, calculate the sales tax on the order which is subtotal multiplied bythe tax rate entered in cell J9. (2 Marks)6. In cell C14, enter a function to insert the current date. (1 Mark)7. In cell C15, enter Standard as the type of delivery for this order. (1 Mark)8. In cell C16, calculate the number of working days it will take to ship the orderby inserting a VLOOKUP function using an exact match. Use C15 as thelookup value, and shipping data in the range I3:K6 as the lookup table.Return the value from the third column of the table. (4 Marks)9. In cell C17, estimate the date of delivery. Use C14 as the start date and C16as the number of working days after the start date. (2 Marks)10. In G33, calculate the shipping and handling fee for the order using an exactmatch Lookup with the data in the range I3:J6. Use the delivery methodspecified in C15 to find the corresponding shipping and handling fee in theDelivery table. (4 Marks)11. In G35, calculate the total by adding subtotal, sales tax, and shipping andhandling fee. (3 Marks)12. Merge and center Product List in the range I18:K18. Apply the Title cell style.(2 Marks)COMP1080 – Spreadsheets – Assignment V213. Apply thin inside and thick outside borders to the range I19:K29 (2 Marks)14. In Cells J31:34, use proper functions to calculate for Total Items, AveragePrice, Highest and Lowest Price. (8 Marks)15. Apply the Format of E31:G33 to the range I31:J34. Use proper numberformat. (2 Marks)16. Use conditional formatting feature to format the prices over $300 in therange K20:K29 with light red fill with dark red text. (3 Marks)17. Adjust the scaling so that the data fits on one page. Create a header withyour name on the right section and a footer with the sheet name code on theleft and file name code on the right section. (3 Marks Engineering & Technology Computer Science COMPUTER A 108 Share QuestionEmailCopy link Comments (0)
