Introduction to Computing MCQs with Answers
Practice important Introduction to Computing MCQs with answers and explanations.
Multiple Choice Questions
Q3021: Fill in the blank: The SUM formula can be copied to multiple cells using the ________ handle in Excel.
- A: Selection
- B: Copy-paste
- C: Drag-and-drop
- D: Fill
View Answer
D
Q3022: What is the result of applying the SUM formula to cells containing non-numeric data?
- A: Error
- B: Sum of values
- C: Ignored
- D: Formula adjusts
View Answer
A
Q3023: Fill in the blank: After applying the SUM formula, the resulting total can be seen in ________.
- A: The formula bar
- B: The original cells
- C: The selected cell
- D: The header
View Answer
C
Q3024: What is the formula to calculate the total expense for January month in Excel?
- A: [ "=SUM(B3)" ]
- B: [ "=AVERAGE(B3)" ]
- C: [ "=SUM(B16)" ]
- D: [ "=MAX(B3)" ]
View Answer
A
Q3025: Which formula is used to calculate the average expense for the Electricity Bill?
- A: [ "=AVERAGE(B3)" ]
- B: [ "=MAX(B3)" ]
- C: [ "=SUM(B16)" ]
- D: [ "=SUM(B3)" ]
View Answer
A
Q3026: How do you find the highest expense for the Electricity Bill in Excel?
- A: ["=MIN(B3)"]
- B: ["=MAX(B3)"]
- C: ["=SUM(B16)"]
- D: ["=AVERAGE(B3)"]
View Answer
B
Q3027: What formula will you use to find the minimum expense for the year 2020 in Excel?
- A: [ "=MIN(B3)" ]
- B: [ "=AVERAGE(B3)" ]
- C: [ "=SUM(B16)" ]
- D: ["=MAX(B3)"]
View Answer
A
Q3028: The formula =SUM(B16) calculates what in the personal expense sheet?
- A: Total expense for the year 2020
- B: Total expense for January month
- C: Average expense for the year 2020
- D: Maximum expense for the year 2020
View Answer
A
Q3029: In Excel, which function is used to find the sum of a range of cells?
- A: [ "=SUM" ]
- B: [ "=AVERAGE" ]
- C: [ "=MIN" ]
- D: [ "=MAX" ]
View Answer
A
Q3030: What does the formula =MAX(B3) return?
- A: Maximum value in the range B3
- B: Minimum value in the range B3
- C: Sum of values in the range B3
- D: Average of values in B3
View Answer
A