CPS FINAL EXAM WITH ALL CORRECT & 100% VERIFIED
ANSWERS|ALREADY GRADED A+
measures the special set of functions and commands called data analysis expression (DAX);
calculated name field in power pivot ✔Correct Answer-Measure
Process of creating a model simulation or small scale representation of data and the relationship
among pieces of data ✔Correct Answer-Data Modeling
Tool that extends the analytical functionality of pivot tables in excel; includes the capability to
include data from multiple data sources into one pivot table ✔Correct Answer-Power Pivot
Located on the data tab; allows you to connect, clean, and transform large amounts of data into an
accessible excel table ✔Correct Answer-Get & Transform
complex mathematical process that's used to solve problems that have multiple variables and the
minimizing or maximizing of result values ✔Correct Answer-Linear Programming
Blue arrows that point from cell to cell; lets you know what cells are referenced in a formula in a
particular cell ✔Correct Answer-Tracer Arrows
Allows you to define cells in such a way that only certain values are accepted; limits what a cell can
contain and defines that ✔Correct Answer-Data Validation
Different way to filter; graphical objects that have buttons you click to filter the data for pivot
tables/charts ✔Correct Answer-Slicers
Interactive chart that allows users to change the groupings that graphically present the data;
graphical representation of a pivot table report ✔Correct Answer-Pivot Chart Report
Interactive view of worksheet data that gives you the ability to summarize the data by selecting
categories in which to group the data ✔Correct Answer-Pivot Table Report
Database inside of excel ✔Correct Answer-Table
Organized collection of data; looks like a spreadsheet, but is a collection of data ✔Correct Answer-
Database
Category of information; descriptive about something
EX. First name, street name, last name, etc. ✔Correct Answer-Field
Descriptive fields together; usually listed in rows ✔Correct Answer-Record
Questions that you ask the database; filters out only what you want
EX. Give all the females that are from Montana in the table ✔Correct Answer-Query
ANSWERS|ALREADY GRADED A+
measures the special set of functions and commands called data analysis expression (DAX);
calculated name field in power pivot ✔Correct Answer-Measure
Process of creating a model simulation or small scale representation of data and the relationship
among pieces of data ✔Correct Answer-Data Modeling
Tool that extends the analytical functionality of pivot tables in excel; includes the capability to
include data from multiple data sources into one pivot table ✔Correct Answer-Power Pivot
Located on the data tab; allows you to connect, clean, and transform large amounts of data into an
accessible excel table ✔Correct Answer-Get & Transform
complex mathematical process that's used to solve problems that have multiple variables and the
minimizing or maximizing of result values ✔Correct Answer-Linear Programming
Blue arrows that point from cell to cell; lets you know what cells are referenced in a formula in a
particular cell ✔Correct Answer-Tracer Arrows
Allows you to define cells in such a way that only certain values are accepted; limits what a cell can
contain and defines that ✔Correct Answer-Data Validation
Different way to filter; graphical objects that have buttons you click to filter the data for pivot
tables/charts ✔Correct Answer-Slicers
Interactive chart that allows users to change the groupings that graphically present the data;
graphical representation of a pivot table report ✔Correct Answer-Pivot Chart Report
Interactive view of worksheet data that gives you the ability to summarize the data by selecting
categories in which to group the data ✔Correct Answer-Pivot Table Report
Database inside of excel ✔Correct Answer-Table
Organized collection of data; looks like a spreadsheet, but is a collection of data ✔Correct Answer-
Database
Category of information; descriptive about something
EX. First name, street name, last name, etc. ✔Correct Answer-Field
Descriptive fields together; usually listed in rows ✔Correct Answer-Record
Questions that you ask the database; filters out only what you want
EX. Give all the females that are from Montana in the table ✔Correct Answer-Query
