Answered step by step
Verified Expert Solution
Question
1 Approved Answer
How is it possible In cell F4, insert a formula without using a function that multiplies Aubrey Irwin's estimated hours (the cell D4 ) and
How is it possible In cell F4, insert a formula without using a function that multiplies Aubrey Irwin's estimated hours (the cell D4) and his pay rate (the cell E4).
SC_EX19_EOM2-1_DebraRush_1 (2) - Excel (Product Activation Failed) X File Home Insert Page Layout Formulas Data Review View Acrobat Tell me what you want to do. & Share IR W B of Cut Calibri 12 AA = Wrap Text General AutoSum ~ AYO Copy . + Fill Paste Merge & Center $ ~ % " 6.0 .00 Conditional Format as Cell Insert Delete Format Clear Sort & Find & Format Painter Formatting * Table Styles Filter * Select Clipboard Font Alignment Number Styles Cells Editing F4 X V A B C D E F G H K M N O Rivera Engineering Project Tracker Date: 5/20/2021 Percent +/- to flag: 10% Estimated Estimated Actual 3 Project ID Assigned to Role Hours Rate Billings Hours Actual Billings Hours +/- Billings +/- Percent +/ 4 MK-435 Aubrey Irwin Project Manager 360.5 85.00 375.0 $31,875.00 14.5 $31,875.00 MK-435 Bruce Keely Analyst 107.0 65.00 120.5 $7,832.50 13.5 $7,832.50 PC-122 Hue Hong Project Manager 290.0 110.00 291.0 $32,010.00 1.0 $32,010.00 GR-380 Diego Olivera Project Manager 150.0 85.00 158.5 $13,472.50 8.5 $13,472.50 8 MK-435 Jeff Asgar Resource Manager 80.0 65.00 82.0 $5,330.00 2.0 $5,330.00 9 PC-122 Jeff Asgar Resource Manager 110.0 65.00 107.0 $6,955.00 3.0 $6,955.00 10 GR-380 Julie Ashman Programmer 180.0 75.00 186.0 $13,950.00 $13,950.00 11 OS-652 Sara Watanabe Analyst 200.0 75.00 197.0 $14,775.00 3.0 $14,775.00 12 OS-652 Diego Olivera Project Manager 115.0 85.00 135.0 $11,475.00 20.0 $11,475.00 13 PC-122 Julie Ashman Programmer 120.0 75.00 120.0 $9,000.00 0.0 $9,000.00 14 Avg. Actual Hours: 15 Min. Actual Hours: 16 Max. Actual Hours: 17 18 19 20 21 22 23 24 Documentation Employees for Projects Project Tracking + + 100% Ready O O F OM 9 N x 92.F Sunny ~ 5 0 2 () 4:11 PMStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started