SHOW FORMULAS AND WORK IN EACH COMPLETED CELL

INSTRUCTIONS 1. Create a Data Validation Input Message- The relevant range is between 11,000 and 16,000 units. Click on Cell D17 and add a Data Validation Input Message usi ng the following Click Data then click Data Validation and input the following A. Settings Allow: Whole number Data: Between Minimum: 11,000 . Maximum: 16,000. B. Input Message Titile- "Relevant Range" Input Message- The relevant range is 11,000 to 16,000 units." C. Error Alert Style-Stop Title-"Invalid Entry Error Message - "The number of units must be between 11,000 and 16,000. 2. Compute each of the seven variances. (Enter your cell references and formulas in the light blue boxes.) 3. Save and submit your file with the appropriate file name (Your First Name Your Last Name Excel #9