Microsoft Excel:What If Analysis and printing review

1. Which statement best describes an Excel What-If Analysis Goal Seeking? 

• A. Allows you to define output results and then shows what input values are needed to generate that result. 
• B. Allows you to investigate how changes to one or two input variables in a formula changes output results 
• C. Allows you to define input variables in various situations. The output result for each situation is show in a summary table.

2. Which statement best describes the What-if Analysis Data Table tool? 

• A. Allows you to define output results and then shows what input values are needed to generate that result. 
• B. Allows you to investigate how changes to one or two input variables in a formula changes output results. 
• C. Allows you to define input variables in various situations. The output result for each situation is show in a summary table.

3. How can you access the hide/unhide command for a group of selected cells? 

• A. Right click on the selected cells 
• B. Click the Page Layout tab 
• C. Press the Ctrl-Delete keys 
• D. Click the Data tab 

4. Which of the following is NOT an example of a what-if analysis? 

• A. Find the how raises will affect employee salaries 
• B. Find the five top sales people in a company 
• C. Find the business profits for different levels of sales 
• D. Find the loan payments based for different interest rates 

5. If you had a worksheet with 46 rows and 3 columns of data, what would probably be the best page orientation for the worksheet?

• Landscape 
• Portrait 

6. If you wanted to do an Excel What-If Analysis of a system with eight different inputs which tool would you use?

• A. Scenario 
• B. Data Table 
• C. Goal Seeking 

7. Which of the following DOES NOT have to be considered when looking at the page layout before printing a worksheet? 

• margins 
• Page breaks
• Formulas 
•  Page orientation

8. 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.

• A. Goal Seeking
• B. Data Table 
• C. Scenario 

9. What is the best View for planning how your Excel worksheet data fits on a page? 

• A. Full Screen 
• B. Page Break Preview 
• C. Page Layout 
• D. Normal 

10. Which What-If Analysis tool would you use to solve the following problem? You want to find out what interest rate you have to get in order to keep your house payment under $1200 a month. 

• A. Goal Seeking 
• B. Data Table 
• C. Scenario