Assignment 6

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 :👇🏻👇🏻👇🏻👇🏻

Comments

Post a Comment

Popular posts from this blog

Assignment 9

Image
  input variables and see the results. 4.  Create the Data Table For a One-Variable Table : Select the range of cells, including the sales, product and the cell with the formula. Go to the  Data  tab. Under the  What-If Analysis  group, click on  Data Table . In the  Data Table  dialog box: For  Row Input Cell , leave it blank (since we are changing the values in the column). For  Column Input Cell , select the cell that contains the sales. 5.  View Results After you click  OK , Excel will calculate the results and fill in the data table. You can now see how the 3 month sales change for each combination of  product and cost.
Read more

Assignment 7

Image
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:
Read more

Assignment 3

  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...
Read more