30 Questions
What is the application program designed to create spreadsheets which can be used to analyze statistical data?
Microsoft Excel
What type of referencing in MS Excel must always start with an equal sign (=)?
Formula
Which number format in MS Excel puts a dollar symbol before each value by default?
Currency
What are the symbols that tell Excel exactly what type of calculations to perform?
Math Operators
What is the function that adds a range of cells in MS Excel?
SUM
What is the function that gets the average of a range of cells in MS Excel?
AVERAGE
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
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
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
What is the main goal of the Self-Learning Module?
To enable learners to continue their studies and learn while at home
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
What is the composition of the Self-Learning Module?
Different parts that guide the learner step-by-step through the lesson
What is the purpose of the AVERAGEIF function?
To compute the average of a range of cells if a certain condition is met
What is the difference between a relative reference and an absolute reference?
Relative references change when copied, while absolute references do not change
What is the purpose of the COUNTIF function?
To count the number of cells in a range if a certain condition is met
What is the term for the range of cells where you want to look for the criteria?
Range
What is the term for the actual range of cells that will be averaged?
Average Range
How does Excel help analyze statistical data?
By providing functions to analyze and compute statistical data
What is the primary objective of Activity 3?
To determine the number of people willing to pay a certain amount
In Activity 4, what is the purpose of encoding data in Microsoft Excel?
To determine the profitability of the product or service
What is one of the aspects of customer data to be logged in Activity 4?
Customer age range
What is the basis for grading the output in Activity 4?
The rubric provided
What is the primary goal of Activity 4?
To try to sell the product or service in school
What is a characteristic of an 'Exemplary' output in the rubric?
All skills from the topic are applied
What is the formula for the company's income?
Profit - agent's commission
What is the percentage of sales used to calculate the agent's commission?
4 %
What is the purpose of copying formulas in the worksheet?
To apply the formula to different appliances
What is the capital cost of a video compact disk?
17, 350
What is the name of the saved worksheet?
DataFormula.Appliance Sales Cost Profit
What is the purpose of using formulas in the worksheet?
To calculate the profit and commission
This self-learning module is designed for students to continue their studies at home. It includes activities, questions, directions, exercises, and discussions to facilitate learning.
Make Your Own Quizzes and Flashcards
Convert your notes into interactive study material.
Get started for free