2 You want to enter a title and apply a cell style to three worksheets at...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
2 You want to enter a title and apply a cell style to three worksheets at the same time. Group the April, May, and June worksheets. Type Savings, Income, & Expenses in cell A1. Select the range A1:C1 and apply the Heading 1 cell style. 3 With the worksheets grouped, you want to calculate the Ending Savings Balance. 9. In cell C6, add the Beginning Savings Balance to the Monthly Savings Added. 4 With the worksheets grouped, you want to unlock a range so that it can be edited. 9. Unlock cell C9 and the range B12:B20 in the grouped worksheets. Then, ungroup the worksheets. Three worksheets should have 3-D references to other worksheets. 10 Display the May worksheet. In cell C4, create a formula with a 3-D reference to cell C6 (the Ending Savings Balance) in the April worksheet. Display the June worksheet. In cell C4, create a formula with a 3-D reference to cell C6 (the Ending Savings Balance) in the May worksheet. Display the Qtr 2 worksheet. In cell C4, create a formula with a 3-D reference to cell C6 (the Ending Savings Balance) in the June worksheet. You are ready to build functions with 3-D references to sum data from all three months on the Qtr 2 worksheet. 10 With the Qtr 2 worksheet active, click cell C9 and insert the SUM function with a 3-D reference to total the salary amounts for all three months. Copy the function in cell C9 to cells C21 and C23. 7 Next, you want to insert a SUM function with a 3-D reference on the Qtr 2 worksheet. 10 Click cell B12 and insert the SUM function with a 3-D reference to total the rent amount for all three months. Copy the function in cell B12 to the range B13:B20. Home Draw Page Layout Formulas Data Review View V Tell me O Commer Insert E Share 曾nsert v * Delete v Calibri (Body) v 11 • A A Wrap Text v Accounting B I S v % > Cell Find & Analyza Data Paste Merga & Center v Cencitonal Format Sart & Sensitivit Formatting as Table Styles E Format v Fiter Select C6 v fe F H K M. P. : Savings, income, Expenses 3 Savings 4. Beginning Savings Balance Morthly Savings Adced 6 Ending Savings Balance $ 300.00 100.00 17 8 Income Salary $ 2,400.00 10 11 Expenses 12 Rent $ 1,100.00 13 Utilities 127.15 14 Savings 100.00 15 Cell Phure 55.22 16 Groceries 389.75 Car Payment Auto Expense 17 775.00 18 84.33 19 Entertainment 54.75 20 Miscdlancous 100.00 21 Tatal Expanses 2,286.80 22 23 Difference 113.20 24 25 26 27 28 29 30 31 32 33 34 35 36 17 April May June Qtr 2 Home Insert Draw Page Layout Formulas Data Review View O Tell me Calibri (Body) v 11 v A A Wrap Text Accounting E Insert v R Delete v Paste B I A v O Merge & Center v $ v % 9 Conditional Format Cell Sort & Find & Formatting as Table Styles H Format v Filter Select C6 fie D G H K L M P R 1 Savings, income, Expenses 3 Savings Beginning Savings Balance Monthly Savings Added 6 Ending Savings Balance 4 100.00 7. B. Income 9 Salary 2400 10 11 Expenses 12 Rent 1100 13 Utilities 131.18 14 Savings 15 Cell Phone 100 55.22 16 Groceries 395.31 17 Car Payment 275 18 Auto Expense 104.35 19 Entertainrment 45.18 20 Miscellaneous 455 21 Total Expenses 2661.24 22 23 Difference -261.24 24 25 26 27 28 29 30 31 32 33 34 35 36 37 April May June Qtr 2 Home Insert Draw Page Layout Formulas Data Review View O Tell me - E Insert v v 11 v A A 27 Calibri (Body) ab wrap Text v Accounting EE Delete v O v A v = = = Paste E Merge & Center v $ v % 2 Conditional Format Cell B U v A Format v Sort & Filter Formatting as Table Styles C6 v fx A E H K M P 1 2nd Quarter Totals Monthly Data 3 Savings Ending Savings Balance April May June 4 Analysis Month with highest positive differencein cell C23 8 Income 9 Salary Month with highest negative difference in cell C23 Difference after three monthsin cell C23 in Qtr 2 1st highest total expense category in Qtr 2 2nd highest total expense category in atr 2 Number of expense categories identical each month 10 11 Expenses 12 Rent 13 Utilities 14 Savings 15 Cell Phone 16 Groceries 17 Car Payment 18 Auto Expense 19 Entertainment 20 Miscellaneous 21 Tatal Expenses 22 23 Difference 24 25 26 27 28 29 30 31 32 EE 34 35 36 37 April May June Qtr 2 + Home Insert Draw Page Layout Formulas Data Review View O Tell me 9 Share D Cor Insert v Calibri (Body) 11 • A A 82 Wrao Text Accounting E Delete v Pasta BTU Conditional Format Cell Sort & Filter E Marge & Center v Find & Analyza Sen . Formatting as Tabla Stylas E Format Saloct Data v fx C6 D K L M N P. R 1 Savings, income, Expenses :2 3 Savings Beginning Savings Ralance Monthly Savings Adced 4 100.00 6 Ending Savings Balance 8 Income 9 Salary 10. 2400 11 Expenses 12 Rent 1100 13 Utilities 115.64 14 Savings 100 15 Cell Phone 55.22 15 Groceries 3R4.18 17 Car Payment 275 18 Nuto Expense 71.64 19 Entertainment 45.31 20 Miscellaneous 95 21 Tatal Exper ses 2241.99 22 23 DIfference 158.01 24 25 26 27 28 29 30 31 32 33 34 35 36 37 April Мay June Qtr 2 2 You want to enter a title and apply a cell style to three worksheets at the same time. Group the April, May, and June worksheets. Type Savings, Income, & Expenses in cell A1. Select the range A1:C1 and apply the Heading 1 cell style. 3 With the worksheets grouped, you want to calculate the Ending Savings Balance. 9. In cell C6, add the Beginning Savings Balance to the Monthly Savings Added. 4 With the worksheets grouped, you want to unlock a range so that it can be edited. 9. Unlock cell C9 and the range B12:B20 in the grouped worksheets. Then, ungroup the worksheets. Three worksheets should have 3-D references to other worksheets. 10 Display the May worksheet. In cell C4, create a formula with a 3-D reference to cell C6 (the Ending Savings Balance) in the April worksheet. Display the June worksheet. In cell C4, create a formula with a 3-D reference to cell C6 (the Ending Savings Balance) in the May worksheet. Display the Qtr 2 worksheet. In cell C4, create a formula with a 3-D reference to cell C6 (the Ending Savings Balance) in the June worksheet. You are ready to build functions with 3-D references to sum data from all three months on the Qtr 2 worksheet. 10 With the Qtr 2 worksheet active, click cell C9 and insert the SUM function with a 3-D reference to total the salary amounts for all three months. Copy the function in cell C9 to cells C21 and C23. 7 Next, you want to insert a SUM function with a 3-D reference on the Qtr 2 worksheet. 10 Click cell B12 and insert the SUM function with a 3-D reference to total the rent amount for all three months. Copy the function in cell B12 to the range B13:B20. Home Draw Page Layout Formulas Data Review View V Tell me O Commer Insert E Share 曾nsert v * Delete v Calibri (Body) v 11 • A A Wrap Text v Accounting B I S v % > Cell Find & Analyza Data Paste Merga & Center v Cencitonal Format Sart & Sensitivit Formatting as Table Styles E Format v Fiter Select C6 v fe F H K M. P. : Savings, income, Expenses 3 Savings 4. Beginning Savings Balance Morthly Savings Adced 6 Ending Savings Balance $ 300.00 100.00 17 8 Income Salary $ 2,400.00 10 11 Expenses 12 Rent $ 1,100.00 13 Utilities 127.15 14 Savings 100.00 15 Cell Phure 55.22 16 Groceries 389.75 Car Payment Auto Expense 17 775.00 18 84.33 19 Entertainment 54.75 20 Miscdlancous 100.00 21 Tatal Expanses 2,286.80 22 23 Difference 113.20 24 25 26 27 28 29 30 31 32 33 34 35 36 17 April May June Qtr 2 Home Insert Draw Page Layout Formulas Data Review View O Tell me Calibri (Body) v 11 v A A Wrap Text Accounting E Insert v R Delete v Paste B I A v O Merge & Center v $ v % 9 Conditional Format Cell Sort & Find & Formatting as Table Styles H Format v Filter Select C6 fie D G H K L M P R 1 Savings, income, Expenses 3 Savings Beginning Savings Balance Monthly Savings Added 6 Ending Savings Balance 4 100.00 7. B. Income 9 Salary 2400 10 11 Expenses 12 Rent 1100 13 Utilities 131.18 14 Savings 15 Cell Phone 100 55.22 16 Groceries 395.31 17 Car Payment 275 18 Auto Expense 104.35 19 Entertainrment 45.18 20 Miscellaneous 455 21 Total Expenses 2661.24 22 23 Difference -261.24 24 25 26 27 28 29 30 31 32 33 34 35 36 37 April May June Qtr 2 Home Insert Draw Page Layout Formulas Data Review View O Tell me - E Insert v v 11 v A A 27 Calibri (Body) ab wrap Text v Accounting EE Delete v O v A v = = = Paste E Merge & Center v $ v % 2 Conditional Format Cell B U v A Format v Sort & Filter Formatting as Table Styles C6 v fx A E H K M P 1 2nd Quarter Totals Monthly Data 3 Savings Ending Savings Balance April May June 4 Analysis Month with highest positive differencein cell C23 8 Income 9 Salary Month with highest negative difference in cell C23 Difference after three monthsin cell C23 in Qtr 2 1st highest total expense category in Qtr 2 2nd highest total expense category in atr 2 Number of expense categories identical each month 10 11 Expenses 12 Rent 13 Utilities 14 Savings 15 Cell Phone 16 Groceries 17 Car Payment 18 Auto Expense 19 Entertainment 20 Miscellaneous 21 Tatal Expenses 22 23 Difference 24 25 26 27 28 29 30 31 32 EE 34 35 36 37 April May June Qtr 2 + Home Insert Draw Page Layout Formulas Data Review View O Tell me 9 Share D Cor Insert v Calibri (Body) 11 • A A 82 Wrao Text Accounting E Delete v Pasta BTU Conditional Format Cell Sort & Filter E Marge & Center v Find & Analyza Sen . Formatting as Tabla Stylas E Format Saloct Data v fx C6 D K L M N P. R 1 Savings, income, Expenses :2 3 Savings Beginning Savings Ralance Monthly Savings Adced 4 100.00 6 Ending Savings Balance 8 Income 9 Salary 10. 2400 11 Expenses 12 Rent 1100 13 Utilities 115.64 14 Savings 100 15 Cell Phone 55.22 15 Groceries 3R4.18 17 Car Payment 275 18 Nuto Expense 71.64 19 Entertainment 45.31 20 Miscellaneous 95 21 Tatal Exper ses 2241.99 22 23 DIfference 158.01 24 25 26 27 28 29 30 31 32 33 34 35 36 37 April Мay June Qtr 2 2 You want to enter a title and apply a cell style to three worksheets at the same time. Group the April, May, and June worksheets. Type Savings, Income, & Expenses in cell A1. Select the range A1:C1 and apply the Heading 1 cell style. 3 With the worksheets grouped, you want to calculate the Ending Savings Balance. 9. In cell C6, add the Beginning Savings Balance to the Monthly Savings Added. 4 With the worksheets grouped, you want to unlock a range so that it can be edited. 9. Unlock cell C9 and the range B12:B20 in the grouped worksheets. Then, ungroup the worksheets. Three worksheets should have 3-D references to other worksheets. 10 Display the May worksheet. In cell C4, create a formula with a 3-D reference to cell C6 (the Ending Savings Balance) in the April worksheet. Display the June worksheet. In cell C4, create a formula with a 3-D reference to cell C6 (the Ending Savings Balance) in the May worksheet. Display the Qtr 2 worksheet. In cell C4, create a formula with a 3-D reference to cell C6 (the Ending Savings Balance) in the June worksheet. You are ready to build functions with 3-D references to sum data from all three months on the Qtr 2 worksheet. 10 With the Qtr 2 worksheet active, click cell C9 and insert the SUM function with a 3-D reference to total the salary amounts for all three months. Copy the function in cell C9 to cells C21 and C23. 7 Next, you want to insert a SUM function with a 3-D reference on the Qtr 2 worksheet. 10 Click cell B12 and insert the SUM function with a 3-D reference to total the rent amount for all three months. Copy the function in cell B12 to the range B13:B20. Home Draw Page Layout Formulas Data Review View V Tell me O Commer Insert E Share 曾nsert v * Delete v Calibri (Body) v 11 • A A Wrap Text v Accounting B I S v % > Cell Find & Analyza Data Paste Merga & Center v Cencitonal Format Sart & Sensitivit Formatting as Table Styles E Format v Fiter Select C6 v fe F H K M. P. : Savings, income, Expenses 3 Savings 4. Beginning Savings Balance Morthly Savings Adced 6 Ending Savings Balance $ 300.00 100.00 17 8 Income Salary $ 2,400.00 10 11 Expenses 12 Rent $ 1,100.00 13 Utilities 127.15 14 Savings 100.00 15 Cell Phure 55.22 16 Groceries 389.75 Car Payment Auto Expense 17 775.00 18 84.33 19 Entertainment 54.75 20 Miscdlancous 100.00 21 Tatal Expanses 2,286.80 22 23 Difference 113.20 24 25 26 27 28 29 30 31 32 33 34 35 36 17 April May June Qtr 2 Home Insert Draw Page Layout Formulas Data Review View O Tell me Calibri (Body) v 11 v A A Wrap Text Accounting E Insert v R Delete v Paste B I A v O Merge & Center v $ v % 9 Conditional Format Cell Sort & Find & Formatting as Table Styles H Format v Filter Select C6 fie D G H K L M P R 1 Savings, income, Expenses 3 Savings Beginning Savings Balance Monthly Savings Added 6 Ending Savings Balance 4 100.00 7. B. Income 9 Salary 2400 10 11 Expenses 12 Rent 1100 13 Utilities 131.18 14 Savings 15 Cell Phone 100 55.22 16 Groceries 395.31 17 Car Payment 275 18 Auto Expense 104.35 19 Entertainrment 45.18 20 Miscellaneous 455 21 Total Expenses 2661.24 22 23 Difference -261.24 24 25 26 27 28 29 30 31 32 33 34 35 36 37 April May June Qtr 2 Home Insert Draw Page Layout Formulas Data Review View O Tell me - E Insert v v 11 v A A 27 Calibri (Body) ab wrap Text v Accounting EE Delete v O v A v = = = Paste E Merge & Center v $ v % 2 Conditional Format Cell B U v A Format v Sort & Filter Formatting as Table Styles C6 v fx A E H K M P 1 2nd Quarter Totals Monthly Data 3 Savings Ending Savings Balance April May June 4 Analysis Month with highest positive differencein cell C23 8 Income 9 Salary Month with highest negative difference in cell C23 Difference after three monthsin cell C23 in Qtr 2 1st highest total expense category in Qtr 2 2nd highest total expense category in atr 2 Number of expense categories identical each month 10 11 Expenses 12 Rent 13 Utilities 14 Savings 15 Cell Phone 16 Groceries 17 Car Payment 18 Auto Expense 19 Entertainment 20 Miscellaneous 21 Tatal Expenses 22 23 Difference 24 25 26 27 28 29 30 31 32 EE 34 35 36 37 April May June Qtr 2 + Home Insert Draw Page Layout Formulas Data Review View O Tell me 9 Share D Cor Insert v Calibri (Body) 11 • A A 82 Wrao Text Accounting E Delete v Pasta BTU Conditional Format Cell Sort & Filter E Marge & Center v Find & Analyza Sen . Formatting as Tabla Stylas E Format Saloct Data v fx C6 D K L M N P. R 1 Savings, income, Expenses :2 3 Savings Beginning Savings Ralance Monthly Savings Adced 4 100.00 6 Ending Savings Balance 8 Income 9 Salary 10. 2400 11 Expenses 12 Rent 1100 13 Utilities 115.64 14 Savings 100 15 Cell Phone 55.22 15 Groceries 3R4.18 17 Car Payment 275 18 Nuto Expense 71.64 19 Entertainment 45.31 20 Miscellaneous 95 21 Tatal Exper ses 2241.99 22 23 DIfference 158.01 24 25 26 27 28 29 30 31 32 33 34 35 36 37 April Мay June Qtr 2 2 You want to enter a title and apply a cell style to three worksheets at the same time. Group the April, May, and June worksheets. Type Savings, Income, & Expenses in cell A1. Select the range A1:C1 and apply the Heading 1 cell style. 3 With the worksheets grouped, you want to calculate the Ending Savings Balance. 9. In cell C6, add the Beginning Savings Balance to the Monthly Savings Added. 4 With the worksheets grouped, you want to unlock a range so that it can be edited. 9. Unlock cell C9 and the range B12:B20 in the grouped worksheets. Then, ungroup the worksheets. Three worksheets should have 3-D references to other worksheets. 10 Display the May worksheet. In cell C4, create a formula with a 3-D reference to cell C6 (the Ending Savings Balance) in the April worksheet. Display the June worksheet. In cell C4, create a formula with a 3-D reference to cell C6 (the Ending Savings Balance) in the May worksheet. Display the Qtr 2 worksheet. In cell C4, create a formula with a 3-D reference to cell C6 (the Ending Savings Balance) in the June worksheet. You are ready to build functions with 3-D references to sum data from all three months on the Qtr 2 worksheet. 10 With the Qtr 2 worksheet active, click cell C9 and insert the SUM function with a 3-D reference to total the salary amounts for all three months. Copy the function in cell C9 to cells C21 and C23. 7 Next, you want to insert a SUM function with a 3-D reference on the Qtr 2 worksheet. 10 Click cell B12 and insert the SUM function with a 3-D reference to total the rent amount for all three months. Copy the function in cell B12 to the range B13:B20. Home Draw Page Layout Formulas Data Review View V Tell me O Commer Insert E Share 曾nsert v * Delete v Calibri (Body) v 11 • A A Wrap Text v Accounting B I S v % > Cell Find & Analyza Data Paste Merga & Center v Cencitonal Format Sart & Sensitivit Formatting as Table Styles E Format v Fiter Select C6 v fe F H K M. P. : Savings, income, Expenses 3 Savings 4. Beginning Savings Balance Morthly Savings Adced 6 Ending Savings Balance $ 300.00 100.00 17 8 Income Salary $ 2,400.00 10 11 Expenses 12 Rent $ 1,100.00 13 Utilities 127.15 14 Savings 100.00 15 Cell Phure 55.22 16 Groceries 389.75 Car Payment Auto Expense 17 775.00 18 84.33 19 Entertainment 54.75 20 Miscdlancous 100.00 21 Tatal Expanses 2,286.80 22 23 Difference 113.20 24 25 26 27 28 29 30 31 32 33 34 35 36 17 April May June Qtr 2 Home Insert Draw Page Layout Formulas Data Review View O Tell me Calibri (Body) v 11 v A A Wrap Text Accounting E Insert v R Delete v Paste B I A v O Merge & Center v $ v % 9 Conditional Format Cell Sort & Find & Formatting as Table Styles H Format v Filter Select C6 fie D G H K L M P R 1 Savings, income, Expenses 3 Savings Beginning Savings Balance Monthly Savings Added 6 Ending Savings Balance 4 100.00 7. B. Income 9 Salary 2400 10 11 Expenses 12 Rent 1100 13 Utilities 131.18 14 Savings 15 Cell Phone 100 55.22 16 Groceries 395.31 17 Car Payment 275 18 Auto Expense 104.35 19 Entertainrment 45.18 20 Miscellaneous 455 21 Total Expenses 2661.24 22 23 Difference -261.24 24 25 26 27 28 29 30 31 32 33 34 35 36 37 April May June Qtr 2 Home Insert Draw Page Layout Formulas Data Review View O Tell me - E Insert v v 11 v A A 27 Calibri (Body) ab wrap Text v Accounting EE Delete v O v A v = = = Paste E Merge & Center v $ v % 2 Conditional Format Cell B U v A Format v Sort & Filter Formatting as Table Styles C6 v fx A E H K M P 1 2nd Quarter Totals Monthly Data 3 Savings Ending Savings Balance April May June 4 Analysis Month with highest positive differencein cell C23 8 Income 9 Salary Month with highest negative difference in cell C23 Difference after three monthsin cell C23 in Qtr 2 1st highest total expense category in Qtr 2 2nd highest total expense category in atr 2 Number of expense categories identical each month 10 11 Expenses 12 Rent 13 Utilities 14 Savings 15 Cell Phone 16 Groceries 17 Car Payment 18 Auto Expense 19 Entertainment 20 Miscellaneous 21 Tatal Expenses 22 23 Difference 24 25 26 27 28 29 30 31 32 EE 34 35 36 37 April May June Qtr 2 + Home Insert Draw Page Layout Formulas Data Review View O Tell me 9 Share D Cor Insert v Calibri (Body) 11 • A A 82 Wrao Text Accounting E Delete v Pasta BTU Conditional Format Cell Sort & Filter E Marge & Center v Find & Analyza Sen . Formatting as Tabla Stylas E Format Saloct Data v fx C6 D K L M N P. R 1 Savings, income, Expenses :2 3 Savings Beginning Savings Ralance Monthly Savings Adced 4 100.00 6 Ending Savings Balance 8 Income 9 Salary 10. 2400 11 Expenses 12 Rent 1100 13 Utilities 115.64 14 Savings 100 15 Cell Phone 55.22 15 Groceries 3R4.18 17 Car Payment 275 18 Nuto Expense 71.64 19 Entertainment 45.31 20 Miscellaneous 95 21 Tatal Exper ses 2241.99 22 23 DIfference 158.01 24 25 26 27 28 29 30 31 32 33 34 35 36 37 April Мay June Qtr 2 2 You want to enter a title and apply a cell style to three worksheets at the same time. Group the April, May, and June worksheets. Type Savings, Income, & Expenses in cell A1. Select the range A1:C1 and apply the Heading 1 cell style. 3 With the worksheets grouped, you want to calculate the Ending Savings Balance. 9. In cell C6, add the Beginning Savings Balance to the Monthly Savings Added. 4 With the worksheets grouped, you want to unlock a range so that it can be edited. 9. Unlock cell C9 and the range B12:B20 in the grouped worksheets. Then, ungroup the worksheets. Three worksheets should have 3-D references to other worksheets. 10 Display the May worksheet. In cell C4, create a formula with a 3-D reference to cell C6 (the Ending Savings Balance) in the April worksheet. Display the June worksheet. In cell C4, create a formula with a 3-D reference to cell C6 (the Ending Savings Balance) in the May worksheet. Display the Qtr 2 worksheet. In cell C4, create a formula with a 3-D reference to cell C6 (the Ending Savings Balance) in the June worksheet. You are ready to build functions with 3-D references to sum data from all three months on the Qtr 2 worksheet. 10 With the Qtr 2 worksheet active, click cell C9 and insert the SUM function with a 3-D reference to total the salary amounts for all three months. Copy the function in cell C9 to cells C21 and C23. 7 Next, you want to insert a SUM function with a 3-D reference on the Qtr 2 worksheet. 10 Click cell B12 and insert the SUM function with a 3-D reference to total the rent amount for all three months. Copy the function in cell B12 to the range B13:B20. Home Draw Page Layout Formulas Data Review View V Tell me O Commer Insert E Share 曾nsert v * Delete v Calibri (Body) v 11 • A A Wrap Text v Accounting B I S v % > Cell Find & Analyza Data Paste Merga & Center v Cencitonal Format Sart & Sensitivit Formatting as Table Styles E Format v Fiter Select C6 v fe F H K M. P. : Savings, income, Expenses 3 Savings 4. Beginning Savings Balance Morthly Savings Adced 6 Ending Savings Balance $ 300.00 100.00 17 8 Income Salary $ 2,400.00 10 11 Expenses 12 Rent $ 1,100.00 13 Utilities 127.15 14 Savings 100.00 15 Cell Phure 55.22 16 Groceries 389.75 Car Payment Auto Expense 17 775.00 18 84.33 19 Entertainment 54.75 20 Miscdlancous 100.00 21 Tatal Expanses 2,286.80 22 23 Difference 113.20 24 25 26 27 28 29 30 31 32 33 34 35 36 17 April May June Qtr 2 Home Insert Draw Page Layout Formulas Data Review View O Tell me Calibri (Body) v 11 v A A Wrap Text Accounting E Insert v R Delete v Paste B I A v O Merge & Center v $ v % 9 Conditional Format Cell Sort & Find & Formatting as Table Styles H Format v Filter Select C6 fie D G H K L M P R 1 Savings, income, Expenses 3 Savings Beginning Savings Balance Monthly Savings Added 6 Ending Savings Balance 4 100.00 7. B. Income 9 Salary 2400 10 11 Expenses 12 Rent 1100 13 Utilities 131.18 14 Savings 15 Cell Phone 100 55.22 16 Groceries 395.31 17 Car Payment 275 18 Auto Expense 104.35 19 Entertainrment 45.18 20 Miscellaneous 455 21 Total Expenses 2661.24 22 23 Difference -261.24 24 25 26 27 28 29 30 31 32 33 34 35 36 37 April May June Qtr 2 Home Insert Draw Page Layout Formulas Data Review View O Tell me - E Insert v v 11 v A A 27 Calibri (Body) ab wrap Text v Accounting EE Delete v O v A v = = = Paste E Merge & Center v $ v % 2 Conditional Format Cell B U v A Format v Sort & Filter Formatting as Table Styles C6 v fx A E H K M P 1 2nd Quarter Totals Monthly Data 3 Savings Ending Savings Balance April May June 4 Analysis Month with highest positive differencein cell C23 8 Income 9 Salary Month with highest negative difference in cell C23 Difference after three monthsin cell C23 in Qtr 2 1st highest total expense category in Qtr 2 2nd highest total expense category in atr 2 Number of expense categories identical each month 10 11 Expenses 12 Rent 13 Utilities 14 Savings 15 Cell Phone 16 Groceries 17 Car Payment 18 Auto Expense 19 Entertainment 20 Miscellaneous 21 Tatal Expenses 22 23 Difference 24 25 26 27 28 29 30 31 32 EE 34 35 36 37 April May June Qtr 2 + Home Insert Draw Page Layout Formulas Data Review View O Tell me 9 Share D Cor Insert v Calibri (Body) 11 • A A 82 Wrao Text Accounting E Delete v Pasta BTU Conditional Format Cell Sort & Filter E Marge & Center v Find & Analyza Sen . Formatting as Tabla Stylas E Format Saloct Data v fx C6 D K L M N P. R 1 Savings, income, Expenses :2 3 Savings Beginning Savings Ralance Monthly Savings Adced 4 100.00 6 Ending Savings Balance 8 Income 9 Salary 10. 2400 11 Expenses 12 Rent 1100 13 Utilities 115.64 14 Savings 100 15 Cell Phone 55.22 15 Groceries 3R4.18 17 Car Payment 275 18 Nuto Expense 71.64 19 Entertainment 45.31 20 Miscellaneous 95 21 Tatal Exper ses 2241.99 22 23 DIfference 158.01 24 25 26 27 28 29 30 31 32 33 34 35 36 37 April Мay June Qtr 2 2 You want to enter a title and apply a cell style to three worksheets at the same time. Group the April, May, and June worksheets. Type Savings, Income, & Expenses in cell A1. Select the range A1:C1 and apply the Heading 1 cell style. 3 With the worksheets grouped, you want to calculate the Ending Savings Balance. 9. In cell C6, add the Beginning Savings Balance to the Monthly Savings Added. 4 With the worksheets grouped, you want to unlock a range so that it can be edited. 9. Unlock cell C9 and the range B12:B20 in the grouped worksheets. Then, ungroup the worksheets. Three worksheets should have 3-D references to other worksheets. 10 Display the May worksheet. In cell C4, create a formula with a 3-D reference to cell C6 (the Ending Savings Balance) in the April worksheet. Display the June worksheet. In cell C4, create a formula with a 3-D reference to cell C6 (the Ending Savings Balance) in the May worksheet. Display the Qtr 2 worksheet. In cell C4, create a formula with a 3-D reference to cell C6 (the Ending Savings Balance) in the June worksheet. You are ready to build functions with 3-D references to sum data from all three months on the Qtr 2 worksheet. 10 With the Qtr 2 worksheet active, click cell C9 and insert the SUM function with a 3-D reference to total the salary amounts for all three months. Copy the function in cell C9 to cells C21 and C23. 7 Next, you want to insert a SUM function with a 3-D reference on the Qtr 2 worksheet. 10 Click cell B12 and insert the SUM function with a 3-D reference to total the rent amount for all three months. Copy the function in cell B12 to the range B13:B20. Home Draw Page Layout Formulas Data Review View V Tell me O Commer Insert E Share 曾nsert v * Delete v Calibri (Body) v 11 • A A Wrap Text v Accounting B I S v % > Cell Find & Analyza Data Paste Merga & Center v Cencitonal Format Sart & Sensitivit Formatting as Table Styles E Format v Fiter Select C6 v fe F H K M. P. : Savings, income, Expenses 3 Savings 4. Beginning Savings Balance Morthly Savings Adced 6 Ending Savings Balance $ 300.00 100.00 17 8 Income Salary $ 2,400.00 10 11 Expenses 12 Rent $ 1,100.00 13 Utilities 127.15 14 Savings 100.00 15 Cell Phure 55.22 16 Groceries 389.75 Car Payment Auto Expense 17 775.00 18 84.33 19 Entertainment 54.75 20 Miscdlancous 100.00 21 Tatal Expanses 2,286.80 22 23 Difference 113.20 24 25 26 27 28 29 30 31 32 33 34 35 36 17 April May June Qtr 2 Home Insert Draw Page Layout Formulas Data Review View O Tell me Calibri (Body) v 11 v A A Wrap Text Accounting E Insert v R Delete v Paste B I A v O Merge & Center v $ v % 9 Conditional Format Cell Sort & Find & Formatting as Table Styles H Format v Filter Select C6 fie D G H K L M P R 1 Savings, income, Expenses 3 Savings Beginning Savings Balance Monthly Savings Added 6 Ending Savings Balance 4 100.00 7. B. Income 9 Salary 2400 10 11 Expenses 12 Rent 1100 13 Utilities 131.18 14 Savings 15 Cell Phone 100 55.22 16 Groceries 395.31 17 Car Payment 275 18 Auto Expense 104.35 19 Entertainrment 45.18 20 Miscellaneous 455 21 Total Expenses 2661.24 22 23 Difference -261.24 24 25 26 27 28 29 30 31 32 33 34 35 36 37 April May June Qtr 2 Home Insert Draw Page Layout Formulas Data Review View O Tell me - E Insert v v 11 v A A 27 Calibri (Body) ab wrap Text v Accounting EE Delete v O v A v = = = Paste E Merge & Center v $ v % 2 Conditional Format Cell B U v A Format v Sort & Filter Formatting as Table Styles C6 v fx A E H K M P 1 2nd Quarter Totals Monthly Data 3 Savings Ending Savings Balance April May June 4 Analysis Month with highest positive differencein cell C23 8 Income 9 Salary Month with highest negative difference in cell C23 Difference after three monthsin cell C23 in Qtr 2 1st highest total expense category in Qtr 2 2nd highest total expense category in atr 2 Number of expense categories identical each month 10 11 Expenses 12 Rent 13 Utilities 14 Savings 15 Cell Phone 16 Groceries 17 Car Payment 18 Auto Expense 19 Entertainment 20 Miscellaneous 21 Tatal Expenses 22 23 Difference 24 25 26 27 28 29 30 31 32 EE 34 35 36 37 April May June Qtr 2 + Home Insert Draw Page Layout Formulas Data Review View O Tell me 9 Share D Cor Insert v Calibri (Body) 11 • A A 82 Wrao Text Accounting E Delete v Pasta BTU Conditional Format Cell Sort & Filter E Marge & Center v Find & Analyza Sen . Formatting as Tabla Stylas E Format Saloct Data v fx C6 D K L M N P. R 1 Savings, income, Expenses :2 3 Savings Beginning Savings Ralance Monthly Savings Adced 4 100.00 6 Ending Savings Balance 8 Income 9 Salary 10. 2400 11 Expenses 12 Rent 1100 13 Utilities 115.64 14 Savings 100 15 Cell Phone 55.22 15 Groceries 3R4.18 17 Car Payment 275 18 Nuto Expense 71.64 19 Entertainment 45.31 20 Miscellaneous 95 21 Tatal Exper ses 2241.99 22 23 DIfference 158.01 24 25 26 27 28 29 30 31 32 33 34 35 36 37 April Мay June Qtr 2 2 You want to enter a title and apply a cell style to three worksheets at the same time. Group the April, May, and June worksheets. Type Savings, Income, & Expenses in cell A1. Select the range A1:C1 and apply the Heading 1 cell style. 3 With the worksheets grouped, you want to calculate the Ending Savings Balance. 9. In cell C6, add the Beginning Savings Balance to the Monthly Savings Added. 4 With the worksheets grouped, you want to unlock a range so that it can be edited. 9. Unlock cell C9 and the range B12:B20 in the grouped worksheets. Then, ungroup the worksheets. Three worksheets should have 3-D references to other worksheets. 10 Display the May worksheet. In cell C4, create a formula with a 3-D reference to cell C6 (the Ending Savings Balance) in the April worksheet. Display the June worksheet. In cell C4, create a formula with a 3-D reference to cell C6 (the Ending Savings Balance) in the May worksheet. Display the Qtr 2 worksheet. In cell C4, create a formula with a 3-D reference to cell C6 (the Ending Savings Balance) in the June worksheet. You are ready to build functions with 3-D references to sum data from all three months on the Qtr 2 worksheet. 10 With the Qtr 2 worksheet active, click cell C9 and insert the SUM function with a 3-D reference to total the salary amounts for all three months. Copy the function in cell C9 to cells C21 and C23. 7 Next, you want to insert a SUM function with a 3-D reference on the Qtr 2 worksheet. 10 Click cell B12 and insert the SUM function with a 3-D reference to total the rent amount for all three months. Copy the function in cell B12 to the range B13:B20. Home Draw Page Layout Formulas Data Review View V Tell me O Commer Insert E Share 曾nsert v * Delete v Calibri (Body) v 11 • A A Wrap Text v Accounting B I S v % > Cell Find & Analyza Data Paste Merga & Center v Cencitonal Format Sart & Sensitivit Formatting as Table Styles E Format v Fiter Select C6 v fe F H K M. P. : Savings, income, Expenses 3 Savings 4. Beginning Savings Balance Morthly Savings Adced 6 Ending Savings Balance $ 300.00 100.00 17 8 Income Salary $ 2,400.00 10 11 Expenses 12 Rent $ 1,100.00 13 Utilities 127.15 14 Savings 100.00 15 Cell Phure 55.22 16 Groceries 389.75 Car Payment Auto Expense 17 775.00 18 84.33 19 Entertainment 54.75 20 Miscdlancous 100.00 21 Tatal Expanses 2,286.80 22 23 Difference 113.20 24 25 26 27 28 29 30 31 32 33 34 35 36 17 April May June Qtr 2 Home Insert Draw Page Layout Formulas Data Review View O Tell me Calibri (Body) v 11 v A A Wrap Text Accounting E Insert v R Delete v Paste B I A v O Merge & Center v $ v % 9 Conditional Format Cell Sort & Find & Formatting as Table Styles H Format v Filter Select C6 fie D G H K L M P R 1 Savings, income, Expenses 3 Savings Beginning Savings Balance Monthly Savings Added 6 Ending Savings Balance 4 100.00 7. B. Income 9 Salary 2400 10 11 Expenses 12 Rent 1100 13 Utilities 131.18 14 Savings 15 Cell Phone 100 55.22 16 Groceries 395.31 17 Car Payment 275 18 Auto Expense 104.35 19 Entertainrment 45.18 20 Miscellaneous 455 21 Total Expenses 2661.24 22 23 Difference -261.24 24 25 26 27 28 29 30 31 32 33 34 35 36 37 April May June Qtr 2 Home Insert Draw Page Layout Formulas Data Review View O Tell me - E Insert v v 11 v A A 27 Calibri (Body) ab wrap Text v Accounting EE Delete v O v A v = = = Paste E Merge & Center v $ v % 2 Conditional Format Cell B U v A Format v Sort & Filter Formatting as Table Styles C6 v fx A E H K M P 1 2nd Quarter Totals Monthly Data 3 Savings Ending Savings Balance April May June 4 Analysis Month with highest positive differencein cell C23 8 Income 9 Salary Month with highest negative difference in cell C23 Difference after three monthsin cell C23 in Qtr 2 1st highest total expense category in Qtr 2 2nd highest total expense category in atr 2 Number of expense categories identical each month 10 11 Expenses 12 Rent 13 Utilities 14 Savings 15 Cell Phone 16 Groceries 17 Car Payment 18 Auto Expense 19 Entertainment 20 Miscellaneous 21 Tatal Expenses 22 23 Difference 24 25 26 27 28 29 30 31 32 EE 34 35 36 37 April May June Qtr 2 + Home Insert Draw Page Layout Formulas Data Review View O Tell me 9 Share D Cor Insert v Calibri (Body) 11 • A A 82 Wrao Text Accounting E Delete v Pasta BTU Conditional Format Cell Sort & Filter E Marge & Center v Find & Analyza Sen . Formatting as Tabla Stylas E Format Saloct Data v fx C6 D K L M N P. R 1 Savings, income, Expenses :2 3 Savings Beginning Savings Ralance Monthly Savings Adced 4 100.00 6 Ending Savings Balance 8 Income 9 Salary 10. 2400 11 Expenses 12 Rent 1100 13 Utilities 115.64 14 Savings 100 15 Cell Phone 55.22 15 Groceries 3R4.18 17 Car Payment 275 18 Nuto Expense 71.64 19 Entertainment 45.31 20 Miscellaneous 95 21 Tatal Exper ses 2241.99 22 23 DIfference 158.01 24 25 26 27 28 29 30 31 32 33 34 35 36 37 April Мay June Qtr 2 2 You want to enter a title and apply a cell style to three worksheets at the same time. Group the April, May, and June worksheets. Type Savings, Income, & Expenses in cell A1. Select the range A1:C1 and apply the Heading 1 cell style. 3 With the worksheets grouped, you want to calculate the Ending Savings Balance. 9. In cell C6, add the Beginning Savings Balance to the Monthly Savings Added. 4 With the worksheets grouped, you want to unlock a range so that it can be edited. 9. Unlock cell C9 and the range B12:B20 in the grouped worksheets. Then, ungroup the worksheets. Three worksheets should have 3-D references to other worksheets. 10 Display the May worksheet. In cell C4, create a formula with a 3-D reference to cell C6 (the Ending Savings Balance) in the April worksheet. Display the June worksheet. In cell C4, create a formula with a 3-D reference to cell C6 (the Ending Savings Balance) in the May worksheet. Display the Qtr 2 worksheet. In cell C4, create a formula with a 3-D reference to cell C6 (the Ending Savings Balance) in the June worksheet. You are ready to build functions with 3-D references to sum data from all three months on the Qtr 2 worksheet. 10 With the Qtr 2 worksheet active, click cell C9 and insert the SUM function with a 3-D reference to total the salary amounts for all three months. Copy the function in cell C9 to cells C21 and C23. 7 Next, you want to insert a SUM function with a 3-D reference on the Qtr 2 worksheet. 10 Click cell B12 and insert the SUM function with a 3-D reference to total the rent amount for all three months. Copy the function in cell B12 to the range B13:B20. Home Draw Page Layout Formulas Data Review View V Tell me O Commer Insert E Share 曾nsert v * Delete v Calibri (Body) v 11 • A A Wrap Text v Accounting B I S v % > Cell Find & Analyza Data Paste Merga & Center v Cencitonal Format Sart & Sensitivit Formatting as Table Styles E Format v Fiter Select C6 v fe F H K M. P. : Savings, income, Expenses 3 Savings 4. Beginning Savings Balance Morthly Savings Adced 6 Ending Savings Balance $ 300.00 100.00 17 8 Income Salary $ 2,400.00 10 11 Expenses 12 Rent $ 1,100.00 13 Utilities 127.15 14 Savings 100.00 15 Cell Phure 55.22 16 Groceries 389.75 Car Payment Auto Expense 17 775.00 18 84.33 19 Entertainment 54.75 20 Miscdlancous 100.00 21 Tatal Expanses 2,286.80 22 23 Difference 113.20 24 25 26 27 28 29 30 31 32 33 34 35 36 17 April May June Qtr 2 Home Insert Draw Page Layout Formulas Data Review View O Tell me Calibri (Body) v 11 v A A Wrap Text Accounting E Insert v R Delete v Paste B I A v O Merge & Center v $ v % 9 Conditional Format Cell Sort & Find & Formatting as Table Styles H Format v Filter Select C6 fie D G H K L M P R 1 Savings, income, Expenses 3 Savings Beginning Savings Balance Monthly Savings Added 6 Ending Savings Balance 4 100.00 7. B. Income 9 Salary 2400 10 11 Expenses 12 Rent 1100 13 Utilities 131.18 14 Savings 15 Cell Phone 100 55.22 16 Groceries 395.31 17 Car Payment 275 18 Auto Expense 104.35 19 Entertainrment 45.18 20 Miscellaneous 455 21 Total Expenses 2661.24 22 23 Difference -261.24 24 25 26 27 28 29 30 31 32 33 34 35 36 37 April May June Qtr 2 Home Insert Draw Page Layout Formulas Data Review View O Tell me - E Insert v v 11 v A A 27 Calibri (Body) ab wrap Text v Accounting EE Delete v O v A v = = = Paste E Merge & Center v $ v % 2 Conditional Format Cell B U v A Format v Sort & Filter Formatting as Table Styles C6 v fx A E H K M P 1 2nd Quarter Totals Monthly Data 3 Savings Ending Savings Balance April May June 4 Analysis Month with highest positive differencein cell C23 8 Income 9 Salary Month with highest negative difference in cell C23 Difference after three monthsin cell C23 in Qtr 2 1st highest total expense category in Qtr 2 2nd highest total expense category in atr 2 Number of expense categories identical each month 10 11 Expenses 12 Rent 13 Utilities 14 Savings 15 Cell Phone 16 Groceries 17 Car Payment 18 Auto Expense 19 Entertainment 20 Miscellaneous 21 Tatal Expenses 22 23 Difference 24 25 26 27 28 29 30 31 32 EE 34 35 36 37 April May June Qtr 2 + Home Insert Draw Page Layout Formulas Data Review View O Tell me 9 Share D Cor Insert v Calibri (Body) 11 • A A 82 Wrao Text Accounting E Delete v Pasta BTU Conditional Format Cell Sort & Filter E Marge & Center v Find & Analyza Sen . Formatting as Tabla Stylas E Format Saloct Data v fx C6 D K L M N P. R 1 Savings, income, Expenses :2 3 Savings Beginning Savings Ralance Monthly Savings Adced 4 100.00 6 Ending Savings Balance 8 Income 9 Salary 10. 2400 11 Expenses 12 Rent 1100 13 Utilities 115.64 14 Savings 100 15 Cell Phone 55.22 15 Groceries 3R4.18 17 Car Payment 275 18 Nuto Expense 71.64 19 Entertainment 45.31 20 Miscellaneous 95 21 Tatal Exper ses 2241.99 22 23 DIfference 158.01 24 25 26 27 28 29 30 31 32 33 34 35 36 37 April Мay June Qtr 2
Expert Answer:
Answer rating: 100% (QA)
Answer Step by Step Solution step 2 select the first worksheet ie april hold down shift key and select till june This allows you to edit the same cell in all worksheets simultaneously Edit a1 cell in ... View the full answer
Posted Date:
Students also viewed these accounting questions
-
You want to enter a one-year interest rate swap contract with semiannual payments to receive a fixed rate and pay the floating rate (LIBOR). The notional principal is $80,000,000. LIBOR effective...
-
At the same time as new hires were taking place, many retailers were cutting back. Out of 1,000 Kwik Save stores in Britain, 107 were to be closed. Out of 424 Somerfield stores, 424 were to be...
-
Modify the LU Factorization Algorithm so that it can be used to solve a linear system, and then solve the following linear systems. a. 2x1 x2+ x3 = 1, 3x1+3x2+9x3 = 0, 3x1+3x2+5x3 = 4. b. 1.012x1 ...
-
Which market segments are the most favorable for Hyundai card? Does the company do an effective job of targeting and reaching those segments? If so, How? If not, why not?
-
Recovery Experts (RE) specializes in data recovery from crashed hard drives. The price charged varies based on the extent of damage and the amount of data being recovered. RE offers a 10% discount to...
-
At December 31, 2012, Albrecht Corporation had outstanding 373,000 shares of common stock and 8,000 shares of 9.5%, $100 par value cumulative, nonconvertible preferred stock. On May 31, 2013,...
-
A social welfare agency has a government budget appropriation for 2006 of $900,000. The agencys major mission is to help disabled persons who are unable to hold jobs. On the average, the agency...
-
CU, Incorporated, ( CUI) produces copper contacts that it uses in switches and relays. CUI needs to determine the order quantity, Q, to meet the annual demand at the lowest cost. The price of copper...
-
An opaque bag contains 3 green marbles and 3 red marbles. Two marbles are randomly drawn one at a time without replacement. P(2nd draw red 1" draw red) 0.20 0.50 0.40 0.60
-
Identify the fallacies committed in the following dialogue. You should be able to find at least one case of each fallacy presented in this section. Food for Thought "Let's hit the produce section...
-
28 A company manufactures a product with a unit variable cost of $90 and a unit sales price of $50. The company has a one-time opportunity to sell an additional 1,000 units at $40 each in a foreign...
-
A horizontal force of 50 N is required to push a wagon across a sidewalk at a constant speed. a. What is the net (unbalanced) force acting on the wagon? b. What forces are acting on the wagon? c. If...
-
How does the interplay between espoused values and enacted norms shape the emergent dynamics of organizational culture, and how can leaders cultivate congruence between these facets to foster...
-
Drawing on course concepts, theories, etc., what do campus leadership and coaches need to do to change these conditions? What needs to happen for athletes of color to be able to trust these programs...
-
A formula for the population of the USA is P(t) Po ae -0.02(t-1800) - where t is the date in years. Some actual data is as follows Date Population 1800 5308000 1820 9638000 1840 17069000 1870...
-
Assume the company has an increase in its Salaries Expense of 20% and a decrease in Service Revenue of 15%. Both of which will be settled after the vear end. Adiust and recalculate the balances in...
-
7.80 E7-6 through E7-10. St (The following information applies to the questions displayed below) Morning Sky, Inc. (MS), manufactures and sells computer games. The company has several product lines...
-
Is it ethical to provide safety training in English to immigrant workers who speak little English, in order to reduce costs?
-
Wollogong Group Ltd. of New South Wales, Australia, acquired its factory building about 10 years ago. For several years the company has rented out a small annex attached to the rear of the building....
-
Listed below are a number of costs typically found in organizations. 1. Property taxes, factory. 2. Boxes used for packaging detergent produced by the company. 3. Salespersons' commissions. 4....
-
You have just been hired by Ogden Company to fill a new position that was created in response to rapid growth in sales. It is your responsibility to coordinate shipments of finished goods from the...
Study smarter with the SolutionInn App