Top 20 Computer MCQs For OSSC LTR Teachers 19 November 2024

Q1. Which shortcut key is used to save a document in MS Word?
(a) Ctrl + S
(b) Ctrl + P
(c) Ctrl + A
(d) Ctrl + V
S1. Ans: (a) Ctrl + S
Sol: The shortcut key Ctrl + S is used to save the current document in MS Word. This ensures that your changes are saved without needing to access the File menu.

Q2. In MS Excel, which function is used to find the average of a range of numbers?
(a) SUM()
(b) AVG()
(c) AVERAGE()
(d) MEAN()
S2. Ans: (c) AVERAGE()
Sol: The AVERAGE() function in Excel calculates the average (arithmetic mean) of a specified range of numbers

Q3. In MS Access, what type of relationship is created when a primary key in one table is related to a foreign key in another table?
(a) One-to-One
(b) One-to-Many
(c) Many-to-Many
(d) Self-Join
S3. Ans: (b) One-to-Many
Sol: In MS Access, a One-to-Many relationship is created when a primary key in one table is linked to a foreign key in another. This is commonly used in relational databases.

Q4. Which shortcut key is used to open the Find and Replace dialog box in MS Word?
(a) Ctrl + F
(b) Ctrl + H
(c) Ctrl + R
(d) Ctrl + G
S4. Ans: (b) Ctrl + H
Sol: Ctrl + H opens the Find and Replace dialog box in MS Word, allowing users to search for and replace text in the document.

Q5. What is the full form of URL?
(a) Universal Resource Link
(b) Uniform Resource Locator
(c) Uniform Resource Link
(d) Universal Resource Locator
S5. Ans: (b) Uniform Resource Locator
Sol: URL stands for Uniform Resource Locator, which is the address used to access web resources on the internet.

Q6. In MS Excel, which of the following is a valid cell reference?
(a) A1
(b) #A1
(c) 1A
(d) A#1
S6. Ans: (a) A1
Sol: In Excel, a valid cell reference follows the format of a column letter followed by a row number, such as A1.

Q7. Which key combination is used to create a new folder in Windows?
(a) Ctrl + Shift + N
(b) Ctrl + Alt + N
(c) Shift + Alt + N
(d) Ctrl + N
S7. Ans: (a) Ctrl + Shift + N
Sol: The shortcut Ctrl + Shift + N is used in Windows to create a new folder quickly.

Q8. In MS Access, which data type is suitable for storing monetary values?
(a) Text
(b) Number
(c) Currency
(d) Date/Time
S8. Ans: (c) Currency
Sol: The Currency data type in MS Access is designed for storing monetary values and calculations involving money.

Q9. Which of the following is the shortcut key to close an active window in MS Word?
(a) Ctrl + W
(b) Alt + F4
(c) Ctrl + F4
(d) All of the above
S9. Ans: (d) All of the above
Sol: Ctrl + W, Alt + F4, and Ctrl + F4 are all valid shortcuts to close an active window in MS Word.

Q10. What does the abbreviation “ISP” stand for?
(a) International Service Provider
(b) Internet Service Provider
(c) Internal Service Protocol
(d) Internet Service Protocol
S10. Ans: (b) Internet Service Provider
Sol: ISP stands for Internet Service Provider, which refers to companies that provide access to the internet.

(a) Ctrl + Y
(b) Ctrl + Z
(c) Ctrl + U
(d) Ctrl + X
S11. Ans: (b) Ctrl + Z
Sol: The shortcut Ctrl + Z is used to undo the last action in MS Word, allowing users to revert changes.

Q12. In MS Excel, which symbol is used to start a formula?
(a) &
(b) =
(c) $
(d) #
S12. Ans: (b) =
Sol: In Excel, formulas must begin with an = sign to indicate that a calculation or function is being performed.

Q13. What is the default file extension for a Microsoft Access database?
(a) .mdb
(b) .accdb
(c) .xlsx
(d) .docx
S13. Ans: (b) .accdb
Sol: The default file extension for an Access database is .accdb, used for databases created in newer versions of Access.

Q14. Which shortcut key in MS Word is used to apply bold formatting to the selected text?
(a) Ctrl + B
(b) Ctrl + I
(c) Ctrl + U
(d) Ctrl + E
S14. Ans: (a) Ctrl + B
Sol: The shortcut Ctrl + B applies bold formatting to the selected text in MS Word.

Q15. What is the full form of HTTP?
(a) HyperText Transfer Process
(b) HyperText Transfer Protocol
(c) HighText Transfer Protocol
(d) HyperText Transmission Protocol
S15. Ans: (b) HyperText Transfer Protocol
Sol: HTTP stands for HyperText Transfer Protocol, which is used for transferring web pages over the internet.

Q16. Which function in MS Excel is used to count the number of numeric values in a range?
(a) COUNT()
(b) COUNTA()
(c) COUNTIF()
(d) SUM()
S16. Ans: (a) COUNT()
Sol: The COUNT() function counts the number of numeric values in a specified range.

Q17. Which key combination is used to switch between open applications in Windows?
(a) Alt + Tab
(b) Ctrl + Tab
(c) Shift + Tab
(d) Alt + Esc
S17. Ans: (a) Alt + Tab
Sol: The shortcut Alt + Tab is used to switch between open applications in Windows.

Q18. In MS Access, which object is used to retrieve specific data by running a query?
(a) Table
(b) Form
(c) Query
(d) Report
S18. Ans: (c) Query
Sol: A Query in MS Access is used to retrieve specific data from one or more tables based on given criteria.

Q19. Which shortcut key is used to redo the last undone action in MS Word?
(a) Ctrl + Z
(b) Ctrl + Y
(c) Ctrl + R
(d) Ctrl + W
S19. Ans: (b) Ctrl + Y
Sol: The shortcut Ctrl + Y is used to redo the last undone action in MS Word.

Q20. What does the abbreviation PDF stand for?
(a) Portable Document Format
(b) Public Document File
(c) Private Document Format
(d) Printable Document File
S20. Ans: (a) Portable Document Format
Sol: PDF stands for Portable Document Format, a file format developed by Adobe for presenting documents consistently across various device