Which is used to perform what if analysis?
Home | Discussion ForumFree Online Test
Which is used to perform what if analysis?
Solver
Goal seek
Scenario Manager
All of above
Answer : D
Free Online Test
View More Related Question
1) To create a formula, you can use:
Values but not cell references
Cell references but not values
Values or cell references although not both at the same time
Value and cell references
View Answer
2) The Delete key of keyboard is assigned to which command in Excel?
3) Which of the following is not an example of a value?
4) When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply
Use =if() function to format the required numbers red
Apply Conditional Formatting command on Format menu
Select the cells that contain number between 0 and 100 then click Red color on Text Color tool
All of above
View Answer
5) To copy formatting from one area in a worksheet and apply it to another area you would use:
The Edit>Copy Format and Edit>Paste Format commands form the menu.
The Copy and Apply Formatting dialog box, located under the Format>Copy and Apply menu.
There is no way to copy and apply formatting in Excel – You have to do it manually
The Format Painter button on the standard toolbar
View Answer