needed asap

Part A 1. Open a new workbook and create a spreadsheet that looks like the following: 2. Enter a simple formula in cell E3 to work out Marion's final score. 3. Calculate final scores for all the other darts players. 4. Make the titles of the spreadsheet Bold and underlined border in Red. 5. Save the file as Darts 6. On a new row, add the name Elizabeth-Jane and scores of 11, 15 and 20. 7. Widen column A to display all names fully. 8. .Calculate Elizabeth-Jane's final score in E8. 9. Change Steve's 'Score 2' to 9 and check that his final score updated automatically. 10. Submit the Excel File in Assignment 1 Drop Box. work out Marion's final score. 3. Calculate final scores for all the other darts players. 4. Make the titles of the spreadsheet Bold and underlined border in Red. 5. Save the file as Darts 6. On a new row, add the name Elizabeth-Jane and scores of 11, 15 and 20. 7. Widen column A to display all names fully. 8. .Calculate Elizabeth-Jane's final score in E8. 9. Change Steve's 'Score 2' to 9 and check that his final score updated automatically. 10. Submit the Excel File in Assignment 1 Drop Box. Part B Open a new workbook and create a spreadsheet based on the following information from your grocery shopping: 1. Worksheet title: SHOPPING (\$)Number Final Price (\$) 3. Items purchased include: i) 10 packets of Cat food at 0.40 ii) 4 litres of Milk at 0.38 iii) 2 loaves of Bread at 0.87 iv) 1 jar of Marmalade at 1.15v)3 packages of Pasta at 0.56vi)2 Pineapples at 1.30 vii) 3 bottles of Lemonade at 0.892. 4. Enter a simple formula in cell D3 to calculate the final price of Cat-food. 5. Work out the final price for all other items. 6. Format the titles of the spreadsheet so that they stand out from the shopping items. 7. Save the file as Shopping on your network drive. 6 . Now amend the entry in cell C2 to read Number Bought and 6. Format the titles of the spreadsheet so that they stand out from the shopping items. 7. Save the file as Shopping on your network drive. 6 . Now amend the entry in cell C2 to read Number Bought, and widen columns C and D to display the full entries. 8. Make the following changes: Pasta costs 49 cent; replace Pineapple with Melon; and increase the number of litres of Milk bought to 6 . 8. Check that the final prices are updated automatically and print a copy of the amended spreadsheet. 9. Insert an additional item between Pasta and Melon for 2 jars of Pasta Sauce at $2.50 each. 10. Add the word TOTAL in cell C11. 11. Enter a simple formula to add up the total cost of all of the items in D11. 12. Create a border with a single top line and double bottom line in Red in cell D11. 13. Save and submit the file