QBA Final Exam Study Guide | 112 Questions with 100% Correct Answers | Updated & Verified
Why should we take the time to format spreadsheets? - -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? - Contrast What is the difference between a formula and a function? - A function is a built-in formula How do you know how to format a spreadsheet in the "real world"? - You'll need to create or conform to the specific standards for an individual company or industry What is syntax? - 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? - ''1 Formatting!' The syntax for the SUM function looks like this: SUM(number1, [number2],...) What is this syntax telling you to do? - Select all cells you want to add together, separate each with a comma, and close with a parenthesis
Document information
- Uploaded on
- July 17, 2023
- Number of pages
- 15
- Written in
- 2022/2023
- Type
- Exam (elaborations)
- Contains
- Questions & answers
