In this scenario, you're the product manager for a toy company. You're reviewing the previous year's sales and deciding which toys should continue in production and which should be discontinued based on performance. Perform the following tasks:

Investigate the four errors in column I. If there is a real problem, fix the problem. Otherwise, choose Ignore Error.

In J$6,$ create a formula using relative references that returns the value of the total number of Furbits sold times their price. Use the fill handle to copy this formula to $J7$ :$15.$

In K$6,$ use the IF function to create a formula that will return Yes if the revenue from Furbits is equal to or higher than the threshold value. in N$5$ and No if it's lower. Reference N$5$ in the formula. Use an absolute reference so this formula can be copied to the rest of the table. When the formula is complete, use the fill handle to copy it to K$7$:K$15.$