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
What is <br> central vision
ser-zykov [4K]
Look for it in the dictanory
7 0
3 years ago
Read 2 more answers
Hanging out with friends, watching your favorite TV show, and buying a pair of new shoes are all examples of _____ for doing wel
SpyIntel [72]
<span>Hanging out with friends, watching your favorite TV show, and buying a pair of new shoes are all examples of rewards for doing well in school. As the result of doing well in studies, a person can hang out with friends, watch their own favorite TV show and can buy a new pair of shoes. Hence all these things are the rewards that are being generated for a good performance in school.</span>
8 0
3 years ago
Read 2 more answers
Explain how a touris could use QR codes at an airport to help plan a holiday
elena55 [62]

Answer:

with tech

Explanation:

8 0
3 years ago
Which option ie an example of an html end tag
Kay [80]
Any end tag in HTML needs to look like this, the word body used in this example is one of the more important elements, but you can replace it to any real element in HTML:
i.e. </body>
8 0
3 years ago
To join a social network you create an avatar true or false
svp [43]
False because not all social media webstites provide avatars
7 0
3 years ago
Read 2 more answers
Other questions:
  • A network administrator is required to upgrade wireless access to end users in a building. To provide data rates up to 1.3 Gb/s
    12·1 answer
  • You asked your colleague to provide feedback on a blog post you recently wrote. When they sent you their feedback, they made edi
    10·1 answer
  • Assume that the string oldSeq has been properly declared and initialized and contains the string segment. Write a code segment t
    6·1 answer
  • Which HTML tag is used to add a paragraph to a web page?
    15·1 answer
  • The blank provides access to the internet May also be internal ??
    14·1 answer
  • When adopting the use of social media in emergency management, it is important to have
    10·1 answer
  • Which one of the following items is an example of software?
    5·1 answer
  • Explain one way in which programmers may get hired.
    9·1 answer
  • What is the next line?
    7·1 answer
  • How do you access the <br><br>internet in your school and at home?​
    11·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!