1. A pie chart is best for showing:
- correlation between two variables
- a timetable
- parts of a whole
- trends over many years
Answer: C) parts of a whole
Explanation: Each slice shows a share of 100%.
MCQs / Computer Science / Lab: MS Excel
Lab: MS Excel MCQs — Computer Science
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.
2. If E2 contains a total of 231 out of 300, the percentage formula is:
- =300/E2
- =E2300/100
- =E2+300
- =E2/300100
Answer: D) =E2/300100
Explanation: Obtained ÷ total × 100.
3. The shortcut to insert a new worksheet is:
- Shift + F11
- Ctrl + N
- F4
- Alt + F1
Answer: A) Shift + F11
Explanation: Or click the + button.
4. =POWER(5,3) returns:
- 125
- 15
- 8
- 243
Answer: A) 125
Explanation: 5³ = 125.
5. To show long text on several lines inside one cell you use:
- Fill Series
- Merge & Center
- Wrap Text
- Sort
Answer: C) Wrap Text
Explanation: The row height increases automatically.
6. Pressing F11 after selecting data:
- deletes the data
- opens Save As
- prints the chart
- creates a chart on a new chart sheet
Answer: D) creates a chart on a new chart sheet
Explanation: Alt + F1 creates it on the same sheet.
7. Paste Link creates:
- a formula linked to the source cell that updates automatically
- a picture of the cells
- a hyperlink to a website
- a new sheet
Answer: A) a formula linked to the source cell that updates automatically
Explanation: e.g. =Sheet1!A1.
8. =SQRT(81) returns:
- 9
- 81
- 6561
- 40.5
Answer: A) 9
Explanation: Square root of 81.
9. Which chart is best for comparing values across categories with vertical bars?
- Line chart
- Scatter chart
- Column chart
- Pie chart
Answer: C) Column chart
Explanation: Columns compare categories.
10. The box that shows the address of the active cell is the:
- Status bar
- Name Box
- Sheet tab
- Formula Bar
Answer: B) Name Box
Explanation: It is left of the formula bar.
11. A new row is inserted:
- at row 1 always
- below the selected row
- in another workbook
- above the selected row
Answer: D) above the selected row
Explanation: Rows below move down.
12. In Excel, columns are identified by:
- colours
- symbols
- letters
- numbers
Answer: C) letters
Explanation: A, B, C … XFD.
13. COUNT counts cells that contain:
- numbers
- formulas only
- any text
- only blank cells
Answer: A) numbers
Explanation: COUNTA counts all non-empty cells.
14. The result of =(2+3)4 is:
- 20
- 9
- 14
- 24
Answer: A) 20
Explanation: Brackets are evaluated first.
15. The number of rows in a modern Excel worksheet is:
- 1,048,576
- 1,000
- 16,384
- 65,536
Answer: A) 1,048,576
Explanation: 16,384 is the number of columns.
16. To combine cells A1:F1 into one centred cell for a title you use:
- Wrap Text
- Merge & Center
- Freeze Panes
- AutoFill
Answer: B) Merge & Center
Explanation: Home → Alignment.
17. The shortcut for Paste Special is:
- Alt + P
- Ctrl + Shift + C
- Ctrl + V
- Ctrl + Alt + V
Answer: D) Ctrl + Alt + V
Explanation: It opens the Paste Special dialog.
18. The Auto Fill Options button lets you choose:
- chart type
- Copy Cells, Fill Series or Fill Formatting Only
- font size
- password
Answer: B) Copy Cells, Fill Series or Fill Formatting Only
Explanation: Appears after dragging the fill handle.
19. To highlight values greater than 80 you use:
- Data Validation → List
- Highlight Cells Rules → Greater Than
- Paste Special → Values
- Filter → Clear
Answer: B) Highlight Cells Rules → Greater Than
Explanation: Then choose the format.
20. Values displayed on top of the bars of a chart are called:
- legends
- axis titles
- data labels
- gridlines
Answer: C) data labels
Explanation: Chart Elements → Data Labels.
21. Text entered in a cell is aligned by default to the:
- top only
- centre
- right
- left
Answer: D) left
Explanation: Numbers are right-aligned.
22. A$1 copied downwards will:
- change to A2
- produce an error
- change to B1
- keep row 1 fixed
Answer: D) keep row 1 fixed
Explanation: The $ before 1 fixes the row.
23. Typing "Monday" and dragging the fill handle produces:
- numbers 1, 2, 3
- an error
- Tuesday, Wednesday, …
- Monday, Monday, … only
Answer: C) Tuesday, Wednesday, …
Explanation: Excel recognises day series.
24. A group of cells from A1 to D5 is written as:
- A1-D5
- A1;D5
- A1:D5
- A1..D5
Answer: C) A1:D5
Explanation: The colon defines a range.
25. In the formula =Sheet2!B5, "Sheet2" refers to:
- another worksheet in the same workbook
- a function
- a chart
- a printer
Answer: A) another worksheet in the same workbook
Explanation: Sheet name followed by ! and the cell.
Page 1 of 4 Next
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