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 .