Microsoft%20Excel%20Interview%20Questions%20and%20Answers
Question: What is the "What If" condition in excel formulas?Answer:The “What If” condition is used to change the data in Microsoft excel formulas to give different answers. Example: You are buying a new car and want to calculate the exact amount of tax that will be levied on it then you can use the “What If” function. For instance there is three cells A4,B4 and C4. First cell says about the amount, second cell will tell about the percentage (7.5%) of tax and final cell will calculate the exact amount of tax. |
Is it helpful?
Yes
No
Most helpful rated by users:
- What is Microsoft Excel?
- What is ribbon?
- How can I hide or show the ribbon?
- How can you wrap the text within a cell?
- Is it possible to prevent someone from copying the cell from your worksheet?