2.3.5.Weekly challenge 3 - sj50179/Google-Data-Analytics-Professional-Certificate GitHub Wiki

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.