Fill in the blank: a data analyst considers which organization created, collected, or funded a dataset in order to understand its _____.

Weekly challenge 3

LATEST SUBMISSION GRADE

100%

Question 1

Fill in the blank: In spreadsheets, data analysts begin _____ with an equal sign (=).

  • charts
  • cells
  • formulas
  • numbers

Correct. In spreadsheets, data analysts begin formulas with an equal sign (=).

Question 2

Fill in the blank: The labels that describe the type of data contained in each column of a spreadsheet are called _____.

  • attributes
  • aspects
  • assignments
  • allowances

Correct. The labels that describe the type of data contained in each column of a spreadsheet are called attributes.

Question 3

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

  • True
  • False

Correct. To determine an organization’s annual budget, a data analyst might use a spreadsheet.

Question 4

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

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

Correct. Formulas are written by the user, and functions are already defined.

Question 5

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

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

Correct. In the function, A1:A12 represents the range. A range is a collection of two or more cells.

Question 6

What is the correct spreadsheet formula for multiplying cell H2 times cell H5?

  • =H2^H5
  • =H2xH5
  • =H2/H5
  • =H2*H5

Correct. The correct spreadsheet formula for multiplying cells H2 times cell H5 is =H2H5. The asterisk () is the operator for multiplication.

Question 7

Fill in the blank: By negatively influencing data collection, ____ can have a detrimental effect on analysis.

  • partiality
  • objectivity
  • filtering
  • bias

Correct. By negatively influencing data collection, bias can have a detrimental effect on analysis.

Question 8

Fill in the blank: A data analyst considers which organization created, collected, or funded a dataset in order to understand its _____.

  • structure
  • length
  • detail
  • context

Correct. Defining the problem domain is part of the structured-thinking process.

🗂️ Page Index for this GitHub Wiki

What is data analyst and how they collect data?

A data analyst collects, cleans, and interprets data sets in order to answer a question or solve a problem. They work in many industries, including business, finance, criminal justice, science, medicine, and government.

What process do data analysts use to recognize the current situation organize information and identify options?

Structured thinking is the process of recognizing the current problem or situation, organizing available information, revealing gaps and opportunities, and identifying the options.

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

Correct. The labels that describe the type of data contained in each column of a spreadsheet are called attributes.
Question 4. What process do data analysts use to keep project-related files together and organize them into subfolders? Correct. Data analysts use foldering to keep project-related files together and organize them into subfolders.