12. A data analyst could use spreadsheets to achieve which of the following tasks?
- Motivate employees
- Write reports
- Build code for a new app
- Predict next quarter’s sales
13. In the function =MAX(G3:G13), what does G3:G13 represent?
- an attribute
- an observation
- The range
- a table
14. What is the correct spreadsheet formula for multiplying cell D5 times cell D7?
- =D5xD7
- =D5^D7
- =D5*D7
- =D5/D7
15. Fill in the blank: A data analyst considers which organization created, collected, or funded a dataset in order to understand its _____.
- structure
- detail
- length
- context
16. Which of the following statements accurately describe formulas and functions? Select all that apply.
- Formulas are instructions that perform specific calculations.
- Formulas may only be used once per spreadsheet column.
- Functions are preset commands that perform calculations.
- Formulas and functions assist data analysts in calculations, both simple and complex.
17. In the function =MAX(B5:B15), what does B5:B15 represent?
- Attribute
- Column
- Observation
- Range
18. What is the correct spreadsheet formula for multiplying cell H2 times cell H5?
- =H2*H5
- =H2/H5
- =H2xH5
- =H2^H5
Shuffle Q/A 2
19. Both formulas and functions in spreadsheets begin with what symbol?
- Equal sign (=)
- Colon (:)
- Hyphen (-)
- Bracket ([)
20. Fill in the blank: By negatively influencing data collection, ____ can have a detrimental effect on analysis.
- objectivity
- bias
- partiality
- filtering