Spreadsheet+L+6




 * Lesson Six** **- Reinforcing Known Concepts**

Spreadsheets are used by everyday accountants and by the average Joe like you and I. Below you will find data relating to a student, Devon Konita, who wants to use a spreadsheet to create a budget while he obtains his Doctorate in Education at Princeton University. Put the following information into a spreadsheet and follow the instructions below. [|//(Click the table to enlarge)//] Lets review... Order of operations for Mathematics:
 * **To add cells** || **=sum(cell range)** ||
 * **To subtract cells** || **=dif(cell range)** ||
 * **To multiply cells** || **=(cell*cell)** ||
 * **To calculate the average** || **=average(cell range)** ||
 * **To change the cell attributes of a cell (currency, date, etc.)** || **right click on the cell, and select format cells** ||
 * B |||| Inside then outside brackets ||
 * E |||| Exponents ||
 * <span style="font-family: Arial, Helvetica, sans-serif">D || <span style="font-family: Arial, Helvetica, sans-serif">Division || <span style="font-family: Arial, Helvetica, sans-serif">from left to right ||
 * <span style="font-family: Arial, Helvetica, sans-serif">M || <span style="font-family: Arial, Helvetica, sans-serif">Multiplication ||^   ||
 * <span style="font-family: Arial, Helvetica, sans-serif">A || <span style="font-family: Arial, Helvetica, sans-serif">Addition || <span style="font-family: Arial, Helvetica, sans-serif">from left to right ||
 * <span style="font-family: Arial, Helvetica, sans-serif">S || <span style="font-family: Arial, Helvetica, sans-serif">Subtraction ||^   ||
 * <span style="font-family: Arial, Helvetica, sans-serif">Row 3 uses a date attribute
 * <span style="font-family: Arial, Helvetica, sans-serif">In row 9, enter formulas that use a function to calculate the total budgeted and actual income for each month.
 * <span style="font-family: Arial, Helvetica, sans-serif">In row 17, enter formulas that use a function to calculate the total budgeted and actual expenses for each month.
 * <span style="font-family: Arial, Helvetica, sans-serif">In cell A18, enter the label Budgeted Savings: and then right align it. Enter formulas that use cell references to calculate the budgeted savings for each month. Budgeted savings are calculated by subtracting the total budgeted expenses from the total budgeted income.
 * <span style="font-family: Arial, Helvetica, sans-serif">In cell A19, enter the label Actual Savings: and then right align it. Enter formulas that use cell references to calculate the actual savings for each month. Actual savings is calculated by subtracting the total actual expenses from the total actual income.
 * <span style="font-family: Arial, Helvetica, sans-serif">Italicize the titles in cells A18 and A19. Resize columns as necessary so all the data is displayed entirely.
 * <span style="font-family: Arial, Helvetica, sans-serif">All currency fields are set to
 * <span style="font-family: Arial, Helvetica, sans-serif">Pay close attention to the formatting of this sheet (**bold**, //Italics//, left and right justification)

<span style="font-family: Arial, Helvetica, sans-serif">*Hint - Don't do any formatting until you have entered all of the data. That applies to any assignment any time you are using a computer.