subject

Use a vlookup function in cell i5 to identify and calculate the federal withholding tax. use the tax rates from the range d21: e25. 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

ansver
Answers: 1

Another question on Computers and Technology

question
Computers and Technology, 22.06.2019 19:20
Consider the following code snippet: #ifndef cashregister_h#define cashregister_hconst double max_balance = 6000000.0; class cashregister{public: cashregister(); cashregister(double new_balance); void set_balance(double new_balance); double get_balance() const; private: double balance[12]; }; double get_monthly_balance(cashregister bk, int month); #endifwhich of the following is correct? a)the header file is correct as given.b)the definition of max_balance should be removed since header files should not contain constants.c)the definition of cashregister should be removed since header files should not contain class definitions.d)the body of the get_monthly_balance function should be added to the header file.
Answers: 1
question
Computers and Technology, 22.06.2019 22:00
During physical science class ben and jerry connected three identical lightbulbs in parallel to a battery where happens when ben removes one of the lightbulbs from it’s socket
Answers: 2
question
Computers and Technology, 22.06.2019 23:30
Select all that apply. which of the following are proofreading options included in microsoft word? spell check find replace grammar check formatting check
Answers: 1
question
Computers and Technology, 24.06.2019 00:50
Which player type acts on other players? a. killer b. achiever c. explorer d. socializer
Answers: 1
You know the right answer?
Use a vlookup function in cell i5 to identify and calculate the federal withholding tax. use the tax...
Questions
question
Health, 31.10.2020 05:40
question
History, 31.10.2020 05:40
question
Biology, 31.10.2020 05:40
question
Biology, 31.10.2020 05:40
question
Mathematics, 31.10.2020 05:40
Questions on the website: 13722361