INFS 3250 – Assignment 4 Build multiplication and division formulas. Set the order of precedence. 1. Open TasteTest . Save the workbook as [your initials] Assign4 in your Lesson 5 folder. 2. Build a multiplication formula by following these steps: a. Click cell F4 and key = . Click cell D4. This is a taste-tester’s regular hourly pay rate. b. Key + . Click cell E4. The tester receives a holiday rate increase, added to the regular pay rate. c. Key * . Click cell C4. The hourly rate is multiplied by the number of hours worked to determine pay. d. Press enter . 3. Copy the formula in cell F4 to cells F5:F8. 4. Build a division formula by following these steps: a. Click cell H4 and key = . Click cell F4. The pay is divided by the number of items tested. b. Key / . Click cell G4. Press enter . c. Copy the formula to cells H5:H8. 5. Set the order of precedence by following these steps: a. Click cell F4. This formula should first add cells D4 and E4 and then multiply that sum by cell C4. b.
This is the end of the preview. Sign up
access the rest of the document.