QBA FINAL EXAM STUDYT GUIDE 2024-2025 |COMPLETE
QUESTIONS AND CORRECT ANSWERS (VERIFIED ANSWERS ) A
GRADED.
Why should we take the time to format spreadsheets? - 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? - ANSWER -Contrast
What is the difference between a formula and a function? - ANSWER
A function is a built-in formula
How do you know how to format a spreadsheet in the "real world"? -
ANSWER -You'll need to create or conform to the specific standards
for an individual company or industry
What is syntax? - 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? -
ANSWER -''1 Formatting!'
The syntax for the SUM function looks like this: SUM(number1,
[number2],...) What is this syntax telling you to do? - 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? - 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? - ANSWER -Quantitative, because
they are measurable, numeric values
What portion of this formula should be calculated first? Y = (X + CD) +
D^2 * X + C - ANSWER -X + CD
Which of the following is an example of qualitative data? - ANSWER -
Major
What is the purpose of creating an absolute reference to a cell in a
formula? - 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? - ANSWER -The selected
range of cells that will have its values averaged
QUESTIONS AND CORRECT ANSWERS (VERIFIED ANSWERS ) A
GRADED.
Why should we take the time to format spreadsheets? - 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? - ANSWER -Contrast
What is the difference between a formula and a function? - ANSWER
A function is a built-in formula
How do you know how to format a spreadsheet in the "real world"? -
ANSWER -You'll need to create or conform to the specific standards
for an individual company or industry
What is syntax? - 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? -
ANSWER -''1 Formatting!'
The syntax for the SUM function looks like this: SUM(number1,
[number2],...) What is this syntax telling you to do? - 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? - 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? - ANSWER -Quantitative, because
they are measurable, numeric values
What portion of this formula should be calculated first? Y = (X + CD) +
D^2 * X + C - ANSWER -X + CD
Which of the following is an example of qualitative data? - ANSWER -
Major
What is the purpose of creating an absolute reference to a cell in a
formula? - 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? - ANSWER -The selected
range of cells that will have its values averaged
