| BUS370 Extra Credit II | |||||||||||||
| For questions 5-8 you MUST leave your formula in the cell in column C to receive credit. |
|||||||||||||
| Answers without the correct formula will not receive credit. |
|||||||||||||
| Turn in your completed Excel file to the Extra Credit II Dropbox by the deadline. |
|||||||||||||
| For problems 1-3, use Excel’s Data Validation functionality |
|||||||||||||
| Answer: | List: | ||||||||||||
| 1 | Use Data Validation to restrict the values in cell C9 to the values shown in cells E9-E13. If the values in E9-E13 change, the restricted values for cell C9 must update as well. |
Red | |||||||||||
| Blue | |||||||||||||
| 2 | Show a Data Validation Input Message “Please select a color” when cell C9 is clicked on. |
Green | |||||||||||
| Yellow | |||||||||||||
| 3 | Show a Data Validation Error Message “You entered an incorrect color” when an incorrect value is entered in cell C9. |
Purple | |||||||||||
| 4 | Enterone formula in cell F17 that when the formula is copied to the rest of the table it completes the multiplication table. (Hint: lock the appropriate row or column in your formula) |
Multiplication Table: | |||||||||||
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | |||||
| 1 | |||||||||||||
| 2 | |||||||||||||
| 3 | |||||||||||||
| 4 | |||||||||||||
| 5 | |||||||||||||
| 6 | |||||||||||||
| 7 | |||||||||||||
| 8 | |||||||||||||
| 9 | |||||||||||||
| 5 | Use the CONCATENATE() function or & to put the values in cells E27 and G27 into cell C27. |
3×3= | 9 | ||||||||||
| 6 | Use an IF() statement to display “Less than 50” in cell C29 if a number less than 50 is entered into cell E29, and “Not less than 50” if a number not less than 50 is entered into cell E29. |
47 | |||||||||||
| 7 | Use an IF() statement to display “Less than 50” in cell C31 if a number less than 50 is entered into cell E31, “Exactly 50” if 50 is entered into cell E31, and “Greater than 50” if a number is greater than 50 is entered into cell E31. |
52 | |||||||||||
| 8 | Use the LEFT() function in cell C33 to display the first 6 characters of cell E33. |
BUS370 Introduction to Supply Chain Management |
