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)
Roztwór
Elda
maestro · Tutor durante 5 años
4.2
(218 Votos)
Respuesta
The correct answer is `=MAX(A1:A10)`.
Explicación
## Step 1The 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.## Step 2The `MIN` function is used to find the smallest number in a range. This does not match the question's requirement.## Step 3The `LARGE` function is used to return the nth largest number in a range. This also does not match the question's requirement.## Step 4The `SUM` function is used to add all numbers in a range. This does not match the question's requirement.## Step 5The `MAX` function is used to find the largest number in a range. This matches the question's requirement.