Entering a Formula Using Data in Multiple Worksheets - Exercise

Contact Us or call 1-877-932-8228
Entering a Formula Using Data in Multiple Worksheets - Exercise

Entering a Formula Using Data in Multiple Worksheets

Duration: 10 to 20 minutes.

In this exercise, you will enter a formula using data from multiple sheets first without names and then using named cells.

  1. Open Multiple Worksheets.xlsx from your Excel2013.2/Exercises folder.
  2. Answer the questions in rows 3, 4, and 5 of Sheet2 using the data in Sheet1 without using named cells.
  3. Answer the questions in rows 10, 11, and 12 of Sheet2 using the data in Sheet1 using named cells. Note: The cells are already named.

Solution:

  1. To answer the questions in rows 3, 4, and 5:
    1. How much was spent on Clothes and Fun Stuff in January?
      1. Type "=".
      2. Select Sheet1 by clicking on it.
      3. Select cell B7.
      4. Type "+".
      5. Select cell B8.
      6. Press Enter.
      7. The formula you entered will read: "=Sheet1!B7+Sheet1!B8".
    2. How much was spent on Groceries in Jan and Mar?
      1. Type "=".
      2. Select Sheet1 by clicking on it.
      3. Select cell B4.
      4. Type "+".
      5. Select cell D4.
      6. Press Enter.
      7. The formula you entered will read: "=Sheet1!B4+Sheet1!D4".
    3. What percent of Quarterly Income did Electric account for from Jan to Mar?
      1. Type "=".
      2. Select Sheet1 by clicking on it.
      3. Select cell E5.
      4. Type "/".
      5. Select cell B1.
      6. Press Enter.
      7. The formula you entered will read: "=Sheet1!E5/QuarterlyIncome".
  2. To answer the questions in rows 10, 11, and 12:
    1. How much was spent on Clothes and Fun Stuff in January? Type "=Jan Clothes+Jan Fun_Stuff".
    2. How much was spent on Groceries in Jan and Mar? Type "=Jan Groceries+Mar Groceries".
    3. What percent of Quarterly Income did Electric account for from Jan to Mar? Type "=Total Electric/QuarterlyIncome".
Next