Page 53 - iPro_trackGPT_V5_Class7
P. 53
Spreadsheets—An 5
Introduction
Goal Glimpse
Features of Excel 2021 Starting Excel 2021
Components of Excel 2021 Window Types of Data
Creating a New Workbook Entering Data in the Worksheet
Saving a Workbook
In previous classes, we've covered Microsoft Word and Microsoft PowerPoint—Word for creating
and editing documents, and PowerPoint for designing impactful presentations. Now, we will
explore another key application in the Microsoft Office Suite: Excel. Excel is a widely used interactive
spreadsheet program that enables us to perform mathematical calculations, analyse data, and
organise information in a tabular format. With Excel, we can also create charts and graphs to present
data more effectively. Excel is particularly valuable for those managing accounts, sales, bills, or
performing complex calculations, as it allows for the creation of electronic spreadsheets.
FEATURES OF EXCEL 2021
Excel offers a range of features that make it the first choice for professionals to efficiently handle
complex accounting and financial tasks, enabling them to make quick decisions. Some of them are
as follows:
Functions and Formulas: Functions are built-in formulas in Excel used for calculating
percentages, interest, averages, and more. Formulas are primarily used for both simple and
complex calculations.
Formatting Features: Excel allows the use of formatting features to enhance the appearance
of the data.
Auto-Calculation: Data is automatically recalculated in the worksheet if any change is made
in a single cell. Boost Bits
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 VisiCalc.
series using Auto Fill feature.
Graphically View Data: In Excel, data can be displayed as charts, which make it easier to
understand, analyse, and compare information effectively.
Spreadsheets—An Introduction 51

