1. #####--symbol in cell to show that the value is too long to display
|
| 2. AUTOFIT--feature that widens the columns to fit the data; do this by double-clicking |
| 3. PAGE BREAK--location on the page where one page ends and another begins |
| 4. BORDER--term for the edge of a cell or range of cells |
| 5. NEGATIVE NUMBERS--numbers that can show up with parantheses, minus signs, or in red |
6. AUTOFILTER--feature that will hide a list of itmes that do not meet the criteria you set and only displays the items you want to see
|
| 7. BUDGET--an analysis of the projected income and expenses for a future period |
| 8. RELATIVE REFERENCE--reference that when copied will change to the new location |
| 9. GROUP SHEETS--way to copy to more than one worksheet at a time |
| 10. HTML--hypertext Markup Language |
| 11. ' (apostrophe)--this symbol typed before a number will turn it into a label |
| 12. RATE--in a financial formula means interest rate per period |
| 13. PV--in a financial formula means present value or principal of loan |
| 14. REVENUE--also income, will vary depending on many factors |
| 15. PASTE SPECIAL--way to copy specific cell content |
| 16. FV--terms for future value in a financial formula |
| 17. NPER--in a financial formula means number of payments |
| 18.PMT FUNCTION--function to calculate a loan payment based on the principal, interest rate, and number of payments |
| 19. FINANCIAL FUNCTIONS--functions used to analyze loans, calculate payments and compute depreciation |
| 20. SERIAL VALUE--term for the numeric value of a date |
| 21. ABSOLUTE REFERENCE--reference that must remain constant; use a $ before column and row reference |
| 22. NUMERIC LABEL--value or number that is not used for calculations |
| 23. WEB PAGE--location on an Internet server identified by a Web address |
| 24. INCOME STATEMENT--document at end of year reporting income, expenses, and profits |
| 25. QUARTERLY--every three months |