Department of Education

SCHOOLS DIVISION OF CITY OF MEYCAUAYAN

Pag-asa St., Malhacan, City of Meycauayan, Bulacan

Senior High School

Activity Performance 11/12

Worksheet in
EMPOWERMENT TECHNOLOGY
Third Quarter – Week 3A
Creates an Original or Derivative ICT
Content to Effectively Communicate or
Present Data or Information Related to
Specific Professional Tracks
(CS_ICT11/12-ICTPT-Ia-b-5)
 ADVANCED SPREADSHEET SKILLS

I. Introduction
Microsoft Excel is a software program produced by Microsoft that allows users
to organize, format and calculate data with formulas using a spreadsheet system. This
software is part of the Microsoft Office suite and is compatible with other applications
in the Office suite.

II. Learning Competency/ Unit of Competency

Lesson 5 MELC 4: Creates an original or derivative ICT content to effectively
communicate or present data or information related to specific professional tracks
(CS_ICT11/12-ICTPT-Ia-b-5)

III. Nominal Duration

4 Days

IV. Objectives/ Learning Outcomes

• Identify the most commonly used functions in Microsoft Excel.
• Distinguish the syntax of the different excel functions.
• Perform some MS Excel functions to some mathematical problems.

V. Content/ Lesson

Introduction to MS-Excel

Materials:
PowerPoint Presentation
Information Sheets
URL reference

VI. Procedure (Knowledge)

Excel is a computer program used to create electronic spreadsheets. Within Excel,

user can organize data, create chart and perform calculations. It is also a convenient program
because it allows user to create large spreadsheets, reference information, and it allows for
better storage of information. Excels operates like other Microsoft (MS) office programs and
has many of the same functions and shortcuts of other MS programs.

Excel has the same basic features as all spreadsheet applications, which use a
collection of cells arranged into rows and columns to organize and manipulate data. They can
also display data as charts, histograms and line graphs.

2
OVERVIEW OF EXCEL

OFFICE BUTTON
• Microsoft excel consists of workbooks. Within
each workbook, there is an infinite number of
worksheets.
• Each worksheet contains Columns and Rows.
• Where a column and a row intersect is called a
cell. For e.g. cell D5 is located where column D
and row 5 meet.
• The tabs at the bottom of the screen represent
different worksheets within a workbook. You
can use the scrolling buttons on the left to bring
other worksheets into view.

RIBBONS

A ribbon is a graphical control element in the form of a set of toolbars placed on

several tabs. The typical structure of a ribbon includes large, tabbed toolbars, filled with
graphical buttons and other graphical control elements, grouped by functionality.
The three parts of the ribbon are:

TABS expose different sets of controls, eliminating

the need for numerous parallel toolbars.

GROUPS are sets of related commands, displayed on

tabs.

COMMANDS are buttons, menu or box where you

enter information.

CELL REFERENCING

1. RELATIVE REFERENCE
A Relative Cell Reference as (a1) is based on the relative position of the cell.
If the position of the cell that contains the reference changes, the reference itself is changed.

2. ABSOLUTE REFERENCE
An Absolute Cell Reference as ($a$1) always refers to a cell in a specific location. If the
position of the cell that contains the formula changes, the absolute reference remains the
same.

3. MIXED REFERENCE
A Mixed Reference has either an absolute column and relative row or absolute row and
relative column. An absolute column reference takes the form $a1, $b1.an absolute row
reference takes the form a$1, b$1.

3
FUNCTIONS

1. IF FUNCTION (LOGICAL)
SYNTAX OF IF
=IF (LOGICAL TEXT, VALUE IF TRUE, VALUE IF
FALSE)

LOGICAL TEXT-
Any value or expression that can be evaluated to
TRUE or FALSE.

VALUE IF TRUE-
Value that is returned if logical text is TRUE.

VALUE IF FALSE-
Value that is returned if logical text is FALSE.

2. IF FUNCTION (NESTED)
SYNTAX OF IF
=IF (LOGICAL_TEST,VALUE_IF_ TRUE,
[VALUE_IF_FALSE])

“NESTING” refers to the practice of joining multiple

functions together in one formula.

BASIC MATH OPERATIONS

BASIC MATH OPERATION FUNCTIONS

=SUM(x,y) or =SUM(range) returns the sum of x and y or all the numbers
within the range (=SUM (value 1, value 2, etc.)
=PRODUCT(x,y) returns the product of x and y (=A1*B1)
=QUOTIENT(x,y) returns the quotient of x divided by y (=A1/B1)
=SUBTRACTION =SUM (A1, -B1) or (=A1-B1)

DATEDIF FUNCTION

SYNTAX OF DATEDIF

=DATEDIF(START_DATE,END_

DATE,”INTERVAL”)

START DATE-
Date from which you want to calculate
TEXT FUNCTIONS
difference.

END DATE-
Date up to which you want to calculate
difference.

INTERVAL-
Form in which you want to calculate
difference.

4
 “D”- days “YM”- months over year
“M”- months “MD”- days over month
“Y”- years

SYNTAX OF FUNCTIONS
1. LOWER FUNCTION is used to convert
text from capital to small.

=LOWER(TEXT)
2. UPPER FUNCTION is used to convert
text from small to capital.
=UPPER(TEXT)
3. PROPER FUNCTION to capitalized each
word of text.
=PROPER(TEXT)

SYNTAX OF FUNCTIONS
1. LEFT FUNCTION return specified no.
of character from start of text.
=left(text,num_chars)
2. RIGHT FUNCTION return specified
no. of character from end of text.
=right(text,num_chars)
3. MID FUNCTION return character
from middle of text, given a starting
position.
=mid(text,startnum,num_char)

OTHER FUNCTIONS

NOW returns current date and time.

TODAY returns current date only.
MOD returns the remainder after a
number is divided by a
divisor.
LEN returns the no. of characters
in a text string.
SUM add all the numbers.

5
VII. Assessment

Activity 1 (Knowledge)
Multiple Choice. Choose the letter of your choice. Write the answer on your answer
sheet.
1. What is the shortcut key for AutoSum?
A. Alt + S C. Ctrl + S
B. Alt + = D. Ctrl + =
2. This is the keyboard shortcut key to save copy documents.
A. Ctrl + P C. F12
B. Ctrl + S D. Alt
3. What are the keyboard shortcut keys to insert a table?
A. Alt + N + R C. Ctrl + F1
B. Alt + H + D + C D. Ctrl + T
4. These are the ribbon that expose different sets of controls, eliminating the need
for numerous parallel toolbars.
A. Tabs C. Commands
B. Groups D. Control button
5. These are parts of the ribbons that can be buttons, menu or box where you enter
information.
A. Tabs C. Commands
B. Groups D. Control button
6. What kind of cell reference is cell $f4, $g4?
A. Absolute reference C. Relative reference
B. Mixed reference D. Relation reference
7. How do you know which cell in Excel is currently selected?
A. The selected cell will be highlighted.
B. It will have a black border around it and the contents of the cell will appear
in the formula bar (above the grid).
C. The number of the selected cell will appear on the status bar at the bottom of
the screen.
D. There is no way of telling which cell is selected.
8. Which of the following option(s) represent the correct formula to multiply two
values located in cells A1 and A2 with each other?
A. Entering the formula: =B1xB2
B. Entering the formula: =B1*B2
C. Entering the formula: =MULTIPLY (B1:B2)
D. All of the above options are correct.
9. This function returns current date and time.
A. NOW C. DATE NOW
B. TODAY D. DATE TODAY
10. This function is used to convert text from capital to small.
A. Proper function C. Upper function
B. Lower function D. Change case

6
Activity 2 (Understanding)
Direction: Identify the following cell references and explain your reason why you
categorize each under a particular cell reference.

1. =$B3+$B4

2. =$A$3+$C$4

3. =G12+M14

4. = B$8+C$8

Activity 3 (Performance)
TASK SHEET 4.1 Creating Formula

7
 TASK SHEET 4.1
Student’s name:
Teacher’s name: Ma. Leonora S. Chou
Date:
Title: Excel Activity: Creating Formula
At the end of the activity, the students are able to perform some
Performance
MS Excel functions to compute the grades of the selected TVL
Objective:
students.
Supplies/
Learning material
Materials:
Equipment: Computer
Procedure:
1. Prepare the computer and make sure that it is working.
2. Using Microsoft Excel, encode the given entry and arrange
the name of students alphabetically.
3. Score must be properly encoded where they need to be
placed.
4. Create a formula to get the total score(TOTAL), Percentage
Score (PS) and Weighted Score (WS).
FORMULA:
• SCORE = Total score of all the given entries
• PS = Total Score of all the given entries / Number
of Items X 100
• WS = PS X Number of Percentage
5. Write your answer where it should be placed.

Assessment
Observation of practical skills.
Method:

PERFORMANCE CRITERIA CHECKLIST

Score
Rudimentary Developing Satisfactory Accomplished Exemplary
Category or
1 2 3 4 5 N/A
All data Most data All data
Several errors.
Some data required required is required is
Some required
Data Entry required is data is entered with entered with
data may be
missing. entered 100% 100%
missing.
correctly. accuracy. accuracy.
Several Most formulas
100% use of
errors in Minor errors used are
Computatio No formulas correct
formula in correct correct
ns, & are used. applicable
calculation formulas applicable
Formulas formulas as
s used. formulas as
required.
required
Some Information is Information
Information is Information organized by is very well
poorly is Information using organized by
organized. organized, is mostly appropriate using
Appropriate using organized, formatting, appropriate
formatting standard using including advanced
Organization such as formatting appropriate shading, formatting,
/ appropriate tools. Some standard alignment including
Formatting labels & labels or formatting tools, borders, shading,
column/row other tools, such special fonts, alignment
widths & important as labels appropriate tools,
heights are formatting and bolding. labels, borders,
not used. tools are appropriate special
missing. column/row fonts,
height & width appropriate

8
 labels,
appropriate
column/row
height &
width
Spreadshee
Spreadsheet is Spreadsheet is Spreadsheet
t is Spreadsheet
VERY difficult visually is attractive,
somewhat is clear &
to read and esthetic, easy to read
difficult to easy to read.
Visual locate mostly easy to & all
read. A few Minor
Appearance information. read & most of required
pieces of information
& Output Major the required information
important has been
information information printed
information cut off when
has been was printed (nothing is
are printed.
omitted. (nothing is cut cut off).
omitted.
off).
All
Most of the
Most of the directions
directions Some of the
Followed None of the directions were
were directions
Directions directions were followed
followed were followed.
were followed. followed accurately
somewhat
accurately. and
accurately.
completely.

TOTAL SCORE

Student’s name and signature: Date:

Teacher’s name and signature:
MA. LEONORA S. CHOU Date:
Teacher III
Note: In the instance that there is no technology to use MS Excel application, just write the
formula on how to get the total score, PS (percentage score), and the WS (the weighted score).
Then, write the final answer beside the formula.

References
Bansal, Mridul. “MS EXCEL PPT PRESENTATION.” SlideShare, January 19, 2013.
https://www.slideshare.net/love1200/ms-excel-ppt-presentation.

Griggs, Amelia. “All the Best Microsoft Excel Keyboard Shortcuts.” How. How-To Geek,
August 11, 2018. https://www.howtogeek.com/361582/all-the-best-microsoft-excel-
keyboard-shortcuts/.

Oxillo, Mark Jhon. “Advanced Spreadsheet Skills - Empowerment Technologies.”

SlideShare, December 14, 2017.
https://www.slideshare.net/markjhonoxillo/advanced-spreadsheet-skills.

“Ribbon (Computing).” Wikipedia. Wikimedia Foundation, May 20, 2020.

https://en.wikipedia.org/wiki/Ribbon_(computing).

Stec, Carly. “15 Excel Formulas, Keyboard Shortcuts & Tricks That'll Save You Lots of
Time.” HubSpot Blog, April 24, 2020. https://blog.hubspot.com/marketing/excel-
formulas-keyboard-shortcuts.

“What Is Microsoft Excel? - Definition from Techopedia.” Techopedia.com, August 25, 2020.
https://www.techopedia.com/definition/5430/microsoft-excel.

9
 All Rights Reserved
2020

ACKNOWLEDGEMENT
CAROLINA S. VIOLETA EdD
Schools Division Superintendent

JERRY DIMLA CRUZ, PhD, CESE

Asst. Schools Division Superintendent

DOMINADOR M. CABRERA EdD

Chief, Curriculum Implementation Division

EDWARD C. JIMENEZ PhD

Education Program Supervisor- LR Manager

RAMILO C. CRUZ PhD

Education Program Supervisor-EPP/TLE/TVL

MA. LEONORA S. CHOU

Developer/Writer

10