answer questions 1-10
Bank docx M Accounting gunistinwimberly x C John Williams (age 42) Is A Gin x swebdav/pid-1344419-dt-content-rid-21247645_1/courses/ACCT1120_202012_CR_10079/ACCT11: BIU A . A . Create Financial Functions 1. The Nper function is used to calculate the amount of each payment required to pay off a loan. A. True B. False 2. Which of the following is a type of financial calculation available in Excel? A Calculating your monthly payment on a loan or mortgage B. Finding how much an investment will be worth in the future C. Finding how long it will take to pay off a debt D. All of these options 3. Vicente is working on a spreadsheet to track how much an investment opportunity he is considering will be worth in 20 years. Which of the following Excel financial functions will provide the information Vicente is looking for? A. Nper B. Pmt C. FV D. Rate E. PVTestBlank docx M Accounting - qunishawinibarely x C John Williams (age 42) is A Sin x 6 0 bbeswebdav/pid-1344419-dt-content-rid-21247645_1/courses/ACCT1120_202012_CR_10079/ACCT112 A . A . E. PV 4. Because interest rates for loans are quoted as annual rates but payments are made monthly, you should divide the interest rate in the formula by which of the following? A. The number of weeks in a year Excel 2016 Page 1 of 3 Test Bank A. The number of months in a year B. The number of years in the loan C. None of these options 9 M hpwebdaw/pid-1344419-dt-content-rid-21247645_1/courses/ACCT1120_202012_CR_10079/ACCT1120 A. A. 5. Match the following financial functions with their descriptions. A Nper 1. The loan amount or initial amount invested B. Pit 2. Number of payment periods over the life of the loan or C. Pv - investment D. Rate 3. The ending balance E. FV 4. The payment made on the loan 5. The interest per payment period Create One-Variable and Two-Variable Data Tables 6. A Data Table, like a normal table, allows the user to sort and filter data. A True B. False 7. In a two-variable Data Table, you create a formula that includes references to two input cells outside the data table. A. True B. False 8. In a one-variable Data Table, when using a row input cell. the formula must be where? A. The first cell at the left of the row hpwebdav/pid-1344419-dt-content-rid-21247645_1/courses/ACCT1120_202012_CR_10079/ACCT11 B A . A - TE 8. In a one-variable Data Table, when using a row input cell, the formula must be where? A. The first cell at the left of the row B. The first cell at the top of the column C. The last cell at the right of the row D. The last cell at the bottom of the column 9. Match these data table-related terms to their descriptions: A. Data Table Has both a row and column of input values One variable Allows the user to insert multiple different value Data Table replace an argument in a formula C. Two-variable Has either a row or column of input values Data Table Use What-If Analysis Tools to Create Scenarios 10. With the Scenario Manager, you can use up to 32 variables. A. True Excel 2016 Page 3 of 3 9 M hp
