C2-M3 Glossary Terms for Course Two, Module Three

Glossary Terms for Course Two, Module Three

Average

• Definition: A spreadsheet function that computes the average of selected cell values.
• Example: To find the average of values in cells A1 to A10, use the formula =AVERAGE(A1:A10).

Lines

• Definition: Lines that can be added around two or more cells in a spreadsheet.
• Application: Often used for aesthetic purposes and organization of data.

Cell/Range of Cells

• Definition: A cell is the basic unit of a spreadsheet, which can contain data or formulas. A range of cells refers to two or more selected cells.
• Example: Cell A1; Range A1:B10.

Counting Function

• Definition: A spreadsheet function that counts the number of cells in a given range that meet specified criteria.
• Example: =COUNTIF(A1:A10, ">10") counts cells with values greater than 10.

Calculation

• Definition: An operation involving addition, subtraction, multiplication, or division, can also be referred to as a math expression or equation.
• Example: An equation such as $(3 + 5) imes 2$.

Fill Handle

• Definition: A box located in the lower right corner of a selected cell which can be dragged to fill neighboring cells.
• Usage: Quickly populates data or formulas in adjacent cells.

Filtering Data

• Definition: The process of displaying only the data that meets specific criteria while hiding the non-relevant data.
• Example: Filtering a sales report to show only transactions above $100.

Header Row

• Definition: The first row in a spreadsheet that labels the types of data contained in each column.
• Purpose: Helps identify what each column represents.

Math Function

• Definition: A function that is part of a mathematical formula.
• Example: Functions like SUM, AVERAGE, MAX, and MIN are all considered math functions.

Max

• Definition: A spreadsheet function that returns the largest numeric value from a specified range of cells.
• Example: =MAX(A1:A10) returns the maximum value from cells A1 through A10.

Min

• Definition: A spreadsheet function that returns the smallest numeric value from a specified range of cells.
• Example: =MIN(A1:A10) returns the minimum value from cells A1 through A10.

Open Data

• Definition: Data that is publicly available for use and accessibility by everyone.

Operation Symbol

• Definition: A symbol that denotes the operation or calculation to be performed, such as +, -, *, or /.

Order of Operations

• Definition: A set of rules that defines the correct sequence to evaluate a mathematical expression, including the use of parentheses to group values.

Problem Domain

• Definition: The area of analysis that includes all activities that affect or are affected by a specific problem.

Collection of Cells

• Definition: A group of two or more cells in a spreadsheet that can be managed or analyzed together.

Static Data Collection

• Definition: A fixed dataset provided periodically to stakeholders.

Return on Investment (ROI)

• Definition: A formula that evaluates the success of an investment by comparing profit to costs involved.

Revenue

• Definition: The total income generated from the sale of goods or services.

Scope of Work

• Definition: An agreed outline of the tasks and deliverables for a project.

Data Arrangement

• Definition: The process of organizing data in a structured manner to enhance understanding, analysis, and visualization.

SUM

• Definition: A spreadsheet function that adds all the values in a specified range of cells.
• Example: =SUM(A1:A10) sums the values from A1 to A10.