Question: Using the List option in the Allow drop-down menu found in the Settings tab of the Data Validation dialog box, you can generate an error

Using the List option in the Allow drop-down menu found in the Settings tab of the Data Validation dialog box, you can generate an error message if a value that is not included in a list is entered in the cell range you’re validating. Suppose you’re entering employee first names in the cell range A1:A10. The only employees of the company are Jen, Greg, Vivian, Jon, and John. Use the List option to ensure that no one misspells a first name.

Step by Step Solution

★★★★★

3.47 Rating (150 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

To ensure that only the allowed employee first names are entered in the cell range A1A10 using the L... View full answer

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 Microsoft Excel Data Analysis 7th Questions!

With the Text Length option in the Allow drop-down menu found in the Settings tab of the Data Validation dialog box, you can generate an error message when the number of characters in a cell does not...

The following additional information is available for the Dr. Ivan and Irene Incisor family. The Incisors own a rental beach house in Hawaii. The beach house was rented for the full year during 2012...

Your program will prompt users for options such as creating an initial balance, entering deposits or withdrawals. Also your program will allow for the printing of account information including...

Tasks: In the Sales-Data worksheet: 1. Break the data in the Salesperson column into two columns: First Name and Lost Name. (Use the Text to Columns feature in the Data tab). Make sure that you also...

Does anyone have the excel file of the instructions below? Office 2016 - myitlab:grader - Instructions Excel Project GO16_XL_CH04_GRADER_4G_HW - Warehouse Loan and Staf Lookup Form 1.0 Project...

Does anyone have the excel file of this document? It would be appreciated. Office 2016 - myitlab:grader - Instructions Excel Project GO16_XL_CH04_GRADER_4G_HW - Warehouse Loan and Staf Lookup Form...

\ table [ [ , letorin,Iroentojut,Sopactin,, ] , [ , S , 4 + 9 , S , 1 1 9 , 8 , 1 9 9 , , ] , [ Situcet , , 0 0 0 , , 0 0 , , 0 , , 0 ] , [ Grosples , , 1 , , 5 , , Dete,, ] , [ Uilt coit,,,,tes,,b ....

QUESTION 4 - ACCOUNTS (20 marks) Open the worksheet tab Accounts. Adjust the Row height for table rows using the Format Cell and Auto Fit Row Height option. Restrict data entry to Budget within the...

This is one that is similar but much easier then the one from earlier. Let me know if you can do this one. 1. Open the MortgageCalc-07 workbook from data files folder. 2. Save the workbook as Excel...

Excel problem 7-3. I have attached the file with the data required to complete the problem. \f1. Open the MortgageCalc-07 workbook from data files folder. 2. Save the workbook as Excel 7-3. 3. Apply...

List two ways in which the OSI reference model and the TCP/IP reference model are the same. Now list two ways in which they differ.

Air traffic control stations often have insufficient numbers of air traffic controllers, sometimes just one person on duty. In a recent study, a lone air traffic controller is managing an airstrip in...