Question can be found here https://goo.gl/a2gqpI Use Excel\'s Data Validation Fu

Question

Question can be found here https://goo.gl/a2gqpI

Use Excel's Data Validation Functionality Use Data Validation to restrict the values in cell C9 to the values shown in cells E8-E13. If the values in E8-E13 change, the restricted values for cell C9 must update as well. Show a Data Validation Input Message "Please select a city" when cell C9 is clicked on. Show a Data Validation Error Message "You entered an incorrect city" when an incorrect value is entered in cell C9. Enter one formula in cell F17 that when the formula is copied to the rest of the table it completes the addition table. (lock the appropriate row or column in your formula) Use the CONCATENATE () function or & to put the values in cells E27 and F27 into cell C27. Use an IF() statement to display "Greater than 500" in cell C29 if a number greater than 500 is entered into cell E29, and "Not greater than 500" if a number not greater than 500 is entered into cell E29. Use the NOW() function to display the current date and time in cell C31 Use the VLOOKUP() function in cell C33 to look up the value "New York" in the E7-F13 table and display its state: NY

Explanation / Answer

1. Use Data -> Data Validation -> Settings tab
   Allow : List
   Source : =$E$8:$E$13
2. Enter the required details in Input Message tab
   Checkbox selected.
   Title : Enter City
   Input Message: Please select a city
2. Enter the required details in Error Alert tab
   Checkbox selected
   Style: Stop
   Title : Error
   Error Message: You entered an incorrect city

4. =$E$17&","&$F$16
5. =CONCATENATE(E27,F27)
6. =IF(E29>500,"Greater than 500","Not greater than 500")
7. =NOW()
8. =VLOOKUP(C9,E8:F13,2,FALSE)

XLS URL : https://drive.google.com/file/d/0Bx-j2pttV5o1WjBlcEZrTng4eFU/view?usp=sharing

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.