Question $34$

We have a cell that has been assigned a Data Validation rule with the following

characteristics:

Settings tab:

Allow: any value

Input Message tab:

Show input message when cell is selected is checked.

Title: Budgeted Income

Input Message: Enter the expected income you will receive this period.

Error Alert tab:

Show error alert after invalid data is entered is checked.

Style: Warning

Title: Invalid Value

Error Message: You have entered an invalid value. Please enter a number.

Which of the following will happen when a user types "Budget" in this field and tries to leave

the field? $($select all that apply$)$

Excel will not allow the focus to leave the cell until the user enters a valid number.

Excel will show the error message.

Excel will display a dropdown list of potential values.

Nothing. The user will leave the cell with no issues.