Excel grader chapter 7 need to get 90 percent thank you

Get perfect grades by consistently using www.college-experts.com. Place your order and get a quality paper today. Take advantage of our current 20% discount by using the coupon code GET20


Order a Similar Paper Order a Different Paper

Vehicle Maintenance

Project Description:

In this project, you will import an
Access database into the Data Model and use PowerPivot to create a PivotTable
and Pivot Chart using multiple tables. Then you will create a Power View
sheet.

Instructions:

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

Step

Instructions

Points Possible

1

Start Excel. Open and save the
downloaded Excel workbook named GO_e07_Grader_h2.xlsx.

0

2

Use PowerPivot to import both tables
in the downloaded Access database 7F_Vehicle_Parts.accdb
into the Data Model.

Insert a PivotTable in a new worksheet. Rename the new sheet PivotTable.

10

3

Place the Supplier field from the
Suppliers table in the COLUMNS area. From the Supply Order Summary table,
place the Item field in the ROWS area, and the Quantity field in the VALUES
area.

12

4

In cell B5, use Quick Explore to
drill to Supply ID, and then drill to Item.

10

5

In PowerPivot, on the Supply Order
Summary table, add a calculated column that multiplies [Quantity] * [Cost]. Rename
the column Total.
Copy the entire worksheet and paste it into cell A2 of the Vehicle Maintenance
worksheet in the main workbook.

8

6

In PowerPivot, insert a PivotChart
in a new worksheet. Rename the new sheet PivotChart.

2

7

Place the Supplier field from the
Suppliers table in the LEGEND (SERIES) area. From the Supply Order Summary
table, place the Total field in the VALUES area, and place the Year Ordered
field in the AXIS (CATEGORY) area.

12

8

Insert a Power View report. Add the
title
Vehicle Maintenance Orders 2014
2016.

12

9

From the Supply Order Summary table,
place the Item, Quantity, and Year Ordered fields (in that order) in the
FIELDS area. Change the visualization to a Stacked Column chart.

12

10

Insert a Map visualization using the
City, State, and Supplier fields from Suppliers and the Total field from
Supply Order Summary. Resize the map to fill the right side of the canvas.
Set the legend to display at the bottom.

12

11

Change the Power View worksheet Text
Size to 75%. Set the background to Light 1 Center Gradient.

10

12

Ensure that the worksheets are
correctly named and placed in the following order in the workbook: Power
View1, PivotChart, PivotTable, Vehicle Maintenance. Save the workbook. Close
the workbook and then exit Excel. Submit the workbook as directed.

0

Total Points

100

                                                                                                                       

Writerbay.net

Do you need help with this or a different assignment? We offer CONFIDENTIAL, ORIGINAL (Turnitin/LopesWrite/SafeAssign checks), and PRIVATE services using latest (within 5 years) peer-reviewed articles. Kindly click on ORDER NOW to receive an A++ paper from our masters- and PhD writers.

Get a 15% discount on your order using the following coupon code SAVE15


Order a Similar Paper Order a Different Paper