Assignment 9

 

    • input variables and see the results.

4. Create the Data Table

  • For a One-Variable Table:

    1. Select the range of cells, including the sales, product and the cell with the formula.


    2. Go to the Data tab.
    3. Under the What-If Analysis group, click on Data Table.



    4. 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.

Comments

Post a Comment

Popular posts from this blog

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