What-If Analysis Quiz
Name:
*
First Name
Last Name
Email:
*
example@example.com
Spreadsheet ID:
*
Your spreadsheet ID is available in the StudentsExcel Portal: http://portal.studentsexcel.com/.
1. What 3 inputs are needed for the PMT (Payment) Function?
*
A. Interest, Loan, Payment
B. Interest, Term, Loan
C. Interest, Term, Payment
D. Term, Loan, Payment
2. Which function calculates the total interest between two periods?
*
A. CUMIPMT
B. CUMPRINC
C. IPMT
D. INT
3. How many fields can you store in a given scenario with Scenario Manager?
*
A. 8
B. 16
C. 32
D. 64
4. The Shapes command appears on which ribbon tab in Excel?
*
A. Data
B. Developer
C. Design
D. Insert
5. What is the Goal Seek feature used for?
*
A. Solving for an output in one cell by changing a single input cell
B. Solving for an output in one cell by changing multiple input cells
C. To search for a specific cell
D. To search for specific text in a spreadsheet
6. Which area of Excel's Options dialog box allows you to enable the Solver feature in Excel?
*
A. Formulas
B. Data
C. Advanced
D. Add-Ins
Calculation
Submit
Should be Empty: