Response Questions Part A To B A) Show Steps How You Do It On Excel: In cell G2, enter a formula using the AND function that includes structured references to display TRUE if a project has a [Project Type of "Mixed Use" and a [Funding Type) of "Loan". Fill the range G3:G13 with the formula in cell G2 if Excel does not do so automatically. B) Show Steps How You Do It On Excel: Add a Total Row, which automatically counts the number of Fast Track values. Using the total row, display the sum of the funding amounts. A B D E F G H I J K C Number of Project L Average Funding Project Name - Start Date Days mber Prop Fast Track Funding Sunding Fu 24 340 148 360 Funding, $ 1,500 $ 24,000 $ 12,500 $ 15,000 Type Commercial Mixed Use Public Residential 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 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 2021 Summary Project Type Public Commercial Public Public Mixed Use Residential Residential Mixed Use Mixed Use Commercial Commercial Mixed Use Mixed Use 90 180 120 21 125 60 420 21 Funding Type Grant Loan Grant Grant Tax Credit Loan Tax Credit Grant Loan Tax Credit Tax Credit Loan Loan $ $ $ $ $ $ $ $ 10,000 15,000 4,000 2,500 9,500 6,000 50,000 2,500