00a1Trips_LastFirst (solution) Homework | Page 7

16 Convert the data range in the Data ( 2 ) sheet to a table . 4.000
Apply the Table Style ​Medium 21 style to the table .
17 Sort the table by departure date from oldest to newest
4.000 and then alphabetically by trip description .
Apply a filter to display trips arranged by agents Avery and Ross only .
18 Display a total row . 3.000
Select a function that calculates totals for all monetary columns .
19 Create Line sparklines in column H in the Summary
6.000 sheet to display six-month trends for each agent .
Show the high point in each sparkline .