Excel Addition Subtraction

What is the result of adding 5 and 3 in Excel?

• 10

• 9

• 8

• 7

How can you subtract 2 from 10 in Excel?

• =10+2

• =10*2

• =10-2

• =SUM(10, -2)

Which function is used to add a range of cells in Excel?

• MERGE

• ADD

• SUM

• TOTAL

In Excel, what function can be used to subtract one cell from another?

• REDUCE

• SUBTRACT

• MINUS

• TAKE AWAY

If cell A1 contains 10 and cell A2 contains 5, what is the result of adding A1 and A2 in Excel?

• 14

• 11

• 15

• 20

If cell B1 contains 20 and cell B2 contains 8, what is the result of subtracting B2 from B1 in Excel?

• 5

• 15

• 10

• 12

What is the shortcut key for autosum in Excel?

• Shift + =

• Alt + =

• Ctrl + =

• Alt + -

How can you subtract multiple cells in Excel?

• Manually type in the negative values for each cell

• Use the SUM function with negative values

• Use the AVERAGE function with negative values

• Use the MAX function with negative values

In Excel, how can you add up a column of numbers quickly?

• Use the AVERAGE function in Excel.

• Use the SUBTRACT function in Excel.

• Use the SUM function in Excel.

• Manually calculate each number in the column.

What is the result of adding the values in cells C1, C2, and C3 in Excel?

• The result is the multiplication of the values in cells C1, C2, and C3.

• The result is the sum of the values in cells C1, C2, and C3.

• The result is the average of the values in cells C1, C2, and C3.

• The result is the subtraction of the values in cells C1, C2, and C3.