Page 18 - Dig_CodeAI_V2.1_Class_5
P. 18
We have learnt about Word and PowerPoint in the previous classes. We know that Word
allows us to create and edit documents, while PowerPoint allows us to create and edit
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 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.
Features of Excel 2016
Excel provides several features that make it 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.
AutoFill: Entering data in a series using AutoFill 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.
16 DigiCode AI (Ver. 2.1)-V

