ADMSHS_Emp_Tech_Q1_M4_L2-Applied-Productivity-Tools-Using-Spread

Empowerment

Technologies

Quarter 1- Module 4.2: Applied Productivity Tools using Spreadsheet

What I Need to Know

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.
3. 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.

Multiple Choice

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

• Long press Alt then click A1 then click D7.

• Select A1 then D7 while pressing shift

• Type A1:D7 in the formula bar

• Press Ctrl + A.

Multiple Choice

What is the formula that will subtract the contents of the cells A7 to A8?

• A7 - A8

• A7 - A8

• A7 - A8 =

• =SUM (A7:A8)

Multiple Choice

How can you create a new tab in Windows Excel?

• In the ribbon, select Home>Tabs>Add Tabs then input how many you like to add.

• Press Ctrl + A then press Ctrl + Shift + n.

• You can’t add tabs in Microsoft Excel.

• In lower portion of the work area, press the plus button besides the tabs.

Multiple Choice

How to format a cell that will automatically add a peso sign?

• 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.

• 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.

• 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.

• 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.

Multiple Choice

What computer program that gives the user the ability to create tables and edit their values.

• Presentation

• Word

• Spreadsheet

• Outlook

Multiple Choice

Which Ribbon Menu is needed to be selected to change the font?

• Home

• Insert

• Page Layout

• Cell Formatting

Multiple Choice

How do you resize a column or width?

• Select the cell the press right click, select format cell then change height and width values.

• In the Formula bar type (h[value]:w[value]).

• Click the cell then in the ribbon select format cell then change height and width values.

• Click and drag the column or row heading

Multiple Choice

How do you change formula style in a sheet?

• Click Insert > Cell Formatting > Table Format > Table Style

• Click Home > Format as Table > Table Style

• Click Cell Formatting > Format Table > Table Style

• You have to select each cell then add cell borders to each of them

Multiple Choice

What is the formula that will add the contents of the cells C1 and C10?

• C1 + C10

• = C1 + C10

• C1 + C10 =

• SUM (C1:C3)

Multiple Choice

Which Ribbon Menu is needed to add a Chart?

• Home

• Insert

• Page Layout

• Cell Formatting

Multiple Choice

How do you resize a graph?

• Click the graph then click and drag any of the handles in the edges of the graph.

• 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.

• Select the table the press Ctrl + Arrow Keys.

• You can’t change the size of graphs.

Multiple Choice

How do you rename a graph into “First Data” in Microsoft Excel?

• Press right click then select rename, a window will appear then type “First Data”.

• Press Ctrl + A then Ctrl + R, rename the chart to “First Data”

• Double click the name of the chart and type “First Data”.

• Graph names can’t be changed as they follow the name from the selected data

Multiple Choice

What is the purpose of the Formula Bar?

• It allows an easy to see input box for formula in a cell

• It is a selection of shortcuts different formula in Microsoft Excel

• It is the formula that allows computation of values from different cells.

• The Formula Bar is a label below the cell that indicates the result of a formula

Multiple Choice

How do you assign which cell the formula = (A1 + A2) + A3 will be displayed on?

• On the formula bar type cell address

• Press right click then select Cell Format then click on the Formula tab, type which cell you

  want that formula will be displayed

• Click Cell Formatting then select the formula then type where it will displayed.

• Type the formula where you want it to be displayed on.

Multiple Choice

With this formula = Expense!C12, what does the Expense! part means?

• It a variable that allows quick reference of a value.

• It is formula label, allowing the user to manage all the formula.

• It indicates that the c12 to be displayed is on the sheet Expense

• This is not a proper use of the formula.

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

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.

What’s New

​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)

3. 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)

4. 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 like.

​

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

​

8. In the Expense tab, drag select C2 to C16, press

right click > Format Cells (see Figure 2.7), the

Format Cell Window will appear.

Report Summarization

3. 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.

​What’s More

​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:

Open Ended

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

Open Ended

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

Assessment

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

Multiple Choice

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

• It allows the data to be stored, organized and analyzed.

• It gives the user the ability to create tables.

• It enables users to record words and numbers.

• It is a software that allows input, editing, formatting and output of text

Multiple Choice

How can you create a new tab in Windows Excel?

• In the ribbon, select Home>Tabs>Add Tabs then input how many tab you like to add.

• In lower portion of the work area, press the plus button besides the tabs.

• Press Ctrl + A then press Ctrl + Shift + N.

• You can’t add tabs in Microsoft Excel.

Multiple Choice

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

• Long press Alt then click A1 then click D7.

• While pressing shift select the A1 then D7

• In the formula bar type A1:D7

• Press Ctrl + A.

Multiple Choice

What is the formula that will subtract the contents of the cells A7 and A8?

• A7 - A8

• = A7 - A8

• A7 - A8 =

• =SUM (A7:A8)

Multiple Choice

How to format a cell that will automatically add a peso sign?

• 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.

• 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.

• 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.

• 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.

Multiple Choice

How do you resize a column or width?

• Select the cell the press right click, select format cell then change height and width

  values.

• In the Formula bar type (h[value]:w[value]).

• Click the cell then in the ribbon select format cell then change height and width values.

• Click and drag the column or row heading.

Multiple Choice

What is the formula that will add the contents of the cells C1 and C10?

• C1 + C10

• = C1 + C10

• C1 + C10 =

• SUM (C1:C3)

Multiple Choice

How do you resize a graph?

• Click the graph then click and drag any of the eight handles in the edges of the graph.

• 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.

• Select the table the press Ctrl + Arrow Keys.

• You can’t change the size of graphs.

Multiple Choice

How do you rename a graph into “First Data” in Microsoft Excel?

• Press right click then select rename, a window will appear then type “First Data”.

• Press Ctrl + A then Ctrl + R, rename the chart to “First Data”

• Double click the name of the chart and type “First Data”.

• Graph names can’t be changed as they follow the name from the selected data.

Multiple Choice

What is the purpose of the Formula Bar?

• It allows an easy to see input box for formula in a cell

• It is a selection of shortcuts different formula in Microsoft Excel

• It is the formula that allows computation of values from different cells.

• The Formula Bar is a label below the cell that indicates the result of a formula

Multiple Choice

Which Ribbon Menu is needed to be selected to change the font?

• Home

• Insert

• Page Layout

• Cell Formatting

Multiple Choice

How do you assign which cell the formula = (A1 + A2) + A3 will be displayed on?

• On the formula bar type cell address

• Press right click then select Cell Format then click on the Formula tab, type which cell

  you want that formula will be displayed

• In the ribbon click Cell Formatting then select the formula then type where it will

  displayed.

• Type the formula where you want it to be displayed on.

Multiple Choice

Which Ribbon Menu is needed to add a Chart?

• Home

• Insert

• Page Layout

• Cell Formatting

Multiple Choice

With this formula = Expense!C12, what does the Expense! part means?

• It a variable that allows quick reference of a value.

• It is formula label, allowing the user to manage all the formula.

• It indicates that the c12 to be displayed is on the sheet Expense

• This is not a proper use of the formula.

Multiple Choice

How do you change formula style in a sheet?

• Click Insert > Cell Formatting > Table Format > Table Style

• Click Home > Format as Table > Table Style

• Click Cell Formatting > Format Table > Table Style

• You have to select each cell then add cell borders to each of them