# excel graphing

posted by .

In column F (cell ranges F5:F16), use an appropriate formula
to calculate the percentage of the grand total for each type of
office supply. Format the results in the Percentage style. If
necessary, decrease the decimal places to round the results
to the nearest whole percent.

I'm not sure what formaula to use to get the percentage?

• excel graphing -

http://search.avg.com/route/?d=4cbfb155&v=7.004.022.004&i=23&tp=chrome&q=excel+tutorial&lng=en-US&iy=&ychte=us

Choose one of the tutorials here, depending on the version of Excel you have.

• excel graphing -

Im trying to find the percent of a grand total.
Total cost 74.75,cost/unit 2.99, number of units 25

I'm still don't understand how to get the percent ive tried everything i divided 2.99/74.85 and got 4% but the answer is 14% they give you the answer but i have to show the formaula i used to get 14 and i don't know how please help.

• excel graphing -

I do not know what numbers are shown in column F (F5 to F16).

Assume for the moment F5:F8 shows:

F G
10 12%
18 21%
32 38%
24 29%

83 100%

83 is the grand total
12% is obtained by dividing 10 by 83, or
+F5/F\$9 (assume the grand total is in F9) The "\$" is necessary because G5=+F5/F\$9, and G6=+F6/F\$9, ...

Hope that helps. If you have questions, please post the contents of F6:F16 as example for discussion.

• F6:F16 -

the answer they gave me was 14% and i am suppose to figure out the formula but i still cant i did 2.99/521.07< which is the grand total at the end of column f16 i still did not get 14

• excel graphing -

In cell E18, use an appropriate formula to calculate the grand
total of column E. Format the result in the Currency style.
In column F (cell ranges F5:F16), use an appropriate formula
to calculate the percentage of the grand total for each type of
office supply. Format the results in the Percentage style. If
necessary, decrease the decimal places to round the results
to the nearest whole percent.
In cell F18, use an appropriate formula to calculate the total
percentage. Format the result in the Percentage style and
decrease the decimal places if necessary to round the result
to the nearest whole percent. (Obviously, the result should
equal 100%.)
Repeat these procedures for column J (Total Cost) and column
K (% of Grand Total) for the month of February. (Place
the grand total of column J in cell J18 and the grand total of
column K in cell K18.) Again, remember to use formulas.

• excel graphing -

I still do not see the contents of cells E5:E16, so I cannot confirm how the 14% answer can be obtained.

On the other hand, if you would calculate the previous cost \$74.75/grandtotal=521.07, you'd get 14.3%, or, 14% rounded to the nearest percent.

What needs to be done is to calculate E18 as +sum(E5:E18).
Then in the cell F5, calculate the percentage by the formula +E5/E\$18. The extra dollar sign between E and 18 is to "fix" the cell number 18 when you copy the cell F5 to other rows.

After that, you would copy the cell F5 to each of the cells F6:F16, and F18.

You should see 1.00 in cell F18. We need now to change the cells in column F to percentages in whole numbers. Format the column F and select type as "percentage", and the number of decimal places as 0.

If you succeed in doing the above, you should have no problem with other columns.

Post if you need further help.

• excel graphing -

Thank you so much i think i've got it

• excel graphing -

You're welcome!

## Similar Questions

1. ### Computer Science/Excel

Here's the problem: John believes that the average American will be in debt forever. He decides to create a table that demonstrates this. He thinks that given 60 months (5 years) to get out of debt and the annual percentage rates 1-5 …
2. ### excel graphing

In cell D21, type the formula to calculate the % change from January to February. That formula is: =(J18-E18)/ABS(E18). Format the result in the Percentage style and decrease the decimal places if necessary to round the result to the …
3. ### excel graphing

In cell D21, type the formula to calculate the % change from January to February. That formula is: =(J18-E18)/ABS(E18). Format the result in the Percentage style and decrease the decimal places if necessary to round the result to the …

In cell D21, type the formula to calculate the % change from January to February. That formula is: =(J18-E18)/ABS(E18). Format the result in the Percentage style and decrease the decimal places if necessary to round the result to the …
5. ### excell graphing

what formula should i use to calculate the total cost of cell ranges like E5:E16
6. ### Math/Excel

I'm not sure what two excel functions to use that will give the correct answer and how to copy the information to each cell and the values stay the same. 2. A home loan is to be repaid by a series of equal monthly payments over many …
7. ### Excel & Math

I'm not sure what two excel functions to use that will give the correct answer and how to copy the information to each cell and the values stay the same. 2. A home loan is to be repaid by a series of equal monthly payments over many …
8. ### Excel

I'm trying to format a database, but I am having this problem- I use the "format as table" feature, but then when I use the drop-down menus that appear, one column will format, but when I go to the next column, the previous change …
9. ### Calc

I need help finding the correct formula after finding the doubling time and continuous percentage. I got the doubling time of 24 days and the continuous percentage of 2.89%. Homework asking use the doubling time to find the continuous …
10. ### Maths Percentage

(1)Raghu has some apple. He sold 40% more than he ate. If he sold 70 apples, how many did he ate?

More Similar Questions