How do I find 7 & 8

Plane ticket Hotel Rate Traveling Days Hotel Expenses Per Diem $ Total Per Diem Total Expenses Using Functions !! $5,000.00 $350.00 $2,450.00 $300.00 $2,100.00 $7,450.00 Create range names for each of the columns containing data and $1,200.00 $250.00 $1,000.00 $300.00 $1,200.00 $2,200.00 Use Range Names to answer the questions below $1,800.00 $320.00 $3,200.00 $200.00 $2,000.00 $5,000.00 $1,200.00 $250.00 $500.00 $300.00 $600.00 $1,700.00 Number of Airline Companies $1,800.00 $320.00 $640.00 $200.00 $400.00 $2,440.00 Average Total Expense $4,532.50 $1,800.00 $320.00 $1,920.00 $200.00 $1,200.00 $3,720.00 Highest Total Expense $8,150.00 $5,000.00 $350.00 $700.00 $300.00 $600.00 $5,700.00 Lowest Total Expense $1,450.00 $1,200.00 $250.00 $2,500.00 $250.00 $2,500.00 $3,700.00 Most expensive Plane Ticket $5,000.00 $5,000.00 $350.00 $2,800.00 $300.00 $2,400.00 $7,800.00 Lowest number of traveling days $5,000.00 $350.00 $1,750.00 $300.00 $1,500.00 $6,750.00 $5,000.00 $350.00 $3,150.00 $300.00 $2,700.00 $8,150.00 Compute the following by referencing the correct cells: $1,200.00 $250.00 $1,250.00 $250.00 $1,250.00 $2,450.00 Percentage of Plane Ticket Cost to Total Expenses $1,200.00 $250.00 $1,250.00 $300.00 $1,500.00 $2,450.00 Percentage of Hotel Expenses to Total Expenses $3,500.00 $310.00 $2,480.00 $300.00 $2,400.00 $5,980.00 $1,200.00 $250.00 $1,250.00 $300.00 $1,500.00 $2,450.00 $1,200.00 $250.00 $250.00 $200.00 $200.00 $1,450.00 $5,000.00 $350.00 $1,750.00 $300.00 $1,500.00 $6,750.00 $5,000.00 $350.00 $2,450.00 $300.00 $2,100.00 $7,450.00 $3,500.00 $310.00 $1,550.00 $300.00 $1,500.00 $5,050.00 $3,500.00 $310.00 $1,550.00 $300.00 $1,500.00 $5,050.00 $5,000.00 $350.00 $1,050.00 $300.00 $900.00 $6,050.00 $1,800.00 $320.00 $640.00 $200.00 $400.00 $2,440.00 $1,200.00 $250.00 $2,000.00 $250.00 $2,000.00 $3,200.00 $1,800.00 $320.00 $1,600.00 $200.00 $1,000.00 $3,400.00 al: $69,100.00 $7,330.00 129 $39,680.00 $6,450.00 $34,950.00 $108,780.00