QBA FINAL EXAM STUDY GUIDE
UPDATED QUESTIONS AND CORRECT
ANSWERS.
Why should we take the time to format spreadsheets? - ANS -It helps communicate the data
more clearly
-It makes the work look more professional
What is used to draw attention to headings and distinguish them from the data in tables? -
ANS Contrast
What is the difference between a formula and a function? - ANS A function is a built-in
formula
How do you know how to format a spreadsheet in the "real world"? - ANS You'll need to
create or conform to the specific standards for an individual company or industry
What is syntax? - ANS The prompts Excel gives you regarding what inputs to use in a function
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? - ANS ''1 Formatting!'
1 @COPYRIGHT 2025/2026 ALLRIGHTS RESERVED
, The syntax for the SUM function looks like this: SUM(number1, [number2],...) What is this
syntax telling you to do? - ANS Select all cells you want to add together, separate each with a
comma, and close with a parenthesis
How is the ROUND function different from using the decrease decimal button? - ANS The
round function actually removes extra digits; the decrease button only hides extra decimal
places from view
What type of data are the Sales amounts in the Paste Special tab, and why are they considered
that type? - ANS Quantitative, because they are measurable, numeric values
What portion of this formula should be calculated first? Y = (X + CD) + D^2 * X + C - ANS X+
CD
Which of the following is an example of qualitative data? - ANS Major
What is the purpose of creating an absolute reference to a cell in a formula? - ANS To ensure
when your formula is copied that the value in the same exact cell is used for each copied
formula
In the syntax =(AVERAGEIFS(average_range, criteria_range1, criteria1,...), what is the
average_range? - ANS The selected range of cells that will have its values averaged
What is the standard deviation of a data set? - ANS The average difference from the data
points to the mean
In a standard normal distribution, what is 1 equal to? - ANS The standard deviation
When you want to fairly compare two values from different distributions, what should you use?
- ANS Their z-scores
2 @COPYRIGHT 2025/2026 ALLRIGHTS RESERVED
UPDATED QUESTIONS AND CORRECT
ANSWERS.
Why should we take the time to format spreadsheets? - ANS -It helps communicate the data
more clearly
-It makes the work look more professional
What is used to draw attention to headings and distinguish them from the data in tables? -
ANS Contrast
What is the difference between a formula and a function? - ANS A function is a built-in
formula
How do you know how to format a spreadsheet in the "real world"? - ANS You'll need to
create or conform to the specific standards for an individual company or industry
What is syntax? - ANS The prompts Excel gives you regarding what inputs to use in a function
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? - ANS ''1 Formatting!'
1 @COPYRIGHT 2025/2026 ALLRIGHTS RESERVED
, The syntax for the SUM function looks like this: SUM(number1, [number2],...) What is this
syntax telling you to do? - ANS Select all cells you want to add together, separate each with a
comma, and close with a parenthesis
How is the ROUND function different from using the decrease decimal button? - ANS The
round function actually removes extra digits; the decrease button only hides extra decimal
places from view
What type of data are the Sales amounts in the Paste Special tab, and why are they considered
that type? - ANS Quantitative, because they are measurable, numeric values
What portion of this formula should be calculated first? Y = (X + CD) + D^2 * X + C - ANS X+
CD
Which of the following is an example of qualitative data? - ANS Major
What is the purpose of creating an absolute reference to a cell in a formula? - ANS To ensure
when your formula is copied that the value in the same exact cell is used for each copied
formula
In the syntax =(AVERAGEIFS(average_range, criteria_range1, criteria1,...), what is the
average_range? - ANS The selected range of cells that will have its values averaged
What is the standard deviation of a data set? - ANS The average difference from the data
points to the mean
In a standard normal distribution, what is 1 equal to? - ANS The standard deviation
When you want to fairly compare two values from different distributions, what should you use?
- ANS Their z-scores
2 @COPYRIGHT 2025/2026 ALLRIGHTS RESERVED
