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
aleksandr82 [10.1K]
3 years ago
15

Use a VLOOKUP function in cell I5 to identify and calculate the federal withholding tax. Use the tax rates from the range D21:E2

5. The VLOOKUP function returns the applicable tax rate, which you must then multiply by the taxable pay.
In the Cell 'I5' of Sheet 'Payroll Data', the 'Formula Result Value' was not set to '104.35'.


Calculate FICA in cell J5 based on gross pay and the FICA rate (cell B23), and calculate the net pay in cell K5. Copy all formulas down their respective columns to row 16.


In the Cell 'K9' of Sheet 'Payroll Data', the 'Formula' was not set to 'G9-I9-J9'.


In the Cell 'H13' of Sheet 'Payroll Data', the 'Formula' was not set to 'G13-B13*$B$24'.


In the Cell 'H16' of Sheet 'Payroll Data', the 'Formula' was not set to 'G16-B16*$B$24'.


In the Cell 'H9' of Sheet 'Payroll Data', the 'Formula Result Value' was not set to '350'.


In the Cell 'I7' of Sheet 'Payroll Data', the 'Formula Result Va
Computers and Technology
1 answer:
SVEN [57.7K]3 years ago
6 0
In the Cell 'H13' of Sheet 'Payroll Data', the 'Formula' was not set to 'G13-B13*$B$24'.
You might be interested in
6.5 Code Practice: Question 1 please help with code!!! Thank you
viva [34]

Answer: Eat my boy toy

Explanation:

7 0
3 years ago
It's a holiday poop in my bitt
Zina [86]

Answer:

bitt

Explanation:

pp

4 0
3 years ago
Read 2 more answers
What is virtual reality?
Burka [1]
The computer-generated simulation of a three-dimensional image or environment that can be interacted with in a seemingly real or physical way by a person using special electronic equipment, such as a helmet with a screen inside or gloves fitted with sensors.
4 0
3 years ago
SOMEONE HELP ME!!!!!
Oliga [24]

Answer:

I don't see the question

Explanation:

5 0
2 years ago
True or false
Semmy [17]
It’s false I hope this helped you
3 0
3 years ago
Other questions:
  • Use this option to view your presentation as your audience will see it. a.File menu b.Play button c.Slide Show button d.Tools me
    6·2 answers
  • How to connect an Apple Watch series 3 to your iPhone (ASAP)
    6·2 answers
  • Buenas , ayudenme con esta tarea de excel 2016
    6·1 answer
  • Boardman College maintains two files—one for Sociology majors and another for Anthropology majors. Each file contains students'
    5·1 answer
  • The part of the computer that contains the brain or the Central Park nursing unit is also known as
    10·1 answer
  • Software enables users to create documents
    13·1 answer
  • If a fire should break out in your building, which of the following actions is NOT recommended?
    10·2 answers
  • Which 2 processes are operational processes
    10·1 answer
  • What are styles? built-in conditional formatting rules formatting applied with the Format Painter defined combinations of format
    15·2 answers
  • State the base of correct addition of 27 + 6 =34​
    13·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!