Excel Assignment – Gala Raffle Sales
Excel Assignment – Gala Raffle Sales
Computers, Mr. Martin
March 2010
Prepare an Excel Worksheet with rows with the following headings: Grade, No. of Tickets, No. of Students, Tickets/Student, Percent of Total, $/Class and $/Student. You will use the ticket data sales for each class and the number of students in each class. You should present this data as shown in the image below.
Now, begin by first calculating the total ticket sales by highlighting the numbers in row 2 and then hit the Summation symbol on the standard tool bar. The summation symbol is the Greek Letter Epsilon ((). The sum of the numbers should appear in Cell K2. Next, calculate the total students in a similar manner. The sum of the students will go in Cell K3.
You should complete row 4 by diving the tickets by the students giving you the Tickets/Student (or Tickets per Student). You can do this by highlighting the blanks in row 4 through column K (that tells Excel where you want the answers), clicking on the calculator (to get the formula bar with the calculator go to view – formula bar), highlighting the numbers in row 2, click the division key on the calculator, highlight the numbers in row 3, and click the “Okay” button.
You will find the percent of total in row 5 by highlighting the blanks in row 5 up to column K (that tells Excel where you want the answers), clicking on the calculator, highlighting the numbers in row 2, clicking the division key on the calculator, enter the number in cell K2, and clicking okay.
To find the $/class multiply the ticket sales for each class by $5. To find the $ per student, divide the $/class by the number of students in each class. You should know how to do these two calculations by your work above.
Once you have completed the worksheet, make two column graphs showing (1) the ticket sales for each class, and (2) the tickets/student for each class. The classes or grades will be on the horizontal or x axis and the tickets will be on the vertical or y axis. Be sure to give each chart a title and label the x and y axes. Do not include the Legend. Save each chart as an object in sheet 1 and position them nicely so I can readily view each under the calculations.
Save you file as your grade, your last name, raffle. For example, 8smithraffle.xls. Turn the saved worksheet into the server folder for your class. (I.e. 8th grade in Class 2010, 7th grade in Class 2011, and 6th grade in Class 2012.)
As a separate and subsequent assignment, I will have you analyze you findings in a Word document.
-----------------------
[pic]
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related searches
- winter gala themes
- microsoft excel sales tracking spreadsheet
- percent of sales excel formula
- excel sales discount formula
- raffle winner picker
- raffle picker app
- raffle ticket winner generator
- raffle winner generator
- raffle app for pc
- online raffle generator
- random raffle picker
- excel inventory and sales template