Learning Task 4 : Read the sentences carefully. Choose the letter of the correct answer. 1. Suppose you want a message to pop up each time a particular cell is selected. How do you make this happen? A. Use a comment C. Use a data validation input message B. Use conditional formatting D. Don't know 2. What is the most likely cause of this error message? Microsoft Excel Х X This value doesn't match the data validation restrictions defined for this cell. Retry Cancel Help A. The user attempted to enter data into a protected worksheet. B. validation rule exists on the cell, but the rule's author didn't configure an error message C. A validation rule was configured, and the rule's author pro- grammed the error message text to read as in the message D. Don't know А
