ASSIGNMENT NO.3

-

 DATA VALIDATION IN EXCEL:

Data validation is a feature that allows you to control the type, format, or range of data that users can input into specific cells. By applying predefined rules, you can ensure that only valid and relevant data is entered into your Excel worksheet.
 

Create a Data Validation Rule

To create the data validation rule, execute the following steps.

1. On the Data tab, in the Data Tools group, click Data Validation.


                  Click Data Validation

On the Settings tab:

3. In the Allow list, click Whole number.

4. In the Data list, click between.

5. Enter the Minimum and Maximum values.

                          Validation Criteria

Input Message

An input message appears when the user selects the cell and tells the user what to enter.

On the Input Message tab:

1. Check 'Show input message when cell is selected'.

2. Enter a title.

3. Enter an input message.

                      


Error Alert

If users ignore the input message and enter a number that is not valid, you can show them an error alert.

On the Error Alert tab:

1. Check 'Show error alert after invalid data is entered'.

2. Enter a title.

3. Enter an error message.

4. Click OK.

Data Validation Result

Now, let's check if the data validation is working properly and as expected.



Comments

Post a Comment

Popular posts from this blog

ASSIGNMENT NO.5

-
Image
HOW TO USE FLASHFILL IN EXCEL Flash Fill is one of the most amazing features of Excel. It grabs a tedious task that would take hours to be performed manually and executes it automatically in a flash. And it does so quickly and simply without you having to do a thing but only provide an example of what you want. step 1:-   Enter the  First Name  in the first result cell and press  Enter . step 2:- Start  typing the next name step 3:-  Flash Fill  will suggest the  first  part of all names  step 4:-  Press  Enter . step 5:- You can see all the  First Names  in column  . step 6:- Separate the surname  Names
Read more

ASSIGNMENT NO.1

-
Image
  How to make pivot table? Creating a pivot table is a great way to summarize and analyze data in Excel or Google Sheets. Here's a step-by-step guide on how to create one: Select Your Data : Highlight the range of data you want to use for the pivot table (including headers). Insert Pivot Table : Go to the Insert tab on the ribbon. Click on PivotTable . Choose Pivot Table Location : Excel will ask if you want to place the pivot table in a New Worksheet or an Existing Worksheet . Choose one based on your preference. Click OK . Add Fields to the Pivot Table : A PivotTable Field List will appear on the right side. Drag and drop the fields (columns from your data) into one of the four areas: Rows : This will categorize your data into rows. Columns : This will categorize your data into columns. Values : This will calculate the data, like sums, averages, counts, etc. Filters : This allows you to filter the data based on certain criteria. Adjust and Cus...
Read more

ASSIGNMENT NO.2

-
Image
  R emoving duplicates in excel: The Remove Duplicates function is used to remove duplicate entries. Duplicate entries are values that two or more are the same. This can be both numbers and text inputs. A1 and A2 are duplicates since they have the same values. Select the range where you want to remove duplicate values. 1. Select Your Data: Highlight the range of cells where you want to remove duplicates. You can select a column or a table (multiple columns and rows) based on your needs. 2. Open the "Data" Tab: Go to the Data tab in the Excel ribbon at the top of the window. 3. Click "Remove Duplicates": In the "Data Tools" group, click the "Remove Duplicates" button. 4. Choose Columns to Check for Duplicates: A pop-up window will appear where you can choose which columns to check for duplicates. By default, Excel will check all columns that are part of your selected range. If you want to remove duplicates based on one specific c...
Read more