Back to lesson
1. Which of the following is not a keyboard shortcut for activating the Data Validation dialog box?
ALT + D + L
ALT + A + V + V
CTRL + D + V
2. To prompt the end user with a pop-up message when a cell is selected, which tab enables this feature in the Data Validation dialog box?
3. Data validation can be tricky to locate on a worksheet. Which of the following is an easy way to locate all data validated cells on a worksheet?
CTRL + SHIFT + O
To locate data validation on a worksheet press the F5 function key or CTRL + G to bring up the Go To dialogue box. Click on 'Special' and select 'Data Validation' and 'All'.
Go to the ‘Data’ tab on the Ribbon, then select ‘Data Validation…’ from the ‘Data Validation’ dropdown in the ‘Data Tools’ group.
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement