ExcelChapter4 - Microsoft Office 2007 Excel Chapter 4...

Info iconThis preview shows pages 1–8. Sign up to view the full content.

View Full Document Right Arrow Icon
Microsoft Office 2007 Excel Chapter 4 Financial Functions, Data Tables, and Amortization
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Objectives Control the color and thickness of outlines and borders Assign a name to a cell and refer to the cell in a formula using the assigned name Determine the monthly payment of a loan using the financial function PMT Use the financial functions PV (present value) and FV (future value) Create a data table to analyze data in a worksheet Add a pointer to a data table Create an amortization schedule Microsoft Office 2007: Complete Concepts and Techniques - Windows Vista 2
Background image of page 2
Objectives Analyze worksheet data by changing values Use names and the Set Print Area command to print sections of a worksheet Set print options Protect and unprotect cells in a worksheet Use the formula checking features of Excel Hide and unhide cell gridlines, rows, columns, sheets, and workbooks Microsoft Office 2007: Complete Concepts and Techniques - Windows Vista 3
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Plan Ahead Create and format the Loan Payment Calculator section of the worksheet Create and format the Interest Rate Schedule section of the worksheet Create and format the Amortization Schedule section of the worksheet Specify and name print areas of the worksheet. Determine which cells to protect and unprotect in the worksheet Microsoft Office 2007: Complete Concepts and Techniques - Windows Vista 4
Background image of page 4
Starting and Customizing Excel Click the Start button on the Windows Vista taskbar to display the Start menu Click All Programs at the bottom of the left pane on the Start menu to display the All Programs list Click Microsoft Office in the All Programs list to display the Microsoft Office list. Click Microsoft Office Excel 2007 to start Excel and display a blank worksheet in the Excel window If the Excel window is not maximized, click the Maximize button next to the Close button on its title bar to maximize the window If the worksheet window in Excel is not maximized, click the Maximize button next to the Close button on its title bar to maximize the worksheet window within Excel Microsoft Office 2007: Complete Concepts and Techniques - Windows Vista 5
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Bolding the Entire Worksheet Click the Select All button immediately above row heading 1 and to the left of column heading A Click the Bold button on the Home tab on the Ribbon Microsoft Office 2007: Complete Concepts and Techniques - Windows Vista 6
Background image of page 6
Entering the Section Title, Row Titles, System Date, Document Properties and Saving the Workshop Select cell B1. Enter Loan Payment Calculator as the section title. Select the range B1:E1. Click the Merge & Center button on the Ribbon With cell B1 active, click the Cell Styles button on the Ribbon and then select the Title cell style in the Cell Styles gallery Position the mouse pointer on the bottom boundary of row heading 1. Drag down until the ScreenTip indicates Height: 23.25 (31 pixels). Position the mouse pointer on the bottom
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 8
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 03/27/2012 for the course MISY 2305 taught by Professor Staff during the Spring '08 term at Texas A&M University, Corpus Christi.

Page1 / 81

ExcelChapter4 - Microsoft Office 2007 Excel Chapter 4...

This preview shows document pages 1 - 8. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online