Introduction to Computing MCQs with Answers
Practice important Introduction to Computing MCQs with answers and explanations.
Chapter: 221
Q3001:
In Excel, what symbol must a formula begin with?
A. +
B. -
C. =
D. /
Correct Answer:
C
Chapter: 221
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
Correct Answer:
B
Chapter: 221
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
Correct Answer:
B
Chapter: 221
Q3004:
In Excel, which symbol is used to specify a range of cells in a formula?
A. -
B. ,
C. :
D. ;
Correct Answer:
C
Chapter: 221
Q3005:
What does the Function Library in Excel contain?
A. Data sorting options
B. Formatting options
C. Different categories of formulas
D. Chart types
Correct Answer:
C
Chapter: 221
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
Correct Answer:
C
Chapter: 221
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
Correct Answer:
A
Chapter: 221
Q3008:
Fill in the blank: A formula in Excel must always start with the ________ symbol.
A. +
B. =
C. :
D. *
Correct Answer:
B
Chapter: 221
Q3009:
Fill in the blank: The ________ symbol is used to specify a range in Excel formulas.
A. -
B. +
C. :
D. ,
Correct Answer:
C
Chapter: 221
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
Correct Answer:
B
Chapter: 221
Q3011:
Which tab on the Excel ribbon contains options for creating and applying formulas?
A. Home
B. Insert
C. Formulas
D. Data
Correct Answer:
C
Chapter: 222
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
Correct Answer:
B
Chapter: 222
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
Correct Answer:
C
Chapter: 222
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
Correct Answer:
B
Chapter: 222
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
Correct Answer:
D
Chapter: 222
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
Correct Answer:
C
Chapter: 222
Q3017:
Which function is being demonstrated in the provided example?
A. AVERAGE
B. SUM
C. IF
D. VLOOKUP
Correct Answer:
B
Chapter: 222
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
Correct Answer:
C
Chapter: 222
Q3019:
Fill in the blank: The SUM formula in Excel begins with the ________ symbol.
A. +
B. -
C. =
D. *
Correct Answer:
C
Chapter: 222
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
Correct Answer:
C