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. 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
Get step-by-step solutions from verified subject matter experts
