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

Question

21-06-2022
Business

contestada

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

Respuesta :

Otras preguntas

As sea levels rise, which of the following will affect marine biodiversity? The acidity of the oceans will decrease. Underwater plants will receive less light

Helpppp Pleasee!?!!? ASAP!!

Which of the following statements best describes the graph of 3x − 2y = 4? A. It is a straight line joining the points (6, 2), (5, 1), and (7, 3). B. It is a st

simplify the expression (-3^2/ 3^3)^2

Given 3 sides of a triangle and how to find right acute or obtuse

Most of the photosynthesis in plants takes place in specialized __________ cells called the __________.

Which of the following is a great collection of resources for those entering the workplace or embarking on a new career?

Select two sentences in the passage that best show how Mr. Auld appeals to Mrs. Auld's concern for the well-being of the narrator, Frederick Douglass. excerpt f

The lines s and t intersect at point R. What is the value of y? y = ____

who tells Wendell Boldens that he as involed in the robery ? monster

Tundexi Tundexi · Answer 1 · 2022-06-23T19:38:49+02: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.

What is a cell?

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.