MS EXCEL WINDOW OPERATION
Microsoft Excel
- developed by Microsoft
- store and represent data
- manage and manipulate d
- create optically logical cha
Parts of Documentation
1. Worksheet made of row
2. Rows - represented by n
3. Columns - represented b
4. Workbook - can consist s
OPERATIONS Formulas and Functions
Microsoft
resent data in tabular form
manipulate data
ly logical charts and more!
on
made of rows and columns
sented by numbers
presented by alphabets
can consist several sheets
MS EXCEL WINDOW OPERATIONS Formulas and Functions
Microsoft Excel Window
- Quick Access Toolbar
- Excel Ribbon
- Formula Bar
- Name Box
- Backstage View
- Worksheet Views
- Zoom Control
- Active Cell Indicator
- Column Letters
- Row Numbers
MS EXCEL WINDOW OPERATION
Basic Operations on Worksheet
- To rename a worksheet
- To inset a new worksheet
- To delete a worksheet
- To copy a worksheet
- To move a worksheet
- To change the worksheet
OPERATIONS Formulas and Functions
Worksheet
worksheet
w worksheet
orksheet
ksheet
rksheet
e worksheet tab color
MS EXCEL WINDOW OPERATION
Basics in Formulas and Functions
*Formula - calculates the value o
- must start with the e
* Function - a predefined formul
- performs calculation
values in a particula
* Cell - single data point in any w
* Row - group of cells that lie ho
* Column - group of cells that lie
* Range - selection of certain cel
* Parts of a Function (syntax):
=, function name (SUM), and
arguments
arguments - information to be c
- can refer to both individua
- must be enclosed within p
1
2
3
Commonly Used Functions:
4 1. SUM
2. AVERAGE
3. COUNT
4. MAX
Commonly Used Functions:
1. SUM
5 2. AVERAGE
6
7
3. COUNT
4. MAX
5. MIN
Samp
OPERATIONS Formulas and Functions
unctions
tes the value of a cell
tart with the equal (=) sign
defined formula
rms calculations using specific
s in a particular order
point in any worksheet
ells that lie horizontally
of cells that lie vertically
n of certain cells
on (syntax):
me (SUM), and one or more
mation to be calculated
both individual cells and cell ranges
losed within parenthesis
unctions:
unctions:
Sample Activity
MS EXCEL WINDOW OPERATION
Solve the following Formula and Function Problems
GIVEN:
Ana's grades:
Math: 95
Computer: 92
P.E.: 85
English: 89
1. How may subjects are to be recorded?
2. What is the sum of Ana's grades from all of he
3. What is Ana's average grade?
4. What is the value of Ana's highest grade?
5. What is the value of Ana's lowest grade?
OPERATIONS Formulas and Functions
Function Problems:
Student Name: Ana
1
2
3
4
recorded?
ades from all of her subjects? Total Subjects:
Sum of grades:
e? Average Grade
highest grade?
owest grade? Highest Grade Value:
Lowest Grade Value:
Student Name: Ana
Subjects Grades
Math 95
Computer 92
P.E. 85
English 89
Total Subjects: 4
Sum of grades: 361
Average Grade 90.25 90.25
Highest Grade Value: 95
Lowest Grade Value: 85
