$23.$ Create a formula in cell G$4$ that determines the sales rating for total sales as follows:

$-$ for total sales greater than or equal to $500,000,$ the sales rating is Awesome

$-$ for total sales greater than or equal to $250,000,$ the sales rating is Great

$-$ for total sales greater than or equal to $100,000,$ the sales rating is Good

$-$ for all other total sales amounts, the sales rating is Needs Work

Copy the formula in cell G$4$ to cells G$5$ through G$9.$

You are expected to use the IFS function in your formula to answer this question correctly. Use

TRUE for the final logical test.

$24.$ In cell H$11$ create a formula that counts the number of customers that had sales greater than

$100,000$ in every one of the three months. You are expected to use the COUNTIFS function in your

formula to answer this question correctly.

$25.$ In cell H$12$ create a formula that looks up the March sales to the customer Rexall. You are expected

to use nested INDEX and MATCH functions to complete this question correctly. You should assume

the array for the INDEX function is the cell range A$4$:G$9.$

$26.$ In cell H$13$ create a formula that calculates the fraction of the current year that has elapsed so far.

For example, if you open this workbook in the year $2050,$ then it must automatically calculate the

fraction of the year $2050$ that has elapsed.

Your entire formula must be contained in cell H$13,$ so you will need to use nested functions.

Hint: Use the DATE, YEAR, and NOW functions to get the date of the first day of the current year. You

can assume values of $1$ for both the month and day $($i$.$e$.$ January $1$st$).$ The YEARFRAC function can

then use this date as the start date, along with the current date as the end date, to determine the

fraction of the current year.