To determine which function can automatically return the value in Cell C77, let's follow the steps below:
1. Identify the cells that contain the relevant values. In this case, cells B77:B81 contain the sales amounts:
- B77: \[tex]$794
- B78: \$[/tex]721
- B79: \[tex]$854
- B80: \$[/tex]912
- B81: \[tex]$1,020
2. Determine which value needs to be placed in cell C77. According to the table, Cell C77 should contain \$[/tex]721.
3. Observe that \[tex]$721 is the second value in the range B77:B81.
4. To extract this value, we can use the INDEX function in Excel. The INDEX function returns the value of a cell in a specified array based on its row and column numbers.
The general syntax for the INDEX function is:
```
INDEX(array, row_num, [column_num])
```
Since we are dealing with a single column of values (B77:B81), we can disregard the [column_num] argument.
Given the range B77:B81, and knowing that \$[/tex]721 is the second value, the appropriate INDEX function would be:
```
=INDEX(B77:B81, 2)
```
This function specifies to look in the range B77:B81 and return the value in the second row of that range, which is \$721.
Thus, the function that can automatically return the value in cell C77 is:
```
=INDEX(B77:B81, 2)
```
This function ensures that Cell C77 reflects the correct value based on its position in the specified range.
