26. =AVERAGE(10,20,30) returns:
- 20
- 60
- 10
- 30
Answer: A) 20
Explanation: (10+20+30)/3 = 20.
MCQs / Computer Science / Lab: MS Excel
Lab: MS Excel MCQs — Computer Science (page 2)
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.
27. To allow users to edit some cells of a protected sheet you must first:
- hide those cells
- delete those cells
- merge those cells
- unlock those cells in Format Cells → Protection
Answer: D) unlock those cells in Format Cells → Protection
Explanation: Untick Locked before protecting.
28. Automatically colouring cells that meet a condition (e.g. marks below 50) is called:
- filtering
- conditional formatting
- data validation
- AutoFill
Answer: B) conditional formatting
Explanation: Home → Conditional Formatting.
29. The error NAME? usually means:
- division by zero
- the number is too large
- a function name is misspelt
- a chart is missing
Answer: C) a function name is misspelt
Explanation: e.g. =SUMM(A1:A5).
30. Arranging data in ascending or descending order is:
- validating
- sorting
- protecting
- filtering
Answer: B) sorting
Explanation: Data → Sort A to Z / Z to A.
31. A reference that changes when a formula is copied is a:
- relative reference
- constant
- absolute reference
- fixed reference
Answer: A) relative reference
Explanation: e.g. A1 becomes A2 when copied down.
32. The key that identifies the colour of each data series in a chart is the:
- gridline
- title
- axis
- legend
Answer: D) legend
Explanation: The legend explains colours.
33. The shortcut for AutoSum is:
- Ctrl + =
- Ctrl + S
- Alt + =
- Shift + S
Answer: C) Alt + =
Explanation: It inserts =SUM() automatically.
34. Pressing the Delete key on a selected row:
- clears its contents but keeps the row
- hides the row
- removes the row completely
- inserts a row
Answer: A) clears its contents but keeps the row
Explanation: Use Delete Sheet Rows to remove it.
35. =MAX(4,9,2,7) returns:
- 4
- 9
- 2
- 22
Answer: B) 9
Explanation: The largest value.
36. Paste Special → Values pastes:
- only the formulas
- only the results, not the formulas
- only formatting
- column widths only
Answer: B) only the results, not the formulas
Explanation: Useful to freeze calculated values.
37. The shortcut to open the Format Cells dialog is:
- Ctrl + F
- Alt + 1
- Ctrl + 1
- Ctrl + 2
Answer: C) Ctrl + 1
Explanation: It includes the Protection tab.
38. To swap the data shown on the X-axis and in the legend you use:
- Quick Layout only
- Switch Row/Column
- Move Chart
- Change Colors
Answer: B) Switch Row/Column
Explanation: Chart Design → Switch Row/Column.
39. The shortcut to insert a line break inside a cell is:
- Ctrl + Enter
- Tab
- Shift + Enter
- Alt + Enter
Answer: D) Alt + Enter
Explanation: It starts a new line in the same cell.
40. The bar that displays the contents or formula of the active cell is the:
- Formula Bar
- Name Box
- Title bar
- Status bar
Answer: A) Formula Bar
Explanation: Edit formulas there.
41. Showing only the rows that meet certain criteria is called:
- filtering
- merging
- validating
- sorting
Answer: A) filtering
Explanation: Other rows are hidden, not deleted.
42. Paste Special → Formats pastes:
- only the values
- only comments
- only the formatting
- nothing
Answer: C) only the formatting
Explanation: Fonts, colours, borders, number formats.
43. To rename a worksheet you can:
- use Merge & Center
- use Paste Special
- press F4
- double-click the sheet tab
Answer: D) double-click the sheet tab
Explanation: Then type the new name.
44. The error DIV/0! appears when:
- the file is not saved
- a function name is misspelt
- the column is too narrow
- a number is divided by zero or an empty cell
Answer: D) a number is divided by zero or an empty cell
Explanation: Division by zero is undefined.
45. The shortcut to turn Filter on or off is:
- Alt + F
- Ctrl + Shift + L
- Ctrl + F
- Ctrl + L
Answer: B) Ctrl + Shift + L
Explanation: It toggles AutoFilter.
46. By default all cells in Excel are:
- unlocked
- hidden
- read-only even without protection
- locked, but locking works only after the sheet is protected
Answer: D) locked, but locking works only after the sheet is protected
Explanation: Locked is the default property.
47. Which Paste Special option converts rows into columns?
- Values
- Skip blanks
- Transpose
- Formats
Answer: C) Transpose
Explanation: Rows and columns are switched.
48. If =B2F1 is copied from C2 to C3, it becomes:
- =B3F2
- =C3G1
- =B3F1
- =B2F1
Answer: C) =B3F1
Explanation: Only the relative part changes.
49. in a cell usually means:
- the cell is protected
- the formula is wrong
- the file is corrupt
- the column is too narrow to show the number
Answer: D) the column is too narrow to show the number
Explanation: Widen the column.
50. The default extension of an Excel workbook is:
- .pptx
- .docx
- .xlsx
- .xls only for new files
Answer: C) .xlsx
Explanation: Older versions used .xls.
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