QBA FINAL STUDY GUIDES WITH
CORRECT ANSWERS
Why should we take the time to format spreadsheets? -
CORRECT ANSWER--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? - CORRECT ANSWER-Contrast
What is the difference between a formula and a function? -
CORRECT ANSWER-A function is a built-in formula
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
What is syntax? - CORRECT ANSWER-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? - CORRECT ANSWER-''1 Formatting!'
, The syntax for the SUM function looks like this: SUM(number1,
[number2],...) What is this syntax telling you to do? -
CORRECT ANSWER-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? - CORRECT ANSWER-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? - CORRECT
ANSWER-Quantitative, because they are measurable, numeric
values
What portion of this formula should be calculated first? Y = (X +
CD) + D^2 * X + C - CORRECT ANSWER-X + CD
Which of the following is an example of qualitative data? -
CORRECT ANSWER-Major
What is the purpose of creating an absolute reference to a cell
in a formula? - CORRECT ANSWER-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? - CORRECT
ANSWER-The selected range of cells that will have its values
averaged
What is the standard deviation of a data set? - CORRECT
ANSWER-The average difference from the data points to the
mean
CORRECT ANSWERS
Why should we take the time to format spreadsheets? -
CORRECT ANSWER--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? - CORRECT ANSWER-Contrast
What is the difference between a formula and a function? -
CORRECT ANSWER-A function is a built-in formula
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
What is syntax? - CORRECT ANSWER-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? - CORRECT ANSWER-''1 Formatting!'
, The syntax for the SUM function looks like this: SUM(number1,
[number2],...) What is this syntax telling you to do? -
CORRECT ANSWER-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? - CORRECT ANSWER-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? - CORRECT
ANSWER-Quantitative, because they are measurable, numeric
values
What portion of this formula should be calculated first? Y = (X +
CD) + D^2 * X + C - CORRECT ANSWER-X + CD
Which of the following is an example of qualitative data? -
CORRECT ANSWER-Major
What is the purpose of creating an absolute reference to a cell
in a formula? - CORRECT ANSWER-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? - CORRECT
ANSWER-The selected range of cells that will have its values
averaged
What is the standard deviation of a data set? - CORRECT
ANSWER-The average difference from the data points to the
mean
