Top 20 Computer MCQs For All Competitive Exams 29 November 2024
Q1. Which tab in MS PowerPoint is used to insert audio or video into a slide?
(a) File
(b) Insert
(c) Design
(d) Animations
Ans: (b) Insert
Sol: The Insert tab in MS PowerPoint allows users to add multimedia elements such as audio and video to slides.
Q2. In MS Excel, which function is used to find the largest number in a range?
(a) MIN
(b) MAX
(c) AVERAGE
(d) COUNT
Ans: (b) MAX
Sol: The MAX function is used in MS Excel to find the largest value in a specified range of cells.
Q3. What is the file extension for a saved MS Access database?
(a) .docx
(b) .xlsx
(c) .pptx
(d) .accdb
Ans: (d) .accdb
Sol: MS Access databases are saved with the .accdb file extension by default in newer versions.
Q4. Which feature in MS PowerPoint is used to apply motion effects to slides?
(a) Transition
(b) Animation
(c) Slide Layout
(d) Slide Master
Ans: (a) Transition
Sol: The Transition feature in MS PowerPoint is used to apply motion effects when moving between slides.
Q5. In MS Word, which tab is used to insert a table?
(a) File
(b) Home
(c) Insert
(d) View
Ans: (c) Insert
Sol: The Insert tab in MS Word contains the option to insert tables into a document.
Q6. What does the “Primary Key” ensure in an MS Access table?
(a) Duplicate records
(b) Unique records
(c) Sorted data
(d) Linked tables
Ans: (b) Unique records
Sol: The Primary Key ensures that all records in a table have a unique identifier, avoiding duplicates.
Q7. Which shortcut key is used to undo the last action in MS Word?
(a) Ctrl + Y
(b) Ctrl + X
(c) Ctrl + Z
(d) Ctrl + V
Ans: (c) Ctrl + Z
Sol: The shortcut key Ctrl + Z is used to undo the last action performed in MS Word.
Q8. Which function in MS Excel calculates the total of a range of cells?
(a) AVERAGE
(b) SUM
(c) COUNT
(d) CONCATENATE
Ans: (b) SUM
Sol: The SUM function is used to calculate the total value of a range of cells in MS Excel.
Q9. Which slide layout is used in MS PowerPoint to include a title and a list of items?
(a) Title Slide
(b) Title and Content
(c) Blank Slide
(d) Two Content
Ans: (b) Title and Content
Sol: The Title and Content layout allows users to add a title and include a list or content below it.
Q10. In MS Access, what is a “Query”?
(a) A table
(b) A report
(c) A search tool
(d) A data retrieval tool
Ans: (d) A data retrieval tool
Sol: A Query in MS Access is used to retrieve specific data from tables based on given conditions.
Q11. What does the “Ctrl + S” shortcut do in MS Word?
(a) Save
(b) Search
(c) Select All
(d) Save As
Ans: (a) Save
Sol: The Ctrl + S shortcut is used to save the current document in MS Word.
Q12. Which chart in MS Excel is best for showing trends over time?
(a) Bar Chart
(b) Pie Chart
(c) Line Chart
(d) Column Chart
Ans: (c) Line Chart
Sol: A Line Chart is ideal for showing data trends over time in MS Excel.
Q13. Which key is used to start a slideshow in MS PowerPoint?
(a) F1
(b) F5
(c) F11
(d) F12
Ans: (b) F5
Sol: Pressing F5 starts the slideshow from the first slide in MS PowerPoint.
Q14. What is the use of the “Relationships” feature in MS Access?
(a) Create new tables
(b) Link tables
(c) Create forms
(d) Design reports
Ans: (b) Link tables
Sol: The Relationships feature links tables in MS Access based on common fields, ensuring data integrity.
Q15. In MS Word, which tool checks for spelling and grammar errors?
(a) Thesaurus
(b) Proofing
(c) Spell Check
(d) Review
Ans: (c) Spell Check
Sol: The Spell Check tool in MS Word identifies and suggests corrections for spelling and grammar errors.
Q16. Which function in MS Excel returns the average value of a range?
(a) SUM
(b) AVERAGE
(c) COUNT
(d) IF
Ans: (b) AVERAGE
Sol: The AVERAGE function calculates the mean value of a specified range in MS Excel.
Q17. How can you duplicate a slide in MS PowerPoint?
(a) Ctrl + C and Ctrl + V
(b) Ctrl + Shift + D
(c) Ctrl + D
(d) Right-click > Copy
Ans: (c) Ctrl + D
Sol: Pressing Ctrl + D duplicates the selected slide in MS PowerPoint.
Q18. Which view in MS Access allows you to design a table?
(a) Datasheet View
(b) Layout View
(c) Design View
(d) Report View
Ans: (c) Design View
Sol: The Design View in MS Access allows users to define table structure and field properties.
Q19. Which shortcut key aligns text to the center in MS Word?
(a) Ctrl + E
(b) Ctrl + L
(c) Ctrl + R
(d) Ctrl + J
Ans: (a) Ctrl + E
Sol: The Ctrl + E shortcut key aligns selected text to the center in MS Word.
Q20. In MS Excel, what does the “IF” function do?
(a) Calculates the sum
(b) Tests conditions
(c) Sorts data
(d) Finds the maximum value
Ans: (b) Tests conditions
Sol: The IF function in MS Excel tests a condition and returns one value for TRUE and another for FALSE.
| Question of the Day
Comment the Answer |
| Which file extension is used to save a PowerPoint presentation that includes animations and transitions? (a) .pptx (b) .ppsx (c) .potx (d) .pptm |
