Page 91 - Computer - 5
P. 91
Introduction to
8 8 Introduction to
Excel 2019
Excel 2019
Pre-Processing
• Features of Excel 2019 • Starting Excel 2019
• Components of Excel 2019 Window • Creating a New Workbook
• Entering Data in a Worksheet • Selecting Cells
• Working with Worksheets • Saving a Workbook
• Opening a Saved Workbook • Closing a Workbook
Computers work with data. Data can be presented in different ways. A Spreadsheet
organises data in a tabular format made up of rows
and columns. Spreadsheets can be manual, created
on paper, or electronic, created using a spreadsheet
software.
Excel 2019 is one of the most popular spreadsheet
software developed by Microsoft. It is widely used to
enter data, perform calculations on it, create charts,
and analyse the data.
A file in Excel is called a Workbook. Each workbook contains one or
more pages called Worksheets. A worksheet consists of a series of rows
and columns. It is also known as a spreadsheet.
FEATURES OF EXCEL 2019
Spreadsheet software provides many advantages over manual spreadsheets.
Excel 2019 lets you:
• arrange data in a workbook across multiple worksheets.
• enter data in a variety of formats, such as text, numbers, and formulas.
• edit and format data in different ways.
• automatically recalculate all the formulas whenever a related number or a
value is changed.
• perform automated calculations using predefined functions.
89