CPA 3NT SST 8b

Data validation

• restricts input to a range of cells
• prevents users from editing the worksheet
• ensures the input on selected cells meets the criteria

In which tab can the Data Validation button be found?

• 
• 
• 
• 

The Data Validation button greyed out. What should you do?

• protect the worksheet (the worksheet is currently unprotected)

• unprotect the worksheet (the worksheet is currently protected)

• restart Microsoft Excel; there is an error

What are the types of data validation? (select all that apply)

• length check
• range check
• type check

This is the data validation criteria. A user inputs RED APPLE. Is it accepted?

• accepted

• not accepted

This is the data validation criteria. A user inputs 0.0. Is it accepted?

• accepted

• not accepted

Alex has a target BMI of 27. To find out what weight he has to be, which feature can be used?

• data validation

• goal seek

• scenario manager

One cell in column Quantity has wrong input. Which cell is it? (eg. A1, D5?)

Cell C3 is the number of paper plates bought. The validation criteria for the cell should have a type check for

• whole numbers

• decimal

• text

They wish to spend exactly $20.00 on the party by only varying the quantity of mee siam bought. What should be entered in the goal seek window?

• 
• 
• 
•