Spreadsheet Assignment #2: Car Count (Feedback/Formative)
PROGRAMS: MS Excel SKILLS: Addition, Pie Chart, Column Chart You have just been given a summer job by a local car dealership to monitor the number of cars and their colour as they pass through a local intersection. In order to impress your new boss, you decide to present the information in a spreadsheet. Create an Excel spreadsheet with the following information and use formulas to complete the totals. Notice that the font is set for Ariel 12 point. Your font is probably set for Ariel 10 point. Select all of the cells and change to a 12 point font. You should do this for all of your Excel assignments. To insert a formula in G2:
AutoSum:
Note that you should have a total in cell G8. This total can either be the total of the days, or the total of colours – both values should be the same.Graphs As impressive as your grid of numbers is, you decide to take it up a notch and provide some charts. Use this site to learn how to include a pie graph of the colour totals and a column chart of the totals for each day. Your finished document should look similar to the example below (with the totals completed by formula). Double click, or right click on individual parts of the graph to change their colour or appearance. When you feel you are complete, check your letter against theĀ car count checklist! When you are satisfied with your assignment, hand in the completed document to the appropriate In Basket folder. (Remember to save it lastname,firstname…) |