Posted: October 1st, 2022

EXCEL WEEKLY ACTIVITY (5%)

Read all instructions carefully – marks based on all steps and formats being complete. When complete e-mail ([email protected]) one Excel file (.xls) and one Word file (.doc) to me by 11:59pm on Friday.

PART ONE
Create a table in Excel with the title centered above the table in row 1, the years in column A starting in row 3 and the province titles in row 2 starting in B2:

Trips by Canadians in Canada (thousands)

2000 2001 2002 2003 2004
NL 3,955 3,902 3,784 3,236 3,107
PEI 977 966 1,125 897 911
NS 7,034 7,019 8,287 7,164 7,066
NB 4,794 5,344 6,075 5,613 5,038
QC 40,842 40,608 45,928 47,216 48,484
ON 65,220 67,160 70,257 62,168 65,290
MB 6,542 6,621 6,265 5,938 6,009
SK 8,222 8,139 8,029 7,413 7,451
AB 20,022 21,256 19,186 15,775 15,890
BC 20,893 20,984 18,842 16,742 15,738

• Center the data under the province titles
• Format the table design as desired
• Create a column chart in Excel including all titles and a legend
• Customize the chart (fonts, colours, background etc) – be creative.
• Give your Excel worksheet a name.
• Copy and paste the chart into Word.
• Save both the Excel and Word files.

PART TWO
Visit the Ministry of Tourism (Ontario) site:
• https://www.ontario.ca/page/tourism-research-statistics
• Go to – Quick Facts – find – Key Sources of Ontario’s Tourism Income
• Copy and paste the numbers for Ontario, US, Overseas and Canadian Provinces
• Highlight data, right click and copy
• Go to a new worksheet in the same Excel workbook and name it.
• Paste the data onto the new worksheet.
• Using that data, create a Pie Chart
• Input the title – Sources of ON’s Tourism Income
• Format the table and chart as desired
• Don’t forget recommendations about legend VS labels
• Don’t forget your source information (add the website link as a source)!
• Copy the chart into the same Word document

PART THREE
Look at the following data:

Percentage Share of Radio Listening, by Format and Audience Category, Fall

Teens Males Females
12 to 17 years 18 years and over
percent
Adult contemporary 25.1 17.3 27.8
Album oriented rock 7.4 7.2 3.3
Canadian Broadcasting Corporation 2.6 11.8 13.7
Contemporary 27.3 8.2 8.1
Country 7.7 8.8 10.5
Dance 2.7 0.4 0.5
Easy listening 1.1 3.3 4.2
Gold/oldies/rock 13.8 17.6 11.1
Middle-of-the-road 0.7 1.9 2.1
Other 4.3 7.4 6.1
Sports 0.6 2.6 0.5
Talk 1.8 10.7 9.6
U.S. stations 4.9 2.8 2.4
Total listening 100.0 100.0 100.0

 In the same Excel workbook but on a new sheet (name it), create a table comparing the radio listening preferences for males versus females
 From that table create a chart using the most appropriate format
 Include relevant titles and formats
 Copy and paste the chart into Word.
 Homework help – Write 2 observations about the chart just below where you pasted in Word.

Order | Check Discount