Scribd
Upload
334 views10 pages

Class 6 - Computer - Excel - Chap1

MS Excel allows users to enter and organize data, perform calculations, and analyze information. It uses a grid of rows and columns to store data in individual cells that can be addressed. Formatting options help present worksheets clearly. Formulas use operators and cell references to calculate values based on input data. Common functions like SUM, AVERAGE, COUNT help summarize and analyze data in Excel.

Uploaded by

PradeepKanwar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
334 views10 pages

Class 6 - Computer - Excel - Chap1

MS Excel allows users to enter and organize data, perform calculations, and analyze information. It uses a grid of rows and columns to store data in individual cells that can be addressed. Formatting options help present worksheets clearly. Formulas use operators and cell references to calculate values based on input data. Common functions like SUM, AVERAGE, COUNT help summarize and analyze data in Excel.

Uploaded by

PradeepKanwar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

INTRODUCTION TO MS EXCEL

Today’s Lesson:
Why do we use MS Excel
Introduction to MS Excel
What is workbook, worksheet

Formatting Worksheet What is a row, column, cell,


cell address, Cell Range,
Active cell, Wrap text
What is Autofill feature
3 Types of Data in Excel
Borders, Resizing Rows/Columns

Merge & Centre, Font Group & Alignment group in Home Tab

Insert Row/Coulmn, Delete Row/Column


Writing Formula, Copying Formula & Automatic Calculation
Writing Functions (Sum, Average, Count, Min, Max) & Copying them
Excel Spreadsheet
• What is a spreadsheet Worksheet ?
• Spreadsheet is known as a sheet of paper that has a set of rows and
columns which make a tabular structure

 A grid is made up of
multiple cells where each
cell is an intersection of
rows and columns.
 Rows are horizontal and
columns are vertical
Uses of MS Excel:
Enter and store data (each cell can contain either
alphanumeric text or numeric values)
Enter formulae to compute or calculate
Analyze data or compare data sets for eg: comparison of
percentages of all students in a class using charts
Different Components of a Worksheet
Minimize Restore button
button
Close button
Microsoft office button
Quick access
toolbar Title Bar
Ribbon

Name box
Active cell
Formula bar
Column

Row

Status
Bar
Types of Data
Mostly we work in three types of data in an Excel worksheet:
Text
• Text is combination of characters, numbers, spaces and special characters (* #,& etc.).
• Text cannot be used for calculations
• Data items like name, Address etc. come under this category
• Text is automatically left aligned in the cell

Number
• Number includes 0-9 digits, +, -, $
• Numbers can be used for calculation
• Data like marks, prices, salary etc. are example of Numeric Data
• Numbers are automatically right aligned in the cell

Date and Time


• Data represented as Date and Time can also be represented in Excel. As Excel treats Date and Time as numbers,
mathematical operations like addition, subtraction can be performed on them. For example date can be entered as
15/1/2004 or as 15- Jan-2004. Time can be entered as 1:30 PM or 1:30:15 PM
Q1. Create the following table in MS Excel
Q1 (cont…) for Formatting Worksheet
Compare the below given 2 Excel Sheets and let us learn how to format your spreadsheet so that it
becomes more presentable.
Entering Excel Formulas
• A very important use of Excel is to do calculations
• A formula is an expression that operates on data values in a range of cells or
a cell
• For example if A1=121 , A2=222 , A3=331 , then =A1+A2+A3 will calculate the
sum of values in the range A1 to A3 or in simple words sum of values in cells A1 ,
A2, A3
• The result of =A1+A2+A3 is 674

“+” Cell address


operator =A1+A2+A3
Equal to operator
Using Formula in worksheet

You might also like