This document introduces the basics of MS-Excel 2010, covering spreadsheet concepts, worksheet creation, data entry, formulas, and common applications.
The text provides an introduction to Microsoft Excel 2010 as a computer application that simulates a paper worksheet using a grid of rows and columns. It explains how cells can contain alphanumeric text or numeric values, including formulas for automatic calculation.
Key features discussed include the ability to create workbooks with multiple worksheets, use graphing tools and pivot tables, and automate tasks such as technical calculations and statistical analysis. The document also details specific spreadsheet components like the Ribbon, Formula Bar, and cell references.
| Maximum worksheets per workbook | 255 |
|---|---|
| Number of rows in worksheet | 1,048,576 |
| Number of columns in worksheet | 16,384 |
Excel 2010 needs Windows Vista or Windows 7 to run on an IBM PC. It can also be used with Windows XP if service pack 3 is installed.
They are commonly used in Production, Planning, Personnel Management, Marketing, Payroll and Accounting.