Question 1

Match between columns
                        Premises: AVERAGEIFS
Criteria2
Criteria
Criteria_range1
Sum_range

Accepted Answer

The Answer of The range of values to be added is...

Question 2

Which of the following functions determines the standard deviation of a sample?

Accepted Answer

A) STDEVA 
B) VARA 
C) STDEV.P 
D) STDEV.S 
A) STDEVA 
B) VARA 
C) STDEV.P 
D) STDEV.S D

Question 3

Which of the following is not an ANOVA calculation type?

Accepted Answer

A) Single-factor 
B) Two-factor with replication 
C) Two-factor without replication 
D) Two wing 
A) Single-factor 
B) Two-factor with replication 
C) Two-factor without replication 
D) Two wing D

Question 4

Match between columns
                        Premises: COVARIANCE.P
COVARIANCE.S
Random variation
Histogram
Critical value of F

Accepted Answer

The Answer of Measures how 2 sets of an entire is...

Question 5

In SUMIF, AVERAGEIF, and COUNTIF functions using text criteria, enclose the criteria in:

Accepted Answer

A) ** 
B)  
C) ## 
D) "" 
A) ** 
B)  
C) ## 
D) ""

Question 6

The ________ function calculates the average, or arithmetic mean, of all cells in a range that meet a specific condition.

Accepted Answer

The answer of The ________ function calculates the average, or...

Question 7

Correlation is a tool included on the Analysis ToolPak.

Accepted Answer

A) True 
 B)False

Question 8

The ________ is the probability of a population being similarity to a sample.

Accepted Answer

The answer of The ________ is the probability of a...

Question 9

The ________ function returns the variance of a population.

Accepted Answer

The answer of The ________ function returns the variance of...

Question 10

Match between columns
                        Premises: Degrees of freedom
P-value
Sum of Squares
ANOVA
F ratio

Accepted Answer

The Answer of The mean square between/mean square within and is...

Question 11

ANOVA stands for analysis of variability.

Accepted Answer

A) True 
 B)False

Question 12

________ returns the forecasted values of a target date using exponential smoothing.

Accepted Answer

A) FORECAST.ETS.CONFINT 
B) FORECAST.ETS 
C) FORECAST.ETS.SEASONALITY 
D) FORECAST.LINEAR 
A) FORECAST.ETS.CONFINT 
B) FORECAST.ETS 
C) FORECAST.ETS.SEASONALITY 
D) FORECAST.LINEAR

Question 13

Which of the following is not an argument in the PERCENTRANK.INC and PERCENTRANK.EXC functions?

Accepted Answer

A) array 
B) criteria 
C) x 
D) significance 
A) array 
B) criteria 
C) x 
D) significance

Question 14

Covariance has two functions associated with it - COVARIANCE.P and COVARIANCE.S.

Accepted Answer

A) True 
 B)False

Question 15

A Forecast worksheet is a business intelligence tool that projects trends based on historical data.

Accepted Answer

A) True 
 B)False

Question 16

Which function returns the standard deviation of a population including logical values and text?

Accepted Answer

A) STDEVA 
B) STDEV.P 
C) STDEVPA 
D) STDEV.S 
A) STDEVA 
B) STDEV.P 
C) STDEVPA 
D) STDEV.S

Question 17

Why is it important to analyze the relationships between a sample and full population?

Accepted Answer

A) To find out how many data points are necessary to be statistically valid 
B) To help make more informed statements about a population 
C) To bring diverging data into analysis 
D) To limit variance 
A) To find out how many data points are necessary to be statistically valid 
B) To help make more informed statements about a population 
C) To bring diverging data into analysis 
D) To limit variance

Question 18

What would be the result of this formula: =AVERAGEIF(A2:A64,"Green",C2:C64)?

Accepted Answer

A) An average of the values in the C and A columns when the values in the B column are Green 
B) There isn't enough information here to tell. 
C) An average of the values in the A column when the values in the C column are Green 
D) An average of the values in the C column when the values in the A column are Green 
A) An average of the values in the C and A columns when the values in the B column are Green 
B) There isn't enough information here to tell. 
C) An average of the values in the A column when the values in the C column are Green 
D) An average of the values in the C column when the values in the A column are Green

Question 19

Match between columns
                        Premises: FREQUENCY
VARPA
CORREL
BINS
STDEVPA

Accepted Answer

The Answer of Helps determine the strength of a relationship is...

Question 20

The ________ function will use average values to determine the rank of a number within a list if tied values are present.

Accepted Answer

The answer of The ________ function will use average values...

Which of the following functions determines the standard deviation of a sample?

Which of the following is not an ANOVA calculation type?

In SUMIF, AVERAGEIF, and COUNTIF functions using text criteria, enclose the criteria in:

The ________ function calculates the average, or arithmetic mean, of all cells in a range that meet a specific condition.

Correlation is a tool included on the Analysis ToolPak.

The ________ is the probability of a population being similarity to a sample.

The ________ function returns the variance of a population.

ANOVA stands for analysis of variability.

________ returns the forecasted values of a target date using exponential smoothing.

Which of the following is not an argument in the PERCENTRANK.INC and PERCENTRANK.EXC functions?

Covariance has two functions associated with it - COVARIANCE.P and COVARIANCE.S.

A Forecast worksheet is a business intelligence tool that projects trends based on historical data.

Which function returns the standard deviation of a population including logical values and text?

Why is it important to analyze the relationships between a sample and full population?

What would be the result of this formula: =AVERAGEIF(A2:A64,"Green",C2:C64)?

The ________ function will use average values to determine the rank of a number within a list if tied values are present.

Introduction to Excel

Formulas and Functions

Charts

Datasets and Tables

Subtotals, Pivottables, and Pivotcharts

What-If Analysis

Specialized Functions

Multiple-Sheet Workbook Management

Imports, Xml, and Power Add-Ins

Collaboration and Workbook Distribution

Templates, Styles, and Macros

Appendix: Exploring Microsoft Office Excel 2016 Comprehensive Poatsygrauer

Filters

Exam 8: Statistical Functions

Which of the following functions determines the standard deviation of a sample?

Which of the following is not an ANOVA calculation type?

In SUMIF, AVERAGEIF, and COUNTIF functions using text criteria, enclose the criteria in:

The ________ function calculates the average, or arithmetic mean, of all cells in a range that meet a specific condition.

Correlation is a tool included on the Analysis ToolPak.

The ________ is the probability of a population being similarity to a sample.

The ________ function returns the variance of a population.

ANOVA stands for analysis of variability.

________ returns the forecasted values of a target date using exponential smoothing.

Which of the following is not an argument in the PERCENTRANK.INC and PERCENTRANK.EXC functions?

Covariance has two functions associated with it - COVARIANCE.P and COVARIANCE.S.

A Forecast worksheet is a business intelligence tool that projects trends based on historical data.

Which function returns the standard deviation of a population including logical values and text?

Why is it important to analyze the relationships between a sample and full population?

What would be the result of this formula: =AVERAGEIF(A2:A64,"Green",C2:C64)?

The ________ function will use average values to determine the rank of a number within a list if tied values are present.

Introduction to Excel

Formulas and Functions

Charts

Datasets and Tables

Subtotals, Pivottables, and Pivotcharts

What-If Analysis

Specialized Functions

Multiple-Sheet Workbook Management

Imports, Xml, and Power Add-Ins

Collaboration and Workbook Distribution

Templates, Styles, and Macros

Appendix: Exploring Microsoft Office Excel 2016 Comprehensive Poatsygrauer

Filters