Podcast
Questions and Answers
What is the application program designed to create spreadsheets which can be used to analyze statistical data?
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 (=)?
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?
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?
What are the symbols that tell Excel exactly what type of calculations to perform?
What is the function that adds a range of cells in MS Excel?
What is the function that adds a range of cells in MS Excel?
What is the function that gets the average of a range of cells in MS Excel?
What is the function that gets the average of a range of cells in MS Excel?
What is the purpose of the pre-test in the Self-Learning Module?
What is the purpose of the pre-test in the Self-Learning Module?
What should learners do when answering exercises and tests in the Self-Learning Module?
What should learners do when answering exercises and tests in the Self-Learning Module?
What is the purpose of the 'Notes to the Teacher' section in the Self-Learning Module?
What is the purpose of the 'Notes to the Teacher' section in the Self-Learning Module?
What is the main goal of the Self-Learning Module?
What is the main goal of the Self-Learning Module?
What should learners do with the answer keys provided in the Self-Learning Module?
What should learners do with the answer keys provided in the Self-Learning Module?
What is the composition of the Self-Learning Module?
What is the composition of the Self-Learning Module?
What is the purpose of the AVERAGEIF function?
What is the purpose of the AVERAGEIF function?
What is the difference between a relative reference and an absolute reference?
What is the difference between a relative reference and an absolute reference?
What is the purpose of the COUNTIF function?
What is the purpose of the COUNTIF function?
What is the term for the range of cells where you want to look for the criteria?
What is the term for the range of cells where you want to look for the criteria?
What is the term for the actual range of cells that will be averaged?
What is the term for the actual range of cells that will be averaged?
How does Excel help analyze statistical data?
How does Excel help analyze statistical data?
What is the primary objective of Activity 3?
What is the primary objective of Activity 3?
In Activity 4, what is the purpose of encoding data in Microsoft Excel?
In Activity 4, what is the purpose of encoding data in Microsoft Excel?
What is one of the aspects of customer data to be logged in Activity 4?
What is one of the aspects of customer data to be logged in Activity 4?
What is the basis for grading the output in Activity 4?
What is the basis for grading the output in Activity 4?
What is the primary goal of Activity 4?
What is the primary goal of Activity 4?
What is a characteristic of an 'Exemplary' output in the rubric?
What is a characteristic of an 'Exemplary' output in the rubric?
What is the formula for the company's income?
What is the formula for the company's income?
What is the percentage of sales used to calculate the agent's commission?
What is the percentage of sales used to calculate the agent's commission?
What is the purpose of copying formulas in the worksheet?
What is the purpose of copying formulas in the worksheet?
What is the capital cost of a video compact disk?
What is the capital cost of a video compact disk?
What is the name of the saved worksheet?
What is the name of the saved worksheet?
What is the purpose of using formulas in the worksheet?
What is the purpose of using formulas in the worksheet?