NEW
Font size
WorksheetsChoose the Right Minus
Total questions: 10
Worksheet time: 5mins
1. What symbol is used in MS Excel to subtract values?
a. +
b. *
c. −
d. /
2. Which formula correctly subtracts 8 from 20?
a. =20+8
b. =8-20
c. =20-8
d. =20/8
Which of the following is the correct way to subtract the value in cell B1 from A1?
a. =A1+B1
b. =A1-B1
c. =B1-A1
d. =A1*B1
Why is subtraction commonly used in Excel?
a. To change fonts
b. To calculate differences between values
b. To calculate differences between values
d. To insert charts
Which formula will give a negative result?
a. =10-5
b. =20-20
c. =5-10
d. =15-5
Excel formulas must always start with which symbol?
a. +
b. #
c. =
d. &
What will be the result of =50-25?
a. 75
b. 25
c. −25
d. 0
Which of the following is NOT a valid subtraction formula in Excel?
a. =A1-B1
b. =100-50
c. =B2-A2
d. A1-B1
What happens if you subtract a larger number from a smaller number in Excel?
a. The result is an error
b. The result is zero
c. The result is negative
d. Nothing happens
Which situation best shows the use of subtraction in Excel?
a. Counting the number of students
b. Finding the remaining balance after expenses
c. Sorting names alphabetically
d. changing cell color
