IT101 Phase 2 Essay

Submitted By deefilkins
Words: 429
Pages: 2

Personal Scenario Microsoft Excel spreadsheets offer a person the ability to input valuable information which can be used as a tool to assist in everyday functions within a household. I use spreadsheets to balance the family budget, assign chores to the children and plan menus. Each of these tasks requires different information to be input within the workbook. It is much easier to keep ongoing workbooks that can be copied or added to. Manual preparation of these documents would take much more time, as they would have to be revised and reprinted each week or month as needed. The household budget is the most important spreadsheet used in our home. I am able to include both of our incomes in order to determine the amount of money coming in each month. Bills are listed alphabetically and due dates determined. The amount paid for each bill is then input and can be changed should the amount change. Once bills are calculated, we are able to determine what is left over and can be put into savings or if we need to make adjustments for unexpected expenses.
Professional Scenario Excel spreadsheets can be used in a variety of reports within a company. Over the years, I have used such spreadsheets to create time sheets, statement reports and for completing inventory reports. Time sheets are prepared by listing the dates and hours worked within the cells of a worksheet. The totals can be input as an equation which will automatically calculate the total hours worked within a given time frame. Statements are also relatively easy to complete through Excel. Again, input the