In Microsoft Excel, the SUM function is used to add numbers contained in a range of cells. The formula =SUM(C1:C12) calculates the total of all numeric values from cell C1 through cell C12. The colon (:) represents a continuous range of cells, so Excel includes C1, C2, C3, and all cells up to C12 in the calculation. This is a commonly used formula for calculating totals in spreadsheets.
In Excel, what is the formula to calculate the sum of cells C1 to C12?
Review the verified answer and explanation for this ETEA Educational Testing and Evaluation Agency past-paper question on CampusFin.
Question context
This question is part of 📁 Microsoft Office within the broader 💾 Computer Science subject and appears in the ETEA Educational Testing and Evaluation Agency preparation collection. Reviewing the answer together with nearby questions helps reinforce the underlying concept and identify how it may appear in competitive exams.