Microsoft Office Tutorials and References
In Depth Information
Additional Microsoft Office Programs
Excel is a powerful spreadsheet program that allows users to organize data,
complete calculations, make decisions, graph data, develop professional-looking reports
(Figure 63), publish organized data to the Web, and access real-time data from Web sites.
The four major parts of Excel are:
Workbooks and Worksheets
• - A workbook is like a notebook. Inside the workbook
are sheets, each of which is called a worksheet . In other words, a workbook is a
collection of worksheets. Worksheets allow users to enter, calculate, manipulate, and
analyze data such as numbers and text. The terms worksheet and spreadsheet are
- Excel can draw a variety of charts.
• - Tables organize and store data within worksheets. For example, once a user
enters data into a worksheet, an Excel table can sort the data, search for specii c data,
and select data that satisi es dei ned criteria.
Web Support -
• Web support allows users to save Excel worksheets or parts of a
worksheet in HTML format, so that a user can view and manipulate the worksheet
using a browser. Excel Web support also provides access to real-time data, such as
stock quotes, using Web queries.