Computer Science, asked by kpkaransingh36, 3 months ago

Write the formula to calculate the Total Sales of North Zone​

Answers

Answered by kalivyasapalepu99
1

1

Open a new spreadsheet in Microsoft Excel.

2

Enter the name, or type, of your first item in cell A1. As an example, you might enter "Action figures."

3

Enter the total sales from the first item in cell B1. If you derived $15,000 from action figures sales, you would enter "$15,000" in cell B1.

4

Repeat this process for each item, or type of item, on a new line. In the example, if you only sold action figures and toy cars, you would enter "Toy cars" in cell A2 and its total sales, such as "$1,000," in cell B2.

5

Enter "=sum(B1:B#)" in the next empty cell in the B column, and replace "#" with the row number of the last filled cell in column B. In the example, you would enter "=sum(B1:B2)" in cell B3 to calculate the total sales of the two items.

6

Type "=item_sales/total_sales" in the C column for each item row. Replace "item_sales" with the individual item's sales and "total_sales" with the reference to the cell you filled out in the previous step. In the example, you would enter "=B1/B3" in cell C1 and "=B2/B3" in cell C2.

7

Right-click the "C" column header and select "Format Cells." Click "Percentage from the Number tab and click "OK" to format the results as a percentage. The data in column C will then display the percent of total sales for each item.

Attachments:
Similar questions