Analyze Data to Answer Questions (Terms)

Question 1

A collection of values in spreadsheet cells

Answer 1

Array

Question 2

A database table that is created and exists temporarily on a database server

Answer 2

Temporary table

Question 3

A function that multiplies arrays and returns the sum of those products

Answer 3

SUMPRODUCT

Question 4

A new field within a pivot table that carries out certain calculations based on the values of other fields

Answer 4

Calculated field

Question 5

A percentage that indicates how many cents of profit has been generated for each dollar of sale

Answer 5

Profit margin

Question 6

A reference within a function that is locked so that rows and columns won’t change if the function is copied

Answer 6

Absolute reference

Question 7

A spreadsheet function that adds numeric data based on one condition

Answer 7

SUMIF

Question 8

A spreadsheet function that converts a text string that represents a number to a numeric value

Answer 8

VALUE

Question 9

A spreadsheet function used to locate the position of a specific lookup value

Answer 9

MATCH

Question 10

A SQL clause that groups rows that have the same values from a table into summary rows

Answer 10

GROUP BY

Question 11

A SQL clause that sorts results returned in a query

Answer 11

ORDER BY

Question 12

A SQL clause that specifies the maximum number of records returned in a query

Answer 12

LIMIT

Question 13

A SQL function that combines RIGHT and LEFT JOIN to return all matching records in both tables

Answer 13

OUTER JOIN

Question 14

A SQL function that is used to combine rows from two or more tables based on a related column

Answer 14

JOIN

Question 15

A SQL function that only returns the distinct values in a specified range

Answer 15

COUNT DISTINCT

Question 16

A SQL function that returns a number rounded to a certain number of decimal places.

Answer 16

ROUND

Question 17

A SQL function that returns records with matching values in both tables

Answer 17

INNER JOIN

Question 18

A SQL function that will return all records from the right table and only the matching records from the left.

Answer 18

RIGHT JOIN

Question 19

A SQL function that will return all the records from the left table and only the matching records from the right table

Answer 19

LEFT JOIN

Question 20

A SQL query that is nested inside a larger query

Answer 20

Subquery

Question 21

A table used to summarize statistical information about data

Answer 21

Summary table

Question 22

An operator (%) that returns the remainder when one number is divided by another

Answer 22

Modulo

Question 23

Lines used to underline words and connect text characters

Answer 23

Underscores

Question 24

Temporarily naming a table or column in a query to make it easier to read and write

Answer 24

Aliasing

Question 25

The process of checking and rechecking the quality of data so that it is complete, accurate, secure and consistent

Answer 25

Data validation process

Question 26

The process of collecting or gathering many separate pieces into a whole

Answer 26

Aggregation

Question 27

The process of gathering data from multiple sources and combining it into a single, summarized collection

Answer 27

Data aggregation