USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
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?
|
|
Date and Time
|
|
|
Whole Numbers
|
|
|
Images or Shapes
|
|
|
Months of the Year
|
Explanation:
Detailed explanation-1: -1) The correct answer is c. You can set data validation for dates, times, whole numbers, decimal numbers or create lists that contain, for example, months of the year. You cannot set data validation for images or shapes.
Detailed explanation-2: -You can use data validation to restrict the type of data or values that users enter into cells. For example, you might use data validation to calculate the maximum allowed value in a cell based on a value elsewhere in the workbook.
Detailed explanation-3: -Answer-1) The Round Function is not a data validation technique..
There is 1 question to complete.