Question 2

Daniel James and three of his friends came up with the idea of starting a travel agency for college      
Students in Nigeria. They invested sixty thousand naira each and started their dream company,     SUMMER BREAK TRAVELS INC.
As sales continued to grow, the management of Summer Break Travel Inc. realized they need a better tracking system for First Quarter Sales.
Prepare a First Quarter Sales Worksheet that shows the sales for the first quarter using the details in Table 1.                                   
                                                                      Table 1

1.  Using function or formula, compute the total;
2. Sales at each marketing outlets;
3. Amount of money made for each vacation place.  (Note: create another column “total”)
4.  Format the table using the instruction below:
5. The title “Summer Break Travels, Inc. First Quarter Sales” should be bold and in upper case;
6. Under locations, all cells should be aligned left but total should aligned right;
7. Fill the table with white background 1 darker – 25”.
8. Create two charts for the first quarter sales:
9. A pie chart starting the most effective sales method;
10. A bar charts starting the most popular vacation place.
11. Type in the formula used in the calculating total for each location below your table (enclosed in “”).
12. Save, print out your work and submit to the supervisor.