INFS 3250 - Assignment 4

INFS 3250 - Assignment 4 - INFS 3250 Assignment 4 Build...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
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.
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.
Ask a homework question - tutors are online