(Solved) : Ex16xlch10graderml1hw Dow Jones 15 Project Description Intern Hicks Financial Small Tradin Q28863457 . . . .

EX16_XL_CH10_GRADER_ML1_HW – Dow Jones 1.5

Project Description:

You are an intern for Hicks Financial, a small tradingcompany located in Toledo, Ohio. Your intern supervisor wants youto create a report that details all trades made in February usingcurrent pricing information from the Dow Jones Index. To completethe task, you will import and shape data using Power Query. Thenyou will create data connections and visualizations of thedata.

Instructions:

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

Step

Instructions

Points Possible

1

Download the file named e10m1Dow.xlsx and save is ase10m1Dow_LastFirst.

0.000

2

Use Power Query to begin to import the Dow Index informationlocated in Table 2 from the