Page 54 - iPrime_V2.2_class7
P. 54
5 Spreadsheets—
An Introduction
Chapter Profile
Features of Excel 2016 Starting Excel 2016
Components of Excel 2016 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 2016
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 to use formatting features to improve the look and feel of
the data.
Auto-Calculation: Data is automatically Clickipedia
recalculated in the worksheet if any change
is made in a single cell.
The first electronic spreadsheet software
Fast Searching: Fast searching and instant
was released in 1979. It was called
replacing of data can be performed by Excel.
VisiCalc.
Auto Fill: Data in a series can be entered
using the Auto Fill feature.
Graphically View Data: Data can be viewed in a graphical form as charts. The charts help to
understand, analyse and compare data in an effective manner.
52 Touchpad iPRIME (Ver. 2.2)–VII

