QBA Final Exam Study Guide questions with correct answers

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 R