48  Assessment — Spreadsheet Basics and Structured Thinking

Question 1

In this spreadsheet, what will be returned from the formula =C4*E2?

	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

Options:
- 2
- 15
- 5
- 50

✅ 50  
<br>Explanation: The formula multiplies the value in cell C4 (10) by the value in cell E2 (5).  
10 × 5 = 50.

Question 2

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

• range
  
• domain
  
• scope
  
• field

✅ range  

Question 3

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

• Make sure the data is filtered and sorted
  
• Establish an agreed-upon outline of the work to be performed
  
• Include key information about data sources
  
• Note when the client can expect reports

✅ Establish an agreed-upon outline of the work to be performed. <br>
✅ Include key information about data sources. <br>
✅ Note when the client can expect reports.  

Question 4

A junior data analyst encounters a spreadsheet error. They realize that their formula is referencing a row that has been deleted, so they correct the formula.
What type of error did they resolve?

• NUM
  
• REF
  
• ERROR or parsing error
  
• VALUE

✅ REF  
<br>Explanation: A `#REF!` error occurs when a formula refers to a cell that no longer exists.

Question 5

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

	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

Options:
- =SUM(B1,D6)
- =SUM(B1:D6)
- =SUM,B1+D6
- =SUM(B1-D6)

✅ `=SUM(B1:D6)`  
<br>Explanation: The colon (:) specifies a range from B1 to D6.

Question 6

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

• The starting place for structured thinking is the problem domain.
  
• Structured thinking involves recognizing the current problem or situation, organizing available information, revealing gaps and opportunities, and identifying options.
  
• Understanding the problem domain makes it possible to know the specific area of analysis required.
  
• The problem domain involves establishing checkpoints so stakeholders are aware of project status and progress.

✅ The starting place for structured thinking is the problem domain. <br>
✅ Structured thinking involves recognizing the current problem or situation, organizing available information, revealing gaps and opportunities, and identifying options. <br>
✅ Understanding the problem domain makes it possible to know the specific area of analysis required.  

Question 7

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

	A	B	C	D
1	68	7	404	0
2	892	0	73	#DIV/0!
3	0	528	599	0

Options:
- Insert a comma between the cell ranges in the formula.
- Search for the correct value in column A.
- 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.

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

Question 8

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

• K15:K3
  
• =K15/3
  
• K15,K3=
  
• =K15/K3

✅ `=K15/K3`  

---