Question

If the price of 100 bags of rice is 4000 rs. When Quantity is 100 unit. Find out net worth. And if price change 7000,10000,15000, 20000 and quantity change 200, 300, 400, 500. solve it in excel sheet by applying "WHAT IF ANALYSIS" (Data table).

Mention steps and with output

IT subject​

Answer 1

Answer:

pooohggddsshjbesfhhgffdsshvzi

Answer 2

Given,

The price of 100 bags of rice is 4000 rs

Quantity is 100 unit

To find,

net worth if price change 7000,10000,15000, 20000 and quantity change 200, 300, 400, 500.

Solution

1. We use the WHAT IF ANALYSIS tab after putting data in.

2. We then use a formula

3. Go to the "Data" tab on the ribbon

4. Select "What If Analysis" then select what is needed

5. Done