3.7 Module 3 challenge

In this spreadsheet, what will be returned from the formula =A4*D3 ?

A. 4

B. 8

C. 12

D. 3

C. 12

Fill in the blank: A range is a collection of ___ cells.

A. averaged

B. numerically ordered

C. two or more

D. duplicate

C. two or more

What are some common focus areas when creating a scope of work as a data analyst? Select all that apply.

A. Set a schedule for the project

B. Include information about data preparation

C. Create a full interactive dashboard to deeply analyze the data

D. Note any key milestones for the project

A. Set a schedule for the project

B. Include information about data preparation

D. Note any key milestones for the project

A data professional encounters a REF error how should they resolve the problem?

A. Ensure the referenced formula name is recognized

B. Insert a limiter between the cell values referenced in the formula

C. Confirm that reference start end dates are in the correct order

D. Determine whether a referenced cell row or column was deleted

D. Determine whether a referenced cell row or column was deleted

In this spreadsheet, which SUM function will add all of the values between cells E1 and F6

A. =SUM (E1: F6)

B. =SUM (E1-F6)

C. =SUM, E1+F6

D. =SUM (E1, F6)

A. =SUM (E1: F6)

6. Which of the following statements accurately describe structured thinking and the problem domain? Select all that apply.

A. Structured thinking enables data professionals to understand problems at a high level.

B. The starting place for structured thinking is the problem domain.

C. The problem domain involves organizing available information, revealing gaps and opportunities, and identifying options.

D. Determining a problem domain helps make it possible to establish requirements.

A. Structured thinking enables data professionals to understand problems at a high level.

B. The starting place for structured thinking is the problem domain.

D. Determining a problem domain helps make it possible to establish requirements.

In this spreadsheet, what should be done to correct the DIV error in cell D1?

A. Copy the formula to the rest of the cells in column D.

B. Ensure the formula is not trying to divide by zero or an empty cell.

C. Search for the correct value in column A.

D. Insert a comma between the cell ranges in the formula.

B. Ensure the formula is not trying to divide by zero or an empty cell.

What is the formula for dividing the value in spreadsheet cell H7 by the value in cell H4?

A. H7: H4

B. =H7/H4

C. =H7/4

D. H7, H4=

B. =H7/H4