Question: EA7-R1 Create a Payroll Register for Audio Warehouse !!! OURO In this exercise, you will create a payroll register for Audio Warehouse using ROUND, IF,

EA7-R1 Create a Payroll Register for Audio Warehouse !!! OURO In this exercise, you will create a payroll register for Audio Warehouse using ROUND, IF, and VLOOKUP functions. You will also modify the worksheet's layout and highlight key elements. Use this information to complete the payroll register. FWT SWT Check Number $18 $12 881 $28 $19 882 Employee Name Ventura, G Carrey, Y Stewart, J Armstrong, s Roberts, F $32 $20 883 $16 $11 884 $10 $6 885 1. Open EA7-R1-Payroll from your Chapter 07 folder and save it as: EA7-R1-Payroll-[YourName] 2. Select cell H9, choose Formulas->Function Library->Insert Function, select the Logical category and then choose the IF function, and click OK. 3. Fill in the Function Arguments dialog box as indicated, clicking OK when finished: . . . Cen@ o ji E 3. Fill in the Function Arguments dialog box as indicated, clicking OK when finished: Logical_Text box: F9=0 Value_If_True box: "N/A" Value_If_False box: F9*G9 4. Copy cell H9 to the range H10:H13. 5. Select cell 19, choose Formulas Function Library-Insert Function, select the Math & Trig category and the Round function, and click OK. 6. In the Number box, type IF (H9="N/A", E9, E9+H9) and in the Num_digits box, type 2; click OK. 7. Copy cell 19 to the range 110:113. 8. Enter the federal and state withholding tax figures in the range J9:K13 Use Nested IF Functions, Absolute Formatting, and Mixed Formatting 9. In cell L9, type: =ROUND(IF(127>$L$24, 0, IF(127+19$L$24, 0, IF (127+19Function Library->Insert Function, select the Logical category and then choose the IF function, and click OK. 3. Fill in the Function Arguments dialog box as indicated, clicking OK when finished: . . . Cen@ o ji E 3. Fill in the Function Arguments dialog box as indicated, clicking OK when finished: Logical_Text box: F9=0 Value_If_True box: "N/A" Value_If_False box: F9*G9 4. Copy cell H9 to the range H10:H13. 5. Select cell 19, choose Formulas Function Library-Insert Function, select the Math & Trig category and the Round function, and click OK. 6. In the Number box, type IF (H9="N/A", E9, E9+H9) and in the Num_digits box, type 2; click OK. 7. Copy cell 19 to the range 110:113. 8. Enter the federal and state withholding tax figures in the range J9:K13 Use Nested IF Functions, Absolute Formatting, and Mixed Formatting 9. In cell L9, type: =ROUND(IF(127>$L$24, 0, IF(127+19$L$24, 0, IF (127+19

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

create a payroll register for audio warehouse Create a Payroll Register for Audio Warenouse 1. Oren EA7-R1-Payroll from yart Chaper or Logical category and then dhoose the If firatiend kis ok. -...

Apply Your Skills 217 Apply Your Skills EA7-A1 Create a Payroll Register for Athletics Supply House In this exercise, you will create a payroll register for Athletics Supply House using ROUND. IF,...

Included Excel Formula Apply Your Skills 217 Apply Your Skills EA7-A1 Create a Payroll Register for Athletics Supply House In this exercise, you will create a payroll register for Athletics Supply...

I need help on this problem and the Google doc provided in this is not public + m + 0 TI-1795 SV Apply Your Skills 217 Apply Your Skills EA7-A1 Create a Payroll Register for Athletics Supply House In...

EA7-A1 Create a Payroll Register for Athletics Supply House In this exercise, you will create a payroll register for Athletics Supply House using ROUND, IF, and VLOOKUP functions. You will also...

File Home Insert Draw Page Layout Formulas Data Review View Help 3 Share AutoSum Calibri 11 AF = = = Accounting TT ab Wrap Text 27 N X Cut Lo Copy Format Painter Fill Paste Insert Delete Format B I U...

EA7-A1 Create a Payroll Register for Athletics Supply House PGIn this exercise, you will create a payroll register for Athletics Supply House using ROUND, IF, and VLOOKUP functions. You will also...

Reinforce Your Skills 215 EAZ-R2 Create a Payroll Register for H.F. Landscaping In this exercise, you will create a payroll register for H.F. Landscaping using ROUND, IF, and VLOOKUP functions. You...

In this exercise, you will create a payroll register for Athletics Supply House using ROUND, IF, and VLOOKUP functions. You will also modify the sworksheet's layout and highlight key elements. Use...

Bell Corporation is 100% owned by George, who has a $400,000 basis in his Bell stock. Bells operations have been unprofitable in recent years, and it has incurred small NOLs. Its operating assets...

Suppose x is an n-vector. The associated vector of differences is the (n 1)-vector d given by d = (x2 x1, x3 x2, . . . , xn xn1). Express d in terms of x using vector operations (e.g., slicing...

The decision concerning hoe the dollars left over from a defense cutback wjll be distributed is an example of

https://media.cheggcdn.com/media/e59/e5900ba1-02b0-44ab-8246-fb980e24e7c1/phpDkQ6Ux

Demonstrates a structured and rational approach towards decision-making.

Produces clear business/project plans that mirror business objectives.

Displays flexibility and creativity when generating ideas/solutions.