QBA Final Exam Study Guide Questions With Complete Answers

QBA Final Exam Study Guide Questions With Complete 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