Question: a . In cell J 2 , enter a formula using the COUNTIF function that counts the number of proposed Commercial projects, using ProposedProjects [

.

In cell J

2,

enter a formula using the COUNTIF function that counts the number of proposed Commercial projects, using ProposedProjects

[

Project Type

]

as the range and cell I

2

as the criteria.

.

Fill the range J

3

5

with the formula in cell J

2 .

.

In cell K

2,

enter a formula using the SUMIF function that totals the funding for proposed Commercial projects, using ProposedProjects

[

Project Type

]

as the range, cell I

2

as the criteria, and ProposedProjects

[

Funding

]

as the sum

_

range.

.

Fill the range K

3

5

with the formula in cell K

2 .

.

In cell L

2,

enter a formula using the AVERAGEIF function that averages the funding for proposed Commercial projects, using ProposedProjects

[

Project Type

]

as the range, cell I

2

as the criteria, and ProposedProjects

[

Funding

]

as the average

_

range.

.

Fill the range L

3

5

with the formula in cell L

2 .

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

8. Camille also wants to summarize the number of discounted products by product type and calculate their total and average discounted prices. In cell K2, enter a formula using the COUNTIF function...

6. a c. In the range 13:L7, Hwan wants to summarize project information. Calculate the number of projects, the total estimates, and the average estimate in each category as follows: In cell 34, enter...

4. In the Projects table, Hwan wants to make sure that everyone entering project information enters the correct project categories, which are listed in the range 14:17. He asks you to ensure users...

Add a Total Row to the Discounts table, which automatically counts the number of Promo Ad values. Using the total row, display the sum of the Current Price and Discount Price amounts. Camille wants...

In the range I3:L7, Hwan wants to summarize project information. Calculate the number of projects, the total estimates, and the average estimate in each category as follows: a. In cell J4, enter a...

1 . In the range I 3 :L 7 , Hwan wants to summarize project information. Calculate the number of projects, the total estimates, and the average estimate in each category as follows: a . In cell J 4 ,...

Camille also wants to summarize the number of discounted products by product fype and calcule their total and average discounted prices. In cell K 2 , enter a formula using the COUNTIF function that...

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)...

Excel SAM Module 6 Pt. 3 12. Dean wants to summarize the number of projects proposed by the project type and calculate their funding amounts and average funding amounts. Calculate this information...

Please help Im stuck. View Help Tell me what you want to do Home Insert Design Layout References Mailings Review Shelly Cashman Excel 2016 | Module 6: SAM Project 1b Go Adventure Tours CREATING....

Below we consider some logical relationships between preferences and types of goods. A. Suppose you consider all the goods that you might potentially want to consume. (a) Is it possible for all these...

The following data were taken from the records of Amana Bread Corporation for the year ended October 31, 2008: Income statement data: Administrative expenses ...............$ 80,000 Cost of...

You have two bonds, a 6 - year zero coupon bond and a 6 - year 5 % coupon bond ( paid semi - annually ) - - which will be more sensitive to interest rate movements?

CT Corp Comprehensive Question Canadian Tire Corporation, Limited (Canadian Tire) is a family of companies that includes a retail segment and a financial services division, among others. The retail...

(Appendices) PREPARATION OF MERCHANDISING FINANCIAL STATEMENTS. Jay Coat Company has prepared the following unadjusted trial balance as of December Ble Ox2: LO9 The following data are also available:...

(Appendices) EFFECTS OF DISCOUNTS ON SALES AND PURCHASES. Helmkamp Products sells golf clubs and accessories to pro shops. During 19x5, Helmkamp purchased merchandise with a list price of $628,500 on...

(Appendices) TERMS OF SHIPMENT AND ENDING INVENTORY. On December 31, Archive Products had two shipments of merchandise in transit from different suppliers. The first shipment, which arrived on...