51. Inserting a column when column C is selected places the new column:
- to the right of column C
- at the end of the sheet
- to the left of column C
- in a new sheet
Answer: C) to the left of column C
Explanation: Existing columns shift right.
MCQs / Computer Science / Lab: MS Excel
Lab: MS Excel MCQs — Computer Science (page 3)
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.
52. The operator ^ in Excel is used for:
- text joining
- subtraction
- exponent (power)
- division
Answer: C) exponent (power)
Explanation: =2^3 gives 8.
53. To create a drop-down list in a cell you choose Allow:
- Whole number
- Time
- Decimal
- List
Answer: D) List
Explanation: Enter the source values separated by commas.
54. If =B2C2 in D2 is copied to D3, it becomes:
- =B2C2
- =B3C2
- =C3D3
- =B3C3
Answer: D) =B3C3
Explanation: Relative references move with the formula.
55. An Excel file is called a:
- workbook
- presentation
- document
- database only
Answer: A) workbook
Explanation: A workbook contains worksheets.
56. When a filter is applied, rows that do not meet the criteria are:
- hidden temporarily
- moved to another sheet
- coloured red
- deleted permanently
Answer: A) hidden temporarily
Explanation: Clearing the filter shows them again.
57. Filter is applied from the:
- Data tab
- Page Layout tab
- Insert tab
- View tab only
Answer: A) Data tab
Explanation: Data → Filter.
58. The message that appears when a validated cell is selected is set in the:
- Error Alert tab
- Protection tab
- Font tab
- Input Message tab
Answer: D) Input Message tab
Explanation: It guides the user before typing.
59. Every formula in Excel begins with:
- @
- =
- +
Answer: B) =
Explanation: The equals sign tells Excel to calculate.
60. =MIN(4,9,2,7) returns:
- 7
- 2
- 4
- 9
Answer: B) 2
Explanation: The smallest value.
61. Charts are inserted from the:
- Home tab
- Data tab only
- Review tab
- Insert tab
Answer: D) Insert tab
Explanation: Insert → Charts group.
62. The intersection of a row and a column is called a:
- cell
- workbook
- range
- sheet
Answer: A) cell
Explanation: Cells hold data.
63. Bars drawn inside cells proportional to their values are called:
- colour scales
- data bars
- sparklines only
- icon sets
Answer: B) data bars
Explanation: A conditional formatting option.
64. "Top 10 Items" is found in:
- Highlight Cells Rules
- Top/Bottom Rules
- Sort
- Data Validation
Answer: B) Top/Bottom Rules
Explanation: Top/Bottom rules highlight highest/lowest values.
65. If A1:A5 contains 3, "Ali", 7, blank, 10 then =COUNT(A1:A5) returns:
- 20
- 3
- 5
- 4
Answer: B) 3
Explanation: Only 3, 7 and 10 are numbers.
66. Which is an absolute cell reference?
- $A1
- A1
- A1
- A$1
Answer: B) A1
Explanation: Both column and row are fixed.
67. Double-clicking the boundary between two column headings:
- inserts a new column
- hides the column
- deletes the column
- AutoFits the column width to its contents
Answer: D) AutoFits the column width to its contents
Explanation: AutoFit adjusts to the longest entry.
68. The small square at the bottom-right corner of the active cell is the:
- sheet tab
- Name Box
- fill handle
- scroll box
Answer: C) fill handle
Explanation: Drag it to AutoFill.
69. Which conditional formatting option uses arrows or traffic lights?
- Color Scales
- Data Bars
- Icon Sets
- Highlight Duplicates
Answer: C) Icon Sets
Explanation: Icon Sets display symbols.
70. Which Error Alert style completely blocks invalid entries?
- Warning
- Notice
- Stop
- Information
Answer: C) Stop
Explanation: Warning and Information may allow entry.
71. Which function adds a range of numbers?
- SUM
- COUNT
- MAX
- PRODUCT
Answer: A) SUM
Explanation: =SUM(B2:B6).
72. The key used to toggle between relative, absolute and mixed references is:
- F4
- F5
- F2
- F9
Answer: A) F4
Explanation: F4 cycles through the reference types.
73. Restricting entries in a cell, such as allowing only whole numbers 0–100, is done with:
- Paste Special
- Freeze Panes
- Data Validation
- Conditional Formatting
Answer: C) Data Validation
Explanation: Data → Data Validation.
74. To create the series 5, 10, 15 … 100 you can use:
- Wrap Text
- Fill → Series with step value 5 and stop value 100
- Merge & Center
- Sort A to Z
Answer: B) Fill → Series with step value 5 and stop value 100
Explanation: Linear series with a step.
75. Absolute references are mainly used for:
- constant values such as a tax rate stored in one cell
- typing text
- inserting charts
- changing fonts
Answer: A) constant values such as a tax rate stored in one cell
Explanation: The constant cell must not move.
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