AutoSave OFF AE sv XI-23.05Student Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X Calibri (Body) 10 ' ab Wrap Text General Insert v HP 28-Ou 8 DX Delete Paste BI U a. A == Merge & Center $ %) .00 .00 0 Conditional Format Cell Formatting as Table Styles Ideas Sort & Filter Find & Select Format v Sensitivity Enable Content Security Warning External Data Connections have been disabled A1 fx Mr. and Mrs. Driggs have four children, all of whom are away at college. Below is a listing of expenses incurred by each child during a recent month. A B C D E F G H I J K L M N P R Mr. and Mrs. Driggs have four children, all of whom are away at college. Below is a listing of expenses incurred by each child during a recent month. S T U V W Y Z 1 2 Expense CHILD Cathy David Rachel 3 Caroline $ Food 4 150.76 $ 344.56 $ 266.76 $ 222.92 5 Rent 475.00 300.00 395.00 225.00 6 Entertainment 44.67 25.00 321.56 66.56 7 Electricity 68.90 110.78 55.89 76.99 8 Auto 220.20 124.44 188.88 9 9 Insurance 87.76 55.55 144.09 47.75 10 Phone 45.45 88.09 25.00 37.98 11 Tuition 825.00 990.00 500.00 12 Books 332.23 433.89 779.54 210.00 13 Clothing 66.90 423.65 103.19 385.58 14 (a) Analyze the data and identify the most expensive child. 15 (b) Analyze the data and identify the expense category of greatest cost. . 16 (c) Comment on the value of line item and object of expenditure analysis of data in a business context. How do modern 17 information systems facilitate such analysis? (d) (optional) Pivot tables are useful tools for enhanced analysis of data. Experiment with the pivot table on the electronic worksheet template, and see if you can confirm you answers to part (a) and part(b). What other ways can the data be sorted? 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Problem Worksheet + Ready 100% AutoSave OFF AE sv XI-23.05Student Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X Calibri (Body) 10 - A i = = Insert v ab Wrap Text General HP 28 Or 5 DX Delete Paste av A. Merge & Center V $ % ) .00 .00 0 Ideas Conditional Format Cell Formatting as Table Styles Sort & Filter Format Find & Select Sensitivity Security Warning External Data Connections have been disabled Enable Content B5 fx B D E G K L M N O R S A (a) 1 (6) 2 (c) 3 (d) Below is a pivot table that includes data from the problem. With a bit of clicking, you should be able to verify the solutions to part (a) and part(b), as well experiment with numerous other sorts of the tabular information. Expense Auto Books Clothing Electricity Entertainment Food Insurance Phone Rent Tuition Grand Total 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 Data Sum of Cathy Sum of David Sum of Rachel Sum of Caroline Sum of Total $ 220.20 $ $ 124.44 $ 188.88 $ 533.52 332.23 433.89 779.54 210.00 1,755.66 66.90 423.65 103.19 385.58 979.32 68.90 110.78 55.89 76.99 312.56 44.67 25.00 321.56 66.56 457.79 150.76 344.56 266.76 222.92 985.00 87.76 55.55 144.09 47.75 335.15 45.45 88.09 25.00 37.98 196.52 475.00 300.00 395.00 225.00 1,395.00 825.00 990.00 500.00 2,315.00 $ 2,316.87 $ 2,771.52 $ 2,215.47 $ 1,961.66 $ 9,265.52 Problem Worksheet + Ready 100% AutoSave OFF AE sv XI-23.05Student Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X Calibri (Body) 10 ' ab Wrap Text General Insert v HP 28-Ou 8 DX Delete Paste BI U a. A == Merge & Center $ %) .00 .00 0 Conditional Format Cell Formatting as Table Styles Ideas Sort & Filter Find & Select Format v Sensitivity Enable Content Security Warning External Data Connections have been disabled A1 fx Mr. and Mrs. Driggs have four children, all of whom are away at college. Below is a listing of expenses incurred by each child during a recent month. A B C D E F G H I J K L M N P R Mr. and Mrs. Driggs have four children, all of whom are away at college. Below is a listing of expenses incurred by each child during a recent month. S T U V W Y Z 1 2 Expense CHILD Cathy David Rachel 3 Caroline $ Food 4 150.76 $ 344.56 $ 266.76 $ 222.92 5 Rent 475.00 300.00 395.00 225.00 6 Entertainment 44.67 25.00 321.56 66.56 7 Electricity 68.90 110.78 55.89 76.99 8 Auto 220.20 124.44 188.88 9 9 Insurance 87.76 55.55 144.09 47.75 10 Phone 45.45 88.09 25.00 37.98 11 Tuition 825.00 990.00 500.00 12 Books 332.23 433.89 779.54 210.00 13 Clothing 66.90 423.65 103.19 385.58 14 (a) Analyze the data and identify the most expensive child. 15 (b) Analyze the data and identify the expense category of greatest cost. . 16 (c) Comment on the value of line item and object of expenditure analysis of data in a business context. How do modern 17 information systems facilitate such analysis? (d) (optional) Pivot tables are useful tools for enhanced analysis of data. Experiment with the pivot table on the electronic worksheet template, and see if you can confirm you answers to part (a) and part(b). What other ways can the data be sorted? 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Problem Worksheet + Ready 100% AutoSave OFF AE sv XI-23.05Student Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X Calibri (Body) 10 - A i = = Insert v ab Wrap Text General HP 28 Or 5 DX Delete Paste av A. Merge & Center V $ % ) .00 .00 0 Ideas Conditional Format Cell Formatting as Table Styles Sort & Filter Format Find & Select Sensitivity Security Warning External Data Connections have been disabled Enable Content B5 fx B D E G K L M N O R S A (a) 1 (6) 2 (c) 3 (d) Below is a pivot table that includes data from the problem. With a bit of clicking, you should be able to verify the solutions to part (a) and part(b), as well experiment with numerous other sorts of the tabular information. Expense Auto Books Clothing Electricity Entertainment Food Insurance Phone Rent Tuition Grand Total 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 Data Sum of Cathy Sum of David Sum of Rachel Sum of Caroline Sum of Total $ 220.20 $ $ 124.44 $ 188.88 $ 533.52 332.23 433.89 779.54 210.00 1,755.66 66.90 423.65 103.19 385.58 979.32 68.90 110.78 55.89 76.99 312.56 44.67 25.00 321.56 66.56 457.79 150.76 344.56 266.76 222.92 985.00 87.76 55.55 144.09 47.75 335.15 45.45 88.09 25.00 37.98 196.52 475.00 300.00 395.00 225.00 1,395.00 825.00 990.00 500.00 2,315.00 $ 2,316.87 $ 2,771.52 $ 2,215.47 $ 1,961.66 $ 9,265.52 Problem Worksheet + Ready 100%