In this spreadsheet, what will be returned from the formula =B4*E3?

• 33

• 90

• 27

• 10

Fill in the blank: A range is a _____ of two or more cells.

• collection

• worksheet

• table

• grid

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

• Establish an agreed-upon outline of the work to be performed

• Note when the client can expect reports

• Make sure the data filtered and sorted

• Include key information about data validation

A data professional troubleshoots a spreadsheet error. After researching the error, they discover that their formula is referencing a column that has been deleted. They update the formula with the correct column name. What type of error did they resolve?

• REF

• VALUE

• ERROR or parsing error

• NUM

In this spreadsheet, which SUM function will add all of the values between cells C1 and E6?

• =SUM(C1:E6)

• \=SUM(C1,E6)

• \=SUM(C1-E6)

• \=SUM,C1+E6

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

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

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

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

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

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

• Search for the correct value in column A.

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

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

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

What is the formula for dividing the value in spreadsheet cell K15 by the value in cell K3?

• \=K15/3

• =K15/K3

• K15:K3

• K15,K3=