samcp Cengage com MFCL Payroll Excel Sign in FILE HOME NSERT

samcp Cengage com MFCL Payroll Excel Sign in FILE HOME NSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Fa Conditional Formatting nsert A Calibri A A General Format as Table Delete Paste Sort & Find & 00 B I U cell style .00 Format Filte Select Clipboard Font Alignment Numbe Style Ce Editing ssN Hourly Rate 1 First Name Last Name Hours Gross 2 William Brown 952-16-4286 $9.25 40 3 Devon Black 701-53-2642 $12.50 32 4 Susan White 703-24-5555 $8.75 16 5 Jason 308-12-2234 308-12-5070 $9.25 31 6 Gretchen Archibald 40 $15.50 728-65-4988 Scott Consolidated Payr n 2 D Question READY Create a formula in the selected table cell that will multiply cell D2 by cell E22. Do NOT use spaces in the formula. Question Show Task List A Task: EX4107 Time Remaining: No Limit Attempts Remaining: 4 Exit 20 of 40

Solution

this is a very simple operation in excel. All you need to do is to use PRODUCT function.
to multiply cell D2 and cell E2 the formula is :
=PRODUCT(D2,E2)

so, if you want to fill the GROSS column of the table by multiplying the respective hourly rate & no. of hours, you can apply the formula for each row in the GROSS column :
=PRODUCT(D2,E2)
=PRODUCT(D3,E3)
=PRODUCT(D4,E4)
=PRODUCT(D5,E5)
=PRODUCT(D6,E6)
=PRODUCT(D7,E7)

feel free if you have any doubt. :)