BIS 155 Course Great Wisdom / tutorialrank.com BIS 155 Course Great Wisdom / tutorialrank.com | Page 17

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