Q1. Which keyboard shortcut is used to insert a hyperlink in MS Word?
A) Ctrl+H
B) Ctrl+K
C) Ctrl+L
D) Ctrl+I
✅ Answer: B) Ctrl+K
💡 Explanation: Ctrl+K opens the Insert Hyperlink dialog in MS Word, Excel, and PowerPoint.
──────────────────────────────────────────────────────────────────────────────────────────
Q2. In MS Excel, the formula =VLOOKUP(A1, B1:D10, 3, FALSE) will:
A) Search column A1 in the 3rd row of B1:D10
B) Find A1’s value in column B of range B1:D10 and return the 3rd column’s value
C) Lookup the value in 3rd column only
D) Return FALSE always
✅ Answer: B) Find A1’s value in column B of range B1:D10 and return the 3rd column’s value
💡 Explanation: VLOOKUP searches the first column of B1:D10 for A1, then returns the value from the 3rd column of the matching row.
──────────────────────────────────────────────────────────────────────────────────────────
Q3. In PowerPoint, the ‘Slide Master’ is used to:
A) Present a slide in full screen
B) Set a uniform design/layout for all slides
C) Lock slides from editing
D) Export presentation as PDF
✅ Answer: B) Set a uniform design/layout for all slides
💡 Explanation: Slide Master controls the default design, fonts, colors, and layout applied to all slides in a presentation.
──────────────────────────────────────────────────────────────────────────────────────────
Q4. What does the Excel function =COUNTIF(A1:A10,”>50″) return?
A) Sum of all values greater than 50
B) Count of cells in A1:A10 with values greater than 50
C) Average of values above 50
D) Maximum value above 50
✅ Answer: B) Count of cells in A1:A10 with values greater than 50
💡 Explanation: COUNTIF counts the number of cells in a range that meet a specified condition — here, values > 50.
──────────────────────────────────────────────────────────────────────────────────────────
Q5. In MS Word, ‘Track Changes’ feature is used to:
A) Record time spent on a document
B) Show edits made by different users with change markings
C) Track document file size
D) Monitor spell check history
✅ Answer: B) Show edits made by different users with change markings
💡 Explanation: Track Changes highlights insertions, deletions, and formatting changes made by reviewers for collaborative editing.
──────────────────────────────────────────────────────────────────────────────────────────
Q6. Which Excel function returns the current date and time?
A) =DATE()
B) =NOW()
C) =TIME()
D) =TODAY()
✅ Answer: B) =NOW()
💡 Explanation: =NOW() returns the current date AND time. =TODAY() returns only the current date without time.
──────────────────────────────────────────────────────────────────────────────────────────
Q7. In MS Excel, absolute cell reference is represented by:
A) A1
B) $A$1
C) A$1
D) &A&1
✅ Answer: B) $A$1
💡 Explanation: In Excel, $ sign locks a reference. $A$1 means both column A and row 1 are absolute (locked) references.
──────────────────────────────────────────────────────────────────────────────────────────
Q8. ‘Mail Merge’ in MS Word connects a document to:
A) Another Word file only
B) A data source like Excel or Access to personalize documents for multiple recipients
C) Email server directly
D) PDF document
✅ Answer: B) A data source like Excel or Access to personalize documents for multiple recipients
💡 Explanation: Mail Merge merges a Word template with a data source (Excel, CSV, etc.) to create personalized mass documents.
──────────────────────────────────────────────────────────────────────────────────────────
Q9. In Excel, to freeze the top row, you go to:
A) Home → Freeze Panes
B) View → Freeze Panes → Freeze Top Row
C) Insert → Freeze → Top Row
D) Data → Freeze Top Row
✅ Answer: B) View → Freeze Panes → Freeze Top Row
💡 Explanation: View tab → Freeze Panes → Freeze Top Row keeps the first row visible while scrolling down.
──────────────────────────────────────────────────────────────────────────────────────────
Q10. What is the default file extension of MS Word 2016 and later documents?
A) .doc
B) .txt
C) .docx
D) .odt
✅ Answer: C) .docx
💡 Explanation: .docx is the default XML-based format for Word 2007 and later. Older versions used .doc format.
──────────────────────────────────────────────────────────────────────────────────────────
Q11. In PowerPoint, ‘Presenter View’ shows:
A) Slides on full screen for audience
B) Current slide, next slide preview, speaker notes, and timer for the presenter
C) Only slide thumbnails
D) Animation timeline
✅ Answer: B) Current slide, next slide preview, speaker notes, and timer for the presenter
💡 Explanation: Presenter View displays speaker notes, next slide preview, and timer on the presenter’s screen while audience sees only slides.
──────────────────────────────────────────────────────────────────────────────────────────
Q12. Which Excel function calculates the payment for a loan based on constant payments and a constant interest rate?
A) =FV()
B) =NPV()
C) =PMT()
D) =IRR()
✅ Answer: C) =PMT()
💡 Explanation: =PMT(rate, nper, pv) calculates periodic payment for a loan given interest rate, number of periods, and present value.
──────────────────────────────────────────────────────────────────────────────────────────
Q13. In MS Word, which key combination creates a non-breaking space?
A) Ctrl+Space
B) Ctrl+Shift+Space
C) Alt+Space
D) Shift+Space
✅ Answer: B) Ctrl+Shift+Space
💡 Explanation: Ctrl+Shift+Space inserts a non-breaking space that prevents line breaks between two words.
──────────────────────────────────────────────────────────────────────────────────────────
Q14. In Excel, the ‘#REF!’ error indicates:
A) A formula has wrong syntax
B) A cell reference is no longer valid (deleted row/column)
C) Division by zero error
D) Value is not a number
✅ Answer: B) A cell reference is no longer valid (deleted row/column)
💡 Explanation: #REF! error appears when a formula references a cell that no longer exists, typically after deleting rows/columns.
──────────────────────────────────────────────────────────────────────────────────────────
Q15. What does ‘Pivot Table’ in Excel do?
A) Rotates the spreadsheet 90 degrees
B) Summarizes, analyzes, and reorganizes large datasets interactively
C) Creates a pie chart
D) Sorts data alphabetically
✅ Answer: B) Summarizes, analyzes, and reorganizes large datasets interactively
💡 Explanation: Pivot Tables allow dynamic summarization, grouping, and analysis of large datasets without writing formulas.
──────────────────────────────────────────────────────────────────────────────────────────
Q16. The shortcut to repeat the last action in MS Word is:
A) Ctrl+Z
B) Ctrl+Y
C) Ctrl+R
D) F4
✅ Answer: D) F4
💡 Explanation: F4 (or Ctrl+Y) repeats the last action performed in MS Word, Excel, and PowerPoint.
──────────────────────────────────────────────────────────────────────────────────────────
Q17. In Excel, the =INDEX(array, row_num, col_num) function:
A) Creates an index of all data
B) Returns the value at the specified row and column in a range
C) Counts indexed items
D) Searches for a value in array
✅ Answer: B) Returns the value at the specified row and column in a range
💡 Explanation: =INDEX returns the value of an element in a table or array based on specified row and column numbers.
──────────────────────────────────────────────────────────────────────────────────────────
Q18. Which tab in MS Word is used to insert a Table of Contents?
A) Home
B) Insert
C) References
D) Layout
✅ Answer: C) References
💡 Explanation: In MS Word, Table of Contents is inserted via the References tab → Table of Contents section.
──────────────────────────────────────────────────────────────────────────────────────────
Q19. In PowerPoint, ‘Transition’ effects are applied to:
A) Individual objects on a slide
B) The movement between slides
C) Text animations only
D) Background images
✅ Answer: B) The movement between slides
💡 Explanation: Transitions control the visual effect when moving from one slide to the next. Animations apply within a slide.
──────────────────────────────────────────────────────────────────────────────────────────
Q20. The Excel shortcut Ctrl+Shift+L is used to:
A) Lock selected cells
B) Toggle AutoFilter (Filter) on selected data
C) Insert a new row
D) Open Format Cells dialog
✅ Answer: B) Toggle AutoFilter (Filter) on selected data
💡 Explanation: Ctrl+Shift+L toggles the AutoFilter feature on/off for the selected data range in Excel.
──────────────────────────────────────────────────────────────────────────────────────────