PLEASE INCLUDE EXCEL FORMULAS

Question 1 Pivot Table Data Use the data in the table below to answer the questions on the Q1 worksheet already created a named range called "order" which includes the entire dataset if that helps.) should be in "comma" format with no decimal place. (i.e 44,910) B - Create a Calculated Field called Total Profits, where Total Profits = TR - TC. Now add this as a column in your pivot table. Settings". Call this column "Contrib to Profits". Format your numbers as percentages with 2 decimal place (i.e 12.12\%). your Pivot Table. Question 1 Pivot Table Data Use the data in the table below to answer the questions on the Q1 worksheet already created a named range called "order" which includes the entire dataset if that helps.) should be in "comma" format with no decimal place. (i.e 44,910) B - Create a Calculated Field called Total Profits, where Total Profits = TR - TC. Now add this as a column in your pivot table. Settings". Call this column "Contrib to Profits". Format your numbers as percentages with 2 decimal place (i.e 12.12\%). your Pivot Table