Exploring Microsoft Office Excel 2016 Comprehensive 1st Edition Mulbery Test Bank Download

Exploring Microsoft Office Excel 2016
Comprehensive 1st Edition Mulbery

Test Bank
Visit to download the full and correct content document: https://testbankdeal.com/dow
nload/exploring-microsoft-office-excel-2016-comprehensive-1st-edition-mulbery-test-b
ank/
Exploring Microsoft Office Excel 2016 Comprehensive (Poatsy/Grauer)
Chapter 8 Statistical Functions
1) In SUMIF, AVERAGEIF, and COUNTIF functions using text criteria, enclose the criteria in:
A) **
B) <>
C) ##
D) ""
Answer: D
Diff: 1
Objective: 1 Use Conditional Math and Statistical Functions
2) What would be the result of this formula:
=AVERAGEIF(A2:A64,"Green",C2:C64)?
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
Answer: D
Diff: 2
3) What is the sum_range argument of:
=SUMIF(A2:A64,"Green",C2:C64)?
A) C2:C64
B) "Green"
C) SUMIF
D) A2:A64
Answer: A
Diff: 1
4) What is the Criteria2 argument of:
=COUNTIFS(A2:A64,"Blue",B2:B64,"Black")?
A) "Blue"
B) B2:B64
C) "Black"
D) A2:A64
Answer: C
Diff: 3
5) This is the top three lines in a list of 8200 records. You want an average of the number of
speeding tickets for Red Toyota Priuses. Which is the correct formula?
A B C D E
Speeding
1 Year Make Model Color Tickets
2 2016 Honda Accord Black 2
3 2018 Toyota Prius Red 0
A) =AVERAGEIFS(A2:A8201,D2:D8201,"Red",B2:B8201,"Toyota",C2:C8201,"Prius")
B) =AVERAGEIFS(E2:E8201,D2:D8201,"Red",B2:B8201,"Toyota",C2:C8201,"Prius")
C) =AVERAGEIF(E2:E8201,D2:D8201,"Red",B2:B8201,"Toyota",C2:C8201,"Prius")
D) =AVERAGEIF(E2:E8201,"Red","Toyota","Prius")
Answer: B
Diff: 3
6) What is the first argument of an SUMIFS function?

A) Criteria_range1
B) Sum_range
C) Criteria1
D) Criteria2
Answer: B
Diff: 2
7) When using the Function Arguments Box, Excel will ________.

A) suggest criteria
B) not enter quotation marks in text criteria
C) suggest ranges
D) enter the quotation marks in text criteria, automatically
Answer: D
Diff: 2
8) 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?
A B C D E
1 Level Last Purchase First Name Last Name Market
2 Silver 12/1/2016 Tanya Smith Tupelo
3 Gold 12/3/2018 Martha Forester Minneapolis
4 Platinum 12/8/2019 Thomas Cord Lakeland
A) =COUNTIF(A2:A3083,"Gold")
B) =COUNTIFS(A2:A3083,"Gold")
C) =COUNTIF(E2:E3083,"Gold")
D) =COUNTIFS(A2:E3083,"Gold")
Answer: A
Diff: 2
9) Relative Standing measures ________.

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
Answer: D
Diff: 2
Objective: 2 Calculate Relative Standing with Statistical Functions
10) The RANK.EQ function returns ________.

A) the rank of a value within a dataset, giving an average ranking to tied values
B) the rank of a value within a dataset, giving the highest ranking possible to ties
C) the rank of a value within a dataset, throwing out ties
D) the rank of a value within a dataset, giving the same ranking to tied values
Answer: D
Diff: 2
11) Which function returns the rank of a value within a dataset, assigning an average rank for
tied values?
A) RANK.EQ
B) RANK.AVG
C) RANK.TIE
D) AVERAGERANK
Answer: B
Diff: 1
12) If you autofill the formula =RANK.AVG(A1,$A$1:$A$5,0) from B1 to B5, what would the
value be in B5?
A B
1 7
2 5
3 8
4 9
5 7
A) 4.5
B) 4
C) 3.5
D) 3
Answer: C
Diff: 3
13) Which of the following is not an argument in the PERCENTRANK.INC and

PERCENTRANK.EXC functions?
A) array
B) criteria
C) x
D) significance
Answer: B
Diff: 2
14) Which of the following is an allowable quart argument in a QUARTILE.EXC function?

A) 4
B) 0
C) 2
D) 5
Answer: C
Diff: 2
15) A college admissions office might use which of the following functions to offer scholarships
to incoming student who are in the top 10% of their high school classes?
A) PERCENTILE.INC
B) PERCENTILE.EXC
C) PERCENTRANK.INC
D) PERCENTRANK.EXC
Answer: A
Diff: 3
16) Which of the following functions determines the standard deviation of a sample?
A) STDEVA
B) VARA
C) STDEV.P
D) STDEV.S
Answer: D
Diff: 3
Objective: 3 Measure Central tendency
17) What function returns the variance of a population?

A) VARA
B) VAR.P
C) VAR.S
D) VARPA
Answer: B
Diff: 3
18) Which of the following values would demonstrate the strongest positive relationship while
using the CORREL function?
A) 0
B) 0.5
C) -1
D) 1
Answer: D
Diff: 2
19) Which function would you use to determine the number of occurrences of a particular value
in a dataset?
A) BINS
B) DEVP
C) FREQUENCY
D) CORREL
Answer: C
Diff: 2
20) What are the two arguments for the FREQUENCY function?
A) data_array, correlation_array
B) data_array, bins_array
C) data_array, set_value
D) data_array, outlier
Answer: B
Diff: 2
21) Which function returns the standard deviation of a population including logical values and
text?
A) STDEVA
B) STDEV.P
C) STDEVPA
D) STDEV.S
Answer: C
Diff: 3
22) A(n) ________ is a dataset that contains a manageable subset of a population.

A) population
B) sample
C) variance
D) standard deviation
Answer: B
Diff: 1
23) The ________ function returns the variance of a sample of numerical data
A) VARPA
B) VAR.P
C) VARA
D) VAR.S
Answer: D
Diff: 2
24) Which function would you use to test for a relationship between students' attendance and
their test scores?
A) CORREL
B) RELATE.S
C) RELATE.P
D) VARPA
Answer: A
Diff: 2
25) What is the common name for the square root of the variance?
A) Correlation coefficient
B) P-value
C) Standard deviation
D) T-test
Answer: C
Diff: 2
26) Which of the following is an Excel Add-in?

A) Analysis ToolPak
B) Frequency
C) Standard deviation
D) ANOVA
Answer: A
Diff: 1
Objective: 4 Load the Analysis ToolPak
27) Why is it important to analyze the relationships between a sample and full population?
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
Answer: B
Diff: 2
28) A(n) ________ is a visual depiction of a population distribution created by the Analysis
ToolPak.
A) histogram
B) ANOVA
C) correlation coefficient
D) mu
Answer: A
Diff: 1
Objective: 5 Perform Analysis Using the Analysis ToolPak
29) ________ determines how two sets of data from a sample vary simultaneously.
A) STDEV.S
B) COVARIANCE.S
C) CORREL
D) STDEV.P
Answer: B
Diff: 2
30) Which of the following outputs from an ANOVA summary report is used to determine the
significance of the F-Test?
A) F
B) dF
C) SS
D) F-crit
Answer: D
Diff: 2
31) Which of the following represents the number of data points in a sample minus one?
A) F ratio
B) Probability
C) Degrees of Freedom
D) Critical value
Answer: C
Diff: 2
32) ________ 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.
A) Covariance
B) Correlation
C) Causation
D) Period
Answer: A
Diff: 2
33) The simplest method of creating a ________ is with the Analysis Toolpak
A) frequency chart
B) histogram
C) standard deviation
D) distribution chart
Answer: B
Diff: 2
34) Which of the following is not an ANOVA calculation type?

A) Single-factor
B) Two-factor with replication
C) Two-factor without replication
D) Two wing
Answer: D
Diff: 2
35) What is SS in an ANOVA summary report?

A) Summary statistics
B) Statistical score
C) Sum of squares
D) Square summary
Answer: C
Diff: 2
36) What is MS in an ANOVA summary report?
A) Mean of the sample squared
B) Maximum of squared value
C) Minimum of squared value
D) Multiplier of sample
Answer: A
Diff: 2
37) What is F in an ANOVA summary report?

A) Frequency
B) Falling rate
C) F ratio
D) Fallibility reading
Answer: C
Diff: 2
38) ________ is a measure of how two sets of data vary simultaneously.

A) Deviation
B) Covariance
C) Probability
D) Frequency
Answer: B
Diff: 1
39) A(n) ________ is a business intelligence tool which extrapolates future values based on
current trends.
A) analysis of variance
B) forecast worksheet
C) standard deviation
D) frequency
Answer: B
Diff: 2
Objective: 6 Create a Forecast Sheet
40) ________ returns the forecasted values of a target date using exponential smoothing.
A) FORECAST.ETS.CONFINT
B) FORECAST.ETS
C) FORECAST.ETS.SEASONALITY
D) FORECAST.LINEAR
Answer: B
Diff: 2
41) To count the number of Finance majors in a list of students and their college majors, use the
________ function.
Answer: COUNTIF
Diff: 2
42) Sum_range is the argument in the ________ function that is added together if a single
condition is met.
Answer: SUMIF
Diff: 2
43) The ________ function calculates the average, or arithmetic mean, of all cells in a range that
meet a specific condition.
Answer: AVERAGEIF
Diff: 2
44) The ________ function counts the number of cells in a range that meet multiple criteria.
Answer: COUNTIFS
Diff: 2
45) In SUMIFS, AVERAGEIFS and COUNTIFS functions, you must have a(n) ________
argument for each criteria_range argument.
Answer: criteria
Diff: 2
46) The ________ function will use average values to determine the rank of a number within a
list if tied values are present.
Answer: RANK.AVG
Diff: 2
47) The ________ function identifies a value's rank within a list of values, omitting the next
rank in the case of tied values.
Answer: RANK.EQ
Diff: 2
48) The ________ function returns a value's rank as a percent between 0% and 100%.
Answer: PERCENTRANK.EXC
Diff: 2
49) The ________ function is best suited to calculate quartiles including quartiles 0 and 4.
Answer: QUARTILE.INC
Diff: 2
50) ________ is a measure of a dataset's dispersion or the difference between the highest and
lowest values.
Answer: Variance
Diff: 1
51) ________ is the measure of how far the data sample spreads from the mean.
Answer: Standard deviation
Diff: 2
52) The ________ is the square root of the variance.

Answer: standard deviation
Diff: 2
53) The ________ function returns the variance of a population.

Answer: VAR.P
Diff: 1
54) ________ statistics help analyze differences between groups and relationships within groups
of data.
Answer: Inferential
Diff: 2
55) The ________ is an add-in program that provides statistical analysis tools.
Answer: Analysis ToolPak, Analysis Tool Pak, Analysis Tool pack, Analysis Toolkit,
Analysis tool, Analysis tools
Diff: 2
56) ________ is a statistical hypothesis test that helps determine if samples of data were taken
from the same population.
Answer: ANOVA
Diff: 1
57) ________ is a measure of how two sets of data vary simultaneously.
Answer: Covariance
Diff: 2
58) A(n) ________ is a visual display of tabulated frequencies.

Answer: histogram
Diff: 2
59) A histogram requires ________ to tabulate data and return a frequency distribution table.
Answer: bins
Diff: 1
60) The ________ is the probability of a population being similarity to a sample.

Answer: P-value
Diff: 2
61) The ________ function returns the forecasted values for a specific future target date using
exponential smoothing.
Answer: FORECAST.ETS
Diff: 2
62) If you have 10 years of SAT data and 10 years of Teacher pay data and you'd like to see a
trend that might predict their behavior in the future, you would create a ________ Sheet.
Answer: Forecast
Diff: 1
63) Sort data in ________ order before beginning a forecast analysis.

Answer: chronological, date, oldest to newest, time
Diff: 1
64) The ________ function returns the length of the repetitive pattern Excel detects for the time
series.
Answer: FORECAST.ETS.SEASONALITY
Diff: 3
65) ________ returns the forecasted values for a specific future target date using exponential
smoothing.
Answer: FORECAST.ETS
Diff: 2
66) Two or more conditions can be used with SUMIFS function.

Answer: TRUE
Diff: 2
67) This formula will successfully count all green items in the range C2:C256.
=COUNTIF(C2:C256,green)
Answer: FALSE
Diff: 3
68) The arguments for COUNTIFS, SUMIFS, AVERAGEIFS are Range and Criteria.
Answer: FALSE
Diff: 1
69) =AVERAGEIFS(C2:C64,A2:A64,"Blue",B2:B64,"Black")
Returns an average of Column C of the items which are either Blue or Black.
Answer: FALSE
Diff: 3
70) Both RANK.EQ and RANK.AVG functions have the same arguments.
Answer: TRUE
Diff: 3
71) The PERCENTRANK.INC function displays a value's rank as a percentile of a range,

including 0% and 100%.
Answer: TRUE
Diff: 2
72) The Significance argument in a PERCENTRANK function is the input for confidence
intervals.
Answer: FALSE
Diff: 1
73) A quartile is a value used to divide a range into five equal groups.
Answer: FALSE
Diff: 2
74) The k argument in a PERCENTILE function is a value from 0 to 1.

Answer: TRUE
Diff: 2
75) The Greek letter mu is the symbol for standard deviation.

Answer: FALSE
Diff: 2
76) The VARPA function calculates the variance of a population for numerical values.
Answer: FALSE
Diff: 3
77) The FREQUENCY function determines the strength of the relationship between two data
sets.
Answer: FALSE
Diff: 1
78) The CORREL function would be useful to determine the strength of a relationship between
two variables.
Answer: TRUE
Diff: 2
79) To determine how often a value occurs in a dataset, use the SUMIFS function.
Answer: FALSE
Diff: 2
80) Inferential statistics and Descriptive statistics are the same thing.
Answer: FALSE
Diff: 2
81) The Analysis ToolPak is available on the Insert Tab.

Answer: FALSE
Diff: 1
82) Correlation is a tool included on the Analysis ToolPak.

Answer: TRUE
Diff: 2
83) ANOVA stands for analysis of variability.
Answer: FALSE
Diff: 3
84) STDEV.S calculates the standard deviation of a sample.

Answer: TRUE
Diff: 1
85) Covariance has two functions associated with it - COVARIANCE.P and COVARIANCE.S.
Answer: TRUE
Diff: 2
86) A histogram is a pie chart created by the Analysis ToolPak.

Answer: FALSE
Diff: 1
87) A Forecast worksheet is a business intelligence tool that projects trends based on historical
data.
Answer: TRUE
Diff: 1
88) The FORECAST.ETS function returns a confidence interval for a forecast at all future dates.
Answer: FALSE
Diff: 2
89) Excel 2016 has NO new functions in the Analysis ToolPak.

Answer: FALSE
Diff: 1
90) FORECAST.ETS.SEASONALITY returns the projected quarter of the year when a

forecasted value will happen.
Answer: FALSE
Diff: 2
91) Match each of the following concepts to its best description:
I. Conditional math
II. Multiple criteria
III. Relative standing
IV. Central tendency
V. Correlation
A. More than one condition

B. Mathematical functions performed only on values which meet specified criteria
C. Measures average or likely distribution from the most likely outcome.
D. Relates a data point to its population
E. The relationship between values of a dataset.
Answer: B, A, D, C, E
Diff: 2
Objective: Multiple Locations in the Chapter
92) Match each of the following functions to its best description of its purpose:
I. COUNTIF
II. COUNTIFS
III. SUMIFS
IV. SUMIF
V. AVERAGEIF
A. Calculates the average, or arithmetic mean, of all cells in a range that meet a specific
condition
B. Calculates the number of cells in a range when a specified condition is met
C. Calculates the total of a range of values when a specified condition is met
D. Calculates the total value of cells in a range that meet multiple criteria
E. Returns the number of cells in a range that meet multiple criteria
Answer: B, E, D, C, A
Diff: 2
I. AVERAGEIFS
II. Criteria
III. Sum_range
IV. Criteria2
V. Criteria_range1
A. The range of values to be added together in conditional math functions

B. The value to be matched in a conditional math function
C. The location of a criteria to be met in a function matching multiple criteria
D. The second criteria in a function matching multiple criteria.
E. The function which returns the average of a given range of values which matches multiple
criteria
Answer: E, B, A, D, C
Diff: 2
94) Match each of the following concepts to its most likely application:
I. Quartile 0
II. Quartile 1
III. Quartile 2
IV. Quartile 3
V. Quartile 4
A. The value at the 75th percentile

B. Highest value within the dataset. Identical to using the MAX function. Allowed in
QUARTILE.INC only
C. The value at the 50th percentile
D. Lowest value in the dataset. Identical to using the MIN function. Allowed in
QUARTILE.INC only
E. The value at the 25th percentile
Answer: D, E, C, A, B
Diff: 1
95) Match each of the following concepts to its most likely application:
I. RANK.EQ
II. RANK.AVG
III. PERCENTRANK.EXC
IV. PERCENTRANK.INC
V. QUARTILE.EXC
A. A value's rank as a percent excluding 0 and 1

B. A value's rank within a list of values, returning the same value for ties
C. The value at a specific quartile for a dataset
D. A value's rank as a percent of the range of data in the dataset with highest and lowest values
E. A value's rank within a list of values, returning the mean value for ties
Answer: B, E, A, D, C
Diff: 2
I. VARPA
II. STDEVPA
III. FREQUENCY
IV. CORREL
V. BINS
A. Standard deviation of a population containing logical values and text

B. Data ranges in which data can be categorized
C. Variance of a population including logical values and text
D. Helps determine the strength of a relationship between two values
E. Determines the number of occurrences of a value in a dataset
Answer: C, A, E, D, B
Diff: 2
97) Match each of the following terms to its description:
I. Inferential Statistics
II. Descriptive Statistics
III. Analysis ToolPak
IV. Population
V. Sample
A. All the members of a group

B. A manageable subset of a dataset
C. Add-in which assists with calculating inferential statistics
D. Helps analyze differences between groups and relationships within groups of data
E. Defines characteristics of a population
Answer: E, D, C, A, B
Diff: 2
I. ANOVA
II. Sum of Squares
III. Degrees of freedom
IV. P-value
V. F ratio
A. The mean square between/mean square within

B. Analysis of Variance
C. The number of data points in the sample
D. Probability of a population being similar to the sample
E. Sum of the squares of the data points in a sample
Answer: B, E, C, D, A
Diff: 2
I. COVARIANCE.P
II. COVARIANCE.S
III. Histogram
IV. Critical value of F
V. Random variation
A. Normal unpredictable changes within a population dataset

B. Measures how 2 sets of sample data vary simultaneously
C. Determines the significance of the F_Test
D. Measures how 2 sets of an entire population data vary simultaneously
E. A charting option available in the Analysis Toolpak
Answer: D, B, E, C, A
Diff: 2
100) Match each of the following concepts to its best description of its purpose:
I. FORECAST.ETS.CONFINT
II. FORECAST.ETS
III. FORECAST.ETS.STAT
IV. FORECAST.ETS.SEASONALITY
V. FORECAST.LINEAR
A. Returns a confidence interval for the forecast value at the target date
B. Calculates a future value along a linear trend by using existing values
C. Returns the forecasted values for a specific future target date using exponential smoothing
D. Returns the requested statistic for the forecast
E. Returns the length of the repetitive pattern for a time series
Answer: A, C, D, E, B
Diff: 2

Exploring Microsoft Office Excel 2016 Comprehensive 1st Edition Mulbery Test Bank Download

Uploaded by

Copyright:

Available Formats

Exploring Microsoft Office Excel 2016 Comprehensive 1st Edition Mulbery Test Bank Download

Uploaded by

Document Information

Original Description:

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Exploring Microsoft Office Excel 2016 Comprehensive 1st Edition Mulbery Test Bank Download

Uploaded by

Copyright:

Available Formats

Exploring Microsoft Office Excel 2016

Comprehensive 1st Edition Mulbery

2) What would be the result of this formula:

3) What is the sum_range argument of:

4) What is the Criteria2 argument of:

6) What is the first argument of an SUMIFS function?

7) When using the Function Arguments Box, Excel will ________.

9) Relative Standing measures ________.

10) The RANK.EQ function returns ________.

13) Which of the following is not an argument in the PERCENTRANK.INC and

14) Which of the following is an allowable quart argument in a QUARTILE.EXC function?

17) What function returns the variance of a population?

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

26) Which of the following is an Excel Add-in?

34) Which of the following is not an ANOVA calculation type?

35) What is SS in an ANOVA summary report?

37) What is F in an ANOVA summary report?

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

52) The ________ is the square root of the variance.

53) The ________ function returns the variance of a population.

58) A(n) ________ is a visual display of tabulated frequencies.

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

63) Sort data in ________ order before beginning a forecast analysis.

66) Two or more conditions can be used with SUMIFS function.

71) The PERCENTRANK.INC function displays a value's rank as a percentile of a range,

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

75) The Greek letter mu is the symbol for standard deviation.

81) The Analysis ToolPak is available on the Insert Tab.

82) Correlation is a tool included on the Analysis ToolPak.

84) STDEV.S calculates the standard deviation of a sample.

86) A histogram is a pie chart created by the Analysis ToolPak.

89) Excel 2016 has NO new functions in the Analysis ToolPak.

90) FORECAST.ETS.SEASONALITY returns the projected quarter of the year when a

91) Match each of the following concepts to its best description:

A. More than one condition

A. The range of values to be added together in conditional math functions

A. The value at the 75th percentile

A. A value's rank as a percent excluding 0 and 1

96) Match each of the following concepts to its best description:

A. Standard deviation of a population containing logical values and text

A. All the members of a group

98) Match each of the following concepts to its best description:

A. The mean square between/mean square within

A. Normal unpredictable changes within a population dataset

You might also like