New Perspectives Excel 2019 | Module 11: SAM Project 1a

Описание: New Perspectives Excel 2019 | Module 11: SAM Project 1a #HempsteadUniversityFoundation



Contact Me:
WhatsApp No:+1(725) 272-9378




Go to the Capital Projects worksheet,
2. Instead of seeing the data sorted by budget amount, Camille would like to see the data by year. Sort the table data by the Completed field from smallest to largest.
3.
a. In cell K3, enter a formula using the COUNTIF function that counts the number of Expansion projects, checking that the column of project types in the Projects table (Projects[Project Type]) is equal to the value in cell J3.
b. Fill the range K4:K7 with the formula in cell K3.


#samsimnetsolution
#Excel Module 11 SAM Project A Hempstead University Foundation
#Excel_Module_11_SAM_Project_A_Hempstead_University_Foundation
#ExcelModule11SAMProjectAHempsteadUniversityFoundation
#samsimnetsolution
#NP_EX19_11a_FirstLastName_1.xlsx
#NP_EX19_11a_FirstLastName_2.xlsx
#NP_EX19_11a
#samsimnetsolution
#cengage
#np
#EX19
#samsimnetsolution
#Cengage_Excel_Module_11_SAM_Project_A
#New Perspectives Excel 2019 Module 11 SAM Project 1a
#New_Perspectives_Excel_2019_Module_11_SAM_Project_1a
#NewPerspectivesExcel2019Module11SAMProject1a
#samsimnetsolution
#shelly cashman excel 2019 module 11 sam project 1a
#shellycashmanexcel2019module11samproject1a
#shelly_cashman_excel_2019_module_11_sam_project_1a
#samsimnetsolution
#Hempstead University Foundation
#Hempstead_University_Foundation
#HempsteadUniversityFoundation
#samsimnetsolution
#CREATE ADVANCED PIVOTTABLES AND USE DATABASE FUNCTIONS
#CREATE_ADVANCED_PIVOTTABLES_AND_USE_DATABASE_FUNCTIONS
#CREATEADVANCEDPIVOTTABLESANDUSEDATABASEFUNCTIONS
#samsimnetsolution
#Excel Module 11 SAM Project A
#Excel_Module_11_SAM_Project_A
#ExcelModule11SAMProjectA
#samsimnetsolution
#Excel Module 11 SAM Project 1a
#Excel_Module_11_SAM_Project_1a
#ExcelModule11SAMProject1a
#samsimnetsolution

4.
a. In cell L3, enter a formula using the SUMIF function that totals the cost for Expansion projects, checking that the column of project types in the Projects table (Projects[Project Type]) is equal to the value in cell J3, and that the formula totals all the final costs (Projects[Final Cost]).
b. Fill the range L4:L7 with the formula in cell L3.
5.
a. In cell M3, enter a formula using the AVERAGEIF function that averages the cost for Expansion projects, checking that the column of project types in the Projects table (Projects[Project Type]) is equal to the value in cell J3, and that the formula averages all the final costs (Projects[Final Cost]).
b. Fill the range M4:M7 with the formula in cell M3.
6. Go to the Cost by Green Feature worksheet.
Ungroup the year data in the PivotTable.
7.
Change the report layout to show the PivotTable in Outline Form.
8. Go to the Cost by Campus worksheet.
a. Sort the data in ascending order by Grand Total.
b. Apply a Label Filter that displays Project ID values that begin with RE.
9. Go to the Project Budgets worksheet.
Make this change for Camille as follows:
a. Add the ID field to the Values area of the PivotTable, making it the first field in the Values area.
b. Change the number format of the Count of ID amounts to Number with 0 decimal places.
10.
Provide this information for Camille as follows:
a. Insert a calculated field named Difference that subtracts the Budget field amount from the Final Cost field amount.
b. Insert another calculated field named % Difference that subtracts the Budget field amounts from the Final Cost field amounts, and then divides the result by the Budget field amount.
c. Change the number format of the Sum of % Difference amounts to Percentage with 2 decimal points.
11.
Add this information to the PivotTable as follows:
a. Add the Budget field to the Values area of the PivotTable, making it the last field in the Values area.
b. Use the Average calculation to summarize the Budget field data.
12. Go to the Project Types by Year worksheet.
a. Expand the Project Type field to show the names of each project.
b. Apply a Value Filter to the Project Type field that displays the top 2 items by the sum of final cost.