4. Richard asks you to calculate the membership prices for the first quarter memberships sold in the gallery ticket office. The individual membership price is $50. Students pay a discounted price of $25. In cell F5, create a formula using the IF function to determine the membership price based on the following criteria: a. If cell D5 (the Category) is Student the price is 25. (Hint: Student must appear in quotes. Do not enter $ for the price.) b. All other individual members must pay 50. Copy the formula in cell F5 into the range F6:F13.

In 2018, laureen is currently single. she paid $2,800 of qualified tuition and related expenses for each of her twin daughters sheri and meri to attend state university as freshmen ($2,800 each for a total of $5,600). sheri and meri qualify as laureen’s dependents. laureen also paid $1,900 for her son ryan’s (also laureen’s dependent) tuition and related expenses to attend his junior year at state university. finally, laureen paid $1,200 for herself to attend seminars at a community college to her improve her job skills.what is the maximum amount of education credits laureen can claim for these expenditures in each of the following alternative scenarios? a. laureen's agi is $45,000.b. laureen’s agi is $95,000.c. laureen’s agi is $45,000 and laureen paid $12,000 (not $1,900) for ryan to attend graduate school (i.e, his fifth year, not his junior year).