Which formula correctly adds the values in cells A1 and B1?
A
=A1+B1 B
=A1*B1 C
=A1-B1 D
=ADD(A1,B1)
Analysis & Theory
`=A1+B1` is the correct syntax for directly adding the contents of A1 and B1.
Which Excel function is commonly used to add multiple numbers or ranges?
A
AVERAGE B
ADD C
SUM D
PLUS
Analysis & Theory
`SUM` is the standard function used to add numbers or ranges of cells.
What does the formula `=SUM(A1:A5)` do?
A
Adds values in cells A1 and A5 only B
Adds values in all cells from A1 to A5 C
Adds text and numbers in A1 to A5 D
Multiplies A1 by A5
Analysis & Theory
`SUM(A1:A5)` adds the contents of cells A1 through A5 inclusively.
How can you quickly add values in a column in Excel using the ribbon?
A
Insert tab > Add Cells B
Data tab > Auto Add C
Home tab > AutoSum D
Review tab > Add Function
Analysis & Theory
The AutoSum button on the Home tab allows you to quickly insert a SUM function.
What happens if one of the cells in a `SUM` range contains text?
A
Excel adds the text as 0 B
Excel converts text to number C
Excel ignores the cell D
Excel throws an error
Analysis & Theory
Excel ignores text in a `SUM` function unless the text can be interpreted as a number.
What is the keyboard shortcut for AutoSum?
A
Ctrl + A B
Alt + S C
Alt + = D
Ctrl + Shift + +
Analysis & Theory
`Alt + =` inserts the SUM function automatically.
Can the `SUM` function add values from multiple non-adjacent ranges?
A
No, only one range at a time B
Yes, using commas to separate ranges C
Yes, using a plus symbol D
Only using macros
Analysis & Theory
You can use multiple ranges in `SUM` like `=SUM(A1:A3, C1:C3)` to add non-adjacent ranges.
Which of the following formulas will correctly add 10 to the value in cell A1?
A
=SUM(10+A1) B
=A1+10 C
=ADD(10,A1) D
=PLUS(10,A1)
Analysis & Theory
`=A1+10` directly adds 10 to the value in cell A1 using a simple arithmetic expression.