Posted: October 1st, 2022

EXCEL WEEKLY ACTIVITY (5%)

Learn all directions fastidiously – marks based mostly on all steps and codecs being full. When full e-mail (dana.winkler@georgiancollege.ca) one Excel file (.xls) and one Phrase file (.doc) to me by 11:59pm on Friday.

PART ONE
Create a desk in Excel with the title centered above the desk in row 1, the years in column A beginning in row three and the province titles in row 2 beginning in B2:

Journeys by Canadians in Canada (hundreds)

2000 2001 2002 2003 2004
NL three,955 three,902 three,784 three,236 three,107
PEI 977 966 1,125 897 911
NS 7,034 7,zero19 eight,287 7,164 7,066
NB four,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 eight,222 eight,139 eight,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

• Heart the information below the province titles
• Format the desk design as desired
• Create a column chart in Excel together with all titles and a legend
• Customise the chart (fonts, colors, background and so forth) – be artistic.
• Give your Excel worksheet a reputation.
• Copy and paste the chart into Phrase.
• Save each the Excel and Phrase recordsdata.

PART TWO
Go to the Ministry of Tourism (Ontario) website:
• https://www.ontario.ca/web page/tourism-research-statistics
• Go to – Fast Information – discover – Key Sources of Ontario’s Tourism Revenue
• Copy and paste the numbers for Ontario, US, Abroad and Canadian Provinces
• Spotlight information, proper click on and replica
• Go to a brand new worksheet in the identical Excel workbook and title it.
• Paste the information onto the brand new worksheet.
• Utilizing that information, create a Pie Chart
• Enter the title – Sources of ON’s Tourism Revenue
• Format the desk and chart as desired
• Don’t neglect suggestions about legend VS labels
• Don’t neglect your supply data (add the web site hyperlink as a supply)!
• Copy the chart into the identical Phrase doc

PART THREE
Have a look at the next information:

Share Share of Radio Listening, by Format and Viewers Class, Fall

Teenagers Males Females
12 to 17 years 18 years and over
p.c
Grownup modern 25.1 17.three 27.eight
Album oriented rock 7.four 7.2 three.three
Canadian Broadcasting Company 2.6 11.eight 13.7
Up to date 27.three eight.2 eight.1
Nation 7.7 eight.eight 10.5
Dance 2.7 zero.four zero.5
Simple listening 1.1 three.three four.2
Gold/oldies/rock 13.eight 17.6 11.1
Center-of-the-road zero.7 1.9 2.1
Different four.three 7.four 6.1
Sports activities zero.6 2.6 zero.5
Discuss 1.eight 10.7 9.6
U.S. stations four.9 2.eight 2.four
Complete listening 100.zero 100.zero 100.zero

 In the identical Excel workbook however on a brand new sheet (title it), create a desk evaluating the radio listening preferences for males versus females
 From that desk create a chart utilizing probably the most acceptable format
 Embrace related titles and codecs
 Copy and paste the chart into Phrase.
 Write 2 observations in regards to the chart slightly below the place you pasted in Phrase.

Order | Check Discount