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
iVinArrow [24]
3 years ago
13

In cell g5, construct a formula to calculate the percent of total by dividing the annual total for salaries and benefits by the

annual total for totals by quarter. use absolute cell references as necessary, format the result in percent style, and then center. fill the formula down through cell g9
Business
1 answer:
bearhunter [10]3 years ago
7 0

Answer & Explanation:

Formula for Annual total for salaries and benefit is given by

=sum(B5:E5) this can be duplicated vertically by copying it down

Formula for totals by Quarter 1 is given by

= sum(B5:B9) this also can be duplicated horizontally in adjacent cells by copying it to the right

Formula for percent totals is done as follows

=F5/$F$10

input the above,copy it down vertically then go to home tab and under number and click the percent tab

done

attached below is a copy of the finished work excel

Download xlsx
You might be interested in
What is the law of demand? ​
Lunna [17]

Answer:

The law of demand states that all other things being equal, the quantity bought of a good or service is a function of price. As long as nothing else changes, people will buy less of something when its price rises. They'll buy more when its price falls.

Explanation:

5 0
3 years ago
Read 2 more answers
Which of the following statements is false? A. A debit card never has a MasterCard or Visa logo on it. B. Your debit card is lik
velikii [3]
A debit card is like cash, because you withdraw from your bank account money that you've already saved in it, so it's not B. or C.
D. is obviously true, so it isn't that either.

So by process of elimination, I'm pretty sure the correct answer is A.

5 0
3 years ago
g Bob makes his first $ 800 deposit into an IRA earning 7.4 % compounded annually on his 24th birthday and his last $ 800 deposi
Gala2k [10]

Answer:

FV= $137,440.62

Explanation:

Giving the following information:

Bob makes his first $ 800 deposit into an IRA earning 7.4 % compounded annually on his 24th birthday and his last $ 800 deposit on his 39th birthday ​(16 equal deposits in​ all). With no additional​ deposits, the money in the IRA continues to earn 7.4 % interest compounded annually until Iob retirees on his 65th birthday.

First, 16 years:

FV= {A*[(1+i)^n-1]}/i

A= annual deposit

FV= {800*[(1.074^16)-1]}/0,074= $23,067.90

Next 25 years.

FV= PV*(1+i)^n

FV= 23,067.90*(1.074)^25= $137,440.62

6 0
3 years ago
You speculate in crude oil futures. Last month, you purchased ten January futures contracts at a quoted price of 99.91. These co
shepuryov [24]

Answer:

Loss of $397,100

Explanation:

The price in future contract is $99.91 per barrel, and actual price is $60.20

The loss per barrel  = $99.91 - $60.20 = $39.71

Total loss = 10 contracts * 1000 barrels * loss of $39.71 per barrels =

= 10*1000*$39.71 = $397,100

5 0
3 years ago
Read 2 more answers
Nancy and Joan bought a small farm for $300,000 under an installment land contract with a $50,000 down payment. They will pay in
KatRina [158]

Answer:

75,000

Explanation:    

300,000-50,000 = 250000*6%*5

6 0
3 years ago
Other questions:
  • A warranty of title does not arise automatically under a contract for a sale of goods.
    5·1 answer
  • Courses of action such as halting the market research project, making responses anonymous, and instituting training on the ama c
    9·1 answer
  • Eley Corporation produces a single product. The cost of producing and selling a single unit of this product at the company's nor
    11·1 answer
  • Pelzer Printing Inc. has bonds outstanding with 9 years left to maturity. The bonds have a 8% annual coupon rate and were issued
    11·1 answer
  • Thermopolis, Inc. reported retained earnings of $490,953 on December 31, 2017. During the year, Thermopolis recorded net income
    12·1 answer
  • A(n) ______ is a network that links the intranets of business partners via the Internet in such a way that the result is a virtu
    7·1 answer
  • Which of the following is NOT one of the components of a firm's business model?
    5·1 answer
  • Flexibility of practice when applied to managerial accounting means that: Multiple Choice The information must be presented in e
    9·1 answer
  • What is an advantage for Freeman XP, a brand experience company that organizes large events such as trade shows, of hiring union
    5·1 answer
  • In long-run equilibrium, monopolistically competitive firms will show a(n) _____.
    12·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!