1. Create a nested IF statement in cells G4:G7 that returns the word Excellent if the Q4 value is greater than 120000, the word Good if the Q4 value is greater than the Q1 value or the word Poor if neither is true. [4]
2. Use Goal Seek to determine the percentage increase needed for the Proposed 2022 Sales

to equal a value of exactly $525,000 and click the OK button to keep the result. [3]

Please answer both the questions not just one.

thank you.

Retail Store Status