These articles allow you to further explore various computing topics and include a quiz for review.
Introduction Learn about how businesses use spreadsheet applications in the real world.
Directions Read the information below and apply what you learn to answer the questions. Check your work carefully, and click Submit.
Business Uses for Spreadsheet Applications
The term spreadsheet comes from the field of accounting, in which business transactions were tracked on large sheets of paper that, when spread out, formed a “spreadsheet.” The spreadsheet application Microsoft Excel borrows its name from accounting because it creates computerized spreadsheets with built-in features such as formulas that make accounting or other types of calculations more efficient.
Many of Excel’s features are designed to help the user analyze data quickly and accurately. For example, Excel includes several built-in formulas that are used to perform automatic calculations. Some of the more common formulas are as follows:
Excel also includes several financial formulas, such as PMT, which calculates the payment of a loan based on a fixed payment and interest rate. In addition to built-in formulas, Excel offers features to expedite changes to data, such as the Find and Replace command, which is used to locate and replace a specific data entry throughout a spreadsheet. In a spreadsheet with thousands of data entries, this feature saves the user a substantial amount of time. In order to organize data visually, Excel contains features that make it easy for the user to organize selected data as a pie chart, bar chart, or other graphic. These graphics help businesses make important decisions, as they can see at a glance their inventory, sales, or other important data.
Businesses use Excel to analyze data in a way that helps them make important decisions, as in the following:
explore our Web site. To report a technical problem with this Web site, please contact the