Page 217 - DCAP101_BASIC_COMPUTER_SKILLS

Basic Computer Skills

Notes Objectives

After studying this unit, you will be able to:

• Understanding of MS Excel features
• Discussion of Excel formulae
• Explanation of Graph and chart in Excel

• Understanding of Design corner
• Process of printing Excel sheet

Introduction

Excel is a Window-based spreadsheet created by Microsoft Corporation, US. It includes all
standard features of a spreadsheet package like automatic recalculation, graphs, and functions.
It also includes several advanced utilities like the facility to include other objects within a
spreadsheet and pivot tables and form designing’.
Excel can be used for a variety of applications. It is commonly used to automate financial
statements, business forecasts, inventory control, and accounting. The package provides
statistical, financial and scientific functions. Therefore, Excel can be used in many scientific
and engineering environments to analyze numeric data. Excel is currently the best-selling
Windows spreadsheet.

11.1 Features

Excel is a feature-rich product that can be used at many different levels.
Multisheet files: Excel’s files (called workbooks) can consist of any number of separate
sheets. The sheets can be worksheets, chart sheets, macro sheets, or custom dialog
boxes. This feature makes it easy to organize the user’s work.

Multiple document interface: This capability of Excel makes it easy to transfer
information between worksheets in different workbooks.
File compatibility: Excel can read files produced by other spreadsheet programs. It can
also read text files, dBASE files, and HTML documents.
Interactive help: While working in Excel, the user can get help on-screen. Excel’s on-
line help is excellent and extremely detailed.
List management: This feature makes it easy to sort, filter, summarize, and manipulate
data stored in the worksheet.

Built-in functions: Excel includes an enormous collection of built-in functions.
Great charts: Excel’s charting features enable the user to modify and augment a wide
assortment of graph types.

Integrated mapping: This feature lets the user display the data in terms of a geographic
map.

Pivot tables: Using this feature, the user can view the data in summarized table form.
Advanced analytical tools: Goal seeking, a powerful Solver feature, and the analysis
.ToolPak add-in features, provides extensive statistical, financial, engineering, and
scientific functions and procedures.

210 LOVELY PROFESSIONAL UNIVERSITY