# Ask Questions to Make Data-Driven Decisions - Module 3 challenge
1. **In this spreadsheet, what will be returned from the formula** `=B4*E3`**?**
(n/a) | A | B | C | D | E |
1 | 95 | 37 | 1 | 6 | 27 |
2 | 5 | 0 | 49 | 31 | 5 |
3 | 78 | 2 | 6 | 2 | 3 |
4 | 6 | 30 | 10 | 62 | 40 |
5 | 42 | 7 | 21 | 9 | 10 |
* 33
* 90
* 27
* 10
2. **Fill in the blank: A range is a \_\_\_\_\_ of two or more cells.**
* collection
* worksheet
* table
* grid
3. **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
4. **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
5. **In this spreadsheet, which** `SUM` **function will add all of the values between cells C1 and E6?**
(n/a) | A | B | C | D | E | F |
1 | 43 | 68 | 225 | 79 | 34 | 15 |
2 | 23 | 54 | 342 | 89 | 467 | 856 |
3 | 67 | 89 | 24 | 787 | 20 | 90 |
4 | 23 | 43 | 375 | 129 | 706 | 43 |
5 | 34 | 967 | 596 | 136 | 67 | 56 |
6 | 23 | 440 | 3254 | 644 | 94 | 35 |
* =SUM(C1:E6)
* \=SUM(C1,E6)
* \=SUM(C1-E6)
* \=SUM,C1+E6
6. **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.
7. **In this spreadsheet, what should be done to correct the DIV error in cell D2?**
(n/a) | A | B | C | D |
1 | 68 | 7 | 404 | 0 |
2 | 892 | 0 | 73 | #DIV/0! |
3 | 0 | 528 | 599 | 0 |
* 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.
8. **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=
---
![](https://cdn.hashnode.com/res/hashnode/image/upload/v1735997220088/edcc9ef5-71da-4791-9875-84c6b9bc08b4.png align="center")