Uses of Microsoft Excel 2002
- Microsoft Excel allows users to manipluate data.computers screen 2 image by chrisharvey from Fotolia.com
Microsoft Excel is a spreadsheet and data program that is included in the Microsoft Office software suite. Microsoft Office software, and consequently Microsoft Excel, can be purchased and run on different versions of the Windows operating system. Excel 2002 is a version of the program originally available for the Windows XP operating system, and it lets users manipulate data in powerful ways. Familiarizing yourself with the uses of Excel 2002 will improve your performance with the program. - Microsoft Excel 2002 is primarily used for making spreadsheets. To create a spreadsheet, users simply open Excel 2002 and customize their worksheet. Additional sheets can be added by clicking the tabs at the bottom of the page. Users can edit the size of the rows and columns by dragging their margins to ensure they are large enough to fit the necessary data. Titles for each row or column can then be added at the top or side, and users can edit the font, font size, and font style.
- Once a spreadsheet is created, it can be used for many practical functions. Excel 2002 spreadsheets can be used to efficiently balance finances. Excel spreadsheets can keep track of expenses and bank account balances, and users can create charts to see how much money is being spent on specific items or services. Additionally, Excel spreadsheets can help users calculate interest on a potential investment to make sure it is worthwhile. Spreadsheets are also used to generate databases. For instance, users can keep track of items they own or contact information for friends and family.
- Excel 2002 users can also use the program to add up all numbers in a column automatically by inputting a formula. To automatically add all values in a given column, users must type the equals sign followed by the word "SUM," then a left parenthesis, the range of values desired, and a right parenthesis. For instance, if a user wants to total the values contained between cells D2 and D9, the formula is "=SUM (D2:D9)". This formula would need to be entered in the space where the user wanted the output to be displayed.
- Microsoft Excel 2002 also contains a calendar application that lets users view their schedules in different ways. Calendars can be viewed in 12 or 13 months sections, and they can be spread over multiple sheets if necessary. Much like other calendar programs, users can enter their special events and occasions in Excel 2002 and keep track of appointments and expenses. The order of the weekdays can be altered as well. Users can choose to start their weeks on Sunday, Monday, or any other day.
