To find the average of cells B1 to B10 in Excel, use the formula =AVERAGE(B1:B10), which tells Excel to calculate the arithmetic mean of all numbers within that specified range of cells.
Which formula is used to find the average of cells B1 to B10 in Excel?
Review the verified answer and explanation for this PPSC Punjab Public Service Commission past-paper question on CampusFin.
Question context
This question is part of 💻 Computing within the broader 💾 Computer Science subject and appears in the PPSC Punjab Public Service Commission preparation collection. Reviewing the answer together with nearby questions helps reinforce the underlying concept and identify how it may appear in competitive exams.