Rockville Auto Sales Excel 2016 Worksheet Project Hi,I am looking for a completed excel workbook with the instructions that have been attached. Vin # 29069

Rockville Auto Sales Excel 2016 Worksheet Project Hi,I am looking for a completed excel workbook with the instructions that have been attached. Vin #
2906934387
6393487147
9356019403
8000086254
9340076442
7433901231
1328395941
8137529693
9650039042
1344751603
3732185591
8251440185
9414505869
4942016124
4094989639
4700777743
1380128961
3860813150
2069016783
2488607421
7541058788
3345743062
1889854267
8131908841
7679546980
1360867906
5739567111
6007144763
3695501103
2482451414
7397531553
3133070112
5322014014
5726149503
4820173885
2706112648
7377188604
5293323010
2406189439
3578026701
1462643171
5122993766
7092958553
8156049535
9305933928
9537026620
Make
BMW
Honda
Toyota
BMW
BMW
Chevy
Chevy
BMW
Ford
Toyota
BMW
Ford
Toyota
Ford
BMW
BMW
BMW
Ford
Honda
BMW
Chevy
Ford
BMW
BMW
BMW
Chevy
Honda
BMW
Ford
Ford
BMW
Honda
Ford
Ford
Ford
BMW
Ford
Honda
Honda
Honda
Toyota
Toyota
Chevy
Honda
Ford
Toyota
Model
5 Series
Civic
Prius
5 Series
5 Series
Malibu
Malibu
5 Series
F-150
Prius
5 Series
F-150
Prius
F-150
5 Series
5 Series
5 Series
F-150
Civic
5 Series
Malibu
F-150
5 Series
5 Series
5 Series
Malibu
Civic
5 Series
F-150
F-150
5 Series
Civic
F-150
F-150
F-150
5 Series
F-150
Civic
Civic
Civic
Prius
Prius
Malibu
Civic
F-150
Prius
Year
2015
2018
2000
2017
2007
2010
2002
2001
2012
2004
2001
2011
2004
2006
2017
2017
2007
2009
2014
2008
2011
2007
2012
2004
2010
2004
2013
2008
2015
2014
2018
2009
2011
2015
2016
2012
2016
2001
2010
2003
2006
2014
2014
2005
2011
2008
Mileage
25709
26609
96905
28681
18384
37085
48868
61480
28541
42890
36595
76254
21380
63737
92048
44667
11158
14095
34428
68172
77099
31562
14427
14966
7877
70797
99041
95344
99021
83281
36000
46323
46216
6971
6921
22089
52774
30840
49544
34825
8887
84930
11654
3997
40807
27785
Sticker Price
$ 30,000.00
$ 30,000.00
$ 22,000.00
$ 30,000.00
$ 34,000.00
$ 27,000.00
$ 25,000.00
$ 22,000.00
$ 30,000.00
$ 25,000.00
$ 27,000.00
$ 22,000.00
$ 30,000.00
$ 22,000.00
$ 22,000.00
$ 25,000.00
$ 34,000.00
$ 34,000.00
$ 27,000.00
$ 22,000.00
$ 22,000.00
$ 27,000.00
$ 34,000.00
$ 34,000.00
$ 40,000.00
$ 22,000.00
$ 22,000.00
$ 22,000.00
$ 22,000.00
$ 22,000.00
$ 27,000.00
$ 25,000.00
$ 25,000.00
$ 40,000.00
$ 40,000.00
$ 30,000.00
$ 22,000.00
$ 27,000.00
$ 25,000.00
$ 27,000.00
$ 40,000.00
$ 22,000.00
$ 34,000.00
$ 40,000.00
$ 25,000.00
$ 30,000.00
8019012354
3737821324
7596630806
5718003239
8010477805
3814357405
1213463078
1563229851
9027521957
8893900890
7454528548
8054683334
5742570103
8163497575
5276867505
1409363873
1089138532
6015917869
9885757629
5306541595
2747847524
7718062943
2976194513
8281760371
4730270762
5161605236
7473005747
6891374035
5463769134
3867060534
3849719202
7200319445
8725850239
5903493846
2373147058
6161188244
4913951544
8806645278
5250708704
8357455137
4370047837
6290615001
8279091856
1218797573
1218797573
2700853328
6729292004
BMW
Toyota
Ford
BMW
BMW
Chevy
Toyota
Chevy
Ford
BMW
BMW
Chevy
BMW
Ford
Honda
Chevy
BMW
Toyota
Ford
BMW
Chevy
BMW
Toyota
Chevy
Honda
Honda
BMW
Honda
Ford
Honda
BMW
Honda
Honda
BMW
BMW
BMW
Chevy
Honda
BMW
Ford
Toyota
Honda
Honda
Ford
Ford
BMW
Ford
5 Series
Prius
F-150
5 Series
5 Series
Malibu
Prius
Malibu
F-150
5 Series
5 Series
Malibu
5 Series
F-150
Civic
Malibu
5 Series
Prius
F-150
5 Series
Malibu
5 Series
Prius
Malibu
Civic
Civic
5 Series
Civic
F-150
Civic
5 Series
Civic
Civic
5 Series
5 Series
5 Series
Malibu
Civic
5 Series
F-150
Prius
Civic
Civic
F-150
F-150
5 Series
F-150
2017
2001
2003
2016
2009
2016
2000
2002
2002
2006
2002
2012
2011
2004
2018
2004
2012
2001
2004
2013
2014
2013
2003
2012
2007
2013
2003
2003
2012
2003
2006
2005
2016
2001
2009
2012
2003
2012
2006
2016
2012
2009
2003
2010
2010
2004
2001
50120
35426
81699
39202
50527
54060
93430
13764
90009
79293
37753
36934
78360
91310
39645
80047
95298
87698
19686
81096
50650
55145
27493
44985
8541
31271
41747
75313
99161
52586
33661
23147
57432
91463
40492
65420
40380
76217
61969
17398
38800
96345
4129
11098
11098
97812
63166
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
22,000.00
27,000.00
22,000.00
27,000.00
22,000.00
22,000.00
22,000.00
34,000.00
22,000.00
22,000.00
27,000.00
27,000.00
22,000.00
22,000.00
27,000.00
22,000.00
22,000.00
22,000.00
34,000.00
22,000.00
22,000.00
22,000.00
30,000.00
25,000.00
40,000.00
27,000.00
25,000.00
22,000.00
22,000.00
22,000.00
27,000.00
30,000.00
22,000.00
22,000.00
25,000.00
22,000.00
25,000.00
22,000.00
22,000.00
34,000.00
27,000.00
22,000.00
40,000.00
34,000.00
34,000.00
22,000.00
22,000.00
9622942163
1532392596
1532392596
6851036813
5095450285
1531278978
4174658862
4174658862
6556316751
6287671745
BMW
Honda
Honda
Toyota
Ford
Honda
Ford
Ford
Ford
Honda
5 Series
Civic
Civic
Prius
F-150
Civic
F-150
F-150
F-150
Civic
2000
2018
2018
2013
2018
2018
2009
2009
2016
2007
57736
3308
3308
79226
70078
82011
54406
54406
58076
49295
$
$
$
$
$
$
$
$
$
$
22,000.00
40,000.00
40,000.00
22,000.00
22,000.00
22,000.00
22,000.00
22,000.00
22,000.00
25,000.00
Vin #
2906934387
6393487147
9356019403
8000086254
9340076442
7433901231
1328395941
8137529693
9650039042
1344751603
3732185591
8251440185
9414505869
4942016124
4094989639
4700777743
1380128961
3860813150
2069016783
2488607421
7541058788
3345743062
1889854267
8131908841
7679546980
1360867906
5739567111
6007144763
3695501103
Date sold
3/18/2018
9/27/2018
7/22/2018
7/1/2018
12/31/2018
4/21/2018
1/31/2018
3/4/2018
10/16/2018
4/18/2018
6/15/2018
3/21/2018
8/6/2018
7/22/2018
9/20/2018
4/11/2018
1/6/2018
12/17/2018
8/3/2018
3/21/2018
6/1/2018
10/9/2018
1/25/2018
11/4/2018
11/2/2018
1/22/2018
5/29/2018
10/26/2018
2/14/2018
Sticker Price
$ 30,000.00
$ 30,000.00
$ 22,000.00
$ 30,000.00
$ 34,000.00
$ 27,000.00
$ 25,000.00
$ 22,000.00
$ 30,000.00
$ 25,000.00
$ 27,000.00
$ 22,000.00
$ 30,000.00
$ 22,000.00
$ 22,000.00
$ 25,000.00
$ 34,000.00
$ 34,000.00
$ 27,000.00
$ 22,000.00
$ 22,000.00
$ 27,000.00
$ 34,000.00
$ 34,000.00
$ 40,000.00
$ 22,000.00
$ 22,000.00
$ 22,000.00
$ 22,000.00
Sale Price
$ 30,000.00
$ 27,000.00
$ 13,200.00
$ 27,000.00
$ 27,200.00
$ 16,200.00
$ 17,500.00
$ 19,800.00
$ 27,000.00
$ 25,000.00
$ 18,900.00
$ 19,800.00
$ 30,000.00
$ 15,400.00
$ 13,200.00
$ 22,500.00
$ 20,400.00
$ 30,600.00
$ 27,000.00
$ 19,800.00
$ 17,600.00
$ 21,600.00
$ 27,200.00
$ 23,800.00
$ 28,000.00
$ 22,000.00
$ 22,000.00
$ 17,600.00
$ 22,000.00
Vin #
Date sold
2906934387
3/18/2018
6393487147
9/27/2018
9356019403
7/22/2018
8000086254
7/1/2018
9340076442 12/31/2018
7433901231
4/21/2018
1328395941
1/31/2018
8137529693
3/4/2018
9650039042 10/16/2018
1344751603
4/18/2018
3732185591
6/15/2018
8251440185
3/21/2018
9414505869
8/6/2018
4942016124
7/22/2018
4094989639
9/20/2018
4700777743
4/11/2018
1380128961
1/6/2018
3860813150 12/17/2018
2069016783
8/3/2018
2488607421
3/21/2018
7541058788
6/1/2018
3345743062
10/9/2018
1889854267
1/25/2018
8131908841
11/4/2018
7679546980
11/2/2018
1360867906
1/22/2018
5739567111
5/29/2018
6007144763 10/26/2018
3695501103
2/14/2018
Total
Sticker Price
$
30,000.00
$
30,000.00
$
22,000.00
$
30,000.00
$
34,000.00
$
27,000.00
$
25,000.00
$
22,000.00
$
30,000.00
$
25,000.00
$
27,000.00
$
22,000.00
$
30,000.00
$
22,000.00
$
22,000.00
$
25,000.00
$
34,000.00
$
34,000.00
$
27,000.00
$
22,000.00
$
22,000.00
$
27,000.00
$
34,000.00
$
34,000.00
$
40,000.00
$
22,000.00
$
22,000.00
$
22,000.00
$
22,000.00
$ 785,000.00
Sale Price
% of sticker
$ 30,000.00
100%
$ 27,000.00
90%
$ 13,200.00
60%
$ 27,000.00
90%
$ 27,200.00
80%
$ 16,200.00
60%
$ 17,500.00
70%
$ 19,800.00
90%
$ 27,000.00
90%
$ 25,000.00
100%
$ 18,900.00
70%
$ 19,800.00
90%
$ 30,000.00
100%
$ 15,400.00
70%
$ 13,200.00
60%
$ 22,500.00
90%
$ 20,400.00
60%
$ 30,600.00
90%
$ 27,000.00
100%
$ 19,800.00
90%
$ 17,600.00
80%
$ 21,600.00
80%
$ 27,200.00
80%
$ 23,800.00
70%
$ 28,000.00
70%
$ 22,000.00
100%
$ 22,000.00
100%
$ 17,600.00
80%
$ 22,000.00
100%
$ 649,300.00
83%
Grader – Instructions
Excel 2016 Project
EX16_XL_CH04_GRADER_CAP_HW – Rockville Auto Sales 1.15
Project Description:
You work for Rockville Auto Sales and have been asked to aid in the development of a spreadsheet to manage sales and
inventory information. You will start the task with a prior worksheet that contains vehicle information and sales data for 2018.
You need to convert the data to a table. You will manage the large worksheet, prepare the worksheet for printing, sort and filter
the table, include calculations, and then format the table.
Steps to Perform:
Step
Instructions
Points
Possible
1
Open the downloaded file exploring_e04_grader_h1.xlsx.
0
2
Freeze the first row on the Fleet Information worksheet.
5
3
Convert the data to a table, name the table Inventory, and apply the Gold, Table Style
Medium 19.
10
4
Remove duplicate records.
3
5
Sort the table by Make in alphabetical order, add a second level to sort by Year Smallest to
Largest, and a third level to sort by Sticker Price Smallest to Largest.
5
6
Repeat the field names on all pages.
5
7
Change page breaks so each vehicle make is printed on a separate page.
5
8
Add a footer with your name on the left side, the sheet name code in the center, and the file
name code on the right side.
6
9
Click the Sales Information worksheet and convert the data to a table, name the table Sales,
and apply the Green, Table Style Dark 11.
10
10
Type % of sticker in cell E1.
2
11
Create a formula with structured references to calculate the percentage of the Sticker Price in
column E.
5
12
Format the range E2:E30 with Percent Style Number Format.
5
13
Add a total row to display the Average of % of sticker and Sum of Sticker Price and Sale Price.
7
14
AutoFit the width of columns B:E to show the total values.
0
15
Select the range E2:E30. Apply Solid Fill Blue Data Bars conditional formatting to the % of
sticker data.
8
16
With the range E2:E30 selected, create a new conditional formatting rule that uses a formula
to apply yellow fill and bold font to values that sold for less than or equal to 70% of the sticker
price. Be sure to select a Rule Type that will use a formula to determine which cells to format.
5
17
On the First Quarter Sales worksheet, rename the table FirstQuarter.
2
18
Filter the data to display January, February, and March sales.
6
Created On: 04/27/2020
1
EX16_XL_CH04_GRADER_CAP_HW – Rockville Auto Sales 1.15
Grader – Instructions
Step
Excel 2016 Project
Points
Possible
Instructions
19
Add a footer with your name on the left side, the sheet name code in the center, and the file
name code on the right side.
6
20
Select Landscape orientation for all sheets.
5
21
Save and close the workbook. Submit the workbook as directed.
0
Total Points
Created On: 04/27/2020
2
100
EX16_XL_CH04_GRADER_CAP_HW – Rockville Auto Sales 1.15

Purchase answer to see full
attachment

Don't use plagiarized sources. Get Your Custom Essay on
Rockville Auto Sales Excel 2016 Worksheet Project Hi,I am looking for a completed excel workbook with the instructions that have been attached. Vin # 29069
Get an essay WRITTEN FOR YOU, Plagiarism free, and by an EXPERT!
Order Essay
Calculate your paper price
Pages (550 words)
Approximate price: -

Why Choose Us

Top quality papers

We always make sure that writers follow all your instructions precisely. You can choose your academic level: high school, college/university or professional, and we will assign a writer who has a respective degree.

Professional academic writers

We have hired a team of professional writers experienced in academic and business writing. Most of them are native speakers and PhD holders able to take care of any assignment you need help with.

Free revisions

If you feel that we missed something, send the order for a free revision. You will have 10 days to send the order for revision after you receive the final paper. You can either do it on your own after signing in to your personal account or by contacting our support.

On-time delivery

All papers are always delivered on time. In case we need more time to master your paper, we may contact you regarding the deadline extension. In case you cannot provide us with more time, a 100% refund is guaranteed.

Original & confidential

We use several checkers to make sure that all papers you receive are plagiarism-free. Our editors carefully go through all in-text citations. We also promise full confidentiality in all our services.

24/7 Customer Support

Our support agents are available 24 hours a day 7 days a week and committed to providing you with the best customer experience. Get in touch whenever you need any assistance.

Try it now!

Calculate the price of your order

Total price:
$0.00

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

No need to work on your paper at night. Sleep tight, we will cover your back. We offer all kinds of writing services.

Essays

Essay Writing Service

You are welcome to choose your academic level and the type of your paper. Our academic experts will gladly help you with essays, case studies, research papers and other assignments.

Admissions

Admission help & business writing

You can be positive that we will be here 24/7 to help you get accepted to the Master’s program at the TOP-universities or help you get a well-paid position.

Reviews

Editing your paper

Our academic writers and editors will help you submit a well-structured and organized paper just on time. We will ensure that your final paper is of the highest quality and absolutely free of mistakes.

Reviews

Revising your paper

Our academic writers and editors will help you with unlimited number of revisions in case you need any customization of your academic papers