Sanjana chaudhary

Assignment 7 USE OF HLOOKUP IN EXCEL In Excel to find and extract data from a table. By the end of these steps, you’ll be able to look up values horizontally across rows with confidence. Step 1: Open Your Excel Spreadsheet First, open your Excel spreadsheet where your data is stored. Make sure your table is well-organized with the necessary data laid out in rows. This organization is crucial for the HLOOKUP function to work correctly. Step 2: Select the Cell for the HLOOKUP Formula Choose the cell where you want the result of the HLOOKUP to appear. Click on an empty cell, which will be the destination for your lookup result. This will help you keep your data organized. Step 3: Enter the Hlookup  Formula In the selected cell, type . =HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup]) Step 4: Press Enter After entering the formula, press Enter to execute it.   OUTPUT:

F   LASH FILL Excel Flash Fill is a feature of Microsoft Excel  where Excel can sense a pattern in the cell and apply the logic to extract a similar resultant pattern out of the remaining cells in the table.   STEP  1.  First, tell Excel what you want to do by entering the value AMA into                           cell E2. STEP  2.   On the Data tab, in the Data Tools group, click Flash Fill ,                                             (or press CTRL + E). RESULT :👇🏻👇🏻👇🏻👇🏻

  IF FUNCTION👇👇   The IF function is one of the most popular functions in Excel, and it allows you to make logical comparisons between a value and what you expect. So an IF statement can have two results. The first result is if your comparison is True, the second if your comparison is False. 1 . Insert an IF function You can open a new Excel spreadsheet, decide where you want to see the result and click on that cell. Next, click the 'fx' button to bring up the function wizard and select the IF function. You can click the ‘OK' button. 2 . Create a logical test The next step is to decide on the condition you want to evaluate in Excel and enter it in the 'logical_test' field.  3. Customise 'value_if_true' The next field is 'value_if_true' and it is optional. You can leave it blank by writing "" into the field space. If you leave it blank and the condition is true, Excel generates a blank result.  4. Customise 'value_if_false' In Exc...

  HOW TO USE FLASHFILL IN EXCEL F lash 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:-  S tart 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

  Pivot table Assignment no:3 Remove duplicate data January 31, 2025   Removing duplicate data is an essential step in data cleaning and preprocessing. Here are some methods to remove duplicate data: # Using Excel 1. *Select the data range*: Choose the cells that contain the data you want to remove duplicates from. 2. *Go to the "Data" tab*: Click on the "Data" tab in the ribbon. 3. *Click on "Remove Duplicates"*: Click on the "Remove Duplicates" button in the "Data Tools" group. 4. *Select the columns to check for duplicates*: Choose the columns you want to check for duplicates. 5. *Click "OK"*: Click "OK" to remove the duplicates. # Using Google Sheets 2. *Go to the "Data" menu*: Click on the "Data" menu. 3. *Select "Remove duplicates"*: Choose "Remove duplicates" from the drop-down menu. 4. *Select the columns to check for duplicates*: Choose the columns you want to check fo...

  Assignment :2 Remove duplicate in MS Excel   Removing Duplicates in Excel:   Definition:- Removing duplicates  in  Microsoft Excel  refers to the process of eliminating repeated or identical rows (or specific data values) in a dataset. This is often done to clean up the data, ensuring that only unique values are retained, which helps in accurate analysis and reporting. When you remove duplicates, Excel scans the selected data range and identifies identical entries (based on the columns you choose) and removes the extra occurrences, leaving only one instance of each unique value. For example: In a dataset of sales transactions, if the same sale is accidentally recorded twice, removing duplicates would eliminate the repeated entry, leaving only one record of the transaction. This process is helpful in cases where data is entered multiple times, whether by mistake or due to import errors, and you need to ensure each entry is counted only once. To remove dupl...