Question: The purpose of this assignment is to practice making user inputs. Be sure to follow the Excel Requirements document (a blue background is not required

 The purpose of this assignment is to practice making user inputs.

The purpose of this assignment is to practice making user inputs. Be sure to follow the Excel Requirements document (a blue background is not required for form control inputs). Create each part on a separate worksheet that is appropriately named. 1. Create a user input cell so that the user can input their age a. Use Data Validation b. Only allow ages of 10 to 100 c. Only allow the user to input whole numbers for their age d. Create an appropriate Input Message e. Use the Stop style of Error Alert f. Create an appropriate Error Message 2. Create a user input cell so that the user can input their favorite vacation location using an in-cell drop down list a. Use Data Validation b. Create and use a list of your 5 favorite vacation locations c. Do NOT create an Input Message d. Use the Information style of Error Alert e. Create an appropriate Error Message 3. Create a user input cell that requires the user to enter 42.3 a. Use Data Validation b. Create an appropriate Input Message c. Use the Warning style of Error Alert d. Create an appropriate Error Message 4. Create a Group Box a. Change the text for the Group Box to: What is your favorite color? b. Create 3 Option Buttons i. Change the text of the Option Buttons to your favorite 3 colors c. Create the cell link for the Option Buttons 5. Create a Combo Box a. Create a list of 4 of your favorite foods to be used with the Combo Box b. Create the cell link for the Combo Box

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!