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
Use the net FUTA tax rate of 0.6% on the first $7,000 of taxable wages. Michael Mirer worked for Dawson Company for six months t
lisov135 [29]

Answer:

$83.4

Explanation:

Under FUTA, only the first $7000 earning per year will be taxed. Any amounts above $7000 will be tax-exempt.

For Michael, the tax will be calculated as follows.

for the$11200 earned in Dawson company

=0.6% x $7000

=0.06/100 x 7000

=0.006 x 7000

=$42

Amount earned working at McBribe

=0.06% x 6900

=0.006 x $6900

=$41.4

Total to be paid by the two companies

=$42 + $ 41.4

=$83.4

5 0
3 years ago
6. A zero coupon bond with 2.5 years to maturity has a yield to maturity of 25% per annum. A 3-year maturity annual-pay coupon b
kari74 [83]
Ahaha s we. S s s s s s s s s. S ss
3 0
3 years ago
A retail store credited the sales revenue account for the sales price and the amount of sales tax on sales. if the sales tax rat
alexira [117]
We have to calculate the amount of the sales taxes owed to a taxing agency.
The tax rate is 5% ( 0.05 ) and the balance in the sales revenue account amounted to $294,000.
$294,000 * 0.05 = $14,700
Answer:
Amount of the sales taxes is B ) $14,700.
8 0
3 years ago
How does inflation hurt your savings?
siniylev [52]

Answer:

have to spend more money

Explanation:

4 0
2 years ago
Which is the last step in making a personal budget?
OlgaM077 [116]
The last step in making a personal budget is to reduce expenses in flexible categories. The correct option among all the options given in the question is option "B". Under normal circumstances, a person cannot make the adding up all sources of income as the last step. Then the expenses will not get added. The flexible expenses are expenses that can always be reduce or are not important expenses. The basis of making the budget is to reduce those unnecessary expenses. So the last step should always be to find ways to reduce the flexible or unwanted expenses.
4 0
3 years ago
Other questions:
  • Company ABA showed its customers products with various combinations of features and attributes, with price being one of them. It
    10·2 answers
  • In 2018, Mark has $18,000 short-term capital loss, $7,000 28% gain, and $6,000 0%/15%/20% gain. Which of the statements below is
    9·1 answer
  • Philosophers draw a distinction between ___________________, which describe the world as it is, and normative statements, which
    6·1 answer
  • Toys R Fun purchased $4,000 of merchandise for resale and paid immediately. To record this transaction, Toys R Fun's accountant
    8·1 answer
  • Depth of product line refers to Multiple Choice the number of different product classes owned by a corporate chain. the percenta
    6·1 answer
  • The u.s. dollar is defined as: commodity money, because it is widely used to buy commodities. fiat money, because it was establi
    14·1 answer
  • A corporation's board of directors are - the sole owners of the corporation. - control the day-to-day activities of the corporat
    5·1 answer
  • when demand does not change much after a price change, demand is: a. variable b. static c. elastic d. inelastic
    8·2 answers
  • THis is funny lol my class is boring hehe I need help with my homework who can be my homework boy/girl?
    14·1 answer
  • The united states is a major trader in ________, the fastest growing segment of world trade.
    7·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!