CPSP Exam Practice questions and Answers 2025
, AND Function - CORRECT ANSWER returns TRUE is all arguments evaluate to TRUE but
false if not
Arguments - CORRECT ANSWER input values that we pass into an excel function
Cell - CORRECT ANSWER -singular unit of data in Excel
-where a row and a column meet
-named after the column and row EX: B9
Conditional Formatting - CORRECT ANSWER allows us to change the formatting rules of
our cells based on some evaluation of a logical formula
Criteria - CORRECT ANSWER -one or more arguments use with advanced logical functions
-cells are compared to the criteria
-if cells match, they are used
Data Mining - CORRECT ANSWER fracture of examining large datasets and identifying
patters, trends or other items of statistical significance
Data Point in Charts - CORRECT ANSWER in a chart this is a cell containing a single piece
of data
Data series - CORRECT ANSWER in a chart is a set of related data points that will be
associated together in the chart
Field - CORRECT ANSWER small unit of data that we want to know about in our table.
represented as a column
Freeze - CORRECT ANSWER allow you to keep row and or column headers in view as you
scroll through a large spreadsheet
Function - CORRECT ANSWER -short cut for many common equations
-mini-program in Excel
-takes in info (arguments) and returns some value
-can call a function in a cell on a spreadsheet
Function returns - CORRECT ANSWER -returns a value whenever it is called
-can be returned in a cell, formula, or value can be used as a argument to another function call
Goal Seek - CORRECT ANSWER Allows us to find an exact value in variables tables
How to type in a formula - CORRECT ANSWER use = to show that we are typing a formula
and not text to display
IF Function - CORRECT ANSWER -first argument is any statement that evaluates to true or
false
, AND Function - CORRECT ANSWER returns TRUE is all arguments evaluate to TRUE but
false if not
Arguments - CORRECT ANSWER input values that we pass into an excel function
Cell - CORRECT ANSWER -singular unit of data in Excel
-where a row and a column meet
-named after the column and row EX: B9
Conditional Formatting - CORRECT ANSWER allows us to change the formatting rules of
our cells based on some evaluation of a logical formula
Criteria - CORRECT ANSWER -one or more arguments use with advanced logical functions
-cells are compared to the criteria
-if cells match, they are used
Data Mining - CORRECT ANSWER fracture of examining large datasets and identifying
patters, trends or other items of statistical significance
Data Point in Charts - CORRECT ANSWER in a chart this is a cell containing a single piece
of data
Data series - CORRECT ANSWER in a chart is a set of related data points that will be
associated together in the chart
Field - CORRECT ANSWER small unit of data that we want to know about in our table.
represented as a column
Freeze - CORRECT ANSWER allow you to keep row and or column headers in view as you
scroll through a large spreadsheet
Function - CORRECT ANSWER -short cut for many common equations
-mini-program in Excel
-takes in info (arguments) and returns some value
-can call a function in a cell on a spreadsheet
Function returns - CORRECT ANSWER -returns a value whenever it is called
-can be returned in a cell, formula, or value can be used as a argument to another function call
Goal Seek - CORRECT ANSWER Allows us to find an exact value in variables tables
How to type in a formula - CORRECT ANSWER use = to show that we are typing a formula
and not text to display
IF Function - CORRECT ANSWER -first argument is any statement that evaluates to true or
false
