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
As you grow older, which of these might make you change your personal finance decisions more?
algol [13]

Answer:

1

Explanation:

As you grow older, and with the possibility of having children and a significant other, you're going to have to dedicate more of your financial budget into your families needs.

3 0
3 years ago
Read 2 more answers
A business must decide whether to open a new office in China. If it opens the
ivolga24 [154]
D a is the correct answer I’m pretty sure
4 0
3 years ago
Suppose that white workers are getting paid $21/hour, while similarly-productive African-American workers are getting paid $18/h
Semmy [17]

Answer:

C) Not hire African-Americans at all, even if they offer to work for free.

Explanation:

Racism is a type of prejudice that even nowadays continues to exist and sadly many important people try to encourage it, like ____________. Feel free to fill in the blank with your favorite president or favorite cabinet member.

Racism is bad, and racist people are bad people. So it shouldn't be a surprise that a racist man/woman will not hire African Americans even if they offer to work for free. They wouldn't probably hire Latin workers or Asians either.

4 0
4 years ago
More free pts for yall!!
antoniya [11.8K]

Answer:

Thank you so much!!

Explanation:

Explanation

5 0
3 years ago
Read 2 more answers
What determines the value of an item?
galina1969 [7]

The value of item is determined by its utility to the person who is purchasing it. If an item has high utility, then consumers are willing to pay more and will value the product more. If an item has low utility, it will not be very valuable to the person. People value items differently. the old saying that one's man's trash is another's treasure holds true here.

7 0
3 years ago
Other questions:
  • A physical inventory on December 31 shows 4,000 units on hand. Eneri sells the units for $13 each. The company has an effective
    9·1 answer
  • A(n) _______ list can help you gain an understanding of contacts who met a certain criteria on a particular date. Then you can l
    12·1 answer
  • Which of the following is not a characteristic of intangible assets?(a)They lack physical existence.(b)They are not financial in
    13·1 answer
  • You were planning to spend your Saturday working at your part-time job, but a friend asks you to go trekking at Karagöl. What is
    13·1 answer
  • What is the biggest advantage of having a checking account
    15·1 answer
  • You invest $1,000 now, at an annual simple interest rate of 6%. What is the effective rate of interest in the fifth year of your
    14·1 answer
  • Suppose the daily market demand for meat in a small town is given by
    15·1 answer
  • Ill mark brainiest for the correct answer
    5·2 answers
  • 10,000 can be invested under two options: Option 1. Deposit the 10,000 into a fund earning an effective annual rate of i; or Opt
    14·1 answer
  • which of the following is a partnership for tax purposes? a.melissa purchases a shoe store and hires her sister, whitney, to man
    10·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!