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.