Instructions attached along with the excel file that will directly be worked in.Problem 1...

Question

Instructions attached along with the excel file that will directly be worked in.

Instructions attached along with the excel file that will directly be worked in.

Problem 1 SalespersonTotal Sales ($)Average Performance Bonus Previous Years ($)Customer AccountsYears with Company Smith, Michael325000.7812499.345212414 Yu, Joe13678.21239.943497 Reeves, Bill452359.1921987.246217521 Hamilton, Joshua87423.917642.9011283 Harper, Derek87654.211250.1393214 Quinn, Dorothy234091.3914567.9833489 Graves, Lorrie379401.9427981.443212112 Sun, Yi31733.59672.911171 Thompson, Nicole127845.2213322.9713173 Please explain what changes you made and why: Problem 2 Gross Domestic Product (in US Dollars, $billions) CountryYear 1Year 2Year 3Year 4Year 5Year 6 Albania7.48.19.711.610.810.6 Argentina169.7198.0241.0301.3285.1339.6 Australia704.5758.3916.9983.0934.21,178.8 Austria272.9290.7336.8375.8344.5341.4 Belgium335.6355.4408.5451.7421.4416.5 Brazil756.8935.51,175.01,407.01,370.81,782.4 Canada1,056.81,193.91,332.11,404.81,245.21,469.9 Costa Rica18.921.224.728.028.033.9 Czech Republic111.7128.7156.6194.6170.9172.6 Finland169.9180.2214.8236.6206.7207.9 France1,915.02,015.02,312.82,541.62,367.92,301.8 Germany2,516.92,632.82,984.73,258.92,973.72,966.1 Greece217.2234.3273.8307.1292.6269.1 Ireland177.7195.3229.6233.3199.5186.2 Israel122.4133.2153.4185.7178.7199.8 Italy1,597.31,661.91,892.72,063.91,900.01,836.9 Mexico823.3928.51,011.91,085.6858.31,010.3 Netherlands567.3600.9694.8775.4708.0700.8 New Zealand108.9105.1129.0125.7112.9136.2 Peru72.384.498.5117.8120.4144.3 Poland267.8300.1371.9463.4382.6413.4 Portugal165.3172.9200.1218.7206.0200.5 Saudi Arabia317.4358.4386.7477.3374.4436.2 Singapore119.7139.1167.0179.3173.8209.7 South Africa220.3232.2254.4247.5256.9328.8 Spain1,012.01,100.01,293.21,459.01,361.01,287.9 Switzerland350.6368.2409.2474.7464.9498.2 Turkey425.5467.9579.0656.6557.7655.8 United Kingdom2,030.32,178.02,504.62,381.91,959.22,005.6 United States12,579.713,336.314,010.914,369.514,113.314,601.6 Please explain what changes you made and why: First, I removed all the unnecessary borders and unbolded the column headers; after removing most of the borders, the bold text wasn't needed to differentiate the column headers. Then, I divided each number by 1 billion to convert the number into a much more readable scale. Finally, I changed the number formatting to display one decimal place with a comma to separate the thousands for additional readability.

module-2-formatting-visualizations-template-lfuk4alo.xlsx screen-shot-2022-05-30-at-63722-pm-2yl55do2.png

Answered 1 days AfterMay 30, 2022

Bikash · Accepted Answer

Problem 1
	Salesperson	Total Sales ($)	Average Performance Bonus Previous Years ($)	Customer Accounts	Years with Company	Last Name	First Name	First Name	Salesperson
	Smith, Michael	325,000.78	12,499.35	124	14	Smith	 Michael	Michael	Michael Smith
	Yu, Joe	13,678.21	239.94	9	7	Yu	 Joe	Joe	Joe Yu
	Reeves, Bill	452,359.19	21,987.25	175	21	Reeves	 Bill	Bill	Bill Reeves
	Hamilton, Joshua	87,423.91	7,642.90	28	3	Hamilton	 Joshua	Joshua	Joshua Hamilton
	Harper, Derek	87,654.21	1,250.14	21	4	Harper	 Derek	Derek	Derek Harper
	Quinn, Dorothy	234,091.39	14,567.98	48	9	Quinn	 Dorothy	Dorothy	Dorothy Quinn
	Graves, Lorrie	379,401.94	27,981.44	121	12	Graves	 Lorrie	Lorrie	Lorrie Graves
	Sun, Yi	31,733.59	672.91	7	1	Sun	 Yi	Yi	Yi Sun
	Thompson, Nicole	127,845.22	13,322.97	17	3	Thompson	 Nicole	Nicole	Nicole Thompson
Please explain what changes you made and why:
1. Removed comma between last and first name by using "Text To Columns" 
2. Used Trim to remove leading space before first name
3. Concatenated first and last name.
4. Removed Bold from data below headers
5.

Instructions attached along with the excel file that will directly be worked in.

Answer To: Instructions attached along with the excel file that will directly be worked in.

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment