Scribd
Upload
6 views13 pages

Advanced Excel Skills for Pasig Schools

Uploaded by

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

Advanced Excel Skills for Pasig Schools

Uploaded by

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

ADVANCED SPREADSHEET SKILLS

SCHOOLS DIVISION OF PASIG CITY


SCHOOLS DIVISION OF PASIG CITY
Menu Maximi
Bar Title Bar ze

Minimi Exi
TWO COMPONENTS OF MAIL
Office
ze t
Button
MERGE
Toolbar
Buttons
Cell Formula
Reference Bar
Column
Headings
Active
Cell

Row
Headings

Worksheet
Tab

SCHOOLS DIVISION OF PASIG CITY


12.
13.

11.
TWO COMPONENTS OF MAIL
MERGE
18.

14. 17.

19.

16.

15.

20.

SCHOOLS DIVISION OF PASIG CITY


BASIC FORMULAS IN MS EXCEL

1. Summation
2. Average
3. AverageIf
4. CountIf
5. Text

SCHOOLS DIVISION OF PASIG CITY


BASIC FORMULAS IN MS EXCEL
1. Summation
Ana wanted to total all her
expenses for the week. Monday she
spent P1,589. Tuesday and
Wednesday she got P2,345.
Thursday and Friday she spent
P2,152
SCHOOLS and
DIVISION P3,451.
OF PASIG CITY
BASIC FORMULAS IN MS EXCEL
2. Average
Solve the average of Peter’s
grades.

Show your answer using MS Excel.

SCHOOLS DIVISION OF PASIG CITY


BASIC FORMULAS IN MS EXCEL

1. AverageIf
2. CountIf

SCHOOLS DIVISION OF PASIG CITY


SCHOOLS DIVISION OF PASIG CITY
SCHOOLS DIVISION OF PASIG CITY
SCHOOLS DIVISION OF PASIG CITY
Any questions?
SCHOOLS DIVISION OF PASIG CITY

You might also like