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 the price of good X rises from $10 to $12, the quantity demanded of good Y rises from 100 units to 114 units. Are X and Y sub
Darina [25.2K]

Answer: Substitute

Explanation:

Substitute goods are the goods that can be used for the same purpose. Complement are the goods that are used together e.g. car and petrol.

It should be noted that when the price of a good increase, people move to the substitute and this will being about the rise in the quantity demanded of the other good.

Therefore, as the price of good X rises from $10 to $12, the quantity demanded of good Y rises from 100 units to 114 units shows that the are substitutes.

4 0
2 years ago
"When the dollar appreciates, U.S." exports increase, while imports decrease. b. exports and imports increase. c. exports decrea
Zina [86]

Answer:

C) Exports decrease, imports increase

Explanation:

If the US dollar appreciates, the US dollar has now more value per unit of foreign currency than before. For example, suppose that today 1 US dollar buys 0.8 Euro, and tomorrow, Europe is hit by a financial crisis, and the US dollar appreciates, and buys 1.2 Euro. The US dollar has appreciated, has become more expensive, becomes now more euros are needed to buy 1 US dollar.

When the US dollar gains value, domestic goods become more expensive compared to foreign goods, and this promotes imports, and reduces exports.

This is the reason why China keeps a depreciated currency: China is an export economy and the cheap Chinese currency makes exports cheaper, and imports more expensive.

5 0
3 years ago
Strategic planning starts with a _____ that reflects a firm’s vision, purpose, and values.
ivann1987 [24]

Strategic planning starts with a mission statement that reflects a firm’s vision, purpose, and values.

Strategic Planning Process: Strategic planning is the process of identifying long-term organizational goals, strategies, and resources, focusing on the horizon more than three years away.

Most large companies rely on one person to evaluate system requirements rather than relying on a system review committee. When assessing the feasibility of a schedule, systems analysts need to consider the trade-off between time and cost.

CRM (Customer Relationship Management) components can provide automated responses to sales inquiries, online order processing, and inventory tracking values.

Learn more about Strategic planning at

brainly.com/question/24864915

#SPJ4

5 0
2 years ago
According to the video, what are a Computer Programmer's real skills? Check all that apply.
choli [55]

Answer:

1 3 thx for the answer!

Explanation:

3 0
3 years ago
Read 2 more answers
Cyclical unemployment is
Andre45 [30]
Cyclical unemployment is a factor of overall unemployment that relates to the cyclical trends in growth and production that occur within the business cycle.


5 0
3 years ago
Other questions:
  • Sally is not feeling well so her mother takes her to the doctor. The doctor tells her she has strep throat, gives her medication
    11·2 answers
  • The panic of 1819:
    15·1 answer
  • Is it easy to start or stop a mma investment
    9·1 answer
  • When the opportunity cost of producing a good rises as you produce more of it, you experience:_______.
    7·1 answer
  • The following information was drawn from the Year 1 accounting records of Ozark Merchandisers: Inventory that had cost $15,000 w
    7·1 answer
  • A company pays its employees $4,250 each Friday, which amounts to $850 per day for the five-day workweek that begins on Monday.
    10·1 answer
  • In conducting interviews and observing factory operations to implement an activity-based costing system, you determine that seve
    15·1 answer
  • There is often litter along highways but rarely in people's yards. Which of the following statements help explain this observati
    10·1 answer
  • Please help, this is very simppleee!! ^^
    8·2 answers
  • What does Rose argue should be the last part of a presentation to the VEnture capitalist?
    13·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!