Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The steps you will follow for this project are as foliow 1) Review the video andior the scripted PDF's for Windows 2) Download the
The steps you will follow for this project are as foliow 1) Review the video andior the scripted PDF's for Windows 2) Download the Excel data file (After you download the YOU NEED TO "SAVE YOUR ASSIGNMENT BY CLICKING THE SAVE BUTTON IN THE UPPER RIGHT HAND CORNER BEFORE YOU EXIT If you not 5) Use your Excel file to answer the six multiple choice questions below (You will have to sell 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 t C) Information on data column headings questions. If your check figures do not match, do not proceed with answering the questions until you have asked for assistance from your instruct Use the pivot table you created for Requirement 1 for Rockway What was the total spending in 2015? OA $182.581.873 OB $174,420.897 Oc. $228,960,833 OD. $174,064.618 Use the pivot table you created for Requirement 2 for Rockway. In 2014, how much was spent in each of the tree categories of government (Education General Govemment, and Public Works OA Education $ 17.574.234 Education General Government $ 112.241.302 General Government Public Works $ Education $ 122.636.591 General Government $ 44205,161 Public Works 45.285,818 Public Works 65.158748 Education $ 14,970.961 General Govern $107.782.352 Public Works $1,311,305 Use the pivot table you created for Requirement 3 for Rockway. In 2016, which account use the fed "AccountDesc" for this answer) was the largest in the General Government category? OA. PROFESSIONAL & TECHNICAL SVC OB SITE IMPROVEMENTS OC. GIC ACTIVE - SCHOOL OD CONSTRUCTION PLANNING & DEV Use the pivot table you created for Requirement 4 for Rockway. In 2016, what was the average amount of each payment to Tuff Construction OA $80.804 OB $351.013 Oc. $1.688.220 OD. $153,539 Use the pivot table you created for Requirement for Rockway. How much in expenditure in 2015 was related to repairs and maintenance? OA $2,061,347 OB. $2.336,017 OC $3,785,972 OD. $2.525,891 Use the plect chart you created for Requirement for Rockway. Analyze the pivot chart and summate trends from the line chart for the years 2013-2016 OA Spending in the Education category overall steadily increased, the General Goverment category overall decreased the Public Works category remained steady OB. Spending in the Education category overall steadily increased the General Govemment category overall remained steady with fluctuations each year: Public Works category remained steady OC. Spending in the Education category overal steadily increased the General Goverment category overal remained steady with fluctuations each year: the Public Works category overall increased with a large increase in 2015, and a decrease in 2016 OD. Spending in the Education category overall steadily decreased the General Goverment category overall decreased the Education category overall steadily decreased
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started