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
The types of problems the mne confronts when determining the need for training of its local workforces include determining who s
lukranit [14]
The correct answer is all of the above. Multinational corporations grapple with a diversity of challenges when choosing training programs for their employees. These include choosing a program that is sensitive to the local culture and how to reconcile it with the global nature of the corporation. This also introduces the challenge of who should conduct the training.
8 0
3 years ago
Read 2 more answers
A group of businessmen and women get together to try to solve the problem of decreased sales of their company's products. One of
Tems11 [23]

Answer:

The answer is brainstorming

Explanation:

6 0
4 years ago
Lance Whittingham IV specializes in buying deep discount bonds. These represent bonds that are trading at well below par value.
Marianna [84]

Answer:

$508.63

Explanation:

For this question, we use the Present value formula that is reflected in the attached spreadsheet. Kindly find it below:

Provided that

Given that,  

Future value = $1,000

Rate of interest = 14%

NPER = 15 years

PMT = $1,000 × 6% = $60

The formula is shown below:

= -PV(Rate;NPER;PMT;FV;type)

So, after solving this, the present value is $508.63

3 0
3 years ago
When a country is not able to produce a good more efficiently than other nations, but produces the good more efficiently than it
nikitadnepr [17]

Answer:

The answer is comparative advantage.

Explanation:

Comparative advantage is when a country is able to produce goods and services at a lower opportunity cost than its trading partners. That means a labour can produce more goods per hour than a labour in its trading partner's country.

A country with a comparative advantage will be able to charge lower price for what she is specialising on.

3 0
3 years ago
Linda visits her favorite clothing store and is disappointed to discover that the shirt she was hoping to purchase is out of sto
Julli [10]

Answer:

d. backorder

Explanation:

Based on the scenario being described within the question it can be said that the sales associate most likely offered to backorder the item for Linda. This is when a retailer places an order for a product that is no longer in stock for the time being, in order to comply with the customer, but will take a while for that order to come in and for the transaction to be completed.

8 0
4 years ago
Other questions:
  • A company's Cash account shows an ending balance of $4,200. Reconciling items included a bookkeeper error of $50 (a $550 check r
    14·1 answer
  • An externality arises when a firm or person engages in an activity that affects the wellbeing of a third party, yet neither pays
    10·1 answer
  • How should Kane work with the salespeople to introduce the change?
    10·1 answer
  • Heidi comes from an upper-middle-class family, and after high school she went through a period of exploration. She spent some ti
    8·1 answer
  • If a purely competitive firm is currently facing a situation where the price of its product is lower than the average variable c
    8·2 answers
  • A ________ is a distinctive group of customers within a larger market who are similar to one another in some way and whose needs
    12·1 answer
  • The Rodriquez family is determined to purchase a $250,000 home without incurring any debt. The family plans to save $2,500 a qua
    15·1 answer
  • Inventory is important in the supply chain for many different reasons. Why would you invest the​ company's money for inventory a
    10·1 answer
  • Give an example of one good or service produced in the United States using the command model. Justify your example using researc
    9·1 answer
  • 6. Consider an economy described by the following equations:
    9·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!