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
FOOT CREAM MINI CASE: Athlete's Aid is a foot cream designed to prevent athlete's foot with once- daily application after shower
alex41 [277]

Answer:

The correct answer is:  negative message framing.

Explanation:

Negative message framing refers to the type of advertisement in which it is exposed benefits of a product in a very aggressive manner, showing proof of what the beneficial results of that product are or what the consequences of not having that product could lead to. As part of the marketing strategy, the advertisement is repeatedly prompted during events related to the use of the product.

3 0
3 years ago
When Olga asks Sven if he wishes to sell his Harley motorcycle, he replies that he would not sell it "for less than $2,000." Olg
klemol [59]

Answer:

The correct answer is B. False

Explanation:

Sven never agreed to selling his motorcycle at the spot, he only made a statement that should he intends to sell it later, he will not sell it lesser than $2000.

6 0
3 years ago
Fill in the missing word to complete the following statement based on the information in this lesson.
Likurg_2 [28]
I think d. sorry if i'm wrong
7 0
3 years ago
Read 2 more answers
For a natural monopoly to exist
vfiekz [6]

Answer:

The correct answer is A

Explanation:

Natural monopoly is the kind of monopoly which exists because of the high start up costs as well as the powerful economies of scale for conducting or performing a business in a particular industry.

And for this type of monopoly to exist , a firm or business need that the long run average cost curve will exhibit the economies of scale by the relevant range of the market demand.

3 0
3 years ago
Mary sells handmade earrings for a living. Susan is a new lawyer and a friend of Mary who gives legal advice to Mary in return f
umka21 [38]

Answer:

a.Susan is wrong, and Mary is free to disclaim warranties.

Explanation:

According to the Magnuson-Moss Act the seller of a product may or may not provide warranty on a product. But is warranty is provided the following conditions must be met.

- The seller must provide a full or limited warranty.

- The coverage of the warranty must be stated

- Warranty must be available to the customers, so that they can read it before making a purchase.

So Mary can choose to disclaim all warranties on her products, not making her liable for any defects found in them. But if she wants to provide warranty it must be written and follow the conditions stated above.

5 0
3 years ago
Other questions:
  • Within a PPF framework, explain each of the following: (a) a disagreement between a person who favors more domes-tic welfare spe
    15·1 answer
  • During this period, people who monitor the U.S. economy were constantly on the lookout for signs of inflation. Explain why infla
    8·1 answer
  • ​ object responsibility is important because it helps to decide what methods are assigned to what classes.
    13·1 answer
  • You are working on a team whose mission is to reduce the time it takes to deliver customer orders Your team is examining all ste
    9·1 answer
  • For each of the following cases determine the ending balance in the inventory account. (Hint: First, determine the total cost of
    8·1 answer
  • Beth is a retired teacher who lives in dallas and does some consulting work for extra cash. at a wage of $40 per hour, she is wi
    8·1 answer
  • Ben wants to file a complaint against a financial service company to report inappropriate use of the money he gave them to inves
    11·2 answers
  • Identify Project Needs The first step in any media-driven project is to determine whether the project is relevant to the purpose
    10·1 answer
  • State courts can review statutes passed by their legislatures to ensure:
    5·1 answer
  • On May 1, Year 1, Benz's Sandwich Shop loaned $10,000 to Mark Henry for one year at 6 percent interest.
    6·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!