Question 1

The FORECAST.ETS function returns a confidence interval for a forecast at all future dates.

Accepted Answer

A) True 
 B)False

Question 2

The ________ function returns the variance of a population.

Accepted Answer

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

Question 3

Which function would you use to determine the number of occurrences of a particular value in a dataset?

Accepted Answer

A) BINS 
B) DEVP 
C) FREQUENCY 
D) CORREL 
A) BINS 
B) DEVP 
C) FREQUENCY 
D) CORREL

Question 4

The Analysis ToolPak is available on the Insert Tab.

Accepted Answer

A) True 
 B)False

Question 5

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 6

Relative Standing measures ________.

Accepted Answer

A) the median of a dataset 
B) the rank value of the quartiles of a dataset 
C) the standard deviation of a dataset 
D) the rank of one value with regard to other values in a dataset 
A) the median of a dataset 
B) the rank value of the quartiles of a dataset 
C) the standard deviation of a dataset 
D) the rank of one value with regard to other values in a dataset

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

FORECAST.ETS.SEASONALITY returns the projected quarter of the year when a forecasted value will happen.

Accepted Answer

A) True 
 B)False

Question 9

The k argument in a PERCENTILE function is a value from 0 to 1.

Accepted Answer

A) True 
 B)False

Question 10

Match between columns
                        Premises: Multiple criteria
Central tendency
Relative standing
Correlation
Conditional math

Accepted Answer

The Answer of Measures average or likely distribution from the is...

Question 11

=AVERAGEIFS(C2:
C64,A2:
A64,"Blue",B2:
B64,"Black")
Returns an average of Column C of the items which are either Blue or Black.

Accepted Answer

A) True 
 B)False

Question 12

The ________ function returns the length of the repetitive pattern Excel detects for the time series.

Accepted Answer

FORECAST.E

Question 13

________ is a measure of how two sets of data vary simultaneously.

Accepted Answer

The answer of ________ is a measure of how two...

Question 14

Excel 2016 has NO new functions in the Analysis ToolPak.

Accepted Answer

A) True 
 B)False

Question 15

Two or more conditions can be used with SUMIFS function.

Accepted Answer

A) True 
 B)False

Question 16

A(n)________ is a dataset that contains a manageable subset of a population.

Accepted Answer

A) population 
B) sample 
C) variance 
D) standard deviation 
A) population 
B) sample 
C) variance 
D) standard deviation

Question 17

What is SS in an ANOVA summary report?

Accepted Answer

A) Summary statistics 
B) Statistical score 
C) Sum of squares 
D) Square summary 
A) Summary statistics 
B) Statistical score 
C) Sum of squares 
D) Square summary

Question 18

What is the first argument of an SUMIFS function?

Accepted Answer

A) Criteria_range1 
B) Sum_range 
C) Criteria1 
D) Criteria2 
A) Criteria_range1 
B) Sum_range 
C) Criteria1 
D) Criteria2

Question 19

Match between columns
                        Premises: FORECAST.LINEAR
FORECAST.ETS.SEASONALITY
FORECAST.ETS
FORECAST.ETS.STAT
FORECAST.ETS.CONFINT

Accepted Answer

The Answer of Returns the requested statistic for the forecast is...

Question 20

Match between columns
                        Premises: Population
Analysis ToolPak
Descriptive Statistics
Inferential Statistics
Sample

Accepted Answer

The Answer of Add-in which assists with calculating inferential statistics is...

The FORECAST.ETS function returns a confidence interval for a forecast at all future dates.

The ________ function returns the variance of a population.

Which function would you use to determine the number of occurrences of a particular value in a dataset?

The Analysis ToolPak is available on the Insert Tab.

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

Relative Standing measures ________.

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

FORECAST.ETS.SEASONALITY returns the projected quarter of the year when a forecasted value will happen.

The k argument in a PERCENTILE function is a value from 0 to 1.

=AVERAGEIFS(C2: C64,A2: A64,"Blue",B2: B64,"Black") Returns an average of Column C of the items which are either Blue or Black.

The ________ function returns the length of the repetitive pattern Excel detects for the time series.

________ is a measure of how two sets of data vary simultaneously.

Excel 2016 has NO new functions in the Analysis ToolPak.

Two or more conditions can be used with SUMIFS function.

A(n)________ is a dataset that contains a manageable subset of a population.

What is SS in an ANOVA summary report?

What is the first argument of an SUMIFS function?

Introduction to Excel

Formulas and Functions

Charts

Datasets and Tables

Subtotals, Pivot-tables, and Pivot-charts

What-If Analysis

Specialized Functions

Multiple-Sheet Workbook Management

Imports, xml, and Power Add-Ins

Collaboration and Workbook Distribution

Templates, styles, and Macros

Office 2016 Common Features

Filters

Exam 8: Statistical Functions

The FORECAST.ETS function returns a confidence interval for a forecast at all future dates.

The ________ function returns the variance of a population.

Which function would you use to determine the number of occurrences of a particular value in a dataset?

The Analysis ToolPak is available on the Insert Tab.

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

Relative Standing measures ________.

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

FORECAST.ETS.SEASONALITY returns the projected quarter of the year when a forecasted value will happen.

The k argument in a PERCENTILE function is a value from 0 to 1.

=AVERAGEIFS(C2: C64,A2: A64,"Blue",B2: B64,"Black") Returns an average of Column C of the items which are either Blue or Black.

The ________ function returns the length of the repetitive pattern Excel detects for the time series.

________ is a measure of how two sets of data vary simultaneously.

Excel 2016 has NO new functions in the Analysis ToolPak.

Two or more conditions can be used with SUMIFS function.

A(n)________ is a dataset that contains a manageable subset of a population.

What is SS in an ANOVA summary report?

What is the first argument of an SUMIFS function?

Introduction to Excel

Formulas and Functions

Charts

Datasets and Tables

Subtotals, Pivot-tables, and Pivot-charts

What-If Analysis

Specialized Functions

Multiple-Sheet Workbook Management

Imports, xml, and Power Add-Ins

Collaboration and Workbook Distribution

Templates, styles, and Macros

Office 2016 Common Features

Filters