Freeze the panes so that the row of column labels does not scroll offscreen.
12 Apply the Light Red Fill with Dark Red Text conditional
4.000 formatting to values in the Total Cost with Taxes column when the values are above average.
13 Insert a function to calculate the total for all trips
4.000
( including taxes) in cell G5, the average trip cost in cell G6, and themedian trip cost in cell G7.
14 Insert a function to calculate the lowest trip cost in cell
6.000
G8 and the highest trip cost in cell G9. Click cell G10 and enter a function to display today ' s date.
15 Copy the Data sheet and place the copied sheet before
4.000 the Summary sheet.
Remove the conditional formatting rule on the Data( 2) sheet.