76. The operator for multiplication in Excel is:
- ×
- x
- ^
Answer: C)
Explanation: Asterisk multiplies.
MCQs / Computer Science / Lab: MS Excel
Lab: MS Excel MCQs — Computer Science (page 4)
85 multiple-choice questions on Lab: MS Excel from Computer Science, each with the correct answer and, where available, a teacher's explanation. Read through them to revise the chapter, then practise the same questions one by one to test yourself.
77. Which keys move to the next worksheet?
- Shift + Enter
- Ctrl + Tab only
- Ctrl + Page Down
- Alt + Tab
Answer: C) Ctrl + Page Down
Explanation: Ctrl + Page Up goes to the previous sheet.
78. The cell in column C and row 7 has the address:
- 7C
- R7C
- C:7
- C7
Answer: D) C7
Explanation: Column letter then row number.
79. The default type of cell reference in Excel is:
- external
- relative
- absolute
- mixed
Answer: B) relative
Explanation: Unless $ is used.
80. A worksheet is protected from the:
- Data tab → Validation
- Review tab → Protect Sheet
- Home tab → Protect
- Insert tab → Protect
Answer: B) Review tab → Protect Sheet
Explanation: Review → Protect Sheet.
81. =PRODUCT(2,3,4) returns:
- 234
- 6
- 9
- 24
Answer: D) 24
Explanation: 2 × 3 × 4.
82. A line chart is best for showing:
- parts of a whole
- a single value
- text data
- trends over time
Answer: D) trends over time
Explanation: e.g. monthly sales.
83. To increase all selected prices by 10% using Paste Special you copy 1.1 and choose the operation:
- Add
- Subtract
- Multiply
- Divide
Answer: C) Multiply
Explanation: Each value is multiplied by 1.1.
84. Which is a mixed reference with the column fixed?
- A1
- $A1
- A1
- A$1
Answer: B) $A1
Explanation: The $ is before the column letter only.
85. The result of =2+34 is:
- 20
- 24
- 9
- 14
Answer: D) 14
Explanation: Multiplication is done before addition.
Previous Page 4 of 4
More Computer Science chapters
- Unit 1: Computer Systems MCQs
- Introduction and History of Computers MCQs
- Introduction to Mobile Applications and Platforms MCQs
- Unit 2: Computational Thinking and Algorithms MCQs
- Types of Computers and Basic Operations MCQs
- HTML5 for Mobiles MCQs
- Unit 3: Programming Fundamentals MCQs
- Input and Output Devices MCQs
- Android OS: Architecture, Framework and Application Development MCQs
- Unit 4: Data and Analysis MCQs
- Storage Units and Memory MCQs
- iOS: Architecture and Framework MCQs