Formative Assessment 11 US 116937

Open the workbook Sales Projections

In cell B7 (Overheads Growth) create a validation entry

Set these validation settings: Whole Number, Less than 1; and switch off Ignore blank

Set the Input Message title to “Input Overheads” and the message to “Enter a fraction such as .15, or a percentage such as 15%”

Set the Error Alert to Stop; title to “High Overheads”, and the message as “Unrealistic figure, please re-enter.”

In cell B7 enter the number 2

Reset the validation Error Alert to Warning

In cell B7 enter the number 2, and accept the number

Display the Data Tool group

Use the Circle Invalid Data button to highlight the number 2 in cell B7

Close the file without saving it