Answered step by step
Verified Expert Solution
Link Copied!

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).

image text in transcribed
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 PM

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Cash Flows

Authors: Cyril Joseph

1st Edition

B0B84RHX2D, B0CPV8WDGT

More Books

Students also viewed these General Management questions

Question

=+ a. What is the per-worker production function?

Answered: 1 week ago