DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
insert data
|
|
|
set up rules that keep you or others from entering invalid data
|
|
|
Put in random data for you
|
|
|
delete unwanted data
|
Detailed explanation-1: -Data validation is a feature in Excel which is used to control what users can enter into a cell. It allows you to dictate specific rules. It also allows users to display a custom message if users try to enter invalid data.
Detailed explanation-2: -Excel can restrict data entry to certain cells by using data validation, prompt users to enter valid data when a cell is selected, and display an error message when a user enters invalid data.
Detailed explanation-3: -Data validation refers to the process of ensuring the accuracy and quality of data. It is implemented by building several checks into a system or report to ensure the logical consistency of input and stored data. In automated systems, data is entered with minimal or no human supervision.
Detailed explanation-4: -You may want to use the data validation tools to check your worksheets for incorrect data that may cause inaccurate calculations or results. Cells that contain invalid data appear with a red circle around them so that you can easily find and correct any problems.
Detailed explanation-5: -Help Inputting Data into a Cell You can create a message that appears when a user selects a cell that has Data Validation. This message allows you to tell the user what or when they can input a value into the cell. Basically, you can input anything you want here.