Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Sound Investing, Chapter 25 - Change In Auditors

Authors: Kate Mooney

3rd Edition

0071719474, 9780071719476

More Books

Students also viewed these Accounting questions