Your Perfect Assignment is Just a Click Away

We Write Custom Academic Papers

100% Original, Plagiarism Free, Customized to your instructions!

glass
pen
clip
papers
heaphones

Take Home: Excel Chapter 4 Grader Project

Take Home: Excel Chapter 4 Grader Project

StepInstructionsPoint Value1Start Excel. Download and open the file named Exp19_Excel_Ch04_Cap_AutoSales.xlsx. Grader has automatically added your last name to the beginning of the filename.
02Freeze the first row on the Fleet Information worksheet.53Convert the data to a table, name the table Inventory, and apply the Gold, Table Style Medium 19.104Remove duplicate records.35Sort 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.56Repeat the field names on all pages.57Change page breaks so each vehicle make is printed on a separate page.58Add 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.69Click the Sales Information worksheet and convert the data to a table, name the table Sales, and apply the Green, Table Style Dark 11.1010Type % of sticker in cell E1.211Create a formula with structured references to calculate the percentage of the Sticker Price in column E.512Format the range E2:E30 with Percent Style Number Format.513Add a table Total Row and then display the Average of % of sticker and Sum of Sticker Price and Sale Price.714AutoFit the width of columns B:E to show the total values.015Select the range E2:E30. Apply Solid Fill Blue Data Bars conditional formatting to the % of sticker data.816With 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.517On the First Quarter Sales worksheet, rename the table FirstQuarter.218Filter the data to display January, February, and March sales.619Add 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.620Select Landscape orientation for all sheets.521Save and close EXP19_Excel_CH04_Cap_AutoSales.xlsx. Exit Excel.0

Order Solution Now

Our Service Charter

1. Professional & Expert Writers: Eminence Papers only hires the best. Our writers are specially selected and recruited, after which they undergo further training to perfect their skills for specialization purposes. Moreover, our writers are holders of masters and Ph.D. degrees. They have impressive academic records, besides being native English speakers.

2. Top Quality Papers: Our customers are always guaranteed of papers that exceed their expectations. All our writers have +5 years of experience. This implies that all papers are written by individuals who are experts in their fields. In addition, the quality team reviews all the papers before sending them to the customers.

3. Plagiarism-Free Papers: All papers provided by Eminence Papers are written from scratch. Appropriate referencing and citation of key information are followed. Plagiarism checkers are used by the Quality assurance team and our editors just to double-check that there are no instances of plagiarism.

4. Timely Delivery: Time wasted is equivalent to a failed dedication and commitment. Eminence Papers is known for timely delivery of any pending customer orders. Customers are well informed of the progress of their papers to ensure they keep track of what the writer is providing before the final draft is sent for grading.

5. Affordable Prices: Our prices are fairly structured to fit in all groups. Any customer willing to place their assignments with us can do so at very affordable prices. In addition, our customers enjoy regular discounts and bonuses.

6. 24/7 Customer Support: At Eminence Papers, we have put in place a team of experts who answer to all customer inquiries promptly. The best part is the ever-availability of the team. Customers can make inquiries anytime.