1) What is a very efficient way to avoid large numbers of iterations? a) Present Value Calculation b) Results table c) Goal seek function d) Interest Rate 2) What is the common question posed to the controller? a) What if b) What Else c) What's That d) What Is It 3) The next step is to re-format cell B12 to identify it as ----- a) By Changing cell b) Goal c) Results Table d) Interest rate 4) This person typically models an answer based on a few discrete points in the equation and does so by manually coding a formula with an electronic spreadsheet? a) Financial Analyst b) Controller c) Accountant d) CEO 5) What should must place in top left corner of the results table? a) Present Value Result Cell b) Goal c) Results Table d) B12 6) What is the electronic spreadsheet that we used in this chapter? a) OneNote b) Word c) Excel d) Publisher 7) What is still present even if the words replaced by “interest rate”? a) Double Variable Calculations b) Present value c) Formula d) C8 8) What does the formula for Present Value calculation in excel? a) =PV(C4C5) b) =-PV(C4,C5,C6) c) Pv(C8,B12) d) =PV(C4,C5,C6) 9) It is listed down the left side of this grid, as was the case for the single variable calculation, while the number of possible periods is displayed in a row across the top of the grid. a) Possible Interest Rates b) Present Value Result Cell c) Interest Rate d) Goal seek function 10) What is the cell reference of C8? a) C5 b) C8 c) B12 d) C4 11) Who will find that simply copying a formula a number of times may be the most efficient way to complete a single variable table, rather than using the Data, Table command described in this chapter? a) Employee b) Manager c) Businessman d) Controller 12) If the larger number of possible answers in a double-variable scenario makes what calculations? a) Goal Seek b) Single Variable Calculations c) Double Variable Calculations d) Present Value 13) What does Excel’s Goal Seek function provides? a) Simple Solution b) Different Solution c) Present Value d) Interest Rate 14) What can you seen if you finish the goal seek table set-up? a) Rate b) Cell Reformatting c) Double Variable d) Goal Seek Status 15) _________ are listed down the left side of this grid a) Double Variable b) Possible interest rates c) Goal Seek Status d) Layout of a Single-Variable Table 16) What is the next step to identify it as “Interest Rate,” even while the underlying formula is still present? a) Click the Custom b) Replaced Cell B12 c) Select the “General” option under the Type heading d) Re-format Cell B12

RECITATION: Chapter 17

от
Внедрить

Таблица лидеров

Визуальный стиль

Параметры

Переключить шаблон

Восстановить автоматически сохраненное: ?