Microsoft Excel formula and functions.ppt

Ms excel

1. Class 4 (a)
Theory
Demonstration and Assignment
MS Excel

2. Learning Objectives
•To use sort and filter techniques to
manage data.
•To review the concepts learnt in Excel.

3. Lesson Plan
Introduction 5mins
Demonstration 15 mins
Assignment 15 mins
Total 35 mins

4. Introduction
•Data can be viewed in ascending or
descending order of the values entered. to
felicitate this sort option is used.
•Many a times, selected data is to be seen
from huge set of data. To felicitate the
same, filer option is used.

5. Demonstration
•Arranging data on the basis of total score
•Select the entire data, click on “sort and
filer” from “editing” ribbon” and select
“custom sort”

6. Demonstration
Click on “sort by” and select the field on which sorting is
required.

7. Demonstration
•Filter:
•To selectively view the data, filer option is
used.
•Select the data and click on filter option
from

8. Demonstration
Select options for which data is to be seen:
Select options for which data is to be seen:

9. Review Assignment
A. Fill in the blanks:
•To view data selectively, _________ option is used.
•To arrange data in some order, ______ option is used.
•To format data selectively, ________ option is used.
•To perform calculations on data, ___________ are
written.
•In built formula in Excel, to perform small operations
are known as _________.
•Formula start with __________.
•To find sum of data, _______ is used where as to
count the number of entries _________ is used.

10. Write Short answers
•Differentiate between formula and
function.
•Differentiate between sort and filter.
•Differentiate between sum() and count().
•Explain conditional formatting?

11. Application Based Questions
Write formula and functions for the above worksheet

12. Class 4 (b)
Practical

13. Practical
1. Open the file saved in previous session,
and implement the following:
–Sort the sheet on the basis of price of items.
–Apply filter to view the data selectively.
2. Compete the sheet discussed in class room
session.