Class 12 ICT Skills MCQ | CBSE Employability Skills ICT MCQ
Class 12 ICT Skills MCQ – Important ICT Skills Questions for Board Exam
Looking for the sureshot way to revise your Class 12 ICT Skills? 💻
These Class 12 ICT Skills MCQ are expertly curated after analysis on previous CBSE papers, ensuring you cover all key and high-weightage topics.
These ICT Skills MCQ of Class 10 with Answers are specially designed as per the latest CBSE Employability Skills syllabus to help you revise all concepts, practice important questions, and boost your confidence before exams.
Q1. How will you usually align the title of a slide?
a) Left
b) Right
c) Center
d) Justify
Answer: c) Center
Q2. PowerPoint is presentation software belongs to
a) Apple
b) Google
c) Microsoft Office
d) Open Office
Q3. An electronic document, which has rows and columns and used to store data in a systematic way for performing calculations is known as
a) Worksheet
b) Workbook
c) Spreadsheet
d) Cell
Q4. For printing document, you will press which key?
a) Font
b) Alignment
c) Border
d) Print
Q5. What will be displayed, if the following formula is entered in cell A1 in a spreadsheet application? =6^2+15/3*2-7
a) 39
b) 15
c) -14
d) -38
Q6. Which bar is located below the Title bar?
a) Menu bar
b) Standard bar
c) Formula bar
d) Formatting bar
Q7. The __ is located below the title bar. It has commands like File, Edit etc. Clicking on each menu option displays a list of commands.
a) Standard bar
b) Menu bar
c) Formatting bar
d) Formula bar
Q8. In the spreadsheet, you can see a worksheet with cells placed in __ but not ___
a) Row, column
b) Column row
c) Row horizontal, column vertical
d) Row, column horizontal
Q9. Which of the following features is used to perform Minus in spreadsheets?
a) Format option
b) Charts
c) Graphs
d) Formula
Q10. Which of the following is not an advantage of spreadsheet?
a) Built-in functions make calculations easier, faster and more accurate
b) Large volume of data cannot be manipulated
c) Data can be exported to or imported from other software
d) All of the above
Q11. Match the following
a) A-2, B-3, C-1
b) A-3, B-1, C-2
c) A-1, B-3, C-2
d) A-1, B-2, C-3
Q12. ___ is the command to select the entire worksheet
a) Ctrl + O
b) Ctrl + A
c) Ctrl + C
d) Ctrl + Z
Class 12 ICT Skills MCQ – Class 12 Employability Skills MCQ
Q13. Which software helps in performing calculations using formulae?
a) Microsoft Outlook
b) Comm Central
c) Range
d) LibreOffice Calc
Q14. Pressing ___ key opens the Start menu?
a) Windows
b) Alt + Windows
c) Ctrl + Windows
d) Alt + Ctrl + Windows
Q15. What is a spreadsheet?
a) An electronic document with blank page
b) An electronic document with rows and columns
c) A tool for creating graph only
d) A type of presentation tool
Q16. Which of these is not a popular spreadsheet software?
a) Microsoft Excel
b) LibreOffice Calc
c) Google Sheets
d) Microsoft Word
Q17. In a spreadsheet, rows are arranged:
a) Vertically
b) Horizontally
c) Randomly
d) Both vertically and horizontally
Q18. In a spreadsheet, columns are arranged:
a) Vertically
b) Horizontally
c) Randomly
d) Both vertically and horizontally
Q19. A cell in a spreadsheet is:
a) Combination of rows and columns
b) Intersection of single row and single column
c) A separate worksheet
d) None of the above
Q20. A cell can contain:
a) Text
b) Numbers
c) Formulas
d) All of the above
Q21. The location of cell is called
a) Cell range
b) Cell address
c) Cell junction
d) Workbook
Q22. The formula bar is used to:
a) Enter or edit data
b) Enter or edit formulas
c) Both a and b
d) None of the above
Q23. The name box shows:
a) The name of selected worksheet
b) The location of the selected cell
c) The name of selected workbook
d) The data stored in selected cell
Q24. A worksheet is:
a) Combination of rows and columns
b) Intersection of single row and single column
c) Combination of workbooks
d) None of the above
Class 12 ICT Skills MCQ – Class 12 Employability Skills MCQ
Q25. A workbook contains:
a) Only one worksheet
b) One or multiple worksheets
c) Only graphs
d) None of the above
Q26. When you enter text in a cell, it is aligned to the ___ side of the cell.
a) right
b) left
c) center
d) justify
Q27. When you enter number in a cell, it is aligned to the ___ side of the cell.
a) right
b) left
c) center
d) justify
Q28. We can enter formula by starting ___ in a cell
a) =
b) @
c) $
d) #
Q29. Selecting multiple cells together is called:
a) Active cell
b) Cell range
c) Formula cell
d) Sheet range
Q30. To select two rows not next to each other, you:
a) Hold Shift and click on both rows
b) Hold Ctrl and click both rows
c) Hold Alt and click both rows
d) Hold Ctrl + Shift and click on both rows
Q31. To save a spreadsheet in another format, you use:
a) File → Save as → Choose type
b) Home → Save as → Choose type
c) File → Open → Choose type
d) None of the above
Q32. The default save format for LibreOffice Calc is:
a) .xls
b) .doc
c) .ods
d) .pdf
Q33. Shortcut to print a spreadsheet is:
a) Ctrl+S
b) Ctrl+O
c) Ctrl+P
d) Ctrl+C
Q34. Formula to add marks of three subjects using cell addresses:
a) =78+45+71
b) =B2+C2+D2
c) =SUM(A1:A3)
d) =B2+B3+B4
Q35. Why is it better to use cell addresses in a formula instead of typing numbers directly?
a) It makes spreadsheet looks colorful
b) The result automatically updates if the data in the cells changes
c) It prevents formula errors
d) None of the above
Q36. Shortcut for making text bold is:
a) Ctrl+I
b) Ctrl+B
c) Ctrl+U
d) Ctrl+S
Class 12 ICT Skills MCQ – ICT Skills Class 12 Questions and Answers
Q37. Importance of formatting is:
a) Makes spreadsheet clear and readable
b) Calculations become easier
c) Makes Editing and deleting easier
d) None of the above
Q38. Sorting data in a spreadsheet helps to:
a) Change font size easily
b) Find a specific item easily
c) Save spreadsheet quickly
d) Delete specific item quickly
Q39. To sort data in descending order:
a) File → Sort → Descending → Choose field
b) Data → Sort → Choose field → Descending
c) Tools → Sort → Descending → Choose field
d) Edit → Sort → Choose field → Descending
Q40. Filtering data allows you to:
a) Print data only
b) View specific data only
c) Save spreadsheet quickly
d) Select all data
Q41. To apply a filter, you:
a) Click AutoFilter icon
b) Type =FILTER() in cell
c) Press Ctrl+F
d) All of the above
Q42. Which of the following is not true for protecting spreadsheet?
a) To prevent unauthorized changes
b) To view specific data automatically
c) To protect spreadsheet, click on Tools → Protect spreadsheet
d) We can also protect spreadsheet from File →Save As
Q43. Which menu option is used to protect a spreadsheet?
a) File → Protect Spreadsheet
b) Tools → Protect Spreadsheet
c) Edit → Protect
d) Data → Filter → Protect
Q44. Which menu option will you use to sort data?
a) Tools
b) Data
c) Format
d) View
Q45. Mr Gupta has a spreadsheet with a list of 500 items. A customer asks for a particular item. He will:
a) apply filter
b) sort the data
c) use password
d) format data
Q46. Mr Verma shares the computer with colleagues. To prevent others from seeing his financial data he should:
a) Lock the computer in a cupboard
b) Change the computer password so no one can use it
c) Apply password to the financial data sheet
d) Leave it as it is
Q47. What is the default alignment of numbers in a cell?
a) Left aligned
b) Right aligned
c) Center aligned
d) Randomly aligned
Q48. “By default, the text in a cell is left aligned.” State whether this is true or false.
a) True
b) False
Class 12 ICT Skills MCQ – Key Questions for CBSE Employability Skills
Q49. What is the shortcut key to underline text in a spreadsheet?
a) Ctrl+b
b) Ctrl+i
c) Ctrl+l
d) Ctrl+u
Q50. Which of the following features is used to perform addition in spreadsheets?
a) Format option
b) Charts
c) Graphs
d) Formula
Q51. The correct order of steps for entering data in a spreadsheet is:
a) type the data, click the cell and press Enter.
b) click the cell, type the data and press Enter.
c) press Enter, click the cell and type the data.
d) click the cell, press Enter and type the data.
Q52. What will you do to select an entire worksheet in a spreadsheet?
a) Click the File tab and select properties from the list
b) Click the grey row heading
c) Click the grey rectangle in the upper left corner of the spreadsheet
d) Click the grey column heading
Q53. A _____________ is an electronic document used to store data in a systematic way and perform calculations just like an expense sheet.
a) spreadsheet
b) worksheet
c) workbook
d) name box
Q54. Which of the following functions can be performed with the help of spreadsheets?
a) Maintaining records
b) Creating videos
c) Analyzing data
d) Performing financial calculations
Q55. Match the columns, and then, choose the correct answer.
a) 1-E, 2-A, 3-B, 4-D, 5-C
b) 1-E, 2-B, 3-C, 4-D, 5-A
c) 1-A, 2-B, 3-C, 4-D, 5-E
d) 1-E, 2-A, 3-D, 4-B, 5-C
Q56. Which of the following is not an advantage of a digital presentation?
a) Can include videos and music
b) Easy to create and edit
c) More effective as compared to other presentation types
d) Cannot be projected to a large audience
Q57. LibreOffice Impress is a type of:
a) Paid software
b) Free and open-source software
c) Shareware
d) Malware
Q58. Which of this software is not a presentation tool?
a) Google Slides
b) MS PowerPoint
c) MS Word
d) LibreOffice Impress
Q59. In LibreOffice Impress, the first slide contains how many textboxes by default?
a) One
b) Two
c) Three
d) None
Q60. By default, LibreOffice Impress saves a file with which extension?
a) .ppt
b) .odp
c) .xls
d) .ods
ICT Skills MCQ Class 12 – ICT Skills Class 12 Questions and Answers
Q61. Which shortcut is used to print a presentation quickly?
a) Ctrl + P
b) Ctrl + S
c) Ctrl + O
d) Ctrl + M
Q62. To add a new slide, you can use the shortcut:
a) Ctrl + N
b) Ctrl + S
c) Ctrl + M
d) Ctrl + D
Q63. Which menu is used to insert a new textbox in a slide?
a) Format
b) View
c) Insert
d) Tools
Q64. Which option is used to insert an image in a presentation?
a) Tools → Insert → Image
b) Format → Picture
c) Insert → Image
d) View → Picture
Q65. Changing slide layout helps to:
a) Organize text and images properly
b) Align the content in desired way
c) Both a and b
d) None of the above
Q66. Which tab is used to select a different layout for a slide?
a) Properties tab
b) Layouts tab
c) Insert tab
d) File tab
Q67. Which menu option will you use to sort data?
a) Tools
b) Data
c) Format
d) View
Q68. Mr Gupta has a spreadsheet with a list of 500 items in his shop. A customer comes and asks for a particular item. How should he arrange the data so that he can find that item fast? He will:
a) apply filter.
b) sort the data.
c) use password.
d) format data.
Q69. Mr Verma shares the computer in his office with other colleagues. He wants to make sure no one sees the financial data he saves on the computer. What should he do?
a) Lock the computer in a cupboard
b) Change the password of his computer so that no one can use it
c) Apply password to the financial data sheet
d) Leave it as it is and hope that no one will open it
Q70. You have a summer vacation project on how to make biogas… What would you use?
a) Chart paper
b) Word document
c) Presentation software
d) Spreadsheet
Q71. What do you need to install on your computer to be able to run Impress?
a) Google
b) Microsoft Office
c) LibreOffice
d) Apple iOS
Class 12 ICT Skills MCQ – CBSE Employability Skills ICT MCQs
Q72. How many textboxes does the first slide of LibreOffice Impress have by default?
a) 1
b) 2
c) 3
d) 4
Q73. Which is the correct step to save a presentation?
a) File>Save As>Type file name>Save
b) File>Open>File name>Open
c) File>Template>Save as Template
d) File>Close>Save>OK
Q74. Which is the correct step to close a presentation?
a) File>Save As>Type file name>Save
b) File>Exit
c) File>Close
d) File>Export
Q75. Which is the correct step for printing a presentation?
a) File>Print
b) File>Print>Handout
c) File>Print>Handout>OK
d) File>OK
Q76. Which menu option do you use to insert a slide?
a) Edit
b) Insert
c) Slide
d) Tools
Q77. How will you, usually, align the title of a slide?
a) Left
b) Right
c) Center
d) Justify
Q78. Which option will you use to change the color of the text?
a) Font Color
b) Font
c) Highlight Color
d) Format
Q79. Which menu option will you click on to insert shapes and images?
a) Format
b) Tools
c) Edit
d) Insert
Q80. What are the steps to insert a square shape in a presentation?
a) Insert > Shape> Line> Square
b) Tools > Shape> Line> Square
c) Insert > Shape> Basic > Square
d) Format > Text > Basic> Square
Q81. What happens when you change the layout of a slide?
a) The format of the text changes
b) New slide is inserted
c) The arrangement of content (text, images, shapes) changes
d) The title gets aligned to the center of the slide
