Spreadsheets_Budget99

=Budget99 Exercise= include component="page" page="menu-Applications" editable="1" include component="page" page="menu-spreadsheets" editable="1"
 * For this exercise, we will use the spreadsheet [[file:Budget99.xls]]**

The spreadsheet you will refer to here, is an example of a typical personal budget showing income and expenses. You will need to enter functions in order answer some of the following questions. Try to do the IF function on your own, but if you have trouble with it, you can have a look back into Exercise 2 of this series. >> Important note to students: When you have finished answering this question successfully, you should save your work. That way, if you make errors later in the exercise, you can always come back to this version of the spreadsheet. >> >> >> >>  > Give cell B37 the range name //income// > Use the range names in cell B40 (Balance) to subtract expenses from income. What is the Balance? > //Note - The "SYNTAX" for Open Office uses "semicolons" > ie. =IF(income>expenses // //**;** "Total Income"**;** "Total Expenses" )//
 * The following are a series of exam type questions. You can check your answers at the end of this page**
 * 1) In cell B17, use the **SUM** function to determine the subtotal for all four months (from cell B15 to E15). What is the subtotal?
 * 2) **$1,879.52**
 * 3) **$2,517.19**
 * 4) **$625.83**
 * 5) **$3,432.20**
 * 1) In cell B35, add cell B25 and cell B30. Now select cells B35 to E35 and Fill Right to copy the formula. What is the subtotal for April?
 * 2) **$1,477.54**
 * 3) **$1,744.55**
 * 4) **$738.16**
 * 5) **$2,477.54**
 * 1) Use the SUM function in cell B37 to sum up the range of cells from B35 to E35. What is the total income?
 * 2) **$4,432.62**
 * 3) **$2,955.08**
 * 4) **$5,910.16**
 * 5) **$1,477.54**
 * 6) If my //net loan// amount changed for April (E28) to $198.75, what is the new subtotal for April in E35?
 * 7) **$1,444.71**
 * 8) **$1,444.51**
 * 9) **$1,477.54**
 * 10) **$1,744.55**
 * 11) Give cell B17 the range name //expenses// (Use Data - Define Range)
 * 1) **$3,392.97**
 * 2) **$5,877.13**
 * 3) **$3,932.79**
 * 4) **$3,359.94**
 * 5) Use the AVERAGE function to find the average income of the range B35:E35. Put it in cell B42. What is the average income?
 * 6) **$1,469.28**
 * 7) **$1,477.54**
 * 8) **$1,444.51**
 * 9) **$1,501.79**
 * 10) Use the AVG function in cell B43 to find the Average Expense of the range of cells B15:E15. What is the average expense?
 * 11) **$632.07**
 * 12) **$629.30**
 * 13) **$639.37**
 * 14) **None of the above**
 * 15) If we change the gas expense for April from $21.23 to $32.30, What is the new average expense?
 * 16) **$648.74**
 * 17) **$629.30**
 * 18) **$692.03**
 * 19) **$632.07**
 * 20) Insert an IF function into cell B51**. The condition is __if__ //income > expenses// then the cell should read "Total Income". If this is false, we want it to read "Total Expense". Which is higher?**
 * 1) Total Expense
 * 2) Total Income
 * 3) none of the above
 * 4) If we have an unexpected Miscellaneous Expense in April totaling $4,000; what is higher now?
 * 5) Total Expense
 * 6) Total Income
 * 7) none of the above