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 .