7-8 excel (1).pdf!*^@&(@**&^@*(*^&*&*(@*&(&*YI#)*IY(&*(#(Y*)@(_@#&&#(*O_P{L|}?Q":OP!W#@10/29/2026, 1:43:28 PM7-8 excel (1)
7-8 excel
An OR function evaluates to TRUE only if all of the conditions are true. - ✔✔False
%
The YEARFRAC function returns the number of the month in a year. - ✔✔False
Which function returns the relative position of a value? - ✔✔MATCH
Why would you nest MATCH in an INDEX function? - ✔✔To use the position returned in the Match
0
function as an argument in the index function
Which of the following are not arguments for the IPMT function? - ✔✔Collection
What is the first argument of an IF function? - ✔✔Logical_test
0
A Truth Table is a matrix that provides true or false for every possible combination for an OR, NOT, or
AND criteria combination. - ✔✔True
What effect does paying an extra small bit of principal on a mortgage have on the life of a 30 year
1
loan? - ✔✔It saves money in interest and shortens the length of the loan.
If you need to find out how many days between two dates, which function would you use? - ✔✔days
Which database function returns the lowest value from the dataset based on your criteria? - ✔✔dmin
An empty cell in the criteria in an Advanced Filter will display no records. - ✔✔false
The MONTH function would return 25 when used on a cell containing August 25, 2018. - ✔✔false
NPER calculates the periodic interest rate of an investment or loan. - ✔✔false
what is <> equivalent to in advanced filters - ✔✔not equal to
The YEARFRAC calculates ________. - ✔✔the fraction of a year in days between two dates
The FREQUENCY function determines the strength of the relationship between two data sets. -
✔✔false
What is the Criteria2 argument of: - ✔✔Black
10/29/2026,
7-8 excel (1).pdf!*^@&(@**&^@*(*^&*&*(@*&(&*YI#)*IY(&*(#(Y*)@(_@#&&#(*O_P{L|}?Q":OP!W#@10/29/2026,
2:11:54 PM7-8 excel (1).pdf!*^@&(@**&^@*(*^&*&*(@*&(&*YI#)*IY(&*(#(Y*)@(_@#&&#(*O_P{L|}?Q":OP!W#@10/29/2026,
1:43:28 PM7-8 excel (1)1:43:28
, 7-8 excel (1).pdf!*^@&(@**&^@*(*^&*&*(@*&(&*YI#)*IY(&*(#(Y*)@(_@#&&#(*O_P{L|}?Q":OP!W#@10/29/2026, 1:43:28 PM7-8 excel (1)
What is the sum_range argument of: - ✔✔C2:C64
Which of the following is not an argument in the PERCENTRANK.INC and PERCENTRANK.EXC
functions? - ✔✔criteria
%
Inferential statistics and Descriptive statistics are the same thing. - ✔✔false
The ________ function returns the variance of a sample of numerical data - ✔✔VAR.S
0
STDEV.S calculates the standard deviation of a sample. - ✔✔True
The FORECAST.ETS function returns a confidence interval for a forecast at all future dates. -
✔✔False
Which function returns the standard deviation of a population including logical values and text? -
0
✔✔STDEVPA
What would be the result of this formula:
=AVERAGEIF(A2:A64,"Green",C2:C64)? - ✔✔An average of the values in the C column when the
1
values in the A column are Green
This is the first 4 lines of an excel list of 3082 records.
Which formula counts the number of Gold Level Members in the entire list? -
✔✔=COUNTIF(A2:A3083,"Gold")
________ is a measure of how two set of data vary simultaneously and is calculated by taking the
average of each product of the deviation of a data point. - ✔✔Covariance
What is MS in an ANOVA summary report? - ✔✔Mean of the sample squared
What are the two arguments for the FREQUENCY function? - ✔✔data_array, bins_array
Which of the following is an allowable quart argument in a QUARTILE.EXC function? - ✔✔2
Which of the following is an Excel Add-in? - ✔✔Analysis ToolPak
=AVERAGEIFS(C2:C64,A2:A64,"Blue",B2:B64,"Black") - ✔✔false
A(n) ________ is a dataset that contains a manageable subset of a population. - ✔✔sample
10/29/2026,
7-8 excel (1).pdf!*^@&(@**&^@*(*^&*&*(@*&(&*YI#)*IY(&*(#(Y*)@(_@#&&#(*O_P{L|}?Q":OP!W#@10/29/2026,
2:11:54 PM7-8 excel (1).pdf!*^@&(@**&^@*(*^&*&*(@*&(&*YI#)*IY(&*(#(Y*)@(_@#&&#(*O_P{L|}?Q":OP!W#@10/29/2026,
1:43:28 PM7-8 excel (1)1:43:28
7-8 excel
An OR function evaluates to TRUE only if all of the conditions are true. - ✔✔False
%
The YEARFRAC function returns the number of the month in a year. - ✔✔False
Which function returns the relative position of a value? - ✔✔MATCH
Why would you nest MATCH in an INDEX function? - ✔✔To use the position returned in the Match
0
function as an argument in the index function
Which of the following are not arguments for the IPMT function? - ✔✔Collection
What is the first argument of an IF function? - ✔✔Logical_test
0
A Truth Table is a matrix that provides true or false for every possible combination for an OR, NOT, or
AND criteria combination. - ✔✔True
What effect does paying an extra small bit of principal on a mortgage have on the life of a 30 year
1
loan? - ✔✔It saves money in interest and shortens the length of the loan.
If you need to find out how many days between two dates, which function would you use? - ✔✔days
Which database function returns the lowest value from the dataset based on your criteria? - ✔✔dmin
An empty cell in the criteria in an Advanced Filter will display no records. - ✔✔false
The MONTH function would return 25 when used on a cell containing August 25, 2018. - ✔✔false
NPER calculates the periodic interest rate of an investment or loan. - ✔✔false
what is <> equivalent to in advanced filters - ✔✔not equal to
The YEARFRAC calculates ________. - ✔✔the fraction of a year in days between two dates
The FREQUENCY function determines the strength of the relationship between two data sets. -
✔✔false
What is the Criteria2 argument of: - ✔✔Black
10/29/2026,
7-8 excel (1).pdf!*^@&(@**&^@*(*^&*&*(@*&(&*YI#)*IY(&*(#(Y*)@(_@#&&#(*O_P{L|}?Q":OP!W#@10/29/2026,
2:11:54 PM7-8 excel (1).pdf!*^@&(@**&^@*(*^&*&*(@*&(&*YI#)*IY(&*(#(Y*)@(_@#&&#(*O_P{L|}?Q":OP!W#@10/29/2026,
1:43:28 PM7-8 excel (1)1:43:28
, 7-8 excel (1).pdf!*^@&(@**&^@*(*^&*&*(@*&(&*YI#)*IY(&*(#(Y*)@(_@#&&#(*O_P{L|}?Q":OP!W#@10/29/2026, 1:43:28 PM7-8 excel (1)
What is the sum_range argument of: - ✔✔C2:C64
Which of the following is not an argument in the PERCENTRANK.INC and PERCENTRANK.EXC
functions? - ✔✔criteria
%
Inferential statistics and Descriptive statistics are the same thing. - ✔✔false
The ________ function returns the variance of a sample of numerical data - ✔✔VAR.S
0
STDEV.S calculates the standard deviation of a sample. - ✔✔True
The FORECAST.ETS function returns a confidence interval for a forecast at all future dates. -
✔✔False
Which function returns the standard deviation of a population including logical values and text? -
0
✔✔STDEVPA
What would be the result of this formula:
=AVERAGEIF(A2:A64,"Green",C2:C64)? - ✔✔An average of the values in the C column when the
1
values in the A column are Green
This is the first 4 lines of an excel list of 3082 records.
Which formula counts the number of Gold Level Members in the entire list? -
✔✔=COUNTIF(A2:A3083,"Gold")
________ is a measure of how two set of data vary simultaneously and is calculated by taking the
average of each product of the deviation of a data point. - ✔✔Covariance
What is MS in an ANOVA summary report? - ✔✔Mean of the sample squared
What are the two arguments for the FREQUENCY function? - ✔✔data_array, bins_array
Which of the following is an allowable quart argument in a QUARTILE.EXC function? - ✔✔2
Which of the following is an Excel Add-in? - ✔✔Analysis ToolPak
=AVERAGEIFS(C2:C64,A2:A64,"Blue",B2:B64,"Black") - ✔✔false
A(n) ________ is a dataset that contains a manageable subset of a population. - ✔✔sample
10/29/2026,
7-8 excel (1).pdf!*^@&(@**&^@*(*^&*&*(@*&(&*YI#)*IY(&*(#(Y*)@(_@#&&#(*O_P{L|}?Q":OP!W#@10/29/2026,
2:11:54 PM7-8 excel (1).pdf!*^@&(@**&^@*(*^&*&*(@*&(&*YI#)*IY(&*(#(Y*)@(_@#&&#(*O_P{L|}?Q":OP!W#@10/29/2026,
1:43:28 PM7-8 excel (1)1:43:28
