WAEC offline past questions - with all answers and explanations in one app - Download for free
WAEC May/June 2024 - Practice for Objective & Theory - From 1988 till date, download app now - 99995

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

Computer Studies
WAEC 2022

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[#]

location[vacation place] mail campus telephone internet
bar beach 5,297.23 3,871.35 4,720.45 2,998.65
trans amusement park ibadan 2,823.23 4,840.53 2,703.56 4,911.16
agodi gardens 6,256.25 7,256.12 2,436.86 7,709.32
obudu park calabar 2,856.15 437.20 4,997.60 1,201.45
total        

 

[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.

 

Post-UTME Past Questions - Original materials are available here - Download PDF for your school of choice + 1 year SMS alerts
WAEC Past Questions, Objective & Theory, Study 100% offline, Download app now - 24709
WAEC offline past questions - with all answers and explanations in one app - Download for free
Explanation

 

            Table 1                                                           markerting outlets [#]

location mail  campus telephone internet total
bar beach lagos 5,297.23 3,871.35 4,720.45 2,998.65 16,887.68
trans amusement park ibadan

2,823.23

4,840.53 2,703.56 4,911.16 15,278.48
agodi gardens 6,256.25 7,256.12 2,436.86 7,709.32 23,657.55
obudu park calabar 2,856.15 437.20 4,997.60 1,201.45 9,492.40
total 17,232.86 16,405.20 14,857.47 16,820.58  
           

   

=SUM[B4:B7]

=SUM[B4:E4]

    SUMMER BREAK TRAVELS ,INC FIRST QUARTER SALES 

Open photo

                             Markerting outlets[#]

Bar beach lagos               

trans amusement park ibadan

Agodi gardens                     

obudu park calabar

 

            Markerting outlets [n] mail

            location[vacation place]

         Open photo  

 


Report an Error Ask A Question Download App
WAEC offline past questions - with all answers and explanations in one app - Download for free
WAEC Past Questions, Objective & Theory, Study 100% offline, Download app now - 24709
Post-UTME Past Questions - Original materials are available here - Download PDF for your school of choice + 1 year SMS alerts

Contributions ({{ comment_count }})

Please wait...

{{ settings.no_comment_msg ? settings.no_comment_msg : 'There are no comments' }}

Quick Questions

Post your Contribution

Please don't post or ask to join a "Group" or "Whatsapp Group" as a comment. It will be deleted. To join or start a group, please click here

{{ quote.posted_by.display_name }}
{{ settings.form_textarea_description }}
 
Post-UTME Past Questions - Original materials are available here - Download PDF for your school of choice + 1 year SMS alerts
WAEC offline past questions - with all answers and explanations in one app - Download for free
WAEC Past Questions, Objective & Theory, Study 100% offline, Download app now - 24709
WAEC May/June 2024 - Practice for Objective & Theory - From 1988 till date, download app now - 99995
WAEC May/June 2024 - Practice for Objective & Theory - From 1988 till date, download app now - 99995
Post-UTME Past Questions - Original materials are available here - Download PDF for your school of choice + 1 year SMS alerts
WAEC offline past questions - with all answers and explanations in one app - Download for free
WAEC Past Questions, Objective & Theory, Study 100% offline, Download app now - 24709