Response Questions Part A To C A. SHOW ALL YOUR STEPS HOW YOU DO IT ON EXCEL: Apply the Calculation style to cell E12 Precision Building Workshop Cost Per Person Cost for each participant 41 vouw 20 Workshop ID 01-KT 02-BT 03-BD 04-LD 05-LR 06-GR 07-CL 11 08-WL 12 Type Kitchen Bathroom Bedroom Laundry Room Living Room/Great Room Game Room Closet Intervention Wall Decor Lighting Number of participants Total cost 1,025 33 660 19 380 150 625 13 195 28 280 210 TOTAL COSTS $ 3,315 B. SHOW ALL YOUR STEPS HOW YOU DO IT ON EXCEL: Change the font color of cell E12 to Orange, Accent 6, then undo that action Precision Building Spring Workshops Workshop ID Type 01-KT Kitchen 02-BT Bathroom 03-BD Bedroom 04-LD Laundry Room 05-LR Living Room/Great Room 06-GR Game Room 07-CL Closet Intervention 08-WL Wall Decor Lighting Cost for each participant 25 20 20 10 Number of participants Total cost 41 $ 1,025 33 $ 660 19 $ 380 15 150 25 625 13 195 280 14 $ 210 TOTAL COSTS $ 3,315 15 10 15 28 S Cost includes facility rental, food, beverages, workbook, promotional materials, staff time, samples, etc. C. SHOW ALL YOUR STEPS HOW YOU DO IT ON EXCEL: Copy the formula in cell E4 into cell E5 E4 A B =C4*D4 C D Precision Building Raise Calculations First Name Raise Amount $3,900 Raise Percent 5% 5% 4% 3% Last Name Winters 5 Harrison 6 Waung 7 Kawasaki 8 Robinson 9 Lopez 10 Wilcox 11 Allu 12 Kapoor Paul Miriam Jason Cara Jayden Jorge Evelynn Sarji Ravi Salary $78,000 $46,000 $52,500 $70,500 $61,000 $66,000 $42,000 $58,000 $59,000 5% 4% 3% 5% 4% 13 Response Questions Part A To C A. SHOW ALL YOUR STEPS HOW YOU DO IT ON EXCEL: Apply the Calculation style to cell E12 Precision Building Workshop Cost Per Person Cost for each participant 41 vouw 20 Workshop ID 01-KT 02-BT 03-BD 04-LD 05-LR 06-GR 07-CL 11 08-WL 12 Type Kitchen Bathroom Bedroom Laundry Room Living Room/Great Room Game Room Closet Intervention Wall Decor Lighting Number of participants Total cost 1,025 33 660 19 380 150 625 13 195 28 280 210 TOTAL COSTS $ 3,315 B. SHOW ALL YOUR STEPS HOW YOU DO IT ON EXCEL: Change the font color of cell E12 to Orange, Accent 6, then undo that action Precision Building Spring Workshops Workshop ID Type 01-KT Kitchen 02-BT Bathroom 03-BD Bedroom 04-LD Laundry Room 05-LR Living Room/Great Room 06-GR Game Room 07-CL Closet Intervention 08-WL Wall Decor Lighting Cost for each participant 25 20 20 10 Number of participants Total cost 41 $ 1,025 33 $ 660 19 $ 380 15 150 25 625 13 195 280 14 $ 210 TOTAL COSTS $ 3,315 15 10 15 28 S Cost includes facility rental, food, beverages, workbook, promotional materials, staff time, samples, etc. C. SHOW ALL YOUR STEPS HOW YOU DO IT ON EXCEL: Copy the formula in cell E4 into cell E5 E4 A B =C4*D4 C D Precision Building Raise Calculations First Name Raise Amount $3,900 Raise Percent 5% 5% 4% 3% Last Name Winters 5 Harrison 6 Waung 7 Kawasaki 8 Robinson 9 Lopez 10 Wilcox 11 Allu 12 Kapoor Paul Miriam Jason Cara Jayden Jorge Evelynn Sarji Ravi Salary $78,000 $46,000 $52,500 $70,500 $61,000 $66,000 $42,000 $58,000 $59,000 5% 4% 3% 5% 4% 13
