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. **

Destination |
June |
July |
August |
Flight Costs |

Milan | 1,000 | 2,000 | 2,500 | €500 |

Barcelona | 1,200 | 1,600 | 2,200 | €400 |

Venice | 1,300 | 1,700 | 2,300 | €370 |

Paris | 1,400 | 1,800 | 2,400 | €180 |

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.

##### Get Solution of this Assessment. Hire Experts to solve this assignment for you Before Deadline.

The post 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 appeared first on QQI Assignments.