ask questions to make data-driven decisions weekly challenge 3 answers
1. Fill in the blank: In spreadsheets, data analysts begin _____ with an equal sign (=).
- cells
- numbers
- formulas
- charts
2. Fill in the blank: The labels that describe the type of data contained in each column of a spreadsheet are called _____.
- assignments
- attributes
- allowances
- aspects
3. Which of the following tasks might be performed using spreadsheets?
- Maintain information about accounts
- Write a sales pitch
- Develop communication skills
- Land a new client
4. Formulas are created by the user, whereas functions are preset commands in spreadsheets.
- True
- False
5. In the function =MAX(B5:B15), what does B5:B15 represent?
- Observation
- Column
- Attribute
- Range
6. What is the correct spreadsheet formula for multiplying cell H2 times cell H5?
- =H2/H5
- =H2^H5
- =H2*H5
- =H2xH5
7. To avoid bias when collecting data, a data analyst should keep what in mind?
- Context
- Opinion
- Stakeholders
- Graphs
8. A data analyst might use descriptive column headers in order to achieve what goal?
- Add context to their data
- Protect the spreadsheet
- Alphabetize the spreadsheet data
- Filter the data
Shuffle Q/A 1
9. To determine an organization’s annual budget, a data analyst might use a slideshow.
- True
- False
10. Which of the following are ways that data analysts can add context to their data? Select all that apply.
- Use descriptive column headers
- Consider where the data came from
- Create reports for stakeholders
- Ask questions about the data
