Projected Actual Try it out!

Jan 2,000 1,895 4,000

Feb 2,500 2,643
3,500
Mar 3,500 3,648
3,000

2,500

2,000

1,500

1,000

500

0
Jan Feb Mar

Projected Actual Try it out!

Jan 2,000 1,895
Feb 2,500 2,643 Chart Title
Mar 3,500 3,648 4,000
3,500
3,000
2,500
2,000
1,500
1,000
500
0
Jan Feb Mar

Projected Actual

Projected Actual Try it out!

Jan 2,000 1,895
Feb 2,500 2,643 Chart Title
Mar 3,500 3,648 4,000
3,500
3,000
2,500
2,000
1,500
1,000
500
0
Projected Actual

Jan Feb Mar

 Projected Actual Try it out!
Jan 2,000 1,895
Feb 2,500 2,643
Mar 3,500 3,648 Chart Title
3,750
3,250
2,750
2,250
1,750

Axis Title
1,250
750
250
Jan Feb Mar
Projected 2,000 2,500 3,500
Actual 1,895 2,643 3,648

Projected Actual Try it out!

Jan 2,000 1,895
Feb 2,500 2,643 Chart Title
Mar 3,500 3,648
3,750
3,250
2,750
2,250
1,750
Axis Title

1,250
750
250
Jan Feb Mar
Projected 2,000 2,500 3,500
Actual 1,895 2,643 3,648

Projected Actual Try it out!

Jan 2,000 1,895
Feb 2,500 2,643 Chart Title
Mar 3,500 3,648
Projected Actual
4,000
3,500
3,000
2,500
2,000
1,500
1,000
500
0
Jan Feb Mar
 1,000
500
0
Jan Feb Mar

Projected Actual Try it out!

Jan 2,000 1,895
Feb 2,500 2,643 Chart Title
Mar 3,500 3,648
Projected Actual
4,000
3,500
3,000
2,500
2,000
1,500
1,000
500
0
Jan Feb Mar

Projected Actual Try it out!

Jan 2,000 1,895
Feb 2,500 2,643
Mar 3,500 3,648 Chart Title
4,000
3,500
3,000
2,500
2,000
1,500
1,000
500
0
Projected Actual

Jan Feb Mar

Chart_1_Manual

Chart_2_Auto, Recommended option

Chart_3_swapping the row/column orientation

Chart_4_1_Applying a chart layout/Chart styles

Chart_4_2_Applying a chart layout/Chart styles

Chart_4_3_Applying a chart layout/Chart styles

Chart_4_4_Applying a chart layout/Chart styles

Chart_4_5_Applying a chart layout/Chart styles

Month Visitors
Jan 7,092
Feb 7,497
Website Visitors We
Mar 7,560 Jan
30,000
Apr 5,796 Feb
May 13,984 25,000 Mar
Jun 18,743 Apr
20,000 May
Jul 15,434 Jun
Aug 14,545 15,000 Jul
Sep 17,434 Aug
10,000 Sep
Oct 16,984
Oct
Nov 15,983 5,000 Nov
Dec 27,822 Dec
0
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 0 5,000 10,00

Website Visitors We
30,000 30,000

25,000 25,000

20,000 20,000

15,000 15,000

10,000 10,000

5,000 5,000

0 0
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr

Website Visitors
Jan
Feb
Website Visito
Mar
Apr
Nov
May
Jun
Jul Oct
Aug
Sep
Oct Sep
Nov
Dec
Aug
Sep
Oct Sep
Nov
Dec
 Website Visitors
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
0 5,000 10,000 15,000 20,000 25,000 30,000

Website Visitors
30,000

25,000

20,000

15,000

10,000

5,000

0
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec

Website Visitors Jan

Dec Feb
40,000

Nov Mar
20,000

Oct 0 Apr

Sep May

Aug Jun
Jul
Sep May

Aug Jun
Jul
Month Sales by Month Try it out!
Jan $186,983
Feb $179,009 Sales by Month
Mar $193,422
$300,000
Apr $185,956
May $196,025 $250,000
Jun $140,323
Jul $139,302 $200,000

Aug $134,922 $150,000

Sep $184,773
Oct $201,233 $100,000
Nov $218,039
$50,000
Dec $240,093
$0
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov

Month Sales by Month Try it out!

Jan $186,983
Feb $179,009
Mar $193,422 Sales by Month
Apr $185,956 $300,000
May $196,025 $250,000
Jun $140,323
$200,000
Jul $139,302
Aug $134,922 $150,000
Sales

Sep $184,773 $100,000

Oct $201,233
Nov $218,039 $50,000

Dec $240,093 $0
Jan Feb Mar Apr May Jun Jul Aug Sep Oct No
Month

Month Widgets Sprockets Try it out!

Jan 60,983 64,983
Feb 56,732 68,981 Widget and Sprocket Sales
Mar 49,831 77,398
160,000
Apr 43,323 88,091 140,000
May 39,879 93,733 120,000
100,000
80,000
60,000
40,000
20,000
0
Jan Feb Mar Apr

Widgets Sprockets
 40,000
20,000
0
Jan Feb Mar Apr

Widgets Sprockets

Month Widgets Sprockets Try it out!

Jan 60,983 64,983
Feb 56,732 68,981 Widget and Sprocket Sales
Mar 49,831 77,398
100%
Apr 43,323 88,091
90%
May 39,879 93,733 80%
70%
60%
50%
40%
30%
20%
10%
0%
Jan Feb Mar Apr M

Widgets Sprockets

Year Quarter Sales Try it out!

2020 Q-1 14,452
Q-2 14,669
Q-3 11,910
Q-4 25,392
2021 Q-1 14,113
Q-2 10,279
Q-3 14,647
Q-4 29,054
2022 Q-1 25,263
Q-2 25,242
Q-3 28,222
Q-4 24,992
2023 Q-1 20,248
Q-2 14,848
Q-3 28,722
Q-4 15,102
 ! Task_1_clustered column

onth

Jul Aug Sep Oct Nov Dec

! Task_1_1_clustered column

Month

un Jul Aug Sep Oct Nov Dec

th

! Task_2_stacked column

rocket Sales

Mar Apr May

Sprockets
Mar Apr May

Sprockets

! Task_3_100% stacked column chart

ocket Sales

ar Apr May

prockets

! Task_4_Multiple column
 Strongly
Item Agree Agree Undecided Disagree
Store locations are convenient 12% 14% 21% 21%
Store hours are convenient 15% 18% 24% 29%
Stores are well-maintained 9% 11% 32% 31%
I like your web site 18% 32% 32% 12%
Employees are friendly 2% 6% 32% 43%
You have a good selection of products 16% 19% 32% 21%
I like your TV ads 5% 9% 32% 38%
You sell quality products 24% 21% 28% 15%
Overall, I am satisfied 6% 28% 24% 25%
I would recommend your company 3% 9% 20% 27%

Strongly
Item Agree Agree Undecided Disagree
Store locations are convenient 12% 14% 21% 21%
Store hours are convenient 15% 18% 24% 29%
Stores are well-maintained 9% 11% 32% 31%
I like your web site 18% 32% 32% 12%
Employees are friendly 2% 6% 32% 43%
You have a good selection of products 16% 19% 32% 21%
I like your TV ads 5% 9% 32% 38%
You sell quality products 24% 21% 28% 15%
Overall, I am satisfied 6% 28% 24% 25%
I would recommend your company 3% 9% 20% 27%
 Try it out!
Strongly
Disagree I would recommend your company 3%
32%
Overall, I am satisfied 6%
14%
17% You sell quality products 24%

8% I like your TV ads 5%

17%
You have a good selection of products 16%
12%
16% Employees are friendly 2%
12% I like your web site 18%
17%
Stores are well-maintained 9%
41%
Store hours are convenient 15%

Store locations are convenient 12%

0% 5% 10% 15% 20% 25% 30%

Try it out!
Strongly
Disagree
32% I would recommend your company

14% Overall, I am satisfied

17% You sell quality products
8% I like your TV ads
17% You have a good selection of products
12% Employees are friendly
16% I like your web site
12%
Stores are well-maintained
17%
Store hours are convenient
41%
Store locations are convenient
0% 10% 20% 30% 40% 50% 60% 70% 80% 90% 100%

Strongly Agree Undecided Disagree Strongly

Agree Disagree
Task_5_Bar_chart

Task_6_Bar_chart
 Year Area 1 Area 2 Try it out!
2013 214,000 356,879
2014 247,250 385,070
2015 277,500 42,600
Median home prices
2016 374,500 520,000 900000
2017 435,000 725,000 800000
2018 489,500 820,000 700000
2019 480,500 759,000 600000
2020 401,700 702,300 500000
2021 302,500 589,000 400000
300000
200000
100000
0
1 2 3 4 5 6 7 8

Year Area 1 Area 2

Employees by Region
West Mid East Try it out!
2017 108 201
2018 121 222
EMPLOYEES BY REGION
2019 136 32 183
2020 208 87 143 West Mid East
2021 312 90 140 350

300

250

200

150

100

50

0
2017 2018 2019 2020 20
 Task_7_Line_Chart

prices

6 7 8 9

Area 2

Task_8_Line_Chart

REGION
East

2020 2021
Version Number of users Try it out!
Excel 365 183
Excel 2019 981
Number of users
Excel 2016 612
Excel 2013 283

Excel 365 Excel 2019 Excel 2016 Excel 2013

Version Number of users Try it out!

Excel 365 183
Excel 2019 981
Excel 2016 612 Number of users
Excel 2013 283 Excel 2013 Excel 365
14% 9%

Excel 2016
30% Excel 2019
48%
Task_10_Pie_chart

Task_11_Pie_chart