QBA Final Exam Study Guide Latest Update
2024-2025 155 Questions and 100% Verified
Correct Answers Actual Exam Guaranteed A+
"33.2%" is a - CORRECT ANSWER: sample statistic
Amazon wants to determine if how many of their Ohio customers are part of the
'Subscribe & Save' program. They take a sample of 15 customers from each zip code in
Ohio (for a total of 11,890 customers). They find that 28.56% of those customers have
received a 'Subscribe & Save' delivery in the past 3 months. - CORRECT ANSWER:
11,890 customers
Are pivot tables updatable? - CORRECT ANSWER: Yes, but not automatically; the
"refresh" button must be pushed to sync with updated data
Assume you have data for sales generated by all employees in a company. In which
scenario would you choose to use a regular SUM function rather than a SUMIFS
function? - CORRECT ANSWER: Find the total sales for all employees
Based on the empirical rule ________ percent of the observations will be contained
within 1 standard deviations around the arithmetic mean, ________ percent of the
observations will be contained within 2 standard deviations around the arithmetic mean,
and ________ percent of the observations will be contained within 3 standard
deviations around the arithmetic mean. - CORRECT ANSWER: about 68, about 95, and
about 99
Can you use a mixture of absolute and relative references in a single formula? -
CORRECT ANSWER: Yes
Employees whose sales exceeded $5000 receive a bonus of $250. Employees whose
sales are $3001 -$5000 get a bonus of $100. Employees whose sales are $1000-3000
get a bonus of $50. What is the correct syntax? - CORRECT ANSWER: IFS(F4>5000,
250, F4>3000, 100, F4>1000, 50)
,Given this syntax: IF(Logical_Test, Value_If_True, Value_If_False) what would be an
example of a "Logical_Test" - CORRECT ANSWER: C4 <= B5
How are COUNTIFS different from SUMIFS and AVERAGEIFS? - CORRECT
ANSWER: SUMIFS and AVERAGEIFS have one more required argument in the syntax
How do Mean and Median differ? - CORRECT ANSWER: The mean is influenced by
outliers but the median is not.
How do you know how to format a spreadsheet in the "real world"? - CORRECT
ANSWER: You'll need to create or conform to the specific standards for an individual
company or industry
How is the ROUND function different from using the decrease decimal button? -
CORRECT ANSWER: The round function actually removes extra digits; the decrease
button only hides extra decimal places from view
How many arguments (inputs) does this syntax REQUIRE? - CORRECT ANSWER:
One
If the correlation coefficient between 2 variables is -0.89, what is the strength of the
correlation? - CORRECT ANSWER: Very strong negative correlation
If the mean and median are similar, which should be used and why? - CORRECT
ANSWER: The mean because that is what you should report if you have a normal
distribution.
If you create a formula in this tab that refers to a cell in the 1 Formatting tab, how would
that tab name appear in the formula? - CORRECT ANSWER: ''1 Formatting!'
If you have qualitative data, which of the following is appropriate to report? - CORRECT
ANSWER: Mode
, If you think that your dataset will change or be updated, what is the best way to
compute descriptive statistics? - CORRECT ANSWER: Use functions (e.g.,
=AVERAGE, =MEDIAN)
If you want to show the total sales for each employee in a pivot table, what categories
would you use for the rows and values, respectively? - CORRECT ANSWER: Employee
for row; Sales for values
If you wanted to lock your reference to cell D2 in a formula and copy that formula across
a row, what should it look like? - CORRECT ANSWER: $D2
If you wanted to lock your reference to cell D7 in a formula and copy that formula down
a column, what should it look like? - CORRECT ANSWER: D$7
In a copyable Index Match Match command, all values are locked except: - CORRECT
ANSWER: The row of the first lookup value and the column of the second lookup value
In a standard normal distribution, what is 1 equal to? - CORRECT ANSWER: The
standard deviation
In function syntax, what do square brackets mean?
Ex: = SUM(number1, [number2],...)
Ex: = MATCH(lookup_value, lookup_array, [match_type]) what do the square brackets
mean? - CORRECT ANSWER: That portion of the function is optional
In the Index function syntax. = Index (array, row_number, col_number) what does
"array" mean? - CORRECT ANSWER: All of the data cells in the table
In the Regression Equation, what is the Y-intercept? - CORRECT ANSWER: The value
of Y when X is 0
2024-2025 155 Questions and 100% Verified
Correct Answers Actual Exam Guaranteed A+
"33.2%" is a - CORRECT ANSWER: sample statistic
Amazon wants to determine if how many of their Ohio customers are part of the
'Subscribe & Save' program. They take a sample of 15 customers from each zip code in
Ohio (for a total of 11,890 customers). They find that 28.56% of those customers have
received a 'Subscribe & Save' delivery in the past 3 months. - CORRECT ANSWER:
11,890 customers
Are pivot tables updatable? - CORRECT ANSWER: Yes, but not automatically; the
"refresh" button must be pushed to sync with updated data
Assume you have data for sales generated by all employees in a company. In which
scenario would you choose to use a regular SUM function rather than a SUMIFS
function? - CORRECT ANSWER: Find the total sales for all employees
Based on the empirical rule ________ percent of the observations will be contained
within 1 standard deviations around the arithmetic mean, ________ percent of the
observations will be contained within 2 standard deviations around the arithmetic mean,
and ________ percent of the observations will be contained within 3 standard
deviations around the arithmetic mean. - CORRECT ANSWER: about 68, about 95, and
about 99
Can you use a mixture of absolute and relative references in a single formula? -
CORRECT ANSWER: Yes
Employees whose sales exceeded $5000 receive a bonus of $250. Employees whose
sales are $3001 -$5000 get a bonus of $100. Employees whose sales are $1000-3000
get a bonus of $50. What is the correct syntax? - CORRECT ANSWER: IFS(F4>5000,
250, F4>3000, 100, F4>1000, 50)
,Given this syntax: IF(Logical_Test, Value_If_True, Value_If_False) what would be an
example of a "Logical_Test" - CORRECT ANSWER: C4 <= B5
How are COUNTIFS different from SUMIFS and AVERAGEIFS? - CORRECT
ANSWER: SUMIFS and AVERAGEIFS have one more required argument in the syntax
How do Mean and Median differ? - CORRECT ANSWER: The mean is influenced by
outliers but the median is not.
How do you know how to format a spreadsheet in the "real world"? - CORRECT
ANSWER: You'll need to create or conform to the specific standards for an individual
company or industry
How is the ROUND function different from using the decrease decimal button? -
CORRECT ANSWER: The round function actually removes extra digits; the decrease
button only hides extra decimal places from view
How many arguments (inputs) does this syntax REQUIRE? - CORRECT ANSWER:
One
If the correlation coefficient between 2 variables is -0.89, what is the strength of the
correlation? - CORRECT ANSWER: Very strong negative correlation
If the mean and median are similar, which should be used and why? - CORRECT
ANSWER: The mean because that is what you should report if you have a normal
distribution.
If you create a formula in this tab that refers to a cell in the 1 Formatting tab, how would
that tab name appear in the formula? - CORRECT ANSWER: ''1 Formatting!'
If you have qualitative data, which of the following is appropriate to report? - CORRECT
ANSWER: Mode
, If you think that your dataset will change or be updated, what is the best way to
compute descriptive statistics? - CORRECT ANSWER: Use functions (e.g.,
=AVERAGE, =MEDIAN)
If you want to show the total sales for each employee in a pivot table, what categories
would you use for the rows and values, respectively? - CORRECT ANSWER: Employee
for row; Sales for values
If you wanted to lock your reference to cell D2 in a formula and copy that formula across
a row, what should it look like? - CORRECT ANSWER: $D2
If you wanted to lock your reference to cell D7 in a formula and copy that formula down
a column, what should it look like? - CORRECT ANSWER: D$7
In a copyable Index Match Match command, all values are locked except: - CORRECT
ANSWER: The row of the first lookup value and the column of the second lookup value
In a standard normal distribution, what is 1 equal to? - CORRECT ANSWER: The
standard deviation
In function syntax, what do square brackets mean?
Ex: = SUM(number1, [number2],...)
Ex: = MATCH(lookup_value, lookup_array, [match_type]) what do the square brackets
mean? - CORRECT ANSWER: That portion of the function is optional
In the Index function syntax. = Index (array, row_number, col_number) what does
"array" mean? - CORRECT ANSWER: All of the data cells in the table
In the Regression Equation, what is the Y-intercept? - CORRECT ANSWER: The value
of Y when X is 0
