ASSIGNMENT 9 Goal seek

-

 The data table in Excel can be used to change two variables. Users need to provide input variables. Excel returns the output based on the formula and variables given by the users.

Step 1: Create a table with various interest rates, as shown in the below image.In the NEXT cell 







Step 2: Select the newly created table. Go to the Data. Under the Forecast group, click on the What-If Analysis drop-down list and choose the Data Table.

what if analyis in excel example 3.3

Step 4: The Data Table window appears.



Step 5: In the Row input cell: box, we should choose the cell reference of tenure years, i.e., cell B3, since, in the newly created table, we have categorized the rows that indicate the tenure as years.



Similarly, in the Column input cell: we should choose the cell reference of interest rates, Again, it is because we have interest rates in a column in the newly arranged data table.


Click OK, and we will get different EMI amounts at different interest rates and different tenures, as shown in the image below:

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