excel 2019 grader dow jones and flight plan

profileHollywood4799
Amy_Exp19_Excel_Ch10_ML2_Flight_Plan.zip
Home>Computer Science homework help>excel 2019 grader dow jones and flight plan

Exp19_Excel_Ch10_ML2_Flight_Plan_Instructions.docx

Grader - Instructions Excel 2019 Project

Exp19_Excel_Ch10_ML2_Flight_Plan

Project Description:

You are student at the Aviation Experts flight school in New York City and as part of your training, you are required to create a flight plan for a cross country trip. You have decided to import your destination information into Excel and use 3D Maps to create an animated tour of the cities you will fly over.

Steps to Perform:

Step

Instructions

Points Possible

1

Start Excel. Download and open the file named Exp19_Excel_Ch10_GRADER_ML2_FlightPlan.xlsx. Grader has automatically added your last name to the beginning of the filename.

0

2

Use the Get & Transform tools to import the text file Exp19_Excel_Ch10_GRADER_ML2-FlightPlan.

75

3

Rename the worksheet Flights.

25

4

Edit the connection properties to refresh when the file is opened.

0

5

Insert a 3D Map that uses Latitude and Longitude as Location dimensions.

0

6

Zoom in until the New York City fills the screen. Rename Scene1 as New York, set the Scene duration to 4 seconds, and the effect to Dolly.

0

7

Add a new Scene named Chicago and reposition the map so Chicago fills the screen.

0

8

Add a new Scene named Denver and reposition the map so Denver fills the screen.

0

9

Add a new Scene named Los Angeles and reposition the map so Los Angeles fills the screen.

0

10

Save and close Exp19_Excel_Ch10_GRADER_ML2_FlightPlan.xlsx. Exit Excel. Submit the file as directed.

0

Total Points

100

Created On: 10/15/2019 1 Exp19_Excel_Ch10_ML2 - Flight Plan 1.0

Amy_Exp19_Excel_Ch10_GRADER_ML2_FlightPlan.xlsx

Sheet1

Exp19_Excel_CH10_GRADER_ML2_Flight Plan_Final.jpg

Exp19_Excel_Ch10_GRADER_ML2-FlightPlan.txt

Flight City State Latitude Longitude 1 New York NY 40.73061 -73.935242 2 Chicago IL 41.881832 -87.623177 3 Denver CO 39.742043 -104.991531 4 Los Angeles CA 34.052235 -118.243683