Education Self-Learning Module

What is the application program designed to create spreadsheets which can be used to analyze statistical data?

Microsoft Publisher
Microsoft PowerPoint
Microsoft Excel (correct)
Microsoft Word

What type of referencing in MS Excel must always start with an equal sign (=)?

Relative referencing
Functions
Absolute referencing
Formula (correct)

Which number format in MS Excel puts a dollar symbol before each value by default?

Date/time
Currency (correct)
Comma
Percent

What are the symbols that tell Excel exactly what type of calculations to perform?

Math Operators (C) Signup and view all the answers

What is the function that adds a range of cells in MS Excel?

SUM (C) Signup and view all the answers

What is the function that gets the average of a range of cells in MS Excel?

AVERAGE (B) Signup and view all the answers

What is the purpose of the pre-test in the Self-Learning Module?

To measure the learner's prior knowledge on the lesson and determine if they need assistance (D) Signup and view all the answers

What should learners do when answering exercises and tests in the Self-Learning Module?

Use a separate sheet of paper to answer the exercises and tests (B) Signup and view all the answers

What is the purpose of the 'Notes to the Teacher' section in the Self-Learning Module?

To offer strategies and reminders for facilitators and parents to support home-based learning (B) Signup and view all the answers

What is the main goal of the Self-Learning Module?

To enable learners to continue their studies and learn while at home (B) Signup and view all the answers

What should learners do with the answer keys provided in the Self-Learning Module?

Keep them confidential and use them to self-check their learning (D) Signup and view all the answers

What is the composition of the Self-Learning Module?

Different parts that guide the learner step-by-step through the lesson (B) Signup and view all the answers

What is the purpose of the AVERAGEIF function?

To compute the average of a range of cells if a certain condition is met (D) Signup and view all the answers

What is the difference between a relative reference and an absolute reference?

Relative references change when copied, while absolute references do not change (C) Signup and view all the answers

What is the purpose of the COUNTIF function?

To count the number of cells in a range if a certain condition is met (C) Signup and view all the answers

What is the term for the range of cells where you want to look for the criteria?

Range (D) Signup and view all the answers

What is the term for the actual range of cells that will be averaged?

Average Range (C) Signup and view all the answers

How does Excel help analyze statistical data?

By providing functions to analyze and compute statistical data (B) Signup and view all the answers

What is the primary objective of Activity 3?

To determine the number of people willing to pay a certain amount (A) Signup and view all the answers

In Activity 4, what is the purpose of encoding data in Microsoft Excel?

To determine the profitability of the product or service (C) Signup and view all the answers

What is one of the aspects of customer data to be logged in Activity 4?

Customer age range (D) Signup and view all the answers

What is the basis for grading the output in Activity 4?

The rubric provided (C) Signup and view all the answers

What is the primary goal of Activity 4?

To try to sell the product or service in school (B) Signup and view all the answers

What is a characteristic of an 'Exemplary' output in the rubric?

All skills from the topic are applied (B) Signup and view all the answers

What is the formula for the company's income?

Profit - agent's commission (D) Signup and view all the answers

What is the percentage of sales used to calculate the agent's commission?

4 % (C) Signup and view all the answers

What is the purpose of copying formulas in the worksheet?

To apply the formula to different appliances (C) Signup and view all the answers

What is the capital cost of a video compact disk?

17, 350 (D) Signup and view all the answers

What is the name of the saved worksheet?

DataFormula.Appliance Sales Cost Profit (A) Signup and view all the answers

What is the purpose of using formulas in the worksheet?

To calculate the profit and commission (C) Signup and view all the answers