Question: BUSINESS MATH Name USING EXCEL Date __| A B c D 1 Chapter 01 - Exercise 12 2 3 1. Create a formula that would

BUSINESS MATH Name USING EXCEL Date __| A B c D 1 Chapter 01 - Exercise 12 2 3 1. Create a formula that would tell Excel to add Cells A1 and B1' then multiply the results by the sum of Cells C1 and D1. Place your answer in Cell B5 below. 4 5 6 7 2. Create a formula that would tell Excel to add Cells 32 and 02. then multiply the results by the difference of Cells C3 minus C4. Place your answer in Cell BS below. a 9 10 11 3. Create a formula that would tell Excel to add Cells D3 plus D4l then multiply the result by 100. Place your answer In Cell B13 below. 12 13 14 15 4. Create a formula that would tell Excel to add cells E1 and E2, then divide the result by Cell E5 times Cell E6. Place your answer In Cell B17 below. 15 17 18 19 5. Create a_formula that would tell Excel to multiply Cell F2 times Cell F3, then add the result to the product of Cell F4 times Cell F5. Place your answer In Cell B21 below. 20 21 22 23 24 Directions: 25 a. Follow the instructions for each of the exercises above. 25 b. Save the le as ch01ex12a.xlsx. 27
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
