please help with the excel sheet
ave i Check Figures - X ho Requirement 1: Cell D5 $183,982,129 Requirement 2: Cell B7 $41,283,065 Requirement 3: Cell D16 $26,788 Requirement 4: Cell D7 $(1,577) end Print Done D E A City of Sunnyview 2 Budgeted Expenditures (hypothetical) 3 For Year Ended December 31, 2016 4 2016 Variance $ Variance % Actual 5 Expenditure (Item Class) 5 Advertising 7 Athletics expense 3 Bonds and debt-related expenditures Books 0 Dues and subscriptions 1 Education-related 2 Miscellaneous line item 3 Professional services expense Property, plant and equipment 5 Rental expense 5 Repairs and maintenance expense Supplies expense Technology expense Utilities expense Total expenditures Budget $ 71,425 36,500 $ 6,880,425 21,900 $ 135,600 $ 325,678 $ 48,952,663 $ 16,885,990 $ 30,500,640 $ 402,670 $ 6,988,512 $ 20,684 $ 645,815 $ 320,970 112,189,372 1 3 data budget your assignment, the next time you enter you may see a different company and set of data.) 3) Perform the requirements on the data file using the video or pdf's 4) Check your work in the Excel file with these check figures. 5) Use your Excel file to answer the six multiple choice questions below (You will have to scroll down to see all of the questions.) Resources A) Information on how to update Excel and Office 365 B) If you do not have Office 365, click here to leam how to get it for free C) Information on data column headings. D) Troubleshooting FAQ Using the pivot table you created for Requirement 1 for Sunnyview, what was the total spending for Sunnyview in 2016? O A. $174.122.819 O B. $156,556,916 OC. $137,943,091 OD. $183,982 129 Using the pivot table you created for Requirement 2 for Sunnyview, how much was spent in General Government in 2016? Click to select your answer and then click Check Answer barts showing Clear All Type here to search BE e a Resources A) Information on how to update Excel and Office 365 B) If you do not have Office 365, dick here to learn how to get it for free C) Information on data column headings D) Troubleshooting FAQ Using the pivot table you created for Requirement 2 for Sunnyview, how much was spent in General Government in 2016? A. $102,348,273 OB. $33.698,066 O C. 521,147,610 OD. $119,277 143 Using the pivot table you created for Requirement 2 for Sunnyview, how much was spent in Public Works in 2016? Click to select your answer and then click Check Answer Clear All barts showing 1 Type here to search RI hp 1) Review the video andfor the scripted PDFs for Windows 2) Download the Excel data file. (After you download the file, YOU NEED TO "SAVE YOUR ASSIGNMENT BY CLICKING THE SAVE BUTTON IN THE UPPER your assignment, the next time you enter you may see a different company and set of data) 3) Perform the requirements on the data file using the video or pdf's 4) Check your work in the Excel file with these check ligures 5) Use your Excel file to answer the six multiple choice questions below. You will have to scroll down to see all of the questions Resources A) Information on how to update Excel and Office 365 B) If you do not have Office 365 dick here to leam how to get it for free C) Information on data column headings D) Troubleshooting FAQ Using the pivot table you created for Requirement 3 for Sunnyview, how much in expenditures did Sunnyview have in professional servicen exponse in 2016? O A. $19,367 O B. $20,370,734 OC. $16,885,990 D. $36,792,330 Using the budgeted worksheet results from requirement 4 for Sunnyview What was the variance expressed as a percentage for bonds and debt-related expediture Click to select your answer and then click Check Answer barts showing Clear AB Type here to search ei E HD a $ 199 hp The steps you will follow for this project are as follows 1) Review the video and/or the scripted PDFs for Windows 2) Download the Excel data file (Alter you download the file. YOU NEED TO "SAVE YOUR ASSIGNMENT BY CLICKING THE SAVE BUTTON IN THE UPPER RIGHT your assignment, the next time you enter you may see a different company and set of data) 3) Perform the requirements on the data file using the video or pdf's 4) Check your work in the Excel file with these check 5) Use your Excel file to answer the six multiple choice questions below. You will have to scroll down to see all of the questions) Resources A) Information on how to update Excel and Office 365 B) If you do not have Oflice 365, dick here to learn how to get it for free C) Information on data column headings D) Troubleshooting FAQ Using the budgeted workahout results from requirement 4 for Sunnyviow what was the variance expressed as a percentage for bands and debt-related expeditures OA 15.40% OB. -6.32% OC -1.50% OD -3.44% Using the budgeted worksheet results from requirement for Sunnyview what was the dollar amount of the variance for technology expense? Click to select your answer and then click Check Answer barts showing Clear All a a BI O Type here to search ** hp Using the budgeted worksheet results from requirement 4 for Sunnyview, what was the dollar amount of the variance for technology expense? OA. $(1,577) OB. $34,931 OC. $(2,897) OD. $6,619 Click to select your answer and then click Check Answer parts showing Clear All ave i Check Figures - X ho Requirement 1: Cell D5 $183,982,129 Requirement 2: Cell B7 $41,283,065 Requirement 3: Cell D16 $26,788 Requirement 4: Cell D7 $(1,577) end Print Done D E A City of Sunnyview 2 Budgeted Expenditures (hypothetical) 3 For Year Ended December 31, 2016 4 2016 Variance $ Variance % Actual 5 Expenditure (Item Class) 5 Advertising 7 Athletics expense 3 Bonds and debt-related expenditures Books 0 Dues and subscriptions 1 Education-related 2 Miscellaneous line item 3 Professional services expense Property, plant and equipment 5 Rental expense 5 Repairs and maintenance expense Supplies expense Technology expense Utilities expense Total expenditures Budget $ 71,425 36,500 $ 6,880,425 21,900 $ 135,600 $ 325,678 $ 48,952,663 $ 16,885,990 $ 30,500,640 $ 402,670 $ 6,988,512 $ 20,684 $ 645,815 $ 320,970 112,189,372 1 3 data budget your assignment, the next time you enter you may see a different company and set of data.) 3) Perform the requirements on the data file using the video or pdf's 4) Check your work in the Excel file with these check figures. 5) Use your Excel file to answer the six multiple choice questions below (You will have to scroll down to see all of the questions.) Resources A) Information on how to update Excel and Office 365 B) If you do not have Office 365, click here to leam how to get it for free C) Information on data column headings. D) Troubleshooting FAQ Using the pivot table you created for Requirement 1 for Sunnyview, what was the total spending for Sunnyview in 2016? O A. $174.122.819 O B. $156,556,916 OC. $137,943,091 OD. $183,982 129 Using the pivot table you created for Requirement 2 for Sunnyview, how much was spent in General Government in 2016? Click to select your answer and then click Check Answer barts showing Clear All Type here to search BE e a Resources A) Information on how to update Excel and Office 365 B) If you do not have Office 365, dick here to learn how to get it for free C) Information on data column headings D) Troubleshooting FAQ Using the pivot table you created for Requirement 2 for Sunnyview, how much was spent in General Government in 2016? A. $102,348,273 OB. $33.698,066 O C. 521,147,610 OD. $119,277 143 Using the pivot table you created for Requirement 2 for Sunnyview, how much was spent in Public Works in 2016? Click to select your answer and then click Check Answer Clear All barts showing 1 Type here to search RI hp 1) Review the video andfor the scripted PDFs for Windows 2) Download the Excel data file. (After you download the file, YOU NEED TO "SAVE YOUR ASSIGNMENT BY CLICKING THE SAVE BUTTON IN THE UPPER your assignment, the next time you enter you may see a different company and set of data) 3) Perform the requirements on the data file using the video or pdf's 4) Check your work in the Excel file with these check ligures 5) Use your Excel file to answer the six multiple choice questions below. You will have to scroll down to see all of the questions Resources A) Information on how to update Excel and Office 365 B) If you do not have Office 365 dick here to leam how to get it for free C) Information on data column headings D) Troubleshooting FAQ Using the pivot table you created for Requirement 3 for Sunnyview, how much in expenditures did Sunnyview have in professional servicen exponse in 2016? O A. $19,367 O B. $20,370,734 OC. $16,885,990 D. $36,792,330 Using the budgeted worksheet results from requirement 4 for Sunnyview What was the variance expressed as a percentage for bonds and debt-related expediture Click to select your answer and then click Check Answer barts showing Clear AB Type here to search ei E HD a $ 199 hp The steps you will follow for this project are as follows 1) Review the video and/or the scripted PDFs for Windows 2) Download the Excel data file (Alter you download the file. YOU NEED TO "SAVE YOUR ASSIGNMENT BY CLICKING THE SAVE BUTTON IN THE UPPER RIGHT your assignment, the next time you enter you may see a different company and set of data) 3) Perform the requirements on the data file using the video or pdf's 4) Check your work in the Excel file with these check 5) Use your Excel file to answer the six multiple choice questions below. You will have to scroll down to see all of the questions) Resources A) Information on how to update Excel and Office 365 B) If you do not have Oflice 365, dick here to learn how to get it for free C) Information on data column headings D) Troubleshooting FAQ Using the budgeted workahout results from requirement 4 for Sunnyviow what was the variance expressed as a percentage for bands and debt-related expeditures OA 15.40% OB. -6.32% OC -1.50% OD -3.44% Using the budgeted worksheet results from requirement for Sunnyview what was the dollar amount of the variance for technology expense? Click to select your answer and then click Check Answer barts showing Clear All a a BI O Type here to search ** hp Using the budgeted worksheet results from requirement 4 for Sunnyview, what was the dollar amount of the variance for technology expense? OA. $(1,577) OB. $34,931 OC. $(2,897) OD. $6,619 Click to select your answer and then click Check Answer parts showing Clear All
