B6IS100: Insert appropriate rows and column headings for each formula used and Use absolute and relative cell references where appropriate: IT Essentials Assignement, DBS, Ireland

Insert appropriate rows and column headings for each formula used.  Use absolute and relative cell references where appropriate.  Sort the table in alphabetical order.

Use appropriate labels for each formula used.                                                                                                                                                                         

Format appropriate numbers to currency, insert 2 decimal places.

2 Insert a Header: Getaway Holiday Summer 2019, change font size and style. Insert your student number as a footer.

3 Insert a heading: June-August 2019 (center this heading over the completed worksheet.

4 Total the number of passengers that traveled each month. Total the number of passengers that traveled to each destination.

5 Insert a column: Calculate the cash intake for each destination

6 Calculate the average number of passengers traveling to Barcelona and Pari only each month.

7 Show the most expensive and cheapest flight costs available to passengers.8 Use an appropriate formula to display today’s date. Format the date to read date, month (written in full), and year.

9 Use an appropriate page orientation, center the spreadsheet horizontally and vertically.