REQUIREMENTS ENGINEERING
REQUIREMENTS VALIDATION AND VERIFICATION
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
To make sure the data entered is sensible.
|
|
|
To make sure that only the correct options are selected.
|
|
|
To make sure that all numbers are in correct length.
|
|
|
To make sure that data is entered where required.
|
Detailed explanation-1: -Data entry is quicker and more accurate when you use a drop-down list to limit the entries people can make in a cell. When someone selects a cell, the drop-down list’s down-arrow appears, and they can click it and make a selection. You can make a worksheet more efficient by providing drop-down lists.
Detailed explanation-2: -Go to Home –> Find & Select –> Go To Special. Data validation has two options: All and Same. All would select all the cells that have a data validation rule applied on it. Same would select only those cells that have the same data validation rule as that of the active cell.
Detailed explanation-3: -Select the cells where you want to restrict data entry. On the Data tab, click Data Validation > Data Validation. In the Allow box, select the type of data you want to allow, and fill in the limiting criteria and values.