Analyze Data to Answer Questions (Terms) Flashcards
A collection of values in spreadsheet cells
Array
A database table that is created and exists temporarily on a database server
Temporary table
A function that multiplies arrays and returns the sum of those products
SUMPRODUCT
A new field within a pivot table that carries out certain calculations based on the values of other fields
Calculated field
A percentage that indicates how many cents of profit has been generated for each dollar of sale
Profit margin
A reference within a function that is locked so that rows and columns won’t change if the function is copied
Absolute reference
A spreadsheet function that adds numeric data based on one condition
SUMIF
A spreadsheet function that converts a text string that represents a number to a numeric value
VALUE
A spreadsheet function used to locate the position of a specific lookup value
MATCH
A SQL clause that groups rows that have the same values from a table into summary rows
GROUP BY
A SQL clause that sorts results returned in a query
ORDER BY
A SQL clause that specifies the maximum number of records returned in a query
LIMIT
A SQL function that combines RIGHT and LEFT JOIN to return all matching records in both tables
OUTER JOIN
A SQL function that is used to combine rows from two or more tables based on a related column
JOIN
A SQL function that only returns the distinct values in a specified range
COUNT DISTINCT
A SQL function that returns a number rounded to a certain number of decimal places.
ROUND
A SQL function that returns records with matching values in both tables
INNER JOIN
A SQL function that will return all records from the right table and only the matching records from the left.
RIGHT JOIN
A SQL function that will return all the records from the left table and only the matching records from the right table
LEFT JOIN
A SQL query that is nested inside a larger query
Subquery
A table used to summarize statistical information about data
Summary table
An operator (%) that returns the remainder when one number is divided by another
Modulo
Lines used to underline words and connect text characters
Underscores
Temporarily naming a table or column in a query to make it easier to read and write
Aliasing
The process of checking and rechecking the quality of data so that it is complete, accurate, secure and consistent
Data validation process
The process of collecting or gathering many separate pieces into a whole
Aggregation
The process of gathering data from multiple sources and combining it into a single, summarized collection
Data aggregation
