Travel Project Data

Question description

Click the link below to download the travel project data document which you will use to complete this part of the course project.

Travel Project Data

  1. Replace the information in brackets <> with the city you used for your travel project and James Student with your first and last names.
  2. Create a table with 4 columns and 6 rows.
  3. Add the following information: Row 1, Column 1: Travelers for <city> Trip.
  4. In Row 2, type each of the following into a cell: Name, # of Travelers, Total Cost, Down Payment. At this point your table should look like this:

table image

  1. Continue entering the table data:

    Row 3: John Jones, 3, 7500, 2500
    Row 4: Terry Jones, 2, 5000, 2000
    Row 5: Ed Murphy, 2, 7500, 1000
    Row 6: Mary Harman, 1, 2500, 1000

  1. Merge the first row over all the columns.
  2. Center the second row.
  3. Select the table and add the Lite Shade Accent 2 Table Style.
  4. Delete the red instructions above the table.
  5. Under the second red line, create a chart using the following information:

    Series: # Trips, # Travelers, # Insured
    Category 1: Chicago, 3, 9, 2
    At this point, your data should look like this:

XL sheet with travel data

  1. Continue adding the chart data:

    New York, 4, 20, 5
    New Orleans 2,18,7
    Orlando, 6, 25, 8

  1. Sometimes the chart that is created will have a place holder for the chart title. If you see Chart Title at the top, select the wording and type: Travel Information. (If your chart does not have Chart Title at the top, that’s fine. Continue to the next step.)
  2. Delete the red line above the chart.
  3. Using the Format Painter, use the Sally Jones line format to match the next four lines.
find the cost of your paper

Case study Analysis( paper)- Prime Bank of Massachusetts

APA format is required. References should be listed immediately after the question that is being answered. Each question lists a minimum number of unique scholarly references; the textbook is considered one unique….

“Letter from Birmingham Jail” was written by Martin Luther King Jr.

Overview “Letter from Birmingham Jail” was written by Martin Luther King Jr., as the title indicates, while he was confined in the Birmingham city jail in April, 1963. King is….

I need to write a medical report to academic advisor

Dear Sir or Madam, I need to write to my academic advisor a medical report ( Turki Alanazi came to our hospital after 14 days of his return from the….