Response Questions Part A To B A) Show Steps How You Do It On Excel: 1) Reverse the icon order 2) Display the red diamond icon in cells with a Number type value greater than or equal to 120 3) Display the yellow triangle icon in cells with a Number type value greater than or equal to 60. 4) Display the green circle icon in cells with a Number type value less than 60 B H C Number of Days 24 E Funding Type, F Funding, G Fast Track J her pros K Total L Average nber Prop Sunding Funding I Project Type Commercial Mixed Use Public Residential 340 148 360 A Project Name - 2 Old Town Design Plan 3 Honu Point Sports Complex 4 Mahina Regional Park 5 Downtown Bike Path 6 Burton Estates Expansion 7 Highacre Farms Modification 8 Makana Road Multifamily 9 Honu Point Center 10 Sunset Heights Zoning 11 Manu Hal Drive Parking 12 Allied Insurance 13 Nalu Parks Village 14 Sunset Heights Zoning 90 Start Date 1/10/2022 1/13/2022 2/22/2022 2/22/2022 3/3/2022 3/13/2022 3/19/2022 3/20/2022 3/20/2022 4/9/2022 4/9/2022 4/18/2022 4/20/2022 D Project Type Public Commercial Public Public Mixed Use Residential Residential Mixed Use Mixed Use Commercial Commercial Mixed Use Mixed Use 2021 Summary Loan Grant Grant Tax Credit Loan Tax Credit Grant Loan Tax Credit Tax Credit 90 180 120 21 125 60 420 21 A O S $ $ S S S $ $ S S S $ 24,000 12,500 15,000 4,500 10,000 15,000 4,000 2,500 9,500 6,000 50,000 2,500 Loan B) Show Steps How You Do It On Excel: 1) In cell J2, enter a formula using the COUNTIF function that counts the number of proposed Commercial projects, using Proposed Projects [Project Type) as the range and cell 12 as the criteria 2) In cell K2, enter a formula using the SUMIF function that totals the funding for proposed Commercial projects, using Proposed Projects[Project Type) as the range, cell 12 as the criteria, and Proposed Projects[Funding) as the sum_range. 3) In cell L2, enter a formula using the AVERAGEIF function that averages the funding for proposed Commercial projects, using Proposed Projects[Project Type) as the range, cell 12 as the criteria, and Proposed Projects[Funding) as the average_range. H I J B Start Date D Project Type F Funding G Fast Track K Total L Average Project Name - Project Type Funding Type ubet Prop Funding C Number of Days 24 340 148 Funding Commercial Mixed Use Public Residential 360 2021 Summary 2 Old Town Design Plan 3 Honu Point Sports Complex 4 Mahina Regional Park 5 Downtown Bike Path 6 Burton Estates Expansion 7 Highacre Farms Modification 8 Makana Road Multifamily 9 Honu Point Center 10 Sunset Heights Zoning 11 Manu Hill Drive Parking 12 Allied Insurance 13 Nalu Parks Village 14 Sunset Heights Zoning 15 1/10/2022C 1/13/2022 2/22/2022 2/22/2022 3/3/2022 3/13/2022 3/19/2022 3/20/2022 3/20/2022 4/9/2022 4/0/2022 4/18/2022 4/20/2022 Public Commercial Public Public Mixed Use Residential Residential Mixed Use Mixed Use Commercial Commercial Mixed Use Mixed Use Grant Loan Grant Gent Tax Credit Los Tax Credit Grant Loan Tax Credit Tax Credit Los $ $ S $ $ $ $ $ 180 1,500 24.000 12.500 15,000 4.500 10,000 15,000 4,000 2,500 9.500 6,000 50,000 2,500 120 21 125 60 420 21 $ $ S $ Loan Response Questions Part A To B A) Show Steps How You Do It On Excel: 1) Reverse the icon order 2) Display the red diamond icon in cells with a Number type value greater than or equal to 120 3) Display the yellow triangle icon in cells with a Number type value greater than or equal to 60. 4) Display the green circle icon in cells with a Number type value less than 60 B H C Number of Days 24 E Funding Type, F Funding, G Fast Track J her pros K Total L Average nber Prop Sunding Funding I Project Type Commercial Mixed Use Public Residential 340 148 360 A Project Name - 2 Old Town Design Plan 3 Honu Point Sports Complex 4 Mahina Regional Park 5 Downtown Bike Path 6 Burton Estates Expansion 7 Highacre Farms Modification 8 Makana Road Multifamily 9 Honu Point Center 10 Sunset Heights Zoning 11 Manu Hal Drive Parking 12 Allied Insurance 13 Nalu Parks Village 14 Sunset Heights Zoning 90 Start Date 1/10/2022 1/13/2022 2/22/2022 2/22/2022 3/3/2022 3/13/2022 3/19/2022 3/20/2022 3/20/2022 4/9/2022 4/9/2022 4/18/2022 4/20/2022 D Project Type Public Commercial Public Public Mixed Use Residential Residential Mixed Use Mixed Use Commercial Commercial Mixed Use Mixed Use 2021 Summary Loan Grant Grant Tax Credit Loan Tax Credit Grant Loan Tax Credit Tax Credit 90 180 120 21 125 60 420 21 A O S $ $ S S S $ $ S S S $ 24,000 12,500 15,000 4,500 10,000 15,000 4,000 2,500 9,500 6,000 50,000 2,500 Loan B) Show Steps How You Do It On Excel: 1) In cell J2, enter a formula using the COUNTIF function that counts the number of proposed Commercial projects, using Proposed Projects [Project Type) as the range and cell 12 as the criteria 2) In cell K2, enter a formula using the SUMIF function that totals the funding for proposed Commercial projects, using Proposed Projects[Project Type) as the range, cell 12 as the criteria, and Proposed Projects[Funding) as the sum_range. 3) In cell L2, enter a formula using the AVERAGEIF function that averages the funding for proposed Commercial projects, using Proposed Projects[Project Type) as the range, cell 12 as the criteria, and Proposed Projects[Funding) as the average_range. H I J B Start Date D Project Type F Funding G Fast Track K Total L Average Project Name - Project Type Funding Type ubet Prop Funding C Number of Days 24 340 148 Funding Commercial Mixed Use Public Residential 360 2021 Summary 2 Old Town Design Plan 3 Honu Point Sports Complex 4 Mahina Regional Park 5 Downtown Bike Path 6 Burton Estates Expansion 7 Highacre Farms Modification 8 Makana Road Multifamily 9 Honu Point Center 10 Sunset Heights Zoning 11 Manu Hill Drive Parking 12 Allied Insurance 13 Nalu Parks Village 14 Sunset Heights Zoning 15 1/10/2022C 1/13/2022 2/22/2022 2/22/2022 3/3/2022 3/13/2022 3/19/2022 3/20/2022 3/20/2022 4/9/2022 4/0/2022 4/18/2022 4/20/2022 Public Commercial Public Public Mixed Use Residential Residential Mixed Use Mixed Use Commercial Commercial Mixed Use Mixed Use Grant Loan Grant Gent Tax Credit Los Tax Credit Grant Loan Tax Credit Tax Credit Los $ $ S $ $ $ $ $ 180 1,500 24.000 12.500 15,000 4.500 10,000 15,000 4,000 2,500 9.500 6,000 50,000 2,500 120 21 125 60 420 21 $ $ S $ Loan