1 / 10

Excel Project 1

Excel Project 1. Step 1: Fill in the Cells in Column A from A1 to A10 with these categories:. Step 2: Expand Column A by double clicking the line between Column A and Column B.

nicholas-park
Download Presentation

Excel Project 1

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. Excel Project 1

  2. Step 1: Fill in the Cells in Column A from A1 to A10 with these categories:

  3. Step 2: Expand Column A by double clicking the line between Column A and Column B.

  4. Step 4: In Cell B2 you will write “Monthly Amount” and Double click the line between column B and C to expand the cell to make it visible. ”

  5. Step 3: Make the labels in Cells A1, A8, A9, A10 & B1 Bold. (Click cell first)

  6. Step 5: In column B just beside its corresponding label, you will but these amounts: • General Bills = $200 • Savings = $100 • Mortgage = $750 • Auto Payment = $350 • Phone = $80 • Grocery = $200 • Total Starting Budget = $2,000

  7. Step 6: Use the SUM function to determine what your total Monthly Expenses are in Cell B8. It is =SUM(Select cells then close the). Click Enter when done.

  8. Step 7: Find out the how much you have left over by creating a function in Cell B10. You will click Cell B10 and type “=” then click your Total Starting Budget amount, then “-”, and finally click your Total Expenses Monthly Expenses amount.

  9. Step 8: Have Mr. Reyes Review your Excel Spreadsheet and Initial Here:________________ (On your document)

  10. All other steps will be on your own.

More Related