1 / 18

Spreadsheets

Spreadsheets. CIL 102 ‘08 Fall. Basic Concepts. Cell Column Letter A..Z,AA..AZ,BA… Row number Cell Address AlphaNumeric, C55 Labels Values Formulas. Navigation Arrow keys Use of cntl Use of End key Home F keys F4 and addressing. Cell Address: Combination of a Column letter

tilly
Download Presentation

Spreadsheets

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Spreadsheets CIL 102 ‘08 Fall

  2. Basic Concepts • Cell • Column Letter A..Z,AA..AZ,BA… • Row number • Cell Address AlphaNumeric, C55 • Labels • Values • Formulas • Navigation • Arrow keys • Use of cntl • Use of End key • Home • F keys • F4 and addressing

  3. Cell Address: Combination of a • Column letter • Row Number

  4. Labels, Values • Contents of a cell • Labels • Values • Formulas

  5. Typing Formulas • Let the system help you insert your formula • First insert sample values before constructing the formula. • Never type in a cell address, point to the cell • Start with the cursor in the cell where the formula belongs. • Press “=“ to start

  6. Typing Formulas • Know your formula 2*(l + w) • After “=“ start typing. • To insert a value, point to it and the system fills in the address.

  7. Typing Formulas • Complete the formula • Each time you must reference a cell, point to it. Note how each reference is highlighted • Complete the formula

  8. Typing Formulas • Change values • The formula recalculates

  9. Built-in Functions • Categories • Autosum • Recent • Financial • Logical • Text • Date/Time • Look-up/Reference • Math • Misc • Browse Category • Mnemonic Names • Name hints at formula • Hover over formula and read description

  10. Loan Payment • Given • Amount of the loan • A.P.R. • No. of Pay Periods • Installment • Use built in formulas • Locate category • Browse for formula • Financial Category • Browse Category • Look for a function whose description makes sense

  11. Loan Calculator • Given • Amount of the loan • A.P.R. • No. of Pay Periods • Installment • Use built in formulas • Locate category • Browse for formula • PMT look good

  12. Loan Calculator • Place cursor • Select function

  13. Loan Calculator • Place cursor in each text box • Read description

  14. Loan Calculator • Place cursor in each text box • Read description

  15. Loan Calculator • Obvious • Nper: ow long • Pv: Amount of loan • Calculation • Rate: Relation between APR and no of periods per year, …/12 • Need to think • Fv: =0 • Type: First payment • Immediate = 1 • One period later = 0

  16. Loan Calculator

  17. Loan Calculator • Look at the result! • Why the “-” sign? • Flow of funds + is one direction (in this case, towards you) - is the opposite direction (away from you)

  18. Loan Calculator • Change values and this becomes a • Car loan calculator • Home mortgage calculator • Any loan with a fixed rate, fixed time frame, and fixed payment • E.g. car loan of 25K at 6% for 4 years.

More Related