Average Profit % = Total Profit / Total Sales
B . Create Grand Totals for the Total Sales and the Total Profit columns .
C . Create the formula that will average all of the item profit %.
D . Create formula to calculate the Remaining Profit needed to make the Marching Band goal for the fundraising campaign .
Remaining Profit = The Profit Goal - Total Profit ( all items )
One of the strengths of Excel is its ability to make tedious and repetitious calculations , for speed and to reduce errors . Like all tools , there is always the possibility that you could use it incorrectly , so with formulas , it is important to verify the formulas you enter are correct .
Note : Refer to the Creating Formulas video in the Lesson tutorials for help with this step .
If you have done the Tutorial on formulas , you will have noticed , during the creation of the formulas , that there are many ways to accomplish similar results . Remember that arithmetic formulas follow an order in which calculations are performed . I make it a personal habit to always use parentheses () to order the calculations in the order in which I want them performed , so as not to make a mistake .
For example , if I enter the following formula into Excel , what is the outcome that I wanted ?
6 + 4 * 10