Welcome Spring!
This week we are working on Excel!
The vocabulary words will be posted on the Vocabulary page... you may recognize some of them from previous vocabulary lessons...
Please copy and paste your definitions...making sure they are correct for use with computer and for Excel use. You do not have to type in twice, but I do want you to have the definitions together this week.
The first lesson in Excel will be to open the program, making sure it is a blank spreadsheet.
This is going to be a real, working budget. Tuesday, you will start the spreadsheet, having a heading, columns and rows denoting date, bills, and your actual budget.
DO NOT put any information, such as your full name, social security or any credit card numbers on this sheet... DO NOT!
I guard your flash drives, the same as I guard my own, but there is always the possibility of them being lost. NEVER put any critical, identifying information on your flash drive.
You will save your worksheet to the flash drive and turn in at the end of the period. Wednesday, you will have a list of bills that you owe, a list of money you have to use, and an idea of how much you need to save each month. You will add these to the Excel sheet
Wednesday, you will complete the spreadsheet, save it to your flash drive. Turn in.
Remember the tabs are essential in creating the worksheet. Using the Formula Tab, the 'Auto Sum' button is your best friend! We will add all of Column D and have the total at the end of the column, then total all of Column H at the end of the column. Using Auto Sum, choose Sum from the dropdown box. This will automatically show the list of your column, click enter, it will automatically add the amounts. Do this for each of the columns of numbers.
in Column H, Row 10, you will use the formula =H?-D? and enter... in place of the ? you will add the row number. This will give you the amount of your income minus your monthly bills. In this way, you will see if you have anything left over or if you are "in the red".
Remember we discussed using averaging for bills that vary from month to month. Showing this on the budget is a good idea, also showing the amounts that are static, ie. mortgage, homeowners insurance, car payments, car insurance, etc are a good idea.
You can choose cells that you want to add together, separate from the others and show them by using the formula sum=(D?,D?) and enter, this will allow those two or three amounts to be added separate from the other rows to show how much you must have to be able to meet payments.
Thursday, we will have a short Quizziz over the vocabulary words that pertain to Excel.
This week we are working on Excel!
The vocabulary words will be posted on the Vocabulary page... you may recognize some of them from previous vocabulary lessons...
Please copy and paste your definitions...making sure they are correct for use with computer and for Excel use. You do not have to type in twice, but I do want you to have the definitions together this week.
The first lesson in Excel will be to open the program, making sure it is a blank spreadsheet.
This is going to be a real, working budget. Tuesday, you will start the spreadsheet, having a heading, columns and rows denoting date, bills, and your actual budget.
DO NOT put any information, such as your full name, social security or any credit card numbers on this sheet... DO NOT!
I guard your flash drives, the same as I guard my own, but there is always the possibility of them being lost. NEVER put any critical, identifying information on your flash drive.
You will save your worksheet to the flash drive and turn in at the end of the period. Wednesday, you will have a list of bills that you owe, a list of money you have to use, and an idea of how much you need to save each month. You will add these to the Excel sheet
Wednesday, you will complete the spreadsheet, save it to your flash drive. Turn in.
Remember the tabs are essential in creating the worksheet. Using the Formula Tab, the 'Auto Sum' button is your best friend! We will add all of Column D and have the total at the end of the column, then total all of Column H at the end of the column. Using Auto Sum, choose Sum from the dropdown box. This will automatically show the list of your column, click enter, it will automatically add the amounts. Do this for each of the columns of numbers.
in Column H, Row 10, you will use the formula =H?-D? and enter... in place of the ? you will add the row number. This will give you the amount of your income minus your monthly bills. In this way, you will see if you have anything left over or if you are "in the red".
Remember we discussed using averaging for bills that vary from month to month. Showing this on the budget is a good idea, also showing the amounts that are static, ie. mortgage, homeowners insurance, car payments, car insurance, etc are a good idea.
You can choose cells that you want to add together, separate from the others and show them by using the formula sum=(D?,D?) and enter, this will allow those two or three amounts to be added separate from the other rows to show how much you must have to be able to meet payments.
Thursday, we will have a short Quizziz over the vocabulary words that pertain to Excel.
No comments:
Post a Comment
Please leave a comment. All comment will appear shortly after review by a moderator.