Response Questions Part A To C A. SHOW ALL YOUR STEPS HOW YOU DO IT ON EXCEL: Center the contents of cell D3 horizontally Precision Building Workshop Cost Per Person Workshop ID Type 01-KT Kitchen 02-BT Bathroom 03-BD Bedroom 04-LD Laundry Room 05-LR Living Room/Great Room 9 06-GR Game Room 10 07-CL Closet Intervention 1108-WL Wall Dcor Lighting Cost for each Number of participant participants Total cost 25 41 $ 1,025 20 33 $ 660 20 19 380 10 15 150 25 625 15 13 195 10 28 $ 280 15 14 210 TOTAL COSTS $ 3,315 25 wwwwwww 12 B. SHOW ALL YOUR STEPS HOW YOU DO IT ON EXCEL: Use the Tell Me box to change the Fill Color of cells in range A3:C3 to Orange, Accent 6, Lighter 60% Precision Building Workshop Attendance Workshop ID Type Q1 Total 150 114 54 42 01-KT 02-BT 03-BD 04-LD 05-LR 06-GR 07-CL 08-WL Kitchen Bathroom Bedroom Laundry Room Living Room/Great Room Game Room closet Intervention Wall Decor Lighting 52 70 39 SHOW ALL YOUR STEPS HOW YOU DO IT ON EXCEL: Without using parentheses, enter a formula in cell F4 that determines the Projected 2002 Take-Home Pay for the employee by taking the value in cell C4, adding the product of cell C4 multiplied by cell D4, and then subtracting the value in cell E4 A E F Precision Building Payroll Projections Projected 2022 Take-Home Pay Raise % 5% $ First Name Paul Miriam Jason 5% 4% 3% Cara 2021 Salary 78,000 46.000 52,500 70.500 61,000 66.000 42.000 58.000 59,000 Last Name 4 Winters 5 Harrison 6 Waung 7 Kawasaki 8 Robinson 9 Lopez 10 Wilcox 11 Allu 12 Kapoor Health Insurance Deduction $ 2,500 1,500 $ 1.500 $ 2,500 2.500 1,500 1.000 1,500 $ 1,500 5% 4% S Jayden Jorge Evelynn Sarji Ravi 3% $ $ S 5% 4% Response Questions Part A To C A. SHOW ALL YOUR STEPS HOW YOU DO IT ON EXCEL: Center the contents of cell D3 horizontally Precision Building Workshop Cost Per Person Workshop ID Type 01-KT Kitchen 02-BT Bathroom 03-BD Bedroom 04-LD Laundry Room 05-LR Living Room/Great Room 9 06-GR Game Room 10 07-CL Closet Intervention 1108-WL Wall Dcor Lighting Cost for each Number of participant participants Total cost 25 41 $ 1,025 20 33 $ 660 20 19 380 10 15 150 25 625 15 13 195 10 28 $ 280 15 14 210 TOTAL COSTS $ 3,315 25 wwwwwww 12 B. SHOW ALL YOUR STEPS HOW YOU DO IT ON EXCEL: Use the Tell Me box to change the Fill Color of cells in range A3:C3 to Orange, Accent 6, Lighter 60% Precision Building Workshop Attendance Workshop ID Type Q1 Total 150 114 54 42 01-KT 02-BT 03-BD 04-LD 05-LR 06-GR 07-CL 08-WL Kitchen Bathroom Bedroom Laundry Room Living Room/Great Room Game Room closet Intervention Wall Decor Lighting 52 70 39 SHOW ALL YOUR STEPS HOW YOU DO IT ON EXCEL: Without using parentheses, enter a formula in cell F4 that determines the Projected 2002 Take-Home Pay for the employee by taking the value in cell C4, adding the product of cell C4 multiplied by cell D4, and then subtracting the value in cell E4 A E F Precision Building Payroll Projections Projected 2022 Take-Home Pay Raise % 5% $ First Name Paul Miriam Jason 5% 4% 3% Cara 2021 Salary 78,000 46.000 52,500 70.500 61,000 66.000 42.000 58.000 59,000 Last Name 4 Winters 5 Harrison 6 Waung 7 Kawasaki 8 Robinson 9 Lopez 10 Wilcox 11 Allu 12 Kapoor Health Insurance Deduction $ 2,500 1,500 $ 1.500 $ 2,500 2.500 1,500 1.000 1,500 $ 1,500 5% 4% S Jayden Jorge Evelynn Sarji Ravi 3% $ $ S 5% 4%
