facebook twitter pinterest google plus Youtube
www.TestsTestsTests.com

www.TestsTestsTests.com

Using Data Validation Tools Excel Test

Excel 2010 Training - Working with Data
Free Online Microsoft Excel Test

* What is Data Validation?
* Numbers, Dates & Time Validation Criteria
* Data Validation Lists
* Input Messages
* Removing a Filter
* Removing Data Validation

10 Question Multiple Choice Quiz with Answers
and Answer Explanations

Using Data Validation Tools Excel Test


1) Data Validation allows you to stipulate what type of data is allowed within a cell.  Which of the following is NOT a valid Validation Criteria type?
a) Date and Time
b) Whole Numbers
c) Images or Shapes
d) Months of the Year

2) Which of the following represent the three sections of Data Validation found within the Data Validation dialogue box?
a) Settings, Input Message, Error Alert
b) Dates & Times, Numbers and Text
c) Data, Data Criteria, Data Validation
d) Rows, Cells and Columns

Question 3 - Using Data Validation Tools Excel Test

3) Study the screenshot above.  What is the message (circled in yellow) called?
a) It is called a Comment.
b) It is called a Cell Note.
c) It is called an Error Alert Message.
d) It is called an Input Message. 

4) Where can I find the option to create a customized error message?
a) Under the Insert tab on the Ribbon, in the Text group. 
b) Under the Review tab on the Ribbon, in the Changes group.
c) Under the Data tab on the Ribbon, in the Data Tools group.
d) All of the options listed above are correct.


Question 5 - Using Data Validation Tools Excel Test

5) Study the list circled in yellow in the screenshot above.  How can you create this kind of dropdown list?
a) Not easily, you will need to know computer programming languages to create this.
b) It’s easy – type all the words you need into a cell, click on Insert and select List, to convert the words you typed into a list.
c) It’s easy – in the Data Validation box, under Validation Criteria, select List.  Insert the location for the list in the Source box.
d) It’s not possible.  Excel is an accounting program, not a data entry program.


6) To remove all data validation rules that have been applied to a worksheet, you must:
a) Select the whole sheet and press the Delete button on your keyboard.
b) Select the whole sheet and in the Data Validation dialogue box, select Clear All.
c) Select the whole sheet, click the dropdown arrow next to the Data Validation button and select Clear Validation Circles.
d) Select the whole sheet, right-click the sheet and select Clear Contents.

Question 7 - Using Data Validation Tools Excel Test

7) Study the screenshot above.  Is it possible to change the wording of the error message?
a) Yes, by typing the title and error message into the Error Alert section of the Data Validation dialogue box.
b) Yes, by right-clicking the error message and selecting Edit from the menu list. Then type the relevant title and message into the box.
c) No, this is a built-in function in Excel and cannot easily be edited.
d) Yes, by creating an Error Message Text Box in the Text group under the Insert tab on the Ribbon.


8) Priscilla wants to ensure that in a Date column on her worksheet, dates that fall BEFORE 1 January 2015 cannot be entered.  How can she achieve this?
a) She should select Date as a Data Validation Criteria.  It will automatically adjust the dates allowed to be after 1 January 2015.
b) She should type 1 January 2015 into the first cell of the Date column and then select Date as a Data Validation Criteria.
c) She should select Date as a Data Validation Criteria.  Select Greater than or equal to in the Data box and insert 1 January 2015 as the Start Date
d) She should select Date as a Data Validation Criteria.  Select Less than or equal to in the Data box and insert 1 January 2015 as the Start Date.


9) Kirsty, an Office Manager, created a feedback form in Excel that everyone in the office will complete a copy of.  She wants to prevent staff from writing more than 500 words in the comments box.  How can she achieve this?
a) She can insert an Input Message stating that no more than 500 characters are allowed.
b) She can set Text Length to be Less than 500 characters.
c) She can size the comment box so that users cannot enter more than 500 characters.
d) She can insert an Error Message stating that no more than 500 characters are allowed.

10) To extend Data Validation, for example a Data Validation List, to cells that it is not applied to yet, I can:
a) Recreate the Data Validation list by selecting the existing cells as well as the additional cells and reapplying the Data Validation Criteria to it.
b) I can copy and paste a cell to which the Data Validation Criteria is applied, to additional cells.
c) Both of the options listed above are correct.
d) Neither of the options listed above are correct.