9

Learning Activity Sheet

ICT
(INTERNET & COMPUTER FUNDAMENTALS)
ICF 9
Quarter 3: Week 1

1
INTERNET & COMPUTER FUNDAMENTALS (ICF 9) – Junior High School
Learning Activity Sheet
Quarter 3 – Week 1

Republic Act 8293, section 176 states that: No copyright shall subsist in
any work of the Government of the Philippines. However, prior approval of the
government agency or office wherein the work is created shall be necessary
for exploitation of such work for profit. Such agency or office may, among
other things, impose as a condition the payment of royalties.

Borrowed materials (i.e., songs, stories, poems, pictures, photos, brand

names, trademarks, etc.) included in this Learning Activity Sheet are owned by
their respective copyright holders. Every effort has been exerted to locate and
seek permission to use these materials from their respective copyright
owners. The publisher and authors do not represent nor claim ownership over
them.
Secretary: Leonor Magtolis Briones
Undersecretary: Diosdado M. San Antonio

Development Team of the Learning Activity Sheet

Writer: Renie Cerbito Caparal

Content Evaluator: Riza R. Laguidao
Illustrator: Kenneth A. Deananeas
Layout Artist: Beatrice A. Olmedo
Management Team: Raul D. Agban Crista Joy A. Torbila
Alex B. Rejuso Isagani E. Licas
Lucila R. Balondo Beatrice A. Olmedo
Anecita B. Marzol Elvira R. Ribo
Michelle M. Probadora

Printed in the Philippines by ________________________

Department of Education – Division of Northern Samar –Region VIII
Office Address: Mabini St., Brgy Acacia, Catarman, Northern Samar
Telefax: (055) 500-9801
E-mail Address: nsamardivision@deped.gov.ph

2
 9
Learning Activity Sheet
ICT
(INTERNET & COMPUTER FUNDAMENTALS)
ICF 9
Quarter 3: Week 1

3
 TECHNOLOGY AND VOCATIONAL EDUCATION
(INTERNET & COMPUTER FUNDAMENTALS)
LEARNING ACTIVITY SHEET (LAS)
Grade 9
Quarter 3 (WEEK 1)
INTRO TO MICROSOFT EXCEL 2019

Name of Learner: _________________________________Score: ______________

Grade Level: ______________Section: __________Date: ____________________

I. Background Information for Learners

Parts of MS Excel Window

SOURCE: https://www.javatpoint.com/parts-of-ms-excel-window

Microsoft Excel is a spreadsheet application in the Microsoft Office suite. A

spreadsheet is an accounting program for the computer. The primary purpose of a
spreadsheet is to work with numbers and text. Spreadsheets can be used to
organize data like alphabetizing a list of named or sorting records, as well as to
calculate and analyze data using mathematical formulas,

4
Basic Parts of Microsoft Excel Window
Some parts of the Excel window (such as Ribbon and scroll bars) are
standard in most other Microsoft programs. However, other features are more
specific to spreadsheets, like the formula bar, worksheet tabs, and name box.

The following are the basic parts of the Microsoft Excel Window:
1. Quick Access Toolbar
2. File Tab
3. Title Bar
4. Control Buttons
5. Menu Bar
6. Ribbon/Toolbar
7. Dialog Box Launcher
8. Name Box
9. Formula Bar
10. Scroll Bars
11. Spreadsheet Area
12. Leaf Bar
13. Column Bar
14. Row Bar Cells
15. Cells
16. Status Bar
17. View Buttons
18. Zoom control
1. Quick Access Toolbar
This toolbar is located in the upper left corner of the screen. Its objective is to
show the most frequently used Excel commands. We can customize this toolbar
based on our preferred commands.
2. File Tab
Excel 2007's Office button has been replaced by the File tab. We can click it
to check the Backstage view, where we can open or save files, create new sheets,
print sheets, and perform other file-related operations.

3. Title Bar
5
 The title bar of the spreadsheet is at the top of the window. It displays the
active document's name.
4. Control Buttons
Control buttons are the symbols that are present in the upper-right side of the
window, enabling us to change the labels, minimize, maximize, share, and close the
sheet.
5. Menu Bar
Under the diskette or save icon or the excel icon (this will depend on the
version of the program), labels or bars which enable changing the sheet which is
shown. These are the menu bar and contain a File, Insert, Page Layout, Formulas,
Data, Review, View, Help, and a Search Bar with a light bulb icon. These menus are
divided into subcategories which simplify the distribution of information and analysis
of calculations.
6. Ribbon/Toolbar
Each menu bar contains several different elements. On the selection of the
menu, a sequence of command options/icons will show on a ribbon. For example, if
we select the "Home" tab, we will see cut, copy, paste, bold, italic, underline, and
more commands. In the same way; we can click on the "Insert" tab, we will see
tables, illustrations, additional, recommended graphics, graphics maps, among
others. On the other hand, if we select the "Formulas" option. Insert functions, auto
sum recently used, finances, logic, text, time, date, etc.
Ribbon/Toolbar is a set of commands organized into three sections.
o Tabs
They are the Ribbon's top part, and they include groups of related
commands. Ribbon tabs include Home, Insert, Page Layout, Formula, Data.
o Groups
They organize related commands; the name of each group is displayed below
the Ribbon. For example, a set of commands related to fonts or a group of
commands related to alignment, etc.
o Commands
They appear within each group, as previously stated.
7. Dialog Box Launcher
Dialog box launcher is a very little down arrow that is present in the lower-
right corner of a command group on the Ribbon. By clicking on this arrow, we can
explore more options related to the concerned group.
8. Name box
Show the location of the active cell, row, or column. We have the option of
selecting multiple options.
6
9. Formula Bar
Formula bar permits us to observe, insert or edit the information/formula
entered in the active cell.
10. Scrollbars
Scrollbars are the tools that enable us to move the document's vertical and
horizontal views. We can activate this by clicking on the platform's internal bar or the
arrows we have on the sides. Additionally, we can use the mouse wheel in order to
automatically scroll up or down: or use the directional keys.
11. Spreadsheet Area
It is the place where we enter our data. It includes all the rows, cells, columns,
and built-in data in the spreadsheet. We can use shortcuts to perform toolbar
activities or formulas of arithmetic operations (add, subtract, multiply, etc.). The
insertion point is the blinking vertical bar known as the "cursor." It specifies the
insertion location of the typing.
12. Leaf Bar
Leaf bar is present at the bottom of the spreadsheet, which says sheet1 is
shown. This sheet bar describes the spreadsheet which is currently being worked
on. Using this, we can alternate a number of sheets or add a new one as per our
convenience.
13. Columns Bar
Columns are a vertically ordered series of boxes across the full sheet. This
column bar is located below the formula bar. The letters of the alphabet are used to
label the columns. Begin with the letter A to Z, and then after Z, it will continue as
AA, AB, and so on. The number of columns that can be used is limited to 16,384.
14. Rows Bar
The row bar is the left part of the sheet where a sequence of numbers is
expressed. Begin with number one (1), and further rows will be added as we move
the pointer down. There is a total of 1,048,576 rows available.
15. Cells
Cells are those parallelepipeds that divide the spreadsheet into many pieces,
separating rows and columns. A spreadsheet's first cell is represented by the first
letter of the alphabet and the number one (A1).
16. Status Bar
The status bar is present at the bottom of the window that displays critical
information. It also indicates whether something is incorrect or whether the
document is ready to be printed or delivered.
This shows the result of the selected digits such as sum, average, count, maximum,
minimum, etc.

7
By right-clicking on the status bar, we can configure the status bar. Any command
from the specified list can be added or removed.
17. View Buttons
View buttons are a set of three buttons arranged at the left of the Zoom
control, close the screen's right-bottom corner. We can see three different kinds of
sheet views in Excel using this method.
o Normal View: - Normal view displays the Excel page in normal view.
o Page Layout View: - The Page Layout view shows the precise layout of an
Excel page it will be printed.
o Page Break View: - This displays page break preview before printing.
18. Zoom Control
The zoom control is present at the lower-right side of the window. It enables
us to ZOOM-IN or ZOOM-OUT a specific area of the spreadsheet. It is represented
by magnifying icons with the symbols of maximizing (+) or minimizing (-).
The various modern versions contain a segment with the icons of more and less, as
well as an element that separates the two alternatives, which permits us to
manipulate them by clicking on any of these.
On the other side, it also explains in percentage how many times the document has
been moved or approached. Microsoft Excel 2019 enables us to zoom out up to 10%
and zoom up to 400%.

II. Learning Competency with Code

LO 1: Intro to Microsoft EXCEL (MS EXCEL) 2019
Identify the Basic Parts of MS Excel Window and its features.

III. General Directions/Instructions:

1. Read and understand all the directions of the proceeding activities.
2. Perform all the tasks as directed.
3. Always observe precautionary measures

IV. Exercises/Activities:
➢ Explore
Directions: Are you familiar with some of the Mirosoft Office Suite Programs?
Name some of the icons presented below. Write your answer on your answer sheet.

8
➢ Learn
Directions: Re -arrange the letters below to reveal the answers.

1)SRABLLORCS ______________________
2) BARALUMROF _____________________
3) XOEBMAN _________________________
4) RABUNEM _________________________
5)RABELTIT __________________________

➢ Engage
Directions. Fill in the graphic organizer with the different types parts of MS Excel
Window that is already familiar to you. Write at least 10 expected answers.

9
  Apply:
Directions. Identify what is being referred to by the following statements. Write
your answer on your answer sheet.

_______________ 1) There are ________________ rows available in MS

Excel.
_______________ 2) ______________ permits us to observe, insert or edit the
information/formula entered in the active cell.
_______________3) The ____________ of the spreadsheet is at the top of the
window. It displays the active document's name.
_______________4) The first cell in MS Excel Spreadsheet is named ______.
_______________5) ______________ is present at the bottom of the
spreadsheet, which says sheet1 is shown.

V. Guide Questions
Directions. Read and answer the following questions below. Write your
answer on the spaces provided.
1) What do you think is the advantage of using MS Excel? Have you
familiarized the basic parts of the MS Excel Window?
__________________________________________________________
__________________________________________________________
__________________________________________________________
_________________________________________________________.

VI. Reflection

What I learned from this lesson are

___________________________________________________________________
___________________________________________________________________
___________________________________________________________________
______________________________________________________________

VII. References for Learners:

https://www.javatpoint.com/parts-of-ms-excel-window

10
 IX. Answer Keys

 EXPLORE

 LEARN 1) SROLL BARS

1)SROLL BARS
2) FORMULA BAR 2) FORMULA BAR
3)3)
NAME BOXBOX
NAME 4) MENU BAR
4) MENU BAR
5) TITLE BAR
5) TITLE BAR
 ENGAGE

Quick Access Toolbar File Tab Title Bar

Control Buttons Menu Bar Ribbon/Toolbar
Dialog Box Launcher Name Box Formula Bar
Scroll Bars Spreadsheet Area Leaf Bar
Column Bar Row Bar Cells Cells
Status Bar View Buttons Zoom control

 APPLY

1) 1,048,576
2) Formula Bar
3) Title Bar
4) A1
5) Leaf Bar

PREPARED BY:
Noted by:

RENIE C. CAPARAL 11
PAUL TEODORO A. MORTA
ARDEE S. ABALOS
Head, Vocational & MAPEH Dept.
GRACE C. GALONO
 Para sa mga katanungan o puna, sumulat o tumawag sa:

Department of Education-Curriculum Implementation Division-Learning

Resource Management Section (CID-LRMS)
Division of Northern Samar
Office Address: Mabini St., Brgy Acacia, Catarman, Northern
Samar
Telefax: (055) 500-9801
E-mail Address: nsamardivision@deped.gov.ph

12