Challenge 3
Terms and definitions for Course 2, Module 3 AVERAGE: A spreadsheet function that returns an average of the values from a selected range
Borders: Lines that can be added around two or more cells on a spreadsheet
Cell reference: A cell or a range of cells in a worksheet typically used in formulas and functions
COUNT: A spreadsheet function that counts the number of cells in a range that meet a specific criteria
Equation: A calculation that involves addition, subtraction, multiplication, or division (also called a math expression)
Fill handle: A box in the lower-right-hand corner of a selected spreadsheet cell that can be dragged through neighboring cells in order to continue an instruction
Filtering: The process of showing only the data that meets a specified criteria while hiding the rest
Header: The first row in a spreadsheet that labels the type of data in each column
Math expression: A calculation that involves addition, subtraction, multiplication, or division (also called an equation)
Math function: A function that is used as part of a mathematical formula
MAX: A spreadsheet function that returns the largest numeric value from a range of cells
MIN: A spreadsheet function that returns the smallest numeric value from a range of cells
Open data: Data that is available to the public
Operator: A symbol that names the operation or calculation to be performed
Order of operations: Using parentheses to group together spreadsheet values in order to clarify the order in which operations should be performed
Problem domain: The area of analysis that encompasses every activity affecting or affected by a problem
Range: A collection of two or more cells in a spreadsheet
Report: A static collection of data periodically given to stakeholders
Return on investment (ROI): A formula that uses the metrics of investment and profit to evaluate the success of an investment
Revenue: The total amount of income generated by the sale of goods or services
Scope of work (SOW): An agreed-upon outline of the tasks to be performed during a project
Sorting: The process of arranging data into a meaningful order to make it easier to understand, analyze, and visualize
SUM: A spreadsheet function that adds the values of a selected range of cells
