Top 20 Computer MCQs For OSSC LTR Teacher 11 December 2024

Q1. Which shortcut key is used to paste copied content in MS Word?
(a) Ctrl + X
(b) Ctrl + V
(c) Ctrl + Z
(d) Ctrl + C
Ans: (b) Ctrl + V
Sol: Ctrl + V is the universal shortcut for pasting copied content in most software, including MS Word.

Q2. Which feature in MS Excel allows you to apply a calculation to multiple cells?
(a) AutoFill
(b) Merge Cells
(c) Conditional Formatting
(d) Filter
Ans: (a) AutoFill
Sol: AutoFill in MS Excel can quickly fill cells with repetitive or sequential data and apply formulas across multiple cells.

Q3. What is the default file extension of an MS Access database?
(a) .xls
(b) .accdb
(c) .docx
(d) .pptx
Ans: (b) .accdb
Sol: MS Access databases are saved with the .accdb extension by default.

Q4. In MS Word, what is the function of the “Track Changes” feature?
(a) To add images
(b) To create a table of contents
(c) To monitor and show edits made to a document
(d) To check for spelling errors
Ans: (c) To monitor and show edits made to a document
Sol: “Track Changes” highlights the edits made by users in a document for easier collaboration.

Q5. Which shortcut key is used to save a document in MS Word?
(a) Ctrl + S
(b) Ctrl + P
(c) Ctrl + O
(d) Ctrl + N
Ans: (a) Ctrl + S
Sol: Ctrl + S is the standard shortcut to save a file in most applications, including MS Word.

Q6. What does the “Filter” feature in MS Excel do?
(a) Sorts data in ascending order
(b) Sorts data in descending order
(c) Displays only specific rows based on conditions
(d) Removes duplicates from data
Ans: (c) Displays only specific rows based on conditions
Sol: Filters allow users to view rows that meet certain criteria, hiding the rest temporarily.

Q7. Which key combination is used to close the current window in most applications?
(a) Ctrl + W
(b) Ctrl + Q
(c) Alt + Tab
(d) Ctrl + E
Ans: (a) Ctrl + W
Sol: Ctrl + W is commonly used to close the currently active window or document.

Q8. Which of these is NOT an internet browser?
(a) Google Chrome
(b) Mozilla Firefox
(c) Microsoft Access
(d) Safari
Ans: (c) Microsoft Access
Sol: Microsoft Access is a database management system, not an internet browser.

Q9. What is the purpose of the “VLOOKUP” function in MS Excel?
(a) To create a chart
(b) To find a value in a table by row
(c) To calculate averages
(d) To remove duplicates
Ans: (b) To find a value in a table by row
Sol: VLOOKUP searches for a value in a table’s first column and returns a value in the same row from another column.

Q10. In MS Word, which feature allows you to format multiple documents with consistent styles?
(a) Styles
(b) Templates
(c) Macros
(d) Themes
Ans: (b) Templates
Sol: Templates provide predefined formatting, making it easy to maintain consistency across multiple documents.

Q11. In MS Excel, what does the “Freeze Panes” feature do?
(a) Locks certain rows or columns in place
(b) Sorts data in the worksheet
(c) Highlights duplicate values
(d) Formats cells automatically
Ans: (a) Locks certain rows or columns in place
Sol: Freeze Panes keeps specific rows or columns visible while scrolling through the worksheet.

Q12. Which protocol is primarily used to send emails?
(a) HTTP
(b) FTP
(c) SMTP
(d) IP
Ans: (c) SMTP
Sol: SMTP (Simple Mail Transfer Protocol) is used for sending emails.

Q13. In MS Access, what is a primary key?
(a) A table to store data
(b) A unique identifier for each record
(c) A type of query
(d) A relationship between tables
Ans: (b) A unique identifier for each record
Sol: The primary key ensures each record in a table is unique.

Q14. Which shortcut key is used to print a document in MS Word?
(a) Ctrl + P
(b) Ctrl + T
(c) Ctrl + R
(d) Ctrl + N
Ans: (a) Ctrl + P
Sol: Ctrl + P is the universal shortcut to access the print dialog box in most applications.

Q15. What does “Ctrl + Z” do in most software applications?
(a) Redo an action
(b) Undo an action
(c) Copy text
(d) Save the document
Ans: (b) Undo an action
Sol: Ctrl + Z is universally used to undo the last action in most software applications.

Q16. In MS Word, which feature is used to create a table of contents?
(a) Header and Footer
(b) Footnotes
(c) Styles and References
(d) Page Layout
Ans: (c) Styles and References
Sol: Styles and the References tab allow users to generate a table of contents.

Q17. Which of the following is NOT a valid file format to save an MS Excel file?
(a) .xlsx
(b) .csv
(c) .pptx
(d) .xlsm
Ans: (c) .pptx
Sol: .pptx is a PowerPoint file format and not compatible with MS Excel.

Q18. What does the term “phishing” refer to in internet security?
(a) Spamming users with ads
(b) Deceiving users into revealing sensitive information
(c) Installing antivirus software
(d) Speeding up internet browsing
Ans: (b) Deceiving users into revealing sensitive information
Sol: Phishing involves using fake websites or emails to steal personal or financial information.

Q19. In MS Excel, which chart type is best suited for showing trends over time?
(a) Pie Chart
(b) Bar Chart
(c) Line Chart
(d) Area Chart
Ans: (c) Line Chart
Sol: Line charts effectively display data trends over time.

Q20. What is the maximum zoom percentage in MS Word?
(a) 200%
(b) 500%
(c) 300%
(d) 400%
Ans: (b) 500%
Sol: MS Word allows zooming in up to 500% for detailed views of the document.