Question: (What exact function I need to put in J13 base in the instruction?) In cell J13, create a formula using the DAVERAGE function to average

(What exact function I need to put in J13 base in the instruction?)

  1. In cell J13, create a formula using the DAVERAGE function to average the budget amounts for Comedy projects in the Projects table, using the range I11:I12 as the criteria.

(What exact function I need to put in J13 base in

A B D E F G - H K L Budget Approved? Delay? Project Information x FALSE FALSE FALSE Project ID Project Name Start Date TV245 Paradise Moon 45005 o FALSE FALSE (! ! Budget > 15000 Number of Projects 22 FALSE FALSE FALSE TRUE O Yes No No Yes No No No Yes No No Yes No No Yes No No No x TRUE ID Project Name Project Type Start Date 1 2 AC533 Just Spirits Action movie 6/22 3 AC210 Tension Sunrise Action movie 6/22 4 TV453 Against the Wall TV show 7/22 5 TV697 Bayridge TV show 7/22 6 AC328 The Castle Behind Me Action movie 9/22 7 C0720 Mack and Mack Comedy 9/22 8 C0789 Space Plum Comedy 10/22 9 CO329 Karate Night Comedy 10/22 10 DR887 Never in Common Drama 11/22 11 DR543 All My Friends Drama 11/22 12 DR521 A Great Getaway Drama 1/23 13 C0325 Teenage Miracle Mile Comedy 1/23 14 DR512 The Great Grasshopper Drama 2/23 15 DR622 Downtown Bike Path Drama 2/23 16 TV482 Because of Winston TV show 3/23 17 AC736 Mad Music Action movie 3/23 18 AC447 A Slight Case of Spring Action movie 19 TV245 Paradise Moon TV show 3/23 20 TV598 Good Gold Bad Blue TV show 21 CO305 Shark Myths Comedy 22 C0220 This Guy Laughed Comedy 4/23 23 TV552 Celeste and Cecilia TV show 4/23 24 Approved Projects FALSE $45,500 $12,000 $22,500 $28,500 $23,010 $18,555 $25,000 $20,000 $19,700 $12,200 $31,500 $24,000 $12,500 $15,000 $24,500 $10,000 $15,000 $14,000 $22,500 $19,500 $16,000 $50,000 Project Type Comedy Average Budget ! FALSE TRUE x Number Total Budget Average Budget O FALSE FALSE FALSE FALSE x Project Type Action movie Comedy Drama TV show 3/23 X Yes No FALSE FALSE (! 3/23 4/23 Yes No Yes FALSE FALSE FALSE

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 General Management Questions!