MS Excel Formula Range Selection
In Excel, if you want to calculate the sum of cells ranging from C1 to C12, then which of the following formula you will use?
Answer: =SUM(C1:C12)
Explanation
=SUM(C1:C12) is the correct Excel formula to sum all values from cell C1 to C12.
The colon : denotes a continuous range of cells.
This question appeared in
Past Papers (6 times)
ETEA 25 Years Past Papers Subject Wise (Solved) (2 times)
KPK Teacher Past Papers SST PST CT TT PET (2 times)
Secondary School Teacher SST Past Papers, Syllabus, Jobs (2 times)
This question appeared in
Subjects (1 times)
COMPUTER (1 times)
Related MCQs
- Which formula is used to find the number of numerical cells in a range of cells in Excel?
- Which of the following functions is used to calculate the average of a range of cells in Excel?
- In MS Excel to add two cells (A1 and A2) togather you use the following formula
- Consider a worksheet of MS Excel, If value of F7 cell is 12 and value of H12 cell is 30. Calculate the answer of following formula=F7*H12 _____?
- How you can update the values of formula cell.If auto calculate the mode of excel cell is disabled
- Which formula is used to calculate IRR?
- Which formula is used to calculate the Median?
- What is the formula to calculate COGS?
- What does the compound interest formula calculate?
- What is the correct formula to calculate a winner’s election percentage?
