Empowerment Technologies Quarter 1 Module 4.2: Applied Productivity Tools using Spreadsheet

SHS Empowerment Technologies Q1 Module 4.2 teaches spreadsheet skills in Excel: formatting, formulas, linked sheets, and charts through a budget project.

This is the Self-Learning Module for Empowerment Technologies, Quarter 1, Module 4.2: Applied Productivity Tools using Spreadsheet. It is a Senior High School Alternative Delivery Mode (ADM) module from DepEd National Capital Region. It covers Lesson 2, Working with Spreadsheet, and walks learners step by step through building a simple monthly budgeting workbook in Microsoft Excel. By the end, learners should be able to explain what a spreadsheet is, create and format a table of data in Excel, and see why Excel is useful.

On this page 7 sections

What learners will learn

The module lists these learning competencies:

  • Uses common productivity tools effectively by maximizing advanced application techniques (CS_ICT11/12-ICTPT-Ic-d-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-Ic-d-5)

After going through the module, learners are expected to:

  1. Explain what a spreadsheet is.
  2. Create a table of data and format it using Microsoft Excel.
  3. Recognize the importance of using Microsoft Excel.

Lessons in Module 4

Module 4 on applied productivity tools has three lessons. This file contains only Lesson 2.

  • Lesson 1: Working with Word Processor
  • Lesson 2: Working with Spreadsheets: organizing data with cell formatting, formulas, linked sheets, and charts. This is the lesson in this file.
  • Lesson 3: Working with Slides

What the lesson teaches

The lesson explains that spreadsheet applications such as Microsoft Excel and Google Spreadsheets let you store, organize, analyze, and interpret large sets of data automatically. The main project is a basic budgeting workbook named My Weekly Budget. The module uses Microsoft Excel. It notes that OpenOffice and LibreOffice also work with minor changes in the steps.

Formatting the spreadsheet

  • Add and rename sheets: click the plus icon beside the sheet tabs to add a sheet. Double-click a sheet name to rename it. In the example, the sheets become Income and Expense.
  • Enter data: the Expense sheet lists items such as rent, electricity, groceries, and insurance, each with a date and an amount. The Income sheet lists salary and business income.
  • Resize columns and rows: click and drag the edge of a column or row heading.
  • Drag select: click the first cell, hold Shift, then click the last cell.
  • Bold and center headings: use Home > Bold and Home > Center.
  • Format as a table: use Home > Format as Table and pick a style, such as Table Style Light 9 for the Expense sheet and Light 10 for the Income sheet.
  • Show amounts in pesos: right-click the selected cells, choose Format Cells, then open the Number tab. Choose Currency, pick the peso sign (₱) or PHP, and set the decimal places to 0.

Save your work often with Ctrl + S.

Formulas and linked sheets

FormulaWhat it does
=SUM(C2:C3)Adds the values in cells C2 to C3
=Income!C4Shows the value of cell C4 from the sheet named Income
=B3-B4Subtracts B4 from B3 (income minus expenses)

A third sheet, Report Summary, holds three rows: Total Monthly Income, Total Monthly Expenses, and Cash Remaining. These cells pull their totals from the other sheets using sheet references. The part before the exclamation mark, as in Expense!, names the sheet where the cell is found. The heading is styled with bold, font size 15, green fill, white font, and centered text.

Making a chart

To chart the data:

  1. Select the income and expense totals, then click Insert > Insert Pie or Doughnut Chart.
  2. Double-click the chart title to rename it, for example to FINANCIAL SUMMARY PIE GRAPH.
  3. Drag any handle on the chart’s edge to resize it.
  4. Hover on the chart’s edge, then click and drag to move it.

Activities in the module

  • What I Know: a 15-item multiple-choice pretest.
  • What’s New, My Expenses: record your own daily expenses for seven days, with the item, amount, and date.
  • What’s More, Activity 1.1 Jose’s Budgeting: build a budget workbook for Jose, a college working student. It needs two sheets, Allowance & Expense and Summary, and the Summary sheet includes a pie chart.
  • What I Have Learned: write short answers on how a spreadsheet improves the presentation of data and on its main advantage for organizing and sorting data.
  • What I Can Do, My Budgeting Application: use your own My Expenses data to make a workbook with three sheets: Allowance, Expense, and Budget Summary.
  • Assessment: a 15-item multiple-choice post-test.
  • Additional Activities, Explore and Expand: study a guide to basic Excel formulas linked in the module. Then make a workbook called Formulas that uses AVERAGE, counts cells with numbers, counts cells with any entry, and displays one cell’s content in another cell.

How to use this module

  • Learners: take the pretest first to check what you already know. Then follow the steps in What is It on a computer, saving as you go. Write your answers on a separate sheet of paper, not on the module. Answer keys for the pretest and the assessment are at the end; use them honestly after you finish.
  • Parents and facilitators: help your child find time on a computer with Excel or a similar program. Encourage them to ask the teacher when a step is unclear.
  • Teachers: the Jose’s Budgeting and My Budgeting Application workbooks make good outputs to collect and check. Check the answer key before using it, since some answers may not match the questions.

Frequently asked questions

What grade level is this Empowerment Technologies module for?

It is a Senior High School module. Its competency codes (CS_ICT11/12) cover Grades 11 and 12, and it is for Quarter 1.

What does Module 4.2 cover?

It covers Lesson 2, Working with Spreadsheet. Learners build a budgeting workbook in Microsoft Excel using cell formatting, peso currency formatting, SUM and subtraction formulas, references to other sheets, and a pie chart.

Does the module have an answer key?

Yes. The last pages have answer keys for the 15-item What I Know pretest and the 15-item Assessment.

What does Expense! mean in the formula =Expense!C12?

It tells Excel that cell C12 is on the sheet named Expense. The formula shows that cell’s value on the current sheet.

Can I use software other than Microsoft Excel?

The module uses Microsoft Excel. It says OpenOffice and LibreOffice can also be used with minor changes in the steps.

Full text of the module

The text below is a transcription of the PDF above, as printed.

Empowerment Technologies Quarter 1- Module 4.2: Applied Productivity Tools using Spreadsheet

Senior High School

[illustration: students learning at home under a tree, at a desk with a globe and a lamp]

CO_Q1_Empowerment Technologies SHS Module 4.2

Empowerment Technologies Alternative Delivery Mode Quarter 1- Module 4.2: Applied Productivity Tools using Spreadsheet First Edition, 2020

Republic Act 8293, section 176 states that: No copyright shall subsist in any workof 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: Leonor Magtolis Briones Undersecretary: Diosdado M. San Antonio

Development Team of the Module

Writers: Kiel Ajello Z. Pecjo Editor: Lorena J. Mutas Reviewers: June Rose A. Estrada Illustrator: Kiel Ajello Z. Pecjo Layout Artist: Kiel Ajello Z. Pecjo Management Team: Malcom S. Garma, Director IV Genia V. Santos, CLMD Chief Dennis M. Mendoza, Regional EPS In Charge of LRMS Micah S. Pacheco, Regional ADM Coordinator Loida O. Balasa, CID Chief Grace R. Nieves, Division EPS In Charge of LRMS Lorena J. Mutas, Division ADM Coordinator

Printed in the Philippines by _____________________

Department of Education – National Capital Region

Office Address: Misamis St., Bago Bantay, Quezon City

Telefax: 02-929-0153 E-mail Address: depedncr@deped.gov.ph

Empowerment Technologies

Quarter 1 – Module 4.2: Applied Productivity Tools using Spreadsheet

Senior High School

Introductory Message

This Self-Learning Module (SLM) is prepared so that you, our dear learners, can continue your studies and learn while at home. Activities, questions, directions, exercises, and discussions are carefully stated for you to understand each lesson.

Each SLM is composed of different parts. Each part shall guide you step-by-step as you discover and understand the lesson prepared for you.

Pre-tests are provided to measure your prior knowledge on lessons in each SLM. This will tell you if you need to proceed on completing this module or if you need to ask your facilitator or your teacher’s assistance for better understanding of the lesson. At the end of each module, you need to answer the post-test to self-check your learning. Answer keys are provided for each activity and test. We trust that you will be honest in using these.

In addition to the material in the main text, Notes to the Teacher are also provided to our facilitators and parents for strategies and reminders on how they can best help you on your home-based learning.

Please use this module with care. Do not put unnecessary marks on any part of this SLM. Use a separate sheet of paper in answering the exercises and tests. And read the instructions carefully before performing each task.

If you have any questions in using this SLM or any difficulty in answering the tasks in this module, do not hesitate to consult your teacher or facilitator.

Thank you.

What I Need to Know

This module was designed and written with you in mind. It is here to help you applied productivity tools with basic and advanced application techniques. The scope of this module permits to be used in many different learning situations. The language used recognize the diverse vocabulary level of students. The lessons are arranged to follow the standard sequence of the course. But the order in which you read them can be changed to correspond with the textbook you are now using.

The module is divided into three lessons, namely:

  • Lesson 1 – Working with Word Processor
  • Lesson 2 – Working with Spreadsheets
  • Lesson 3 – Working with Slides

Learning Competencies and Codes:

  1. Uses common productivity tools effectively by maximizing advanced application techniques. CS_ICT11/12-ICTPT-Ic-d-4
  2. Creates an original or derivative ICT content to effectively communicate or present data or information related to specific professional tracks. CS_ICT11/12-ICTPT-Ic-d-5

After going through this module, you are expected to:

  1. Explain what a spreadsheet is.
  2. Create a table of data and format it using Microsoft Excel.

Recognize the importance of using Microsoft Excel.

What I Know

Directions: Choose the letter of the best answer. Write the chosen letter on a separate sheet of paper.

  1. Harold wants to drag select cells A1 to D7. How can he accomplish this?

    • A. Long press Alt then click A1 then click D7.
    • B. Select A1 then D7 while pressing shift
    • C. Type A1:D7 in the formula bar
    • D. Press Ctrl + A.
  2. What is the formula that will subtract the contents of the cells A7 to A8?

    • A. A7 – A8
    • B. = A7 – A8
    • C. A7 – A8 =
    • D. =SUM (A7:A8)
  3. How can you create a new tab in Windows Excel?

    • A. In the ribbon, select Home>Tabs>Add Tabs then input how many you like to add.
    • B. Press Ctrl + A then press Ctrl + Shift + n.
    • C. You can’t add tabs in Microsoft Excel.
    • D. In lower portion of the work area, press the plus button besides the tabs.
  4. How to format a cell that will automatically add a peso sign?

    • A. Select the cell or cells you want to edit then press Insert > Symbol > More Symbols. Scroll down and look for the peso sign then press insert.
    • B. Select the cell or cells you like to add formatting. Press right click then click Symbol > More Symbols. Scroll down and look for the peso sign then press insert.
    • C. In the ribbon, select the Home tab then click Format Cells. In the Number tab, click Currency then in the dropdown box search for the peso sign symbol.
    • D. Select the cell or cells you like to add formatting press right click then Format Cells. Then in the Number tab, click Currency then in the dropdown box search for the peso sign symbol.
  5. What computer program that gives the user the ability to create tables and edit their values.

    • A. Presentation
    • B. Word
    • C. Spreadsheet
    • D. Outlook
  6. Which Ribbon Menu is needed to be selected to change the font?

    • A. Home
    • B. Insert
    • C. Page Layout
    • D. Cell Formatting
  7. How do you resize a column or width?

    • A. Select the cell the press right click, select format cell then change height and width values.
    • B. In the Formula bar type (h[value]:w[value]).
    • C. Click the cell then in the ribbon select format cell then change height and width values.
    • D. Click and drag the column or row heading
  8. How do you change formula style in a sheet?

    • A. Click Insert > Cell Formatting > Table Format > Table Style
    • B. Click Home > Format as Table > Table Style
    • C. Click Cell Formatting > Format Table > Table Style
    • D. You have to select each cell then add cell borders to each of them
  9. What is the formula that will add the contents of the cells C1 and C10?

    • A. C1 + C10
    • B. = C1 + C10
    • C. C1 + C10 =
    • D. SUM (C1:C3)
  10. Which Ribbon Menu is needed to add a Chart?

    • A. Home
    • B. Insert
    • C. Page Layout
    • D. Cell Formatting
  11. How do you resize a graph?

    • A. Click the graph then click and drag any of the handles in the edges of the graph.
    • B. Select the table then press right click, a window will appear, select the Width change the value desired then select height change the value desired.
    • C. Select the table the press Ctrl + Arrow Keys.
    • D. You can’t change the size of graphs.
  12. How do you rename a graph into “First Data” in Microsoft Excel?

    • A. Press right click then select rename, a window will appear then type “First Data”.
    • B. Press Ctrl + A then Ctrl + R, rename the chart to “First Data”
    • C. Double click the name of the chart and type “First Data”.
    • D. Graph names can’t be changed as they follow the name from the selected data
  13. What is the purpose of the Formula Bar?

    • A. It allows an easy to see input box for formula in a cell
    • B. It is a selection of shortcuts different formula in Microsoft Excel
    • C. It is the formula that allows computation of values from different cells.
    • D. The Formula Bar is a label below the cell that indicates the result of a formula
  14. How do you assign which cell the formula = (A1 + A2) + A3 will be displayed on?

    • A. On the formula bar type cell address
    • B. Press right click then select Cell Format then click on the Formula tab, type which cell you want that formula will be displayed
    • C. Click Cell Formatting then select the formula then type where it will displayed.
    • D. Type the formula where you want it to be displayed on.
  15. With this formula = Expense!C12, what does the Expense! part means?

    • A. It a variable that allows quick reference of a value.
    • B. It is formula label, allowing the user to manage all the formula.
    • C. It indicates that the c12 to be displayed is on the sheet Expense
    • D. This is not a proper use of the formula.

Lesson 2: Working with Spreadsheet

The ability to organize data to a usable information is an important skill you need to learn. Spreadsheet applications like Microsoft Excel and Google Spreadsheets allow large set or group of data to be stored, organized, analyzed and interpreted automatically.

What’s In

This lesson will focus on the advanced use of spreadsheet applications. In creating a basic budgeting application, you will create a presentable basic budgeting application where you can input financial data, as your output. You will be able to create a spreadsheet application using the following:

  • Cell Formatting
  • Conditional Formatting
  • Advance Formulas
  • Linked Tales.

Microsoft Excel will be used in the following activities. You may also use Google Slides, OpenOffice and Libre Office with minor changes in the steps

What’s New

My Expenses

Open a spreadsheet. Record or write your daily expenses within a week. Specify the expense, the amount, and the date it is made. Follow the given example as your reference.

Example: MY DAILY EXPENSES

DAY 1 – July 06, 2019 (Sunday) Food (Snacks) – Php 20 School Supplies – Php 30

Day 2 – July 07, 2019 (Monday) Transport Allowance – Php 20 Food (Lunch) – Php 35 Computer Shop – Php 15

Continue until Day 7

What is It
Formatting the Spreadsheet
  1. In your desktop, create a document named ‘My Weekly Budget’. Always Remember to save your progress by pressing Ctrl + S.
  2. Create an additional tab by clicking the plus icon in the sheets tab below. (as shown by a red box in Figure 2.1)

[illustration: sheet tabs showing “Sheet1” and a plus icon outlined in a red box, with the tooltip “New sheet”]

Figure 2.1: Adding new sheets

  1. Rename Sheet1 by double click its name and change it to Income. Do the same with Sheet2 and change it to Expense. (see Figure 2.2)

[illustration: sheet tabs showing “Income” and “Sheet2” with a plus icon]

Figure 2.2: Renaming Sheets

  1. Select the Income tab and type the following data as seen in Figure 2.3. Then click the Expense tab and type the following data as seen in Figure 2.3
EXPENSEDATEAMOUNT
Rent/mortgageJanuary 3, 20191000
ElectricJanuary 5, 20191200
Car GasolineJanuary 5, 20191000
Cellphone LoadJanuary 5, 2019500
FoodJanuary 10, 20203000
GroceriesJanuary 10, 20193200
Car Loan PaymentJanuary 16, 20195000
Credit CardsJanuary 16, 20191020
InsuranceJanuary 16, 20191500
Personal careJanuary 20, 2019600
EntertainmentJanuary 20, 2019500
MiscellaneousJanuary 20, 2019480
Car ExpensesJanuary 22, 20192000
Business ExpensesJanuary 29, 20196000

Figure2.3: Expense Tab

  1. To adjust the cell width or height, click and drag the edge of the column or row heading respectively as seen in Figure 2.4

[illustration: spreadsheet column and row headings; labels read “Click and drag Column Heading to change Width” and “Click and drag Row Heading to change Width”]

Figure 2.4: Adjusting Column

  1. Go to the Income tab, then drag select cells A1 to C1. While the A1 to C3 cells are selected, in the ribbon click Home > Center then click Home > Bold as seen in Figure 2.5. Do the same for the Expense tab.

[illustration: Home ribbon with the Bold and Center buttons labeled “Bold” and “Center”; spreadsheet fragment below]

INCOMEDATEAMOUNT
SalaryJanuary 21, 201925000
Business IncomeJanuary 29, 201970000

Figure 2.5: Bold and Center

NOTE: Drag Selection You drag select by clicking on the first cell while pressing shift key, then click the second cell specified. Particularly in Figure 2.4 you can do this on A1 then, while pressing shift, press C1.

  1. In the Expense tab, drag select from A1 to C15 then from the ribbon, click Home > Format as Table > Table Style Light 9 as specified in Figure 2.2. A prompt will appear as seen in Figure 2.6 that validates the selection range, then press OK. Do the same to A1 to C3 in the Income tab but use Table Style Light 10 instead.

[illustration: Format as Table gallery with a box labeled “Cell Formatting” and an arrow to the gallery; spreadsheet fragment with EXPENSE, DATE, and AMOUNT columns]

Figure 2.6: Cell Format Selection Pan

  1. In the Expense tab, drag select C2 to C16, press right click > Format Cells (see Figure 2.7), the Format Cell Window will appear.

[illustration: right-click context menu with “Format Cells…” highlighted; other items listed are Sort, Insert Comment, Pick From Drop-down List…, and Define Name…]

Figure 2.7 Format Cell

  1. Format Cell Window will appear. In the Number tab, press Currency and search in the dropdown box for the Peso sign symbol (₱) or PHP. Change decimal places to 0 then press OK. (see Figure 2.8)

[illustration: Format Cells dialog, Number tab; Category list shows Currency selected; Sample ₱1,000; Decimal places 0; Symbol ₱]

Figure 2.8 Format Cell Window

  1. Do steps 8 and 9 for C2 to C4 to the Income tab.
Report Summarization
  1. In the Income tab, click C4 then type =SUM(C2:C3). This will automatically compute the sum of cells C2 to C3 as seen in Figure 2.9

Do the same for the Expense tab, but use the code =SUM(C2:C15) instead.

  1. Create another tab, rename it Report Summary.

Figure 2.9 Format Cell Window

ABCD
1Financial Summary
2
3Total Monthly Income
4Total Monthly Expenses
5Cash Remaining
  1. In Report Summary tab, type the data as seen in Figure 2.9. Notice the space between A1 and A3.


  2. Select A1, then in the Home tab in the ribbon, edit the following: (see Figure 2.10)


    a) Bold
    b) Change Font Size to 15.
    c) Change Fill Color to Green.
    d) Change Font Color to White.
    e) Center


[illustration: Home tab ribbon with Calibri font size 15 and the labels a to e marking Bold, font size, fill color, font color, and Center; formula bar shows “Financial Summary”]

Figure 2.9 Text settings and Formatting

  1. Drag select A3 to A5 then click Home > Bold.


  2. Select B3 then type = Income!C4, this will display the content of C4 in the Income tab. (see Figure 2.11)


  3. Do the same with B4 but type = Expense!C12.


  4. Select B5, then type =B3-B4 as seen in Figure 2.12. This formula will display the difference between B4 and B3.


  5. Drag select B3 to B5, press right click > Format Cells, the Format Cell Window will appear. In the Number Tab, press Currency and search in the dropdown box for the Peso sign symbol (₱) or PHP as seen in Figure 2.8, press OK.


AB
1Financial Summary
2
3Total Monthly Income32000
4Total Monthly Expenses27000

[illustration: formula bar shows “=Income!C4” with cell B3 selected]

Figure 2.11: Total Income

ABC
1Financial Summary
2
3Total Monthly Income32000
4Total Monthly Expenses27000
5Cash Remaining5000

[illustration: formula bar shows “=B3-B4” with cell B5 selected]

Figure 2.12 Total

Table Creation
  1. To create a graph, drag select A3 to B4 then press Insert> Insert Pie or Doughnut Chart as seen in Figure 2.13.

[illustration: Insert ribbon with the Insert Pie Chart button labeled “Insert Pie Chart”; spreadsheet fragment shows “Total Monthly Income” with ₱32,000]

Figure 2.13: Insert Pie Chart

  1. Double click on the Title of the graph and change it into FINANCIAL SUMMARY PIE GRAPH as seen in Figure 2.14.

[chart: pie chart; Figure 2.14 Chart Renaming] Labels: chart title “FINANCIAL SUMMARY PIE GRAPH” (labeled “Chart Title”); legend entries “Total Monthly Income” and “Total Monthly Expenses”; cells to the left show ₱32,000 and ₱27,000 (partly visible). Values are not labeled on the chart.

Figure 2.14 Chart Renaming

  1. To resize the graph, click and drag the lower rightmost handle then move the mouse to the left as seen in Figure 2.15. Any handles can be used in this purpose as long as you drag away from the handle you clicked.

[illustration: resized chart with a broken arrow; label reads “Drag lower right handle in the direction of the broken arrow”]

Figure 2.15: Table Resize

  1. To move the graph, hover on the edge of the chart then click and drag it anywhere you want it to move.

[illustration: pie chart with a move cursor at the chart edge; label reads “Hover on the edge, then drag and click”]

Figure 2.15: Moving a Table

What’s More
Activity 1.1 Jose’s Budgeting

Jose, a college working student, wants to create a budgeting spreadsheet application for a month’s worth of financial activity. Create a similar Budgeting Spreadsheet Application following the lesson discussed earlier with the data provided in Figure 2.16. It must have two (2) tabs namely Allowance & Expense and Summary.

IncomeAmounExpenseAmount
Parent’s Allowance₱500Food₱850
Sallary₱5,000Transport₱700
Extra Income₱300Dormitory₱1,000
₱5,800School Expenses₱1,750
School Supplies₱250
Misc.₱500
₱5,050

[transcriber’s note: the second column header is cut off in the image and reads “Amoun”; the fourth column header reads “Amoun” as well, and both are transcribed as printed]

Figure 2.16: Jose’s Budgeting Data

The Allowance & Expense tab contains Jose’s source of income and its amount as well as his expenses and amount. Follow the formatting as seen in Figure 2.16.

The Summary tab must contain a summary of the total income, expense, and the remaining money along with the pie chart. This is similar to what you did in the discussion.

What I Have Learned

In a piece of paper, write a narrative on what you have learned based on the following concepts:

  1. How does a Spreadsheet application improve the presentation of your data?


  1. What is the main advantage of using a Spreadsheet in terms of organizing and sorting data?


What I Can Do
My Budgeting Application

Using data from the previous activity in the lesson My Expenses, create a similar Budgeting Spreadsheet Application. It must have three (3) tabs namely: Allowance, Expense and Budget Summary. Like the activity earlier, Allowance tab contains your source allowance (and income if any) and its amount. The Expense tab contains different expenses and their amount. The Budget Summary tab must contain a summary of the total income, expense and the remaining money.

Assessment

Directions: Choose the letter of the best answer. Write the chosen letter on a separate sheet of paper.

  1. Based on the activities, what is the use of a Spreadsheet software?

    • A. It allows the data to be stored, organized and analyzed.
    • B. It gives the user the ability to create tables.
    • C. It enables users to record words and numbers.
    • D. It is a software that allows input, editing, formatting and output of text
  2. How can you create a new tab in Windows Excel?

    • A. In the ribbon, select Home>Tabs>Add Tabs then input how many tab you like to add.
    • B. In lower portion of the work area, press the plus button besides the tabs.
    • C. Press Ctrl + A then press Ctrl + Shift + N.
    • D. You can’t add tabs in Microsoft Excel.
  3. Harold wants to drag select cells A1 to D7. How can he accomplish this?

    • A. Long press Alt then click A1 then click D7.
    • B. While pressing shift select the A1 then D7
    • C. In the formula bar type A1:D7
    • D. Press Ctrl + A.
  4. What is the formula that will subtract the contents of the cells A7 and A8?

    • A. A7 – A8
    • B. = A7 – A8
    • C. A7 – A8 =
    • D. =SUM (A7:A8)
  5. How to format a cell that will automatically add a peso sign?

    • A. Select the cell or cells you want to edit then press Insert > Symbol > More Symbols. Scroll down and look for the peso sign then press insert.
    • B. Select the cell or cells you like to add formatting. Press right click then click Symbol > More Symbols. Scroll down and look for the peso sign then press insert.
    • C. In the ribbon, select the Home tab then click Format Cells. In the Number tab, click Currency then in the dropdown box search for the peso sign symbol.
    • D. Select the cell or cells you like to add formatting press right click then Format Cells. Then in the Number tab, click Currency then in the dropdown box search for the peso sign symbol.
  6. How do you resize a column or width?

    • A. Select the cell the press right click, select format cell then change height and width values.
    • B. In the Formula bar type (h[value]:w[value]).
    • C. Click the cell then in the ribbon select format cell then change height and width values.
    • D. Click and drag the column or row heading.
  7. What is the formula that will add the contents of the cells C1 and C10?

    • A. C1 + C10
    • B. = C1 + C10
    • C. C1 + C10 =
    • D. SUM (C1:C3)
  8. How do you resize a graph?

    • A. Click the graph then click and drag any of the eight handles in the edges of the graph.
    • B. Select the table then press right click, a window will appear, select the Width change the value desired then select height change the value desired.
    • C. Select the table the press Ctrl + Arrow Keys.
    • D. You can’t change the size of graphs.
  9. How do you rename a graph into “First Data” in Microsoft Excel?

    • A. Press right click then select rename, a window will appear then type “First Data”.
    • B. Press Ctrl + A then Ctrl + R, rename the chart to “First Data”
    • C. Double click the name of the chart and type “First Data”.
    • D. Graph names can’t be changed as they follow the name from the selected data.
  10. What is the purpose of the Formula Bar?

    • A. It allows an easy to see input box for formula in a cell
    • B. It is a selection of shortcuts different formula in Microsoft Excel
    • C. It is the formula that allows computation of values from different cells.
    • D. The Formula Bar is a label below the cell that indicates the result of a formula
  11. Which Ribbon Menu is needed to be selected to change the font?

    • A. Home
    • B. Insert
    • C. Page Layout
    • D. Cell Formatting
  12. How do you assign which cell the formula = (A1 + A2) + A3 will be displayed on?

    • A. On the formula bar type cell address
    • B. Press right click then select Cell Format then click on the Formula tab, type which cell you want that formula will be displayed
    • C. In the ribbon click Cell Formatting then select the formula then type where it will displayed.
    • D. Type the formula where you want it to be displayed on.
  13. Which Ribbon Menu is needed to add a Chart?

    • A. Home
    • B. Insert
    • C. Page Layout
    • D. Cell Formatting
  14. With this formula = Expense!C12, what does the Expense! part means?

    • A. It a variable that allows quick reference of a value.
    • B. It is formula label, allowing the user to manage all the formula.
    • C. It indicates that the c12 to be displayed is on the sheet Expense
    • D. This is not a proper use of the formula.
  15. How do you change formula style in a sheet?
    a. Click Insert > Cell Formatting > Table Format > Table Style
    b. Click Home > Format as Table > Table Style
    c. Click Cell Formatting > Format Table > Table Style
    d. You have to select each cell then add cell borders to each of them


Additional Activities

Explore and Expand: Using the link/QR code reader/scanner provided, study the Basic Formula guides (Seven Basic Excel Formulas for Your Workflow). Create a new excel document called ‘Formulas‘ and accomplish the following:

  1. In cell A6, output the AVERAGE of A1 to A5.
  2. Count how many cells has numbers from B1 to B9 display the answer in B10.
  3. Count how many cells has inputs (regardless if it is text or number) from C1 to C9 display the answer in C10.
  4. In cell D2, it will display whatever is in Cell D1.

[illustration: QR code]

https://corporatefinanceinstitute.com/resources/excel/study/basic-excel-formulas-beginners/

Answer Key

[illustration: answer key sheet printed upside down]

What I KnowAssessment
1. C1. A
2. B2. B
3. D3. B
4. D4. B
5. C5. D
6. A6. D
7. D7. B
8. B8. A
9. B9. C
10. B10. A
11. A11. A
12. C12. D
13. A13. B
14. D14. C
15. C15. B

[transcriber’s note: the answer key table is printed upside down on the page; the values were read from the rotated text]

References

Bandala, Argel et. al. Empowerment Technologies. Diwa Learning Town, 2016

Wikipedia. “Word Processor”. Last modified October 15, 2019. https://en.wikipedia.org/wiki/Word_processor.

Corporate Finance Institute. “Basic Excel Formula Guide”, Last modified October 27, 2019. https://corporatefinanceinstitute.com/resources/excel/study/basic-excel-formulas-beginners/s

For inquiries or feedback, please write or call:

Department of Education – Bureau of Learning Resources (DepEd-BLR) Ground Floor, Bonifacio Bldg., DepEd Complex Meralco Avenue, Pasig City, Philippines 1600

Telefax: (632) 8634-1072; 8634-1054; 8631-4985

Email Address: blr.lrqad@deped.gov.ph * blr.lrpd@deped.gov.ph

One response to “Empowerment Technologies Quarter 1 Module 4.2: Applied Productivity Tools using Spreadsheet”

  1. emilyn villahermoso

    please provide complete topic for module 4.1 for empowerment technologies

Leave a Reply

Your email address will not be published. Required fields are marked *

For students and teachers

Looking for a school?

Look up the enrollment, teachers, classrooms and facilities of more than 60,000 schools across the Philippines, from DepEd’s public data. Free to use.

Philippine Schools Directory by TeacherPH · every region, province, division and district