MNSC 341 HOMEWORK ASSIGNMENT 3
(Excel Project 4)
Due Date: Submit it along with Lab Assignment 3
Part 1: (30points) Answer to all questions of “Apply Your Knowledge 1 : Understanding the IF Function and Absolute Referencing” from your textbook (page E3.69). Copy the page and write your answers on that copy and submit.
Part2: (10points)
Multiple Choice, True/False, and Fill-up the blanks questions
1.In the accompanying figure, the amortization schedule ______.
a. provides general, basic information about the loan
b. answers 11 different what-if questions pertaining to the effect of interest rates
c. connects to other Office documents or HTML files
d. shows the beginning and ending balances and the amount of payment that applies to the principal and interest over a period of time
2.To control the color and thickness of an outline and border, use the Border tab in the ______dialog box.
a. Pick From Listb. Insert Commentc. Format Cellsd. Clear Contents
3.Down Pymt is written as the name ______when referencing the adjacent cell.
a. down pymtb. down_pymtc. down-pymtd. down*pymt
4.The general form of the PMT function is ______.
a. =PMT(rate, payment, loan amount)b. =PMT(payment, loan amount, rate)
c. =PMT(loan amount, rate, payment)d. =PMT(rate, loan amount, payment)
5.Labels are different from names in all of the following ways except ______.
a. labels are not absoluteb. labels show up in the Names box
b. labels cannot be used on other worksheets in the workbook
c. labels can be used without entering underscores in place of spaces
6.The FV function is one of the more often used financial functions that returns the future value of an investment based on ______.
a. periodic, constant payments and a constant interest rate
b. sporadic, inconsistent payments and a constant interest rate
c. periodic, varying payments and a varying interest rate
d. sporadic, inconsistent payments and a varying interest rate
7.To define a selected range as a Data table, click ______on the menu bar and then point to Table.
a. Insertb. Formatc. Datad. Edit
8.Analysts often look for the row in the data table that agrees with the ______.
a. input cell namesb. input cell resultsc. output cell namesd. output cell results
9.When a formula is entered in a cell, Excel assigns the cell the ______.
a. Currency style formatb. same format as the first cell reference in the formula
b. Comma style formatd. same format as the last cell reference in the formula
10.With Excel, hyperlinks easily can be created to ______.
a. other files on a personal computerb. an intranet
b. the World Wide Webd. all of the above
11.Cells should be protected only ______.
a. before the worksheet has been fully tested and displays incorrect results
b. before the worksheet has been fully tested and displays the correct results
c. after the worksheet has been fully tested and displays incorrect results
d. after the worksheet has been fully tested and displays the correct results
12.To determine the down payment for a specific monthly payment using the Goal Seek command, click ______on the menu bar and then click Goal Seek.
a. Windowb. Toolsc. Filed. Insert
13.Two of the more powerful aspects of Excel are its wide array of functions and its capability of organizing answers to what-if questions.
a.Trueb. false
14.Using a column as a separator between sections on a worksheet is a common technique used by spreadsheet specialists.
a.Trueb. false
15.While cells usually are formatted after values are entered, Excel also allows cells to be formatted before values are entered.
a.Trueb. false
16.If a percent sign (%) is appended to 8.25 when it is entered into a cell, Excel automatically formats the number to the Percent style with no decimal places.
a.Trueb. false
17.To select a cell that has been assigned a name, click the Name box arrow and then click the name of the cell to be selected.
a.Trueb. false
18.To activate label usage, click Insert on the menu bar, click Object, click the Calculation tab, and select Accept labels in formulas.
a.Trueb. false
19.Excel provides more than 50 financial functions that can help solve the most complex financial problems.
a.Trueb. false
20.In a one-input data table, the values in one or more cells can vary and Excel then calculates the results of one formula and displays the result.
a.Trueb. false
21.When defining a range as a data table, the section title and column headings are part of the data table because they identify the data table and columns in the table.
a.Trueb. false
22.To add additional formulas to a one-input data table, enter them in adjacent cells in the same row as the current formulas and define the entire new range as a data table by using the Table command on the Data menu.
a.Trueb. false
23.In a function, dollar signs within cell references indicate the cell reference is relative and, therefore, will change as the function is copied.
a.Trueb. false
24.The Comma Style button on the Formatting toolbar uses the digit 0 to represent zero.
a.Trueb. false
25.When building a worksheet for novice users, cells in the worksheet that should not be changed should be left unprotected, such as cells that contain text and formulas.
a.Trueb. false
26.If a cell is protected and the worksheet user attempts to change its value, Excel displays a dialog box with a message indicating the cells are protected.
a.Trueb. false
27.To change the font style of an entire worksheet to bold, double-click the move handle on the Formatting toolbar, click the ______button, and then click the Bold button on the Formatting toolbar.
28.To assign a name that is not a text item in an adjacent cell, use the ______on the Name submenu.
29.Excel's ______is a function that can be used to determine the monthly payment for a loan.
30.The major drawback to using labels in some applications is that they are ______, which means the label may very well reference a cell that is nonadjacent to the label.
31.A(n) ______is a range of cells that shows the answers generated by formulas in which different values have been substituted.
32.A(n) ______allows the values of two cells to vary, but it can be applied to only one formula in the data table.
33.Use the ______on the Data menu to define a range as a data table.
34.A(n) ______is a series of fixed payments (such as the monthly payment in cell E4 in the accompanying figure) made at the end of a fixed number of terms at a fixed interest rate.
35.A(n) ______can be inserted, such as clip art, or drawn and then made into a hyperlink.
36.______are cells whose values can be changed at any time.
37.To change cells in a protected worksheet, point to Protection on the Tools menu and then click ______.
38.A(n) ______can be created when a user wants to keep others from changing a worksheet from protected to unprotected.
39.To protect a worksheet, click Tools on the menu bar, point to Protection, and then click Protect sheet on the ______.
40.The ______on the Tools menu can be used to determine what value is needed to produce a required result.
Srayf02/MNSC240 HomeWork Assign.3 Page 1 Version 1