In Open Office Calc, the formula” = Max (A2:A10)” stored in cell A11 when copied to cell B11it changes to ___________
Question
In Open Office Calc, the formula” = Max (A2:A10)” stored in cell A11 when copied to cell B11it changes to ___________
Solution
The formula changes to "=MAX(B2:B10)". This is because Open Office Calc uses relative cell references by default. So, when you copy the formula from cell A11 to B11, the cell references change from column A to column B.
Similar Questions
What does the function =MAX(A1:A10) do? aFinds the minimum value in the range bAverages the values in the range cCounts the number of cells in the range dFinds the maximum value in the range
Which Excel function is used to find the largest value in a range of cells?a) =SUMb) =MAXc) SUMd) MAX
In Calc, when you copy or move the formula to the other cells, the reference cellautomatically gets changed is called ____
______ function is use to get maximum number of among series of data in excel.
Which one is not a function of Excel?SUMAVGMINMAXIf
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.