computer applications and business system concepts
Description
Module 03 Content
Click the link below to download the travel project data document which you will use to complete this part of the course project.
CGS1240-Mod-3-Travel-Project-data.docx
Replace the information in brackets <> with the city you used for your travel project and James Student with your first and last names.
Create a table with 4 columns and 6 rows.
Add the following information: Row 1, Column 1: Travelers for <city> Trip.
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:
Excel sheet example
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
Merge the first row over all the columns.
Center the second row.
Select the table and add the Lite Shade Accent 2 Table Style.
Delete the red instructions above the table.
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
Continue adding the chart data:
New York, 4, 20, 5
New Orleans 2,18,7
Orlando, 6, 25, 8
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.)
Delete the red line above the chart.
Using the Format Painter, use the Sally Jones line format to match the next four lines.
Submit your completed assignment by following the directions linked below. Please check the Course Calendar for specific due dates.
Save your assignment as a Microsoft Word document. (Mac users, please remember to append the “.docx” extension to the filename.) The name of the file should be your first initial and last name, followed by an underscore and the name of the assignment, and an underscore and the date. An example is shown below:
Jstudent_exampleproblem_101504
Unformatted Attachment Preview
To:
Sally Jones
From:
James Student
Date:
January 15, 202x
Subject:
Travelers for the trip
Below is the current status of the trip:
Create your table below this line and then delete this line.
Create your chart below this line and then delete this line.
Purchase answer to see full
attachment
Have a similar assignment? "Place an order for your assignment and have exceptional work written by our team of experts, guaranteeing you A results."