ZuoTi.Pro
Question

On the Attendance worksheet, in cell L5, enter an IF function to determine if the percentage in cell K5 is greater than or equal to the goal in cell H18

On the Attendance worksheet, in cell L5, enter an IF function to determine if the percentage in cell K5 is greater than or equal to the goal in cell H18. The function should return the text Goal Met if true and Review if false. Set the reference to cell H18 as an absolute reference.

e02h3JobFairAttendance Microsoft Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW SIMS ▼ Define Name fUse in Formula 喝Create from Selection Defined Names Trace Precedents mE Trace Dependents Remove Arrows Show Formulas Calculate Now Error Checking . watch Calculation Calculate Sheet Window Options nsert AutoSum Recently Financial Logical Text Date &Lookup & Math & More Used -Time ReferenceTrig FunctionsManager Time-Reference- Trig. Functions . Manager Remove ArrowsEvaluate Formula ㊧Evaluate Formula Function Library Formua Auditing 5 Altamonte Springs 6 Central Orlando 7 Caselberry 8 Kissimmee 9 Lake Mary 10 Mount Dora 11 St. Cloud 12 13 14 2015 Admission Fee: 15 16 Total Attendees (2011-2015): 17 Total Locations: 18 19 7% $ 36,79 .65 $47,301.28 33% $ 169,979.15 $203,715.36 12% $ 63,800.00 $ 76,925.48 6% $ 31,900.00 $ 41,583.12 14% $ 71,790.95 $88,174.02 11% $ 56,590.60 $69,893.57 17% $ 90,707.65 $106,215.52 $521,565.00 $ 633,808.35 1580 2109 98 2247 2307 9683 10204 10657 2422 60 453 4580 48791054952 40(952) 150 4501 1,601 2568 11190 11861 4200 4452 2100 2226 4726 5010 3949 6330 34,335 36,395 7873 8145 83% 83% 2641 2598 1850 938 2325 2542 2900 4501 764 3320 3548 5311 5687 Total Attendance 26,825 28,851 30,678 30,78432,700 81% 81% 85% 3647 687 4873 4998 531 3879 3764 3725 376 5971 $ 15.95 City Name: Kissimmee 2015 Percentage: 149,838 Profit from Admission - Goal 80% 2015 Statistics

business   finance   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

The following are the data inputs in spreadsheet:

The following are the obtained results in spreadsheet:

0 1
Add a comment
Know the answer?
Add Answer to:
On the Attendance worksheet, in cell L5, enter an IF function to determine if the percentage in cell K5 is greater than or equal to the goal in cell H18
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • 11. In cell N2, enter a formula using the IF function and a structured reference to...

    11. In cell N2, enter a formula using the IF function and a structured reference to determine if Alison Simoneau is eligible for tuition remission. a. The IF function should first determine if the staff member’s Service Years is greater than 1. Remember to use a structured reference to the Service Years column. b. The function should return the text Eligible if the staff member’s Service Years is greater than 1. c. The function should return the text Not Eligible...

  • In cell H15, enter a VLOOKUP function to determine the 2018 percentage of total attendance for the city listed in cell H14. Use the range A5:H11 as the table array.

     In cell H15, enter a VLOOKUP function to determine the 2018 percentage of total attendance for the city listed in cell H14. Use the range A5:H11 as the table array.

  • Preparing a Performance Report using Excel's ABS, IF and SUM Functions Perfect Parties, Inc. has several...

    Preparing a Performance Report using Excel's ABS, IF and SUM Functions Perfect Parties, Inc. has several divisions, one of which provides birthday parties at their facility, and has provided the actual and planning budget results for the month of June. The Controller has asked you prepare the Birthday Party Division Budget Performance Report. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. Cell Reference: Allows you to refer to data from...

  • 1-Use the OR function with appropriate arguments in cell I11 to determine if there is a...

    1-Use the OR function with appropriate arguments in cell I11 to determine if there is a "Fly Ball". There is a "Fly Ball" if a "Catchable Fly Ball [is] Hit to" the "Infield" (cell E11 is "Yes") or "Shallow Outfield" (cell F11 is "Yes"). 2-Use the NOT function in cell J11 to determine if there are "Not 2 Outs". Use the "Outs" column in your determination. 3-Use the AND function in cell K11 to determine if all of the conditions...

  • Perfect Parties, Inc. has several divisions, one of which provides birthday parties at their facility, and...

    Perfect Parties, Inc. has several divisions, one of which provides birthday parties at their facility, and has provided the actual and planning budget results for the month of June. The Controller has asked you prepare the Birthday Party Division Budget Performance Report. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. Cell Reference: Allows you to refer to data from another cell in the worksheet. From the Excel Simulation below, if...

  • Please using giving excell formulas from this excel document :) Alanco, Inc a variety of products...

    Please using giving excell formulas from this excel document :) Alanco, Inc a variety of products and is currently manufacturing all of its own component parts. An outside supplier has offered to sell one of those components to Alanco. The Controller has asked you to help evaluate this offer to determine If the company should make or buy the output the result from cell C4, or 27,000,000 in this example Allows you to use the basic math symbols to perform...

  • Enter an IF function in cell G3 on the Payroll Details worksheet to calculate the Social...

    Enter an IF function in cell G3 on the Payroll Details worksheet to calculate the Social Security tax. Social Security funds are used by the government to provide income for people who are retired, a beneficiary of a retiree, or disabled. An employer must withhold 4.2% of an employee’s weekly pay for Social Security. However, an employee is only taxed up to $100,000. The logical test of the IF function should assess if the value in the Pay Year to...

  • Adams Corporation evaluates divisional managers based on Return on Investment (ROI) and has provided the operating...

    Adams Corporation evaluates divisional managers based on Return on Investment (ROI) and has provided the operating results of the Northern Division from last year. The Controller has asked you to compute the ROI and Residual Income based on data from last year and if the division adds a new product line. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. • Cell Reference: Allows you to refer to data from another...

  • The Chestnut Street Company plans to issue a bond semiannually on March 31st and September 30th....

    The Chestnut Street Company plans to issue a bond semiannually on March 31st and September 30th. The Controller has asked you to calculate Information about the bond assuming two different market interest rates in the Excel Simulation below. The present value factor tables are Included in the first four tabs of the Excel Simulation. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. • Cell Reference: Allows you to refer to...

  • I have completed these but wanting to compare such as Question 14. Is the word "Total"...

    I have completed these but wanting to compare such as Question 14. Is the word "Total" added in the row or written as "Average" or "Total Average" Also Question 8 is not clear what fill color. Is it supposed to stay as blue and just select gradient fill? Very unclear questions. Thank you. Question: EX16_XL_VOL1_GRADER_CAP_AS – Travel Vacations 1.4 ( Excel, Chapter 4) Project Description: 1 Start Excel. Download and open the file named exploring_ecap_grader_a1.xlsx. 2 On the DC worksheet,...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT