Principles of
Corporate Finance |
Tenth Edition |
| | | | | | | | | |
Instructions |
| | | | | | | | | |
| | | Navigating the Workbook | | | | | |
| | | Entering
your information | | | | | |
| | | Entering
data | | | | | |
| | | Printing | | | | | |
| | | Help | | | | | |
| | | | | | | | | |
| Navigating
the Workbook | | | | | | | |
| | | | | | | | | |
| Each chapter of the spreadsheets to accompany
Principles of Corporate Finance ; | | |
| 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 Principles of Corporate Finance, 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 | | | | | | | |
| | | | | | | | | |
| 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 | | | | | | | | |
| | | | | | | | | |
| 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 | | | | | | | | |
| | | | | | | | | |
| 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. ; | | | | | | |
| | | | | | | | | |
| Help | | | | | | | | |
| There are two sources of
help throughout these spreadsheet templates. ; ;
First, you will find comments | | |
| in specific cells
(highlighted in red) providing tips to what formula or function is needed to
complete ; | | |
| the problem. ; Second, you will find links to Microsoft
Office’s online help page when an Excel Function ; | | |
| is needed to complete the
problem. | | | | | | |