Nothing Special   »   [go: up one dir, main page]
Scribd Logo
Upload

Welcome to Scribd!

  • 3 views

    SC FIM 6e Chapter 18

    Uploaded by

    shironz

    Copyright:

    © All Rights Reserved
    Download as XLS, PDF, TXT or read online from Scribd

    SC FIM 6e Chapter 18

    Uploaded by

    shironz
    3 views5 pages

    Original Title

    SC_FIM_6e_Chapter_18

    Copyright

    © © All Rights Reserved

    Available Formats

    XLS, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as XLS, PDF, TXT or read online from Scribd
    Download as xls, pdf, or txt
    3 views5 pages

    SC FIM 6e Chapter 18

    Uploaded by

    shironz

    Copyright:

    © All Rights Reserved
    Download as XLS, PDF, TXT or read online from Scribd
    Download as xls, pdf, or txt
    of 5

    Financial Markets and Institutions

    Spreadsheet Templates
    MAIN MENU -- Chapter 18

    Instructions Problem 4

    Help Topics Problem 5

    Copyright © 2015 McGraw-Hill Education

    Copyright © 2004 McGraw-Hill/Irwin


    Financial Markets and Institutions Main Menu

    Instructions

    Navigating the Workbook


    Entering your information
    Entering data
    Printing

    Navigating the Workbook Top

    Each chapter of the spreadsheets to accompany Financial Markets and Institutions


    contains links to help you navigate the workbook. These hyperlinks help you
    move around the workbook quickly. The Main Menu contains links to each
    problem from the chapter that contains the Excel icon. From the Main Menu,
    click on the question you wish to complete. You can always return to the main
    menu by clicking on the link located in the upper right corner of each worksheet.

    You can move quickly around an Excel workbook by selecting the worksheet tab
    at the bottom of the screen. Each worksheet in an Excel workbook will have its own
    tab. In the spreadsheets to accompany Financial Markets and Institutions, you will
    see a separate tab for each problem, along with the Main Menu, Instructions and
    Help Topics worksheets.

    Another way to move quickly around an Excel workbook is by using the following
    keyboard shortcuts:
    CTRL+PAGE DOWN: Moves you to the next sheet in the workbook.
    CTRL+PAGE UP: Moves you to the previous sheet in the workbook.

    Entering your information Top

    For each question, you will see the following lists and boxes:

    Student Name:
    Course Name:
    Student ID:
    Course Number:

    Enter your information in these cells before submitting your work.

    Entering data Top

    To enter numbers or text for these questions, click the cell you want, type the data and
    press ENTER or TAB. Press ENTER to move down the column or TAB to move across the row.

    For cells or columns where you want to enter text, select “Format,” and then “Cells” from
    Excel’s main menu at the top of your screen. Select the “Number” tab and then “Text”
    from the category list.

    Printing Top

    To print your work, select "File," and then "Print Preview" from Excel’s main menu at the top
    of your screen. The print area for each question has been set, but be sure to review
    the look of your print job. If you need to make any changes, select “Setup” when
    you are previewing the document.

    Copyright © 2005 McGraw-Hill/Irwin


    Financial Markets and Institutions Main Menu

    Help Topics

    ENTERING FORMULAS IN EXCEL Top


    Select the cell in which you want to enter the formula and type an equal sign.
    Enter the formula using standard formula operators such as plus (+) and minus (-). For multiplication use (*).
    Use a forward slash (/) for division; and the caret (^) for exponents.

    You control the order of calculation by using parentheses to group operations that should be performed first.

    One of the best uses of formulas is a reference to another cell. The cell that contains the formula is known
    as a dependent cell when its value depends on the values in other cells.
    For example, the formula in the cell below calculates a value depending on what is entered in the cell to its right.
    25 50

    Copyright © 2005 McGraw-Hill/Irwin


    Chapter 18
    Problem 4: Using a Spreadsheet to Calculate Pension Benefit Payments (LG 18-2)

    Student Name:
    Course Name:
    Student ID:
    Course Number:

    Select the red highlighted items below for tips and suggestions to complete this problem.

    Average => Annual


    Retire Salary Payment
    now FORMULA = FORMULA For help with entering form
    in 2 years =
    in 5 years =
    in 8 years =
    in 10 years =

    Copyright © 2005 McGraw-Hill/Irwin


    Chapter 18
    Problem 5: Using a Spreadsheet to Calculate Pension Benefit Payments (LG 18-2)

    Student Name:
    Course Name:
    Student ID:
    Course Number:

    Select the red highlighted items below for tips and suggestions to complete this problem.

    Average => Annual


    Retire Salary Payment
    now $50,000 = FORMULA For help with entering form
    in 2 years $51,005 =
    in 5 years $52,551 =
    in 8 years $54,143 =
    in 10 years $55,231 =

    Copyright © 2006 McGraw-Hill/Irwin

    You might also like