Problemas

What is the formula to find the largest number in a range? =MIN(A1:A10) =LARGE(A1:A10) =SUM(A1:A10) =MAX(A1:A10)
Solución

Eldamaestro · Tutor durante 5 años

4.2 (218 votos)
Responder
The correct answer is `=MAX(A1:A10)`.
Explicar
## Step 1<br />The problem asks for the formula to find the largest number in a range in a spreadsheet program such as Microsoft Excel or Google Sheets. The options provided are different functions that can be used in spreadsheet programs.<br /><br />## Step 2<br />The `MIN` function is used to find the smallest number in a range. This does not match the question's requirement.<br /><br />## Step 3<br />The `LARGE` function is used to return the nth largest number in a range. This also does not match the question's requirement.<br /><br />## Step 4<br />The `SUM` function is used to add all numbers in a range. This does not match the question's requirement.<br /><br />## Step 5<br />The `MAX` function is used to find the largest number in a range. This matches the question's requirement.
Haz clic para calificar: