1. Open the Excel 3 Activity 4 Wage Comparison Bar Chart file from the shared drive. 2. Save the file to your student Excel 3 folder as 21 Activity Activity. 3. Add your name to the spreadsheet in place of the name "Your Name". 4. Create a Bar chart for the i-phone-u-phone Employees comparing their Grass Pay for the week. a. Highlight A3 A12, hold the CTRL key down and highlight 13:112 b. Go to Insert, Bar and choose a Clustered Bar in 3-D S. Move the Bar Chart to its own sheet by clicking on the Design Tab, choose Move Chart from the far right side of the ribbon. On the Move Chart window, choose New Sheet and name it 3D Bar Chart dick OK. 28 Opet Perd 6. Make the following changes to your Chart Sheet: a. Update header and footer to class format and document properties. b. From the Layout Tab: 1. Remove the Legend ii. Add a Chart Title, above the Chart, i-phone-u-phone ili. Change the font size to 28 iv. Add a subtitle by double clicking at the end of the title, press enter and type Wage Comparison Change the font for the subtitle to size 20 c. Show Data Labels from the Layout Tab, Data Labels button. 1. Format the numbers to Currency, 2 decimal places. II. Right click on one of the values, go to Format Data Labels, Choose Number and then choose Currency. d. Change the horizontal labels to i-phone-u-phone currency also. 7. Go to Print Preview and compare with the key. 8. Go to the Chart Analysis Worksheet in your listening guide and answer question 84. 9. Re-save. Save in pdf format KEY
1. Open the Excel 3 Activity 4 Wage Comparison Bar Chart file from the shared drive. 2. Save the file to your student Excel 3 folder as 21 Activity Activity. 3. Add your name to the spreadsheet in place of the name "Your Name". 4. Create a Bar chart for the i-phone-u-phone Employees comparing their Grass Pay for the week. a. Highlight A3 A12, hold the CTRL key down and highlight 13:112 b. Go to Insert, Bar and choose a Clustered Bar in 3-D S. Move the Bar Chart to its own sheet by clicking on the Design Tab, choose Move Chart from the far right side of the ribbon. On the Move Chart window, choose New Sheet and name it 3D Bar Chart dick OK. 28 Opet Perd 6. Make the following changes to your Chart Sheet: a. Update header and footer to class format and document properties. b. From the Layout Tab: 1. Remove the Legend ii. Add a Chart Title, above the Chart, i-phone-u-phone ili. Change the font size to 28 iv. Add a subtitle by double clicking at the end of the title, press enter and type Wage Comparison Change the font for the subtitle to size 20 c. Show Data Labels from the Layout Tab, Data Labels button. 1. Format the numbers to Currency, 2 decimal places. II. Right click on one of the values, go to Format Data Labels, Choose Number and then choose Currency. d. Change the horizontal labels to i-phone-u-phone currency also. 7. Go to Print Preview and compare with the key. 8. Go to the Chart Analysis Worksheet in your listening guide and answer question 84. 9. Re-save. Save in pdf format KEY
MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
Related questions
Question
Transcribed Image Text:1. Open the Excel 3 Activity 4 Wage Comparison Bar Chart file from the shared drive.
2. Save the file to your student Excel 3 folder as 21_Activity Activity4
3. Add your name to the spreadsheet in place of the name "Your Name".
4. Create a Bar chart for the i-phone-u-phane Employees comparing their Grass Pay for the week.
a. Highlight A3:A12, hold the CTRL key down and highlight J3J12
b. Go to Insert, Bar and choose a Clustered Bar in 3-D
5. Move the Bar Chart to its own sheet by clicking on the Design Tab, choose Move Chart from the far
right side of the ribbon. On the Move Chart window, choose New Sheet and name it 3D Bar Chart
dick OK.
Choose y
6. Make the following changes to your Chart Sheet:
a. Update header and footer to class format and document properties.
b. From the Layout Tab:
1. Remove the Legend
II. Add a Chart Title, above the Chart, i-phone-u-phone
ill. Change the font size to 28
iv. Add a subtitle by double clicking at the end of the title, press enter and type
Wage Comparison Change the font for the subtitle to size 20
c. Show Data Labels from the Layout Tab, Data Labels button.
1. Format the numbers to Currency, 2 decimal places.
II. Right click on one of the values, go to Format Data Labels, Choose Number and
then choose Currency.
d. Change the horizontal labels to
i-phone-u-phone
Wage Comparison
currency also.
7. Go to Print Preview and compare with the
key.
8. Go to the Chart Analysis Worksheet in
your listening guide and answer question
14.
9. Re-save.
Save in pdf format
Spreachtas
KEY
Transcribed Image Text:Employee
Your Name
Bob Forapples
Harry Knuckles
Jack Enjill
w
Mark Papers
O
Owen Money
Patty Cakes
Thomas Talksalot
Tim Burr
Ty Ping
Total
Monday Tuesday Wednesday Thursday
4.5
5
4.5
4.5
4
4
4
4
8
8
8
5
4
4
5.5
6
A
4
F
5.5
4
4
8
5.5
5
35
5
8
5.5
6
51.5
8
44.5
4.5
5
8
38
Friday
i-phone-u-phone
Weekly Payroll
Saturday Total
7
4
8
5
4.5
4.5
4.5
8
5
.
4
5.5
8
5
6
46
6
6
45
30
20
40
23
20
21
21
40
22
23
260
Hourly
Wage
9.25
7.25
12.35
7.35
7.25
7.65
7.75
14.5
8.35
7.25
Gross
Pay
277.50
145.00
494.00
169.05
145.00
2000
160.65
463 35
162.75
580.00
183.70
166.75
$2,484.40
Social
Security
Medicare
17.21
4.16
8.99
30.63
10.48
2.18
7.41
2.54
8.99
2.18
20
0.00
9.96
2.41
AM
24.0
10.09
35 05
2.44
35.96
8.70
2.76
11.39
10.34
$154.03
2.50
$37.27
FICA
5.55
2.90
9.88
3.38
2.90
3.21
3.26
11.60
3.67
3.34
$49.69
State
Tax
4.72
2.47
8.40
2.87
247
2.47
2.73
2.77
9.86
3.12
2.83
$42.23
Net
Pay
245.87
128.47
437.68
149.78
ww
128.47
443.34
142.34
444.30
144.20
513.88
162.76
147.74
$2,201.18
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 1 images
Recommended textbooks for you
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman