In cell J2, enter a formula using the COUNTIF function that counts the number of proposed Commercial projects, using ProposedProjects[Project Type] as the range and cell I2 as the criteria.Fill the range J3:J5 with the formula in cell J2.In cell K2, enter a formula using the SUMIF function that totals the funding for proposed Commercial projects, using ProposedProjects[Project Type] as the range, cell I2 as the criteria, and ProposedProjects[Funding] as the sum_range.Fill the range K3:K5 with the formula in cell K2.In cell L2, enter a formula using the AVERAGEIF function that averages the funding for proposed Commercial projects, using ProposedProjects[Project Type] as the range, cell I2 as the criteria, and ProposedProjects[Funding] as the average_range.Fill the range L3:L5 with the formula in cell L2.

According to the Question below the Solution: As per our guidelines we are supposed to answer?️…

Answered: In cell J2, enter a formula using the…

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

Related questions

Question

In cell J2, enter a formula using the COUNTIF function that counts the number of proposed Commercial projects, using ProposedProjects[Project Type] as the range and cell I2 as the criteria.
Fill the range J3:J5 with the formula in cell J2.
In cell K2, enter a formula using the SUMIF function that totals the funding for proposed Commercial projects, using ProposedProjects[Project Type] as the range, cell I2 as the criteria, and ProposedProjects[Funding] as the sum_range.
Fill the range K3:K5 with the formula in cell K2.
In cell L2, enter a formula using the AVERAGEIF function that averages the funding for proposed Commercial projects, using ProposedProjects[Project Type] as the range, cell I2 as the criteria, and ProposedProjects[Funding] as the average_range.
Fill the range L3:L5 with the formula in cell L2.