Question 7/13Based on the values in Cells B77:B81, what function can automatically return the value in Cell C77?BC76 Sales77£794£1,02078£72179£85480£91281£1,02
Question
Question 7/13Based on the values in Cells B77:B81, what function can automatically return the value in Cell C77?BC76 Sales77£794£1,02078£72179£85480£91281£1,02
Solution
Para responder a la pregunta, primero debemos entender qué valor se encuentra en la celda C77 y cómo se relaciona con los valores en las celdas B77:B81.
-
Observa los valores en las celdas B77:B81:
- B77: £794
- B78: £721
- B79: £854
- B80: £912
- B81: £1,020
-
Identifica qué función puede devolver automáticamente un valor basado en estos datos. Las funciones comunes que se utilizan para este propósito son:
SUM: Suma todos los valores.AVERAGE: Calcula el promedio de los valores.- `
Similar Questions
On the Year1 sheet, in cell B8, enter a formula to display the value of cell B7 from the Salaries sheet
Which of the following functions would you use to calculate the value of cell C18.(1)Group of answer choices=SUM=COUNT=COUNTIF=COUNTA
Enter a formula in cell B10 to return a value of 35000 if the Net Profit After Tax (cell B9) is greater than or equal to 470000 or 100 if it is not.
From the previous question, for what values of n is the number 7 appended to list a. 7 6 8 9
Question 19Which spreadsheet function vertically searches for a certain value in a column in order to return a corresponding piece of information?1 pointVALUEVIEWVALIDATEVLOOKUP
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.