NEW
Font size
WorksheetsExcel Quiz
Total questions: 10
Worksheet time: 14mins
Suppose the formula =D7+F8/G8-H5+2 is in cell D10. Which is the best method to work out the value required in F8 to get a value of 850 from the formula?
Use Goal Seek to set D10 to 850 by changing F8
Use Goal Seek to set F8 to 850 by changing D10
Use the Scenario manager to place 850 in D10
Don’t know
Suppose the formula =D7+F8/G8-H5+2 is in cell D10, and you want to review the potential outcomes where F8 is equal to 45, 85 and 97. Which is the best method or tool to be able to call up each option quickly?
Scenario Manager
Manually changing the values and printing the results
Goal Seek
Don’t know
When working with the Scenario Manager, in order to preserve the original information, it's best to ...
Set up a Goal Seek to find out the original values needed
Save the workbook so you can toss it away and restore the original values
Create a base case Scenario first to allow you to reset to the original values
Don’t know
Where is the Goal Seek function located?
Under the Goal tab on the Ribbon.
Under the Data tab on the Ribbon.
Under the Formulas tab on the Ribbon.
Under the Insert tab on the Ribbon.
Which What-If Analysis tool would you use to solve the following problem? You want to figure out how to keep a car loan under $400 a month.
Goal Seeking
Data Table
Scenario
Excel is a good application for What IF analysis. Which of the following tool help you for this?
Formula Editing
Research
Track Change
Goal Seek
Which of the following is not What IF analysis tool in Excel?
Goal Seek
Scenarios
Macros
None of above
In order to arrange the countries from those with the highest population to those with the lowest, you need to sort on the population field in ……………
Ascending order
Descending order
Alphabetical order
Random order
Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?
Logical
Math & Trigonometry
Statistical
Financial
How do you rearrange the data in ascending or descending order?
Data, Sort
Data, Form
Data, Table
Data Subtotals
