2022 WAEC Computer Studies Practical 2. Daniel James and three of his friends came up with the idea of starting…

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 Travels Inc. realised 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 the table  below

                                                                                               Markerting outlets[#]

[a]   (a) Using function or fomula, compute the total:
         [i] sales at each marketing outlet; (ii)
         [ii] amount of money made for each vacation place. (Note: create another column “total”)

(b)     Format the table using the instruction below: ) the title “Summer Break  Travels, Inc.

          First Quarter Sales” should be Bold and in Upper Case;

         (ii) fill the table with white background 1 darker-25″

[c]      Create two charts for the first quarter sales: )

            [i] a pie chart stating the most effective sales method;

            [ii] a bar chart stating the most popular vacation place.
[d]        Type in the formula used in calculating total for each location below your table

            (enclosed in””)

[e]        Save, print out your work and submit to the supervisor.