Answer :
To determine the correct formula for displaying the word "Score:" along with the sum of the cells C1 through C4 if the sum is zero, and "No score yet" otherwise, let's analyze each option provided.
1. Option A:
```
=IF(SUM(C1:C4)<0, "Score: " & SUM(C1:C4), "No score yet")
```
- This formula checks if the sum of C1 through C4 is less than zero.
- If the sum is less than zero, it displays "Score: " followed by the sum.
- Otherwise, it displays "No score yet".
- This formula does not align with what we need since we are interested in checking if the sum is exactly zero.
2. Option B:
```
=IF(SUM(C1:C4)=0, "Score: " & SUM(C1:C4), "No score yet")
```
- This formula checks if the sum of C1 through C4 is equal to zero.
- If the sum equals zero, it displays "Score: " followed by the sum.
- Otherwise, it displays "No score yet".
- This formula meets our requirement as it checks if the sum is zero and displays the appropriate message.
3. Option C:
```
=IF(SUM(C1:C4)>0, "No score yet", "Score: " & SUM(C1:C4))
```
- This formula checks if the sum of C1 through C4 is greater than zero.
- If the sum is greater than zero, it displays "No score yet".
- Otherwise, it displays "Score: " followed by the sum.
- This formula also does not align with our needs since it checks for a condition that is the reverse of what we need.
Having analyzed all the options, we can conclude that Option B correctly implements the required logic:
```
=IF(SUM(C1:C4)=0, "Score: " & SUM(C1:C4), "No score yet")
```
This formula will display "Score: 0" if the sum of cells C1 through C4 is zero, and "No score yet" otherwise.
1. Option A:
```
=IF(SUM(C1:C4)<0, "Score: " & SUM(C1:C4), "No score yet")
```
- This formula checks if the sum of C1 through C4 is less than zero.
- If the sum is less than zero, it displays "Score: " followed by the sum.
- Otherwise, it displays "No score yet".
- This formula does not align with what we need since we are interested in checking if the sum is exactly zero.
2. Option B:
```
=IF(SUM(C1:C4)=0, "Score: " & SUM(C1:C4), "No score yet")
```
- This formula checks if the sum of C1 through C4 is equal to zero.
- If the sum equals zero, it displays "Score: " followed by the sum.
- Otherwise, it displays "No score yet".
- This formula meets our requirement as it checks if the sum is zero and displays the appropriate message.
3. Option C:
```
=IF(SUM(C1:C4)>0, "No score yet", "Score: " & SUM(C1:C4))
```
- This formula checks if the sum of C1 through C4 is greater than zero.
- If the sum is greater than zero, it displays "No score yet".
- Otherwise, it displays "Score: " followed by the sum.
- This formula also does not align with our needs since it checks for a condition that is the reverse of what we need.
Having analyzed all the options, we can conclude that Option B correctly implements the required logic:
```
=IF(SUM(C1:C4)=0, "Score: " & SUM(C1:C4), "No score yet")
```
This formula will display "Score: 0" if the sum of cells C1 through C4 is zero, and "No score yet" otherwise.
