Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Excel Donors receive a premium as a token of appreciation if their donation is at the Gold level or they are repeat donors. Provide this
Excel
- Donors receive a premium as a token of appreciation if their donation is at the "Gold" level or they are repeat donors. Provide this information for Jane as follows:
- In cell K5, insert a formula using the OR function that returns TRUE if the donation level (cell H5) equals "Gold" or the repeat donor indicator (cell J5) equals "Y".
- Use the Fill Handle to fill the range K6:K17 with the formula in cell K5, filling the range without formatting.
- Jane likes to keep track of the total number of pledges she has received for the university. In cell B19, enter a formula using the COUNT function that counts the number of pledge IDs (the range A5:A17).
- Jane also likes to keep track of the approximate amount of pledges she has received. In cell B20, enter a formula using the ROUNDUP and SUM functions that totals the pledge amounts (the range D5:D17) and rounds the result up to -3 decimal places, or three places before the decimal point.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started