Page 17 - Digicode_AI_class_5
P. 17
We have learnt about Word and 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 very important for those who maintain accounts for
sales, bills, or do mathematical calculations as it is used to create 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 used for performing simple as The first electronic
well as complex calculations. spreadsheet software
Formatting Features: Excel allows the use of formatting was released in 1979. It
features to improve the look of the data. was called VisiCalc.
Auto-Calculation: Data is automatically recalculated in
the worksheet if any change is made in a single cell.
Fast Searching: Fast searching and instant replacing of data.
Auto Fill: Entering data in a series using Auto Fill feature.
Graphically View Data: Data can be viewed in a graphical form as charts. The charts
help us to understand, analyse and compare data in an effective manner.
Starting Excel 2016
To open Excel 2016, follow the given steps:
2 Scroll to find
Excel 2016 and
click on it.
1 Click on the Start
button.
Introduction to Excel 2016 15

