Question one: cell I$3-$ Enter a formula that results in gross profit as a percent of sales using the data in row $2$

Question two: cell N$3-$ Enter a formula that result in total cost of bid requests using the data in row two

Question three: cell O$3-$ Enter a formula that results in total cost of shipments using the data in row $2$

Question four: cell P$3-$ Enter a formula that results in total cost of standard

orders using the data in row $2$

Question five: cell Q$3-$ Enter a formula that results in total cost of special orders using the data in row $2$

Question six: cell R$3-$ Enter a formula that result in net income as a percent of sales using the data in row two

The next questions are in relation to a pivot table please tell me how to filter them properly to get the right answers. The filters are $($customer$,$ region, revenue, cost of goods sold, percentage of sales gross profit, number of bid request, number of shipments, number of standard orders, number of special orders, total cost of bid request, total cost of shipments, total cost of standard orders, total cost of special orders, percentage of sales net income$)$

Question one: what is the total dollar amount of gross profit in the tadoussac and dawson regions combined?

Question two: what is the average net income percentage in the banff and jasper regions combined?

Question three: what is the percentage for the customer in the killarney region with the highest gross profit percentage?

Question four: What is the dollar net income for the region with the second highest amount?