JHS

Learning Strand 6
Digital Citizenship
BASIC SPREADSHEET
Accreditation and Equivalency (A&E) Program Module

1
 Book Record

School: District:

Division: Region: Date Received by School:

To the Learner
Use the table below by following the instructions:
1. Write your name clearly under the column Name of Borrower.
2. Use the following letters in recording the condition of the book before and after borrowing:

A. new C. used book in Fair Condition

B. used book in Good Condition D. used book in Poor Condition

Date
Name of Borrower Date Issued Condition Condition
Returned

Take Care of Your Book

Dos: Don’ts:
1. Cover your book using a plastic cover, 1. Do not fold the pages.
manila paper, old newspaper, or magazine. 2. Do not write on the cover or pages.
2. Be sure your hands are clean when you 3. Do not cut out any picture.
handle or turn the pages. 4. Never detach or tear any page.
3. When using a book for the first time, lay it 5. Do not leave it open or lying face down
on its back and open only a few pages at a when not in use.
time. 6. Do not use pencils, ballpens, or thick
4. Use a piece of paper or cardboard for objects as bookmarks.
bookmarks. 7. Do not force the book into a packed
5. Paste or tape immediately any torn pages. schoolbag.
Always take care of damaged book. 8. Do not use it to cover your head when it is
6. Handle the book with care when passing raining.
from one person to another. 9. Do not sit on it.
7. Always keep your book in a clean dry place.
8. When your book is lost, report it to your
teacher right away.
 JHS

Learning Strand 6
Digital Citizenship
BASIC SPREADSHEET

Accreditation and Equivalency (A&E) Program Module

iii
Learning Strand 6 – Junior High School
Alternative Learning System
Module: Basic Spreadsheet
First Edition, 2023
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 module 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.

Published by the Department of Education

Secretary: Sara Z. Duterte-Carpio
Undersecretary: Gina O. Gonong

Development Team of the Module

Writer: Janet B. Alcantara

Editors: Ruth Vanessa T. Bayon

Reviewers: Arlene Malaybalay, Priscilla V. Salo,

Mahnnie Q. Tolentino, Dino R. Cuyag,
Aljon I. Arevalo, Reuben C. Herrera

Illustrators: Paul Francis L. Quines

Kathleen Joy D. Ayawan

Layout Artists: Jardine M. Balbuena,

Dino Rosario Cuyag

Management Team:

Bureau of Alternative Education (BAE)

Bureau of Learning Resources (BLR)
Regional Office CAR
Schools Division of Tabuk

ii
iii
User’s Guide
For the ALS Learner:

This module was designed to provide you with fun and meaningful opportunities
for guided and independent learning at your own pace and time. You will be
enabled to process the contents of the learning resource while being an active
learner.

This module has the following parts and corresponding icons:

This will give you an idea of the skills or

What Is This Module competencies you are expected to learn in
About? the module.

Let’s See What You This part includes an activity that aims to
Already Know check what you already know about the
lesson. If you get all the answers correct
(100%), you may decide to skip

What Will You Learn This contains objective/s or the learning

from This Module? competencies in a lesson. This may include a
brief rationale on what you will learn.

Let’s Do This This part gives instruction to the learner to

perform the activity/ies as mentioned-above
to ensure learning the competencies or the
objectives.

Let’s Study and This section provides a brief discussion of the

Analyze lesson. This aims to help you discover and
understand new concepts and skills.

Let’s Try This This comprises activities for independent

practice to solidify your understanding and
skills of the topic. You may check the
answers to the exercises using the Answer
Key at the end of the module.

Let’s See What You This section provides an activity that will
Have Learned help you transfer your new knowledge or
skill in real-life situations or concerns.

Let’s Remember and This contains key concepts taken from all the
Review lessons covered in every module.

iii
 This is an activity in a form that increase the
strength of the response and tends to induce
Explore More
repetitions of actions/learning.

This is a task which aims to evaluate your

What Have You level of mastery in achieving the given
Learned?
learning competency.

This contains answers to all activities in the

Answer Key module.

This portion gives information about the

Glossary meanings of the specialized words used in
the module.

Reference This is a list of all sources used in developing

this module.

The following are some reminders in using this module:

1. Use the module with care. Do not put unnecessary mark/s on any part of
the module. Use a separate sheet of paper in answering the exercises.
2. Don’t forget to answer the Pre-assessment before moving on to the other
activities included in the module.
3. Read the instruction carefully before doing each task.
4. Observe honesty and integrity in doing the tasks and checking your
answers.
5. Finish the task at hand before proceeding to the next.
6. Return this module to your ALS Teacher/Instructional Manager/Learning
Facilitator once you are through with it.

If you encounter any difficulty in answering the tasks in this module, do not
hesitate to consult your ALS Teacher/Instructional Manager/Learning Facilitator.
Always bear in mind that you are not alone.

We hope that through this material, you will experience meaningful learning and
gain deep understanding of the relevant competencies. You can do it!

iv
iii
 Contents

What Is This Module About? ........................................................................ 1

Let’s See What You Already Know ................................................................ 1
What Will You Learn From This Module? ..................................................... 3
Let’s Do This................................................................................................ 3
Let’s Study and Analyze ............................................................................... 4
Let’s Try This ............................................................................................. 12
Let’s See What You Have Learned .............................................................. 13
Let’s Remember and Review....................................................................... 13
Let’s See What you Have Learned?............................................................. 14
Answer Key ................................................................................................ 17
Glossary .................................................................................................... 18
References ................................................................................................. 19

iiiv
 What Is This Module About?

This module is made to inform learners about spreadsheet application

which is the Microsoft Excel, there is a number of spreadsheet programs but of
all of them, Excel is the most widely used. People have been using it for the last
30 years and throughout these years, it has been upgraded with more and more
features. (LS6DC-DA/S-PSC-AE/JHS-29)

The best part about Excel is, that it can apply to many business tasks,
including statistics, finance, data management, forecasting, analysis, tracking
inventory & billing, and business intelligence. Persons who know anything about
microsoft excel spreadsheet application will make them more aware of their
usefulness and may use them in their daily lives and help them cope with the
different situations, especially in times of pandemic that we are suffering today.

Let’s See What You Already Know

I. Directions: Write TRUE in the blank before each sentence if the statement
is TRUE, and FALSE if it is NOT.

__________1. Active cell is a cell that is currently selected.

__________2. A row is a horizontal set of cells.

__________3. A column is a vertical set of cells.

__________4. The Title bar will show the name of your

workbook,followed by the application name( “ Microsoft Excel” ).

_________ 5. The status bar is the thin bar at the bottom of the Excel
window.

1
II. Directions: Read the following statement and write the letter that corresponds
to the correct answer in your answer sheet.

1. It is a file that consist of cells in rows and columns and can help arrange,
calculate, and sort data.

A. cell
B. column
C. active cell
D. spreadsheet

2. It is a smallest but most powerful part of a spreadsheet. You can enter your
data into a cell either by typing or by copy-paste.
A. row
B. cell
C. column
D. active cell

3. It can be a text, a number, or a date. You can also customize it by changing

its size, font color, background color, borders, etc.
A. row
B. data
C. excel
D. column

4. Which holds charts, images, and diagrams in a worksheet?

A. row
B. column
C. worksheet
D. spreadsheet

5. Which toolbar is frequently used to quickly access the options?

A. Status bar
B. Address bar
C. Formula bar
D. Quick access toolbar

2
 What Will You Learn From This Module?

This module is made to guide and nourish learners about Micorosoft Excel
spreadsheet application. After going through this module, you should be able to;
• Demonstrate how to open/close a spreadsheet application
• Demonstrate how to save a spreadsheet under another name to a
location on a drive.
• Show how to save a spreadsheet under another name to a location on
a drive.
• Demonstrate how to save a spreadsheet as another file type like:
o Excel template
o Text
o PDF
o Webpage

Let’s Do This

Directions: Let’s see how acquainted you are by arranging the jumbled letters
below. Write your answer in the small boxes.

1. I L F E UMNE

2. R F A O L U M ABR

3. N C M O L U

4. S D A R E S T E H P E

5. E W O E R H K S T

6. K O W O B O R K

7. L C E L

8. C E X L E

9. I V T A C E LCLE

10. D R E S A S D RBA

3
 Let’s Study and Analyze

In today’s world, technology plays a crucial role in nearly every aspect of our
lives. One of the topics that needs to be learned is Spreadsheet applications which
are widely used in various files of learning purposes due to their ability to organize
and analyze data. In this module, the steps on how to open a new blank workbook,
the steps in opening existing spreadsheet document, and the steps on how to close
a spreadsheet are discussed.

A. Steps on How to Create a New Blank Workbook

1. Click the start button.

2. If open, type the name of spreadsheet application in the search bar and
see icon to pop-up.

43
3. Click the excel icon to open and wait to proceed in the spreadsheet workbook.

4. Once the spreadsheet is open, click the “Blank Workbook” to start a new
spreadsheet workbook.

5. Welcome to MS excel spreadsheet, you are good to go!

53
B. Steps on How to Open an Existing Spreadsheet Document
1. Click the File tab.

2. Click Open.

Tips: Shortcut Press Ctrl + O to quickly display the Open tab of the
Backstage view.

3. Select the location where the file is saved.

You can choose from:

Recent: Recent files you've worked on.

Shared with Me: Files others have shared with you on OneDrive or SharePoint
Online.

OneDrive: Microsoft's cloud-based storage.

This PC: Browse files on your local computer.

Browse: Opens a dialog box where you can browse through your computer's
folders, drives, and network shares.

6
3
 4. Select the file you want to open.

5. Click Open.

C. Steps on How to Close a Spreadsheet

1. In the spreadsheet workbook, click the specific control button seen on the
upper right corner of the spreadsheet window.

73
2. Click the “X” button to close the spreadsheet.

3. If there will be progress of the file, a dialog box will appear to confirm your action.
Click Save button to update the file.

38
4. A dialog box will appear to save your file. Select location and type the file name
before clicking the Save button.

5. A dialog box will appear to confirm your action. Click Save button to update the
file.

9
3
ADDITIONAL TIPS:

You may choose to save your file using the following format: Excel, Text, PDF,
Webpage

Excel Format

PDF Format

Webpage Format

3
10
Text Format

Click the Save button.

11
3
 Let’s Try This

I. Directions: Arrange the following step-by-step procedure in using Spreadsheet

application. Write “1” if that is the first step, “2” for second step, “3” for
third step, and so on.

A. Opening a New Blank Worksheet

After opening the start button, type the spreadsheet application in the
search bar and select the icon.

Once the spreadsheet is open, click the “Blank Workbook” to start a new
workbook.

Welcome to spreadsheet application, you are good to go!

Click the start button.

Click the spreadsheet icon to open and proceed in the workbook.

B. Opening a Saved Spreadsheet Document

Select the file you want to open.

Click Open. (Shortcut)

Click the File tab.

Wait for the spreadsheet to respond.

Select the location where the file is saved.

C. Closing a Spreadsheet application.

If there will be progress of the file in the spreadsheet, saving your file is
needed.

Click the “X” icon to close the spreadsheet.

In the spreadsheet workbook, Go to home above the bar.

Assign a file name and save your spreadsheet document.

3
12
 Let’s See What You Have Learned

I. Directions: List down the steps on how to save spreadsheet to a location

on a drive.

1._________________________________________________________

2._________________________________________________________

3._________________________________________________________

4._________________________________________________________

5._________________________________________________________

Let’s Remember and Review

Spreadsheet is a software that assists users in processing and analyzing

tabular data.

It is a computerized accounting tool. Data is always entered in a cell

(Intersection of a row and a column)

Some of the popular spreadsheet software include MS Excel, Numeric,

Google sheet etc.

A. Steps on how to open a Spreadsheet

1. Click the start button.

2. If open, type “Excel” in the search bar and see Excel icon to pop-up.

3.Click the excel icon to open and wait to proceed in the spreadsheet.

4.Once the spreadsheet is open, click the ‘Blank Workbook” to start a new
spreadsheet workbook.

5.Welcome to MS excel spreadsheet, you are good to!

3
13
B. Steps on how to close a Spreadsheet

1.If there will be progress of the file in the spreadsheet, saving your file is
needed.

2.Click the “X” icon to close the spreadsheet.

3.In the spreadsheet workbook, Go to home above the bar.

4.Assign a file name and save your spreadsheet document.

C. Steps on the Saved Spreadsheet Document

1.Select the file you want to open.

2.Click Open. (Shortcut)

3.Click the File tab.

4.Click Open.

5.Select the location where the file is saved.

Let’s See What you Have Learned?

A. Directions: Read and analyze the following questions and select the best answer.
Write the correct answer in the Answer Sheet.
1. What is the vertical line in a spreadsheet?

A. Cell

B. Row

C. Column

D. Gridlines

2. What is the first step in opening the spreadsheet application?

A. Click the start button.

B. Click the excel icon to open and wait to proceed in the spreadsheet
workbook.

C. Welcome to MS excel spreadsheet, you are good to go!

D. If open, type “Excel” in the search bar and see Excel icon to pop-up.

3
14
2. Arrange the following statement in closing a spreadsheet Excel below.

I. Click the “X” icon to close the spreadsheet.

II. In the spreadsheet workbook, Go to home above the bar.

III. Save your file, assign a file name, and save your spreadsheet document.

A. II – I - III

B. I – II - III

C. III – II - I

D. II – III – I

4. It is a cell that is currently selected and highlighted by a rectangular box.

A. cell

B. active cell

C. worksheet

D. spreadsheet

5. In the spreadsheet application window, where can you find the name of your
workbook?

A. Title bar

B. Status bar

C. Address bar

D. Formula bar

15
3
B. Directions: Match Column A with corresponding item in Column B. Write your
answer on the space provided for each number.

Column A Column B
_____1.

A. Once the spreadsheet is

open, click the “Blank
Workbook” to start a new
spreadsheet workbook.

_____2.

B. Click the start button.

_____3.

C. Welcome to MS excel
spreadsheet, you are good
to go!

_____4.

D. If open, type “Excel” in the

search bar and see Excel
icon to pop-up.

_____5.

E. Click the excel icon to

open and wait to proceed in
the spreadsheet workbook.

16
3
 17
3
Let’s See What Let Solve This
You Have Problem
Learned 1. FILE MENU
A. 2. FORMULA BAR
1. C 3. COLUMN
2. A 4. SPREADSHEET
3. A 5. WORKSHEET
4. B 6. WORKBOOK
5. A 7. CELL
8. EXCEL
B. 9. ACTIVE CELL
1. C 10. ADDRESS BAR
2. D
3. E
4. B
5. A
Let’s Try This Let see What You
A. B. C. Already Know
3 2 1 I. T/F
4 3 4 1. T
5 1 2 2. F
1 4 3 3. F
2 5 4. T
5. T
II. MC
What You have 1. A
Learned 2. B
3. C
Answers may vary 4. A
5. A
Answer Key
Glossary

Cell A cell is a smallest but most powerful part of a

spreadsheet. You can enter your data into a cell either
by typing or by copy-paste

Worksheet A worksheet is made up of individual cells which can

contain a value, a formula, or text. It also has an
invisible draw layer, which holds charts, images, and
diagrams.

Workbook A workbook is a separate file just like every other

application has. Each workbook contains one or more
worksheets.

Column A column is a vertical set of cells.

Row A row is a horizontal set of cells.

Fill Handle It’s a small dot present in the lower right corner of the
active cell.

Address Bar It shows the address of the active cell.

Formula Bar The formula bar is an input bar, below the ribbon. It
shows the content of the active cell, and you can also
use it to enter a formula in a cell.

Title Bar The title bar will show the name of your workbook,
followed by the application name (“Microsoft Excel”).

File Menu The file menu is a simple menu like all other
applications.

Quick Access A toolbar to quickly access the options which you

Toolbar frequently use

Ribbon Ribbon tabs are a bunch of specific option group which

further contains the option.

Worksheet Tab This tab shows all the worksheets which are present in
the workbook.

Status Bar It is a thin bar at the bottom of the Excel window.

18
3
References
“An Introduction to Microsoft Excel | Basics Knowledge + Components + Examples”
Punnet @Excelchamps 2023

https://excelchamps.com/excel-basics/. Accessed on June 6, 2023 How to Open

an Excel Workbook. 2023 CustimGuide Inc.
https://www.customguide.com/excel/open-excel-workbook/ Accessed on June 21,
2023

19
3
For inquiries or feedback, please write or call:

Department of Education - Bureau of Alternative Education (DepEd-BAE)

5th Floor, Bonifacio Bldg., DepEd Complex

Meralco Avenue, Pasig City, Philippines 1600

Telephone No.: 08-636-3603

Email Address: bae.od@deped.gov.ph * bae.pmsdd@deped.gov.ph