Page 59 - TP_iPlus_V2.1_Class7
P. 59
Spreadsheets—An
Introduction
5
Learning Outcomes
Features of Excel 2016 Starting Excel 2016
Components of Excel 2016 Window Types of Data
Creating a New Workbook Entering Data in the 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.
i + FEATURES OF EXCEL 2016
Excel provides several features which make it the first choice for professionals to quickly perform
extensive 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.
Info Byte
• Auto-Calculation: Data is automatically
recalculated in the worksheet if any The first electronic spreadsheet software
change is made in a single cell. was released in 1979. It was called VisiCalc.
57
Spreadsheets—An Introduction

