Business Finance Homework Help
Business Finance Homework Help. excel help
1 | Start Excel. Download and open the file named Exp19_Excel_Ch10_Cap-AutoSales.xlsx. Grader has automatically added your last name to the beginning of the filename. | 0 |
2 | Use Get & Transform (Power Query) to import the file e10c1Agents.csv. | 10 |
3 | Rename the worksheet Agents. | 5 |
4 | Use Get & Transform (Power Query) to import the Vehicles table from the file e10c1Vehicles.accdb. | 10 |
5 | Rename the worksheet Sales. | 5 |
6 | Load the file e10c1Customer_Leads.txt in the Power Query Editor. Use the Power Query Editor to ensure the first row is used as Headers. Close and load the table. | 10 |
7 | Rename the worksheet Customer_Leads. | 5 |
8 | Add the Vehicles, e10c1Agents, and e10c1Customer_Leads tables to the data model. | 12 |
9 | Define the following relationship: Table: e10c1Agents Field: AgentID Table: Vehicles Field: AgentID |
10 |
10 | Use Power Pivot to create a PivotTable on Sheet1 starting in cell B3. Add the Last field from the e10c1Agents table to the Rows area and Price from the Vehicles table to the Values area. | 11 |
11 | Format the range C4:C20 with Accounting Number Format. | 5 |
12 | Insert a Clustered Column Pivot Chart. Position the chart so the upper left corner is in the center of cell D3. | 9 |
13 | Add the Chart Title Sales. | 3 |
14 | Rename the worksheet SalesAnalysis. | 5 |
15 | Create a 3D Map based on the Vehicles table in the Sales Worksheet. Add City and State to the Location dimension. Zoom in so Los Angeles fills the entire map. | 0 |
16 | Edit Scene 1 by changing the name to West Coast, setting the Scene duration to 6 seconds, and setting the Transition Effect to Dolly. | 0 |
17 | Add a new scene called East Coast. Zoom out and reposition the map to view the Eastern seaboard. | 0 |
18 | Set the Scene duration to 6 seconds, and set the Transition Effect to Dolly. | 0 |
19 | Edit the connection properties of e10c1Agents.CSV, e10c1Vehicles.accdb, and e10c1Customer_Leads.txt to refresh when opening the file. | 0 |
20 | Save and close Exp19_Excel_Ch10_Cap-AutoSales.xlsx. Exit Excel. Submit the file as directed. | 0 |
Business Finance Homework Help
"Our Prices Start at $11.99. As Our First Client, Use Coupon Code GET15 to claim 15% Discount This Month!!"
![](https://courseworkgeeks.com/wp-content/uploads/2018/08/order_now-1.png)