About SophiaPretty

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:

Accounting,Algebra See all

Accounting,Algebra,Applied Sciences,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Communications,Computer Science,Economics,Engineering,English,Environmental science,Essay writing Hide all

Teaching Since:	Jul 2017
Last Sign in:	304 Weeks Ago, 3 Days Ago
Questions Answered:	15833
Tutorials Posted:	15827

Education

MBA,PHD, Juris Doctor
Strayer,Devery,Harvard University
Mar-1995 - Mar-2002

Experience

Manager Planning
WalMart
Mar-2001 - Feb-2009

Category > Computer Science Posted 06 Jan 2018 My Price 10.00

Rockville Auto Sales and have been asked to aid in the development

I want to know the correct answer. Some of theses questions are not clear.

Please help!!!!

EX16_XL_CH04_GRADER_CAP_HW - Rockville Auto Sales 1.5

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.

Instructions:

For the purpose of grading the project you are required to perform the following tasks:

Step	Instructions	Points Possible
1	Open the downloaded file exploring_e04_grader_h1.xlsx.	0.000
2	Freeze the first row on the Fleet Information worksheet.	3.000
3	Convert the data to a table, name the table Inventory, and apply the Table Style Medium 19.	10.000
4	Remove duplicate records.	2.000
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.000
6	Repeat the field names on all pages.	5.000
7	Change page breaks so each vehicle make is printed on a separate page.	5.000
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.	5.000
9	Click the Sales Information worksheet and convert the data to a table, name the table Sales, and apply the Table Style Dark 11.	10.000
10	Type % of sticker in cell E1.	2.000
11	Create a formula with structured references to calculate the percentage of the Sticker Price in column E.	8.000
12	Format the range E2:E30 with Percent Style Number Format.	5.000
13	Add a total row to display the Average of % of sticker and Sum of Sticker Price and Sale Price.	5.000
14	AutoFit the width of columns B:E to show the total values.	5.000
15	Apply Solid Fill Blue Data Bars conditional formatting to the % of sticker data.	8.000
16	Select the range E2:E30 and 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 sale price.	5.000
17	On the First Quarter Sales worksheet, rename the table FirstQuarter.	5.000
18	Filter the data to display January, February, and March sales.	2.000
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.	5.000
20	Select Landscape orientation for all sheets.	5.000
21	Save and close the workbook. Submit the workbook as directed.	0.000
	Total Points	100.000

Attachments:

Answers

SophiaPretty

(5)

Status NEW Posted 06 Jan 2018 02:01 PM My Price 10.00

----------- ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly

Not Rated(0)

Buy Answer

Hire Dedicated Virtual Team / Business Solution for SMEs.