Course 2, Module 3

 0    23 flashcards    krystianpuchacz
download mp3 print play test yourself
 
Question English Answer English
AVERAGE
start learning
A spreadsheet function that returns an average of the values from a selected range
Borders
start learning
Lines that can be added around two or more cells on a spreadsheet
Cell reference
start learning
A cell or a range of cells in a worksheet typically used in formulas and functions
COUNT
start learning
A spreadsheet function that counts the number of cells in a range that meet a specific criteria
Equation
start learning
A calculation that involves addition, subtraction, multiplication, or division (also called a math expression)
Fill handle
start learning
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
start learning
The process of showing only the data that meets a specified criteria while hiding the rest
Header
start learning
The first row in a spreadsheet that labels the type of data in each column
Math expression
start learning
A calculation that involves addition, subtraction, multiplication, or division (also called an equation)
Math function
start learning
A function that is used as part of a mathematical formula
MAX
start learning
A spreadsheet function that returns the largest numeric value from a range of cells
MIN
start learning
A spreadsheet function that returns the smallest numeric value from a range of cells
Open data
start learning
Data that is available to the public
Operator
start learning
A symbol that names the operation or calculation to be performed
Order of operations
start learning
Using parentheses to group together spreadsheet values in order to clarify the order in which operations should be performed
Problem domain
start learning
The area of analysis that encompasses every activity affecting or affected by a problem
Range
start learning
A collection of two or more cells in a spreadsheet
Report
start learning
A static collection of data periodically given to stakeholders
Return on investment (ROI)
start learning
A formula that uses the metrics of investment and profit to evaluate the success of an investment
Revenue
start learning
The total amount of income generated by the sale of goods or services
Scope of work (SOW)
start learning
An agreed-upon outline of the tasks to be performed during a project
Sorting
start learning
The process of arranging data into a meaningful order to make it easier to understand, analyze, and visualize
SUM
start learning
A spreadsheet function that adds the values of a selected range of cells

You must sign in to write a comment