Today's Assignments:
1. Continue working on the Budeting Assignment (see link below) to create a budget using Google Sheets. Complete page 2 & 3,
2. Create a google slides spreadsheet. Enter the figures from your Budget packet into your google sheets budget file like the example on page three.
3. Open a blank file in Google Sheets.
- Name your budget Budget for "Your Name"
- Create a field for gross income, net income, and list a column for each payperiod.
-
Create column headings for fixed expenses, variable expenses, total Expenses, savings, and spending on wants.
Google Sheets Tips::
Adding, subtracting, multipication, or division of two different cells
= Cell name + Cell name
= cell name * cell name
= cell name / cell name
= cell name - cell name
Adding, subtracting, multipication, or division of one cell by a number
= Cell name + 2 adds =C12+2
= cell name * 2 multiplies =C12* 2
= cell name / 2 divides by =C12/2
= cell name - 2 subtracts 2 =C12-2
All formulas begin with an equal sign and no spaces between.
Example: =A12+A13
Adding Several Fields at once::
-enter equal sign followed by Sum, followed by a parenthesis, first cell name, followed by a colon, then last cell name followed by a parenthesis. See example: This will add all up for you.
=sum(A12:A20) |
