1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
Arte-miy333 [17]
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]2 years ago
7 0

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.

<h3>What is a cell?</h3>

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.

Read more about cell

<em>brainly.com/question/25879801</em>

#SPJ1

You might be interested in
How does the dynamic model of aggregate supply and aggregate demand explain​ inflation? A. by showing that if total spending in
boyakko [2]

Answer:

The correct answer is option A.

Explanation:

The dynamic model of aggregate supply and aggregate demand shows that if an economy the total spending in the economy increases faster than total production, there will be a shortage. This shortage will cause the price level to increase and will ultimately lead to inflation.  

When the increase in aggregate demand is greater than the increase in aggregate supply, it will create a shortage in the economy. The demand for goods and services will be more than the supply of goods and services. This will cause the price level to increase.

4 0
3 years ago
Zumbrunn Company’s income statement contained the following condensed information. ZUMBRUNN COMPANY Income Statement For the Yea
kotykmax [81]

Answer:

Explanation:

the solution is given in the file attached. I hope it helps you. Thank you

Download docx
8 0
4 years ago
Read 2 more answers
During its first year of operations, Novak Corp. Had these transactions pertaining to its common stock. Jan. 10 Issued 26,000 sh
bonufazy [111]

The journal entries to record the common stock transactions under the two scenarios are as follows:

a) Assuming that the common stock has a par value of $4 per share:

Jan. 10 Debit Cash $104,000

Common Stock $104,000

July 1 Debit Cash $495,000

Common Stock $220,000

Additional Paid-in Capital $275,000

b) Assuming that the common stock is no-par with a stated value of $3 per share

Jan. 10 Cash $104,000 Common Stock $78,000 Additional Paid-in Capital $26,000

July 1 Cash $495,000 Common Stock $165,000 Additional Paid-in Capital $330,000

<h3>What is the difference between par value and stated value?</h3>

There is <u>no major difference</u> between the par value and the stated value of the common stock, except as follows.

While the stated value is assigned when there is no par value for accounting purposes, the par value is assigned when the shares are authorized for issuance.

The two function as the face value of the shares which can be compared to the market value to discover if there is additional paid-in capital or not.

<h3>Data and Calculations:</h3>

a) Jan. 10 Cash $104,000 Common Stock $104,000

July 1 Cash $495,000 Common Stock $220,000 Additional Paid-in Capital $275,000

b) Jan. 10 Cash $104,000 Common Stock $78,000 Additional Paid-in Capital $26,000

July 1 Cash $495,000 Common Stock $165,000 Additional Paid-in Capital $330,000

Learn more about recording stock issuance transactions at brainly.com/question/17201601

7 0
2 years ago
What are the pressure that Lenovo faces for global integration?
blsea [12.9K]

Answer:

cost reduction and standardizing its products globally.

Explanation:

  • Lenovo needs to capitalize on the consumer trends and the universal needs of the products globally and seek to reduce the costs in increasing flexibility, acquire knowledge, scale economies, and improve on the quality of the product and the process that creates them.
4 0
3 years ago
Pacific Packaging's ROE last year was only 6%; but its management has developed a new operating plan that calls for a debt-to-ca
Gre4nikov [31]

Answer:

0.11%

Explanation:

Given that

Earning before interest and tax = $560,000

Interest = $336,000

The computation of company's return on equity is shown below:-

So, the Earning before tax

= $560,000 - $336,000

= $224,000

Tax = $224,000 × 30%

= $67,200

Earnings after interest and taxes = Earning before tax - Tax

= $224,000 - $67,200

= $156,800

Asset turnover ratio = total revenue ÷ total assets

3.4 = $8,000,000  ÷ total assets

Total assets = 2,352,941.18

Equity ratio = 1 - debt ratio

= 1 - 0.40

= 0.60

Total Equity = equity ratio × total assets

= 0.60 × 2,352,941.18

= 1,411,764.71

Return on Equity = Net income ÷ Equity

= $156,800 ÷ 1,411,764.71

= 0.11%

6 0
3 years ago
Other questions:
  • Dodson Company traded in a manual pressing machine for an automated pressing machine and gave $40,000 cash. The old machine cost
    13·1 answer
  • What is a living will
    10·1 answer
  • A company purchased equipment valued at $120,000. It traded in old equipment for a $95,000 trade-in allowance and the company pa
    10·1 answer
  • What are the two factors that are examined in the administrative management theory when trying to create an organization that is
    15·1 answer
  • Appointing a Chief Technology Officer (CTO) to administer the organization's technology base and translate vision and planning i
    12·1 answer
  • C&amp;A Fast Food has four activities in serving a customer: greet customer, take order, process order, and deliver order. Each
    12·1 answer
  • Sports Corp. has 10 million shares of common stock outstanding, 5 million shares of preferred stock outstanding, and 1 million b
    13·2 answers
  • nterest rates on 2-year Treasury securities are currently 6.0%, while 6-year Treasury securities yield 6.5%. If the pure expecta
    5·1 answer
  • The act of retaining or keeping something
    6·1 answer
  • Danks Corporation purchased a patent for $405,000 on September 1, 2019. It had a useful life of 10 years. On January 1, 2021, Da
    8·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!