Introduction to Computing MCQs with Answers
Practice important Introduction to Computing MCQs with answers and explanations.
Multiple Choice Questions
Q3001: In Excel, what symbol must a formula begin with?
- A: +
- B: -
- C: =
- D: /
View Answer
C
Q3002: Which section in the formula ribbon provides access to different categories of formulas?
- A: Formula bar
- B: Function library
- C: Data tools
- D: Review pane
View Answer
B
Q3003: What is a formula in Excel?
- A: A cell reference
- B: A set of mathematical instructions
- C: A type of chart
- D: A formatting style
View Answer
B
Q3004: In Excel, which symbol is used to specify a range of cells in a formula?
- A: -
- B: ,
- C: :
- D: ;
View Answer
C
Q3005: What does the Function Library in Excel contain?
- A: Data sorting options
- B: Formatting options
- C: Different categories of formulas
- D: Chart types
View Answer
C
Q3006: To create a basic formula in Excel, which step should you perform first?
- A: Select the range
- B: Type the formula
- C: Select the cell for the formula
- D: Click Enter
View Answer
C
Q3007: What will the formula =SUM(A1
- A: Add all the numbers in cells A1 to A5
- B: Subtract A5 from A1
- C: Multiply A1 by A5
- D: Divide A1 by A5
View Answer
A
Q3008: Fill in the blank: A formula in Excel must always start with the ________ symbol.
- A: +
- B: =
- C: :
- D: *
View Answer
B
Q3009: Fill in the blank: The ________ symbol is used to specify a range in Excel formulas.
- A: -
- B: +
- C: :
- D: ,
View Answer
C
Q3010: What will happen if you press Enter after typing a formula in Excel?
- A: The formula will be deleted
- B: The formula will be applied
- C: The formula will be copied
- D: The formula will be saved as text
View Answer
B