Introduction to Computing MCQs with Answers
Practice important Introduction to Computing MCQs with answers and explanations.
Multiple Choice Questions
Q3011: Which tab on the Excel ribbon contains options for creating and applying formulas?
- A: Home
- B: Insert
- C: Formulas
- D: Data
View Answer
C
Q3012: What is the purpose of the SUM formula in Excel as shown in Figure 219?
- A: To calculate averages
- B: To sum total marks
- C: To subtract marks
- D: To divide marks
View Answer
B
Q3013: Which figure demonstrates the application of the SUM formula to calculate total marks?
- A: Figure 217
- B: Figure 218
- C: Figure 219
- D: Figure 220
View Answer
C
Q3014: Fill in the blank: The SUM formula in Excel is used to ________ the values in a specified range of cells.
- A: Average
- B: Sum
- C: Subtract
- D: Multiply
View Answer
B
Q3015: What happens when the SUM formula is copied to following cells?
- A: The data is erased
- B: The total is updated
- C: The formula is changed
- D: The total is calculated
View Answer
D
Q3016: Fill in the blank: In the scenario provided, the SUM formula was applied to calculate the total marks of ________.
- A: Teachers
- B: Subjects
- C: Students
- D: Classes
View Answer
C
Q3017: Which function is being demonstrated in the provided example?
- A: AVERAGE
- B: SUM
- C: IF
- D: VLOOKUP
View Answer
B
Q3018: What does Figure 220 show in relation to Figure 219?
- A: The original data
- B: A graph of the data
- C: The results after applying SUM formula
- D: The formula bar
View Answer
C
Q3019: Fill in the blank: The SUM formula in Excel begins with the ________ symbol.
- A: +
- B: -
- C: =
- D: *
View Answer
C
Q3020: Which of the following is required to use the SUM formula in Excel?
- A: Selecting data manually
- B: Entering text data
- C: Defining a range of cells
- D: Using absolute references
View Answer
C