Week 3: More spreadsheet basics

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

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

11. In spreadsheets, formulas and functions end with an equal sign (=).

  • True
  • False

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

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

21. Attributes are used in spreadsheets for what purpose?

  • Analyze the data in a row
  • Insert data into each column
  • Add a new column
  • Label the data in each column

22. To determine an organization’s annual budget, a data analyst might use a slideshow.

  • True
  • False

23. Which of the following statements describes a key difference between formulas and functions?

  • Formulas contain words and numbers, and functions contain numbers only.
  • Formulas span two or more cells, and functions exist in only one cell.
  • Formulas are used in graphs, and functions are not.
  • Formulas are written by the user, and functions are already defined.

24. What do data analysts use to label the type of data contained in each column in a spreadsheet?

  • Tables
  • Menus
  • Attributes

  • Headings

25. In the function =MAX(A1:A12), what does A1:A12 represent?

  • The range
  • The operator
  • The maximum
  • The formula

26. Fill in the blank: Putting data into context helps data analysts eliminate _____.

  • labels
  • intolerance
  • bias
  • fairness

27. What is the correct spreadsheet formula for multiplying cell K3 times cell K8?

  • =K3*K8
  • =K3xK8
  • =K3/K8
  • =K3^K8

Leave a Reply