Module 2.2 Spreadsheet Exercise Note that the weekly spreadsheet exercise is designed to help you complete your Excel assessment. This week we will be focusing on FORMULAS in Excel. A formula is an equation that performs calculations between cells in a worksheet or table. A formula in Excel always begins with an equal sign. A simple formula may contain cell references and operators. Instructions: ⦁ Use the Excel sheet you created in Week 3. ⦁ Read the Basic Skills in Using Excel 2013. Pdf. (pages 9-13) provided during week 3. However, if you prefer watching the video on how to use Excel, go to this website: Introduction to Excel - https://www.youtube.com/watch?v=J4zq3R8b5dQ ⦁ Using the excel worksheet you have created in week 3, add a column at the end and name it fee paid (Note that participants may pay different registration fee depending on their financial circumstances, that is, discounts are given to some participants) ⦁ Add 5 sample data in your spreadsheet ⦁ Create another tab in your excel document and call the worksheet Race-budget, ⦁ Create a table that looks like this: ⦁ Under the Income/Funding table, add to the description the data "Registration" ⦁ In the registration row, add the unit cost of $145 and estimated quantity of 200. Your excel sheet should look similar to this: ⦁ Compute the estimate amt by using the formula : unit cost * estimate qty (create this formula in the estimate amount cell; excel should automatically compute the estimated amount) ⦁ Compute for the actual number of registration. CountA is a predefined excel formula that counts cells that are not empty, you can use this to count the number of people who registered for the event (refer to the Basic Skills in Using Excel 2013. pdf or https://www.youtube.com/watch?v=J4zq3R8b5dQ) to learn how to use formula. ⦁ Using the sum excel formula, compute the total of the estimated amount, and the total of the actual amount. ⦁ Your excel worksheet should look similar to this (amount reflected will be different because you have a different set of data): compute the sum of these cells compute the sum of these cells ⦁ Add more data in the description column (jersey, caps, minor sponsors and major sponsors) ⦁ Add data to the unit cost, estimate qty, actual qty and actual amount for jersey, caps, minor sponsors and major sponsors Your excel worksheet should look similar to this: ⦁ Save your Excel workbook. ⦁ Document either in Excel or in a Word document the step you undertook in producing the Spreadsheet. Save your document. ⦁ BACK-UP! BACK-UP! BACK-UP! Do not forget to keep a back-up files. Either upload in your google drive or dropbox; and/or just e-mail the file to yourself so that you have a copy in your email; and/or save in a USB drive. ⦁ You can show your work to your lecturer for feedback. ⦁ REMEMBER THAT THIS EXERCISE IS PART OF THE FINAL EXCEL SPREADSHEET ASSESSMENT YOU HAVE TO SUBMIT ON WEEK 7.