Excel 2003For Introductory Computer courses in Microsoft Office 2003 or courses in Computer Concepts with a lab component for Microsoft Office 2003 applications.
|
From inside the book
Results 1-3 of 36
Page 361
Robert T. Grauer, Maryann Barber. practice exercises 6. Consumer Loans : The worksheet in Figure 7.22 displays selected loans ( those with a loan type of " A " ) from a comprehensive set of loan records . Your assignment is to open the ...
Robert T. Grauer, Maryann Barber. practice exercises 6. Consumer Loans : The worksheet in Figure 7.22 displays selected loans ( those with a loan type of " A " ) from a comprehensive set of loan records . Your assignment is to open the ...
Page 433
... loan , for example , requires 360 payments , whereas a 15 - year loan takes only 180. Data validation is also built into the worksheet . For example , the worksheet will reject any loans greater than 30 years or any loans with ...
... loan , for example , requires 360 payments , whereas a 15 - year loan takes only 180. Data validation is also built into the worksheet . For example , the worksheet will reject any loans greater than 30 years or any loans with ...
Page 434
... Loan Parameters as Indicated Principal Annual Interest Date of First Payment Term of Loan ( years ) Extra Payment Every Period Your Instructor's Last Name Your Last Name $ 100,000 7.00 % 3/16/2003 Loan Summary Information Monthly ...
... Loan Parameters as Indicated Principal Annual Interest Date of First Payment Term of Loan ( years ) Extra Payment Every Period Your Instructor's Last Name Your Last Name $ 100,000 7.00 % 3/16/2003 Loan Summary Information Monthly ...
Common terms and phrases
Add-Ins Window Help Amortization Schedule ApplicationTitle Atlanta Chicago Account Rep Click and drag Click in cell Click OK column command button copy create criteria range Data Window Help database Delete dialog box drag to select Edit View Insert End Sub event procedure executed Exercise 2 continued Extra Payment File Edit View Format Debug Run Format Iools Data Hands-on Exercise Insert Format Debug Insert Format Iools Iools Data Window keyboard shortcut loan loop macro recorder Manager menu and click Microsoft Access Microsoft Excel Microsoft Visual Basic MsgBox statement Name Goes Options password Pivot Chart pivot table Print Product Pull Qtr 1 Qtr question for help Salary Save the workbook Scenario sheet Sheet1 shown in Figure Solution File Edit step summary workbook summary worksheet Switchboard ThisWorkbook toolbar Tools menu Total Type a question VBA editor VBA procedure VBAProject View Insert Format worksheet tab