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?
-
What is accounting analysis? Explain.
-
What are unit-level, batch-level, product-level, customer-level, and organization-sustaining activities?
-
Recover pyridine from water using chlorobenzene as solvent in a countercurrent extractor. Feed is \(25.9 \mathrm{wt} \%\) pyridine and \(74.1 \mathrm{wt} \%\) water. Solvent is pure chlorobenzene,...
-
Omega Corporation reports the following results for the current year: Gross profits on sales $120,000 Dividends from less-than-20%-owned domestic corporations . 40,000 Operating expenses 100,000...
-
stock outstanding when the board of directors declared a stock there was $12. The entry to record the declaration of this dividend is: utable $36.000
-
Debbie Gibson is considering three investment options for a small inheritance that she has just receivedstocks, bonds, and money market. The return on her investment will depend on the performance of...
-
Shares of stocks are only issued upon full payment of subscription.
-
Explain deinstitutionalization. What was the purpose of deinstitutionalization? What have been the consequences of deinstitutionalization? How is deinstitutionalization related to the...
-
Why do we have environmental policies? What are the purposes of environmental policy? Give an example of an environmental policy, and the goal or goals it is meant to achieve.
-
When goods are produced privately, but the cost of their purchase is paid for by the taxpayer or some other third party, a. consumers have a strong incentive to search out those firms offering them...
-
Thunderduck Shoes relevant range of production is 7,500 units to 12,500 units. When it produces and sells 10,000 units, its unit costs are as follow: Account Direct materials Direct labor Sales...
-
Read the text and then discuss it taking into account the rules regarding discrimination in employment and ethical and professional conduct in business. What discriminatory situations occur in each...
-
A company uses the dollar-value LIFO method of computing inventory. An external price index is used to convert ending inventory to base year. The company began operations on January 1, 2024, with an...
-
Is it ethical to provide safety training in English to immigrant workers who speak little English, in order to reduce costs?
-
Explain how government policies may stabilize the economy.
-
Describe how government policies can improve economic outcomes.
-
Discuss how increasing productivity leads to higher economic growth.
Study smarter with the SolutionInn App