Page 64 - Code & Click - 5

8 Introduction to Excel 2016

Pre-Processing
Pre-Processing
• Features of Excel 2016 • Starting Excel 2016
• Components of Excel 2016 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

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 2016 is one of the most popular spreadsheet
software developed by Microsoft.

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 2016
Spreadsheet software provides many advantages over manual spreadsheets. Excel 2016
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.
• perform automated calculations using predefined functions.
• fill data automatically by using
patterns in series.
• represent data visually using charts
and other graphic objects.
• create, maintain, and analyse databases

easily.

Knowledge Discovery Subject Enrichment

Some spreadsheet software, other than Excel, are LibreOffice Calc, Kingsoft Spreadsheets,
and Gnumeric.

62