QBA Final Exam Study Guide LATEST WITH 110 REAL EXAM QUESTIONS AND CORRECT ANSWERS(VERIFIED ANSWERS)|AGRADE

QBA Final Exam Study Guide LATEST WITH 110 REAL EXAM QUESTIONS AND CORRECT ANSWERS(VERIFIED ANSWERS)|AGRADE 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 What is the standard deviation of a data set? - ANSWER- The average difference from the data points to the mean In a standard normal distribution, what is 1 equal to? - ANSWER- The standard deviation When you want to fairly compare two values from different distributions, what should you use? - ANSWER- Their z-scores