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.
 Open Multiple Worksheets.xlsx from your Excel2013.2/Exercises folder.
 Answer the questions in rows 3, 4, and 5 of Sheet2 using the data in Sheet1 without using named cells.
 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.
 To answer the questions in rows 3, 4, and 5:

How much was spent on Clothes and Fun Stuff in January?
 Type "=".
 Select Sheet1 by clicking on it.
 Select cell B7.
 Type "+".
 Select cell B8.
 Press Enter.
 The formula you entered will read: "=Sheet1!B7+Sheet1!B8".

How much was spent on Groceries in Jan and Mar?
 Type "=".
 Select Sheet1 by clicking on it.
 Select cell B4.
 Type "+".
 Select cell D4.
 Press Enter.
 The formula you entered will read: "=Sheet1!B4+Sheet1!D4".

What percent of Quarterly Income did Electric account for from Jan to Mar?
 Type "=".
 Select Sheet1 by clicking on it.
 Select cell E5.
 Type "/".
 Select cell B1.
 Press Enter.
 The formula you entered will read: "=Sheet1!E5/QuarterlyIncome".
 To answer the questions in rows 10, 11, and 12:

How much was spent on Clothes and Fun Stuff in January? Type "=Jan Clothes+Jan Fun_Stuff".

How much was spent on Groceries in Jan and Mar? Type "=Jan Groceries+Mar Groceries".

What percent of Quarterly Income did Electric account for from Jan to Mar? Type "=Total Electric/QuarterlyIncome".