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?...
why should we take the time to format spreadsheets
if you create a formula in this tab that refers to
Written for
Amsterdam University College (AUC)
NURSING
QBA
All documents for this subject (2)
Seller
Follow
TIFFACADEMICS
Reviews received
Content preview
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
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller TIFFACADEMICS. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $14.99. You're not tied to anything after your purchase.
