Skip to content

Menu

Game modes

Account

← Office Applications
GK QUESTION#1335

Which option correctly describes the cell references accepted as arguments by Microsoft Excel’s SUM function?

  1. AExternal data sources only
  2. BEntire worksheets only
  3. CIndividual cell references and ranges of cellsCorrect answer
  4. DIndividual cells only
Show AnswerHide Answer

Answer

C. Individual cell references and ranges of cells

Show ExplanationHide Explanation

Explanation

SUM accepts individual cell references and cell ranges, including more than one range. For example, =SUM(A1,A3) adds values from two separate cells, while =SUM(A1:A5) adds values across a range. Its arguments are not restricted to individual cells, entire worksheets or external data sources only.

Sign in to report a question issue

Explore this topic

In Microsoft Word, the Mail Merge Wizard is located under the _________ tab.In MS-Excel 365, you can use _________ when you want to change a cell reference within a formula…Consider the following statements about MS PowerPoint: 1. The slide number can be added to each slide of…