In column e, enter formulas that calculate the percentage of the grand total for each type of school supply (total cost of each

Question

2 years ago

13

In column e, enter formulas that calculate the percentage of the grand total for each type of school supply (total cost of each

item divided by the grand total). your formulas must use appropriate absolute cell references. format the calculated values as percentage with 0 decimal places.
someone please tell me what formula to use to get the % of grand totals

Business

1 answer:

anyanavicka [17] · Answer 1 · 2023-07-30T09:47:41+03:00

The formula to use get the % of grand totals is as follows:

after having the group subtotals, enter the formula SUBTOTAL(9,B2:B21) into a cell you need then press Enter key.

In a spreadsheet. this refers to the rectangular area that is formed by the intersection of a column and a row.

On a typical spreadsheet, every cells have its assigned code from Combination of Number 1-10 to Alphabet A-Z.

In order to calculate the percentage of the grand total for each type of school supply, we will need to enter a formula in the "% of Grand Total" column to divide the value in the "Total Cost" column by the grand total which will format the result as a percentage.