Excel 2007 ® Business and Personal Finances

1. Excel 2007® Business and Personal Finances How can Excel 2007 help you create data and content in a worksheet?

2. Lesson 2: Create Data and Content Excel 2007 has many automated tools and commands that will help you create data and content in a worksheet.

3. Lesson 2: Create Data and Content View This Presentation to Answer the Following Questions: • How do I edit, find, and replace cell contents? • What are AutoSum, AVERAGE, MIN, and MAX? • How do I move and copy cells? • How do I delete a column or row? •How can I use the Fill handle tool? •Why should I insert a hyperlink? •What vocabulary words should I review?

4. Lesson 2: Create Data and Content A budget is an estimate of income and expenses over time. In a typical budget… expenses fill cells in the left column, and amounts occupy cells to the right.

5. Lesson 2: Create Data and Content Enter and edit data directly into any cell or can use the formula bar. Each cell in a worksheet can contain… words After you have keyed data into a cell, press Enter to move to the cell below. or numbers

6. Lesson 2: Create Data and Content To edit the contents of a cell, double-click the cell and insert the new data. You can also click a cell and edit the contents in the formula bar.

7. Lesson 2: Create Data and Content To clear, or empty, the contents of a cell, use the Clear Contents button. You can also press Delete to clear the contents of a cell.

8. Lesson 2: Create Data and Content If you want to replace the contents ofa cell with a different phrase or number, use the Find and Replace dialog box. Find and Replace will find all the cells that match the old content and replace it with new content.

9. Lesson 2: Create Data and Content AutoSum, AVERAGE, MIN, and MAX are built-in formulas called functions. Click the AutoSum drop-down arrow to access the AVERAGE, MAX, and MIN functions. The AutoSum function adds values in rows or columns.

10. Lesson 2: Create Data and Content The AVERAGE function finds the numeric average of a list of cells. The MAX function identifies the largest number in a group of selected cells. The MIN function identifies the smallest number in a group of selected cells.

11. Lesson 2: Create Data and Content To move and copy cells, use the Cut, Copy, and Paste commands. The Paste command pastes cells from the Clipboard to the worksheet. The Cut command cuts cells and places them on the Clipboard.

12. Lesson 2: Create Data and Content Instead of deleting the contents of a cell and rekeying them into a new place, you can simply move the cell. Select the cells you want to move, then click the edge and drag the cells to their new location.

13. Lesson 2: Create Data and Content Academic Skills Check How can a budget help you manage your money? Answer: A budget can help you manage your money by keeping track of your income and expenses, so you don’t spend money you don’t have.

14. Lesson 2: Create Data and Content Academic Skills Check How can identifying fixed costs help you estimate how much you might spend over a year? Answer: You can anticipate future costs by tracking past costs.

15. Lesson 2: Create Data and Content Tech Check What function adds the values in a worksheet’s row or column? Answer: The AutoSum function adds the values in a row or column.

16. Lesson 2: Create Data and Content Tech Check How do you find the numeric average of a list of cells? Answer: Use the AVERAGE function to find the numeric average of a list of cells.

17. Lesson 2: Create Data and Content To delete the contents of a row or column, select the row or column and press the Delete key. When you delete a row or column, both the contents of the cells and the cells themselves are removed from the worksheet.

18. Lesson 2: Create Data and Content You can also insert new rows and columns between existing rows and columns. Inserting new rows and columns allows you to add months or items to a budget.

19. Lesson 2: Create Data and Content Be careful when you insert or delete a cell. The cells around the inserted or deleted cell shift. The data may no longer line up with the column or row headings.

20. Lesson 2: Create Data and Content To copy one cell’s contents into several cells at once, use the Fill handle. Sometimes you may want to insert the same contents into many different cells. For example, a bill may cost the same every month, or you may want to copy a formula across multiple cells.

21. Lesson 2: Create Data and Content Add a hyperlinkto link related files so that you can easily access them. If a part of your worksheet references another file, you can insert a hyperlink that will open the file when you click a link in your worksheet.

22. Lesson 2: Create Data and Content Academic Skills Check What are some of the reasons you might need to add rows or cells to a budget? Answers may include: Insert rows or cells to a worksheet to add months and more expense and income items to a budget.

23. Lesson 2: Create Data and Content Tech Check What happens to surrounding cells when you delete an old cell or insert a new one? Answer: The cells around the inserted or deleted cell shift, so that data may no longer line up with column or row headings.

24. Lesson 2: Create Data and Content Tech Check How do you insert the same content across multiple cells? Answer: Use the Fill Handle to insert the same content across multiple cells.

25. Lesson 2: Create Data and Content Tech Check How do you make a part of your worksheet link to a related part in a different worksheet file? Answer: Insert a hyperlink that will open the file when you click on it.

26. Lesson 2: Create Data and Content Vocabulary Review function A built-in, or preset, formula that is used to solve an equation.

27. Lesson 2: Create Data and Content Vocabulary Review AutoSum A function used to add values in rows or columns.

28. Lesson 2: Create Data and Content Vocabulary Review MIN A function used to identify the smallest value in a group of cells.

29. Lesson 2: Create Data and Content Vocabulary Review MAX A function used to identify the largest value in a group of cells.

30. Lesson 2: Create Data and Content Vocabulary Review cut To remove data, usually for the purpose of pasting it somewhere else in a worksheet.

31. Lesson 2: Create Data and Content Vocabulary Review paste To place previously cut or copied text into a worksheet.

32. Lesson 2: Create Data and Content Vocabulary Review Clipboard Where cut or copied data is stored so that it can be copied into a different location in a worksheet.

33. Lesson 2: Create Data and Content Vocabulary Review hyperlink A link in a worksheet to a Web page or to a different worksheet in another file.