Module 3 challenge _ Coursera_M2

A B C D E F 1 5435 8568 23525 9679 2534 1745 2 1234 5421 3452 6589 4567 856 3 567 96789 2214 7887 2340 890 4 2231 43453 12375 23129 78906 9430 5 46342 86967 56796 52136 673 5856 6 35235 4740 83254 644 5794 352 Correct 6. Which of the following statements accurately describe structured thinking and the problem domain? Select all that apply. 0.75 / 1 po Correct Correct You didn’t select all the correct answers 7. In this spreadsheet, what should be done to correct the DIV error in cell D3? A B C D 1 0 3786 44 0 2 747 2356 101 0 3 343 0 64 #DIV/0! 1 / 1 po Correct 8. What is the formula for dividing the value in spreadsheet cell K15 by the value in cell K3? 1 / 1 po Correct =SUM(B1:D6) =SUM(B1-D6) =SUM(B1,D6) =SUM,B1+D6 Structured thinking enables data professionals to identify areas that need deeper investigation and understanding. The problem domain involves having a clear list of deliverables and a timeline for major tasks and activities. The starting place for structured thinking is the problem domain. The problem domain is the specific area of analysis that encompasses every activity affecting a problem. 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. K15,K3= =K15/3 =K15/K3 K15:K3