Get Free ICT Skills MCQs Class 12 for CBSE Board. Practice all MCQs to boost your preparation, revise key concepts, and score high in exam.
Q1. 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
Show Answer
b. An electronic document with rows and columns
Q2. Which of these is not a popular spreadsheet software?
a. Microsoft Excel
b. LibreOffice Calc
c. Google Sheets
d. Microsoft Word
Show Answer
d. Microsoft Word
Q3. In a spreadsheet, rows are arranged:
a. Vertically
b. Horizontally
c. Randomly
d. Both vertically and horizontally
Show Answer
b. Horizontally
Q4. In a spreadsheet, columns are arranged:
a. Vertically
b. Horizontally
c. Randomly
d. Both vertically and horizontally
Show Answer
a. Vertically
Q5. 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
Show Answer
b. Intersection of single row and single column
Q6. A cell can contain:
a. Text
b. Numbers
c. Formulas
d. All of the above
Show Answer
d. All of the above
Q7. The location of cell is called:
a. Cell range
b. Cell address
c. Cell junction
d. Workbook
Show Answer
b. Cell address
Q8. 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
Show Answer
c. Both a and b
Q9. 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
Show Answer
b. The location of the selected cell
Q10. 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
Show Answer
a. Combination of rows and columns
ICT Skills MCQ Class 12
Q11. A workbook contains:
a. Only one worksheet
b. One or multiple worksheets
c. Only graphs
d. None of the above
Show Answer
b. One or multiple worksheets
Q12. We can enter formula by starting ___ in a cell:
a. =
b. @
c. $
d. #
Show Answer
a. =
Q13. Selecting multiple cells together is called:
a. Active cell
b. Cell range
c. Formula cell
d. Sheet range
Show Answer
b. Cell range
Q14. The default save format for LibreOffice Calc is:
a. .xls
b. .doc
c. .ods
d. .pdf
Show Answer
c. .ods
Q15. Shortcut to print a spreadsheet is:
a. Ctrl+S
b. Ctrl+O
c. Ctrl+P
d. Ctrl+C
Show Answer
c. Ctrl+P
Q16. 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
Show Answer
b. =B2+C2+D2
Q17. Why is it better to use cell addresses in a formula instead of typing numbers directly?
a. It makes spreadsheet look colorful
b. The result automatically updates if the data in the cells changes
c. It prevents formula errors
d. None of the above
Show Answer
b. The result automatically updates if the data in the cells changes
Q18. Shortcut for making text bold is:
a. Ctrl+I
b. Ctrl+B
c. Ctrl+U
d. Ctrl+S
Show Answer
b. Ctrl+B
Q19. 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
Show Answer
b. Find a specific item easily
Q20. 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
Show Answer
b. Data → Sort → Choose field → Descending
ICT Skills MCQ Class 12
Q21. Filtering data allows you to:
a. Print data only
b. View specific data only
c. Save spreadsheet quickly
d. Select all data
Show Answer
b. View specific data only
Q22. To apply a filter, you:
a. Click AutoFilter icon
b. Type =FILTER() in cell
c. Press Ctrl+F
d. All of the above
Show Answer
a. Click AutoFilter icon
Q23. Which menu option is used to protect a spreadsheet?
a. File → Protect Spreadsheet
b. Tools → Protect Spreadsheet
c. Edit → Protect
d. Data → Filter → Protect
Show Answer
b. Tools → Protect Spreadsheet
Q24. Which menu option will you use to sort data?
a. Tools
b. Data
c. Format
d. View
Show Answer
b. Data
Q25. 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?
a. apply filter
b. sort the data
c. use password
d. format data
Show Answer
b. sort the data
Q26. 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
Show Answer
c. Apply password to the financial data sheet
Q27. What is the default alignment of numbers in a cell?
a. Left aligned
b. Right aligned
c. Center aligned
d. Randomly aligned
Show Answer
b. Right aligned
Q28. “By default, the text in a cell is left aligned.” State whether this is true or false.
a. True
b. False
Show Answer
a. True
Q29. What is the shortcut key to underline text in a spreadsheet?
a. Ctrl+b
b. Ctrl+i
c. Ctrl+l
d. Ctrl+u
Show Answer
d. Ctrl+u
Q30. Which of the following features is used to perform addition in spreadsheets?
a. Format option
b. Charts
c. Graphs
d. Formula
Show Answer
d. Formula
Q31. 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
Show Answer
b. click the cell, type the data and press Enter
Q32. 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
Show Answer
c. Click the grey rectangle in the upper left corner of the spreadsheet
ICT Skills MCQ Class 12
Q33. 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
Show Answer
a. spreadsheet
Q34. 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
Show Answer
a, c, d. Maintaining records, Analyzing data, Performing financial calculations
Q35. 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
Show Answer
a. 1-E, 2-A, 3-B, 4-D, 5-C
Q36. Which menu option will you use to sort data?
a. Tools
b. Data
c. Format
d. View
Show Answer
b. Data
Q37. Mr Gupta has a spreadsheet with a list of 500 items in his shop. How should he arrange the data so that he can find an item fast?
a. apply filter
b. sort the data
c. use password
d. format data
Show Answer
b. sort the data
Q38. Mr Verma shares the computer in his office. He wants to make sure no one sees the financial data he saves. What should he do?
a. Lock the computer in a cupboard
b. Change the password of his computer
c. Apply password to the financial data sheet
d. Leave it as it is
Show Answer
c. Apply password to the financial data sheet
Q39. You have a summer vacation project on how to make biogas. You have done research, photos, and videos. Now, you have to make a presentation before the class. What would you use?
a. Chart paper
b. Word document
c. Presentation software
d. Spreadsheet
Show Answer
c. Presentation software
Q40. What do you need to install on your computer to run Impress?
a. Google
b. Microsoft Office
c. LibreOffice
d. Apple iOS
Show Answer
c. LibreOffice
Q41. How many textboxes does the first slide of LibreOffice Impress have by default?
a. 1
b. 2
c. 3
d. 4
Show Answer
b. 2
Q42. 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
Show Answer
a. File>Save As>Type file name>Save
ICT Skills MCQ Class 12
Q43. 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
Show Answer
c. File>Close
Q44. Which is the correct step for printing a presentation?
a. File>Print
b. File>Print>Handout
c. File>Print>Handout>OK
d. File>OK
Show Answer
b. File>Print>Handout
Q45. Which menu option do you use to insert a slide?
a. Edit
b. Insert
c. Slide
d. Tools
Show Answer
b. Insert
Q46. How will you usually align the title of a slide?
a. Left
b. Right
c. Center
d. Justify
Show Answer
c. Center
Q47. Which option will you use to change the color of the text?
a. Font Color
b. Font
c. Highlight Color
d. Format
Show Answer
a. Font Color
Q48. Which menu option will you click on to insert shapes and images?
a. Format
b. Tools
c. Edit
d. Insert
Show Answer
d. Insert
Q49. 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
Show Answer
c. Insert > Shape> Basic > Square
Q50. 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
Show Answer
c. The arrangement of content (text, images, shapes) changes