Page 55 - Trackpad_ipro 4.1_Class7
P. 55
Spreadsheets—An
Introduction
Chapter
05
Your Aim
to learn about:
Features of Excel 2019 Starting Excel 2019
Components of Excel 2019 Window Types of Data
Creating a New Workbook Entering Data in a Worksheet
Saving a Workbook
We have learnt about Microsoft Word and Microsoft PowerPoint in the previous classes. We know
that Word allows us to create and edit documents, and PowerPoint allows us to create and edit
effective presentations. In this chapter, we will learn about another important application program
of Microsoft Office Suite, called Excel. Excel is the most commonly used interactive spreadsheet
program that allows us to perform mathematical calculations, analyse data, and store data in tabular
format. We can create charts and graphs from the data and convey more meaningful information.
Excel is an especially useful tool for keeping records of sales, bills, and performing mathematical
calculations because it can be used for creating electronic spreadsheets using the data.
FEATURES OF EXCEL 2019
Excel provides several features which make Excel the first choice for professionals to quickly perform
lengthy accounting and financial tasks and take immediate decisions. Some of them are as follows:
Functions and Formulas: Functions are the built-in formulas used for calculating percentage,
interest, average, etc., in Excel. Formulas are mainly used for performing simple as well as
complex calculations.
Formatting Features: Excel allows the use of formatting features to improve the look and
feel of the data.
Auto-Calculation: Data is automatically recalculated in the worksheet if any change is made
in a single cell. Clickipedia
Fast Searching: Excel allows fast
searching and instant replacing of data.
The first electronic spreadsheet software
Auto Fill: Excel allows entering data in a
was released in 1979. It was called
series using the Auto Fill feature.
VisiCalc.
Graphically View Data: In Excel, data
can be viewed in a graphical form as charts. The charts help understand, analyse and compare
data in an effective manner.
Spreadsheets—An Introduction 53

