ASH INFO 103 Week 3 Assignment Using Microsoft Excel
Check this A + tutorial guideline at
http:// www. assignmentclick. com / info- 103 / info-103-week-3-assignment-usingmicrosoft-excel
For more classes visit http:// www. assignmentclick. com
INFO 103 Week 3 Assignment Using Microsoft Excel
As indicated in the guidance for Week 3 Excel can be used for many purposes. For example, Excel can be used to develop and track your personal income and expenses against a monthly budget. Assume a family has developed a monthly budget and desires to compare actual expenses for July to their budget. Before we begin, for income and savings we use the formula( Actual – Budget) and for costs or expenses we use the formula( Budget – Actual). We do this because we are trying to determine whether the difference or variance is better or worse. It is better to earn a higher salary but it is worse to spend more than budget. Here are the detailed instructions: 1. In cell A1, enter the following title for this worksheet: Personal Budget vs. Actuals. 2. In cell A3, enter the following: Item. 3. In cell B3, enter the following: Factor. 4. In cell C3, enter the following: Budget Amount.