Question: Insert an IF function in column I that displays a $ 6 0 0 bonus if an agent's average sales are greater than the average

Insert an IF function in column I that
displays a $600 bonus if an agent's average
sales are greater than the average of all
sales for the six months. Use two nested
AVERAGE functions in the logical_test
argument of the IF function to make the
comparison. Use cell reference for Bonus.
Insert an IF function in column I that displays a

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 Programming Questions!

Q:

Only Need TASK 6, please explain the steps, thanks. K19 fx A B D F H 1 K L M N 0 P Q 2012 Total Sales by Agent 1 January - June 2 January February March April May June Trends Bonus 3 Avery $ 3,671 $...

Q:

H I J K L M N O P Q R S T U V 2012 Total Sales by Agent A B C D E F G 2012 Total Sales by Agent January - June January February March April May June Avery $ 3,671 $ 2,973 $ 4,017 $ 5,040 $ 4,963 $...

Q:

2 0 1 2 Total Sales by Agent January - June Bonus $ 6 0 0 Task 5 Create Line sparklines in column H in the Summary sheet to display six - month trends for each agent. Show the high point in each...

Q:

Home Insert Draw Page Layout Formulas D A1 4 x fx Vin # Prius 2009 A B C 1 Vin I Make Model 2 2906934387 BMW 5 Series 3 6393487147 Honda Civic 4 9356019403 Toyota 58000086254 BMW 5 Series 6...

Q:

Create a list named myList with the following four elements (with their names): 1. numbers: The even numbers from -30 to 30. 2. strings: Five character strings a,b,c,d,e. 3. matrix: One 2x3 matrix 5...

Q:

Assessment Task 2 Manage workforce planning BSBHRM513 Student Declaration To be filled out and submitted with assessment responses I declare that this task and any attached document related to the...

Q:

Cherry Kola I Vacationer Process 5" Reach out to farms to connect on matchmakingiendorsement services Meet with and decide on logistics of the projectsfrate of pay. Contract an independent contractor...

Q:

Base Price $1,699 $1,749 $1,799 $1,849 $1,899 $1,949 Commission 2.5% 3.0% 3.5% 4.0% 4.5% 5.0% Package 10 20 30 40 50 60 70 80 Tour Description Adventures in Canada Check Out the Czech Republic!...

Q:

Excel project due Friday please help EXP E Capstone 1 - European Excursions 2.5 Project Description: You work for a travel company that specializes in arranging travel accommodations for student...

Q:

Excel Chapter 7-Real Estate Exp19_Excel_Cho7_Cap_Real_Estate Project Description: You are the office manager for a real estate company in northern Utah County. You tracked real estate listings,...

Q:

2. Suppose the central bank sets the reserve requirement ratio at 5%. The maximum the central bank is willing to lend is 25% of required reserves, charging the gross real rate of return of 1. We...

Q:

Income statement and balance sheet data for Great Adventures, Inc., are provided below. GREAT ADVENTURES, INC. Income Statement For the Year Ended December 31, 2014 Revenues: Service revenue (clinic,...

Q:

Please assist with the following that needs application of ratio equations ( Accounting )

Q:

Consider the given discrete probability distribution Find the probability that x exceeds 4 X p x 0 76 0 89 0 87 0 24 0 11 2 0 13 4 7 0 02 9 0 09