Q1. In MS Word, what is the default file extension for a document saved as a "Template"?
A) .docx
B) .dotx
C) .docm
D) .txt
E) .pdf
Answer: B
Q2. Which key combination is used to insert a "Page Break" manually in MS Word?
A) Ctrl + Enter
B) Shift + Enter
C) Alt + Enter
D) Ctrl + Shift + Enter
E) Space + Enter
Answer: A
Q3. In Excel, which function key allows you to edit the contents of a cell directly (Toggle Edit Mode)?
A) F1
B) F2
C) F4
D) F5
E) F12
Answer: B
Q4. The "Gutter Margin" refers to:
A) The bottom margin.
B) Margin added to the binding side of the page for printing.
C) The right margin.
D) The top margin.
E) Space between columns.
Answer: B
Q5. In PowerPoint, "Presenter View" allows:
A) The audience to see notes.
B) The presenter to see speaker notes and the next slide while the audience sees only the current slide.
C) Editing during the show.
D) Printing slides.
E) Recording audio.
Answer: B
Q6. Which Excel function is used to join text from two or more cells into one cell?
A) JOIN
B) MERGE
C) CONCATENATE (or CONCAT)
D) ADDTEXT
E) COMBINE
Answer: C
Q7. The shortcut Ctrl + H opens which dialog box in MS Word?
A) History
B) Find and Replace (Replace tab)
C) Hyperlink
D) Header
E) Help
Answer: B
Q8. Which chart type in Excel is best for showing trends over time (continuous data)?
A) Pie Chart
B) Line Chart
C) Scatter Plot
D) Doughnut Chart
E) Radar Chart
Answer: B
Q9. To create a "Hanging Indent" in Word, which shortcut is used?
A) Ctrl + T
B) Ctrl + H
C) Ctrl + M
D) Ctrl + I
E) Ctrl + J
Answer: A
Q10. In Excel, a cell reference like $A$1 is called:
A) Relative Reference
B) Absolute Reference
C) Mixed Reference
D) Circular Reference
E) Dynamic Reference
Answer: B
Q11. What is the maximum number of rows in a single Excel worksheet (2019/365)?
A) 65,536
B) 1,048,576
C) 16,384
D) Unlimited
E) 50,000
Answer: B
Q12. The F12 key in MS Office applications typically opens:
A) Save As dialog box
B) Save
C) Open
D) Print
E) Help
Answer: A
Q13. In Word, "Drop Cap" is used to:
A) Drop the text to the next page.
B) Make the first letter of a paragraph large (spanning multiple lines).
C) Capitalize all text.
D) Add a caption.
E) Delete text.
Answer: B
Q14. Which feature in Excel automatically fills a series of data (like days of the week) when you drag the handle?
A) AutoComplete
B) AutoFill
C) AutoCorrect
D) Flash Fill
E) Smart Fill
Answer: B
Q15. The shortcut Shift + F3 in Word changes:
A) Font Size
B) Text Case (Upper, Lower, Sentence)
C) Color
D) Font Style
E) Paragraph Spacing
Answer: B
Q16. In PowerPoint, which view shows thumbnails of all slides to easily reorder them?
A) Normal
B) Slide Sorter
C) Reading View
D) Notes Page
E) Master View
Answer: B
Q17. What does the "Format Painter" do?
A) Paints pictures.
B) Copies formatting from one object/text and applies it to another.
C) Clears formatting.
D) Draws shapes.
E) Colors the background.
Answer: B
Q18. Which specific Excel error appears when a column is not wide enough to display the number?
A) #VALUE!
B) #NAME?
C) ######
D) #DIV/0!
E) #N/A
Answer: C
Q19. To insert a "Hyperlink" (Link) in Word/Excel, press:
A) Ctrl + L
B) Ctrl + K
C) Ctrl + H
D) Alt + K
E) Shift + H
Answer: B
Q20. "Mail Merge" involves a "Main Document" and a:
A) Data Source
B) Secondary Document
C) Form Letter
D) Backup File
E) Web Page
Answer: A
Q21. The shortcut Ctrl + = (Equal sign) in Word creates:
A) Superscript
B) Subscript
C) Double Underline
D) Strikethrough
E) Bold
Answer: B
Q22. The shortcut Ctrl + Shift + + (Plus sign) in Word creates:
A) Superscript (
𝑋
2
X
2
)
B) Subscript
C) Increase Font Size
D) Zoom In
E) Add Page
Answer: A
Q23. In Excel, which symbol is used to start every formula?
A) +
B) -
C) =
D) @
E) #
Answer: C
Q24. "Pivot Table" is a tool used for:
A) Rotating the screen.
B) Summarizing and analyzing large datasets dynamically.
C) Drawing tables.
D) Merging cells.
E) Validating data.
Answer: B
Q25. Which function counts only cells that contain numbers?
A) COUNTA
B) COUNT
C) COUNTIF
D) SUM
E) TOTAL
Answer: B (COUNTA counts text/non-empty too).
Q26. To select the entire worksheet in Excel, press:
A) Ctrl + A
B) Alt + A
C) Shift + Space
D) Ctrl + Space
E) F8
Answer: A
Q27. In PowerPoint, F5 starts the slideshow from:
A) The current slide.
B) The beginning (Slide 1).
C) The end.
D) The custom show.
E) The hidden slides.
Answer: B (Shift + F5 starts from current).
Q28. "Macro" in MS Office is:
A) A large file.
B) A series of commands/instructions recorded to automate repetitive tasks (written in VBA).
C) A virus.
D) A formula.
E) A chart.
Answer: B
Q29. Which tab contains the "Watermark" option in MS Word (newer versions)?
A) Home
B) Insert
C) Design
D) Layout
E) View
Answer: C (In older versions, it was Page Layout).
Q30. "Portrait" and "Landscape" are types of:
A) Page Orientation
B) Paper Size
C) Margins
D) Fonts
E) Alignments
Answer: A
Q31. Which Excel feature allows you to restrict the type of data entered in a cell (e.g., numbers only between 1-10)?
A) Data Validation
B) Conditional Formatting
C) Filter
D) Sorting
E) Protect Sheet
Answer: A
Q32. In Word, Ctrl + J applies which alignment?
A) Left
B) Center
C) Right
D) Justify
E) None
Answer: D
Q33. What is the intersection of a Row and Column called?
A) Box
B) Cell
C) Grid
D) Pixel
E) Square
Answer: B
Q34. The "Ribbon" can be minimized/maximized by double-clicking a tab or pressing:
A) Ctrl + F1
B) Alt + F1
C) Shift + F1
D) Ctrl + R
E) F11
Answer: A
Q35. "Thesaurus" tool in Word (Shift + F7) is used for:
A) Spelling check.
B) Grammar check.
C) Finding Synonyms and Antonyms.
D) Word count.
E) Translation.
Answer: C
Q36. In Excel, VLOOKUP searches for data in:
A) The first row.
B) The first column.
C) Diagonal cells.
D) Any random cell.
E) The last column.
Answer: B (Vertical Lookup).
Q37. Which "Paste Special" option copies only the result of a formula, not the formula itself?
A) Paste Values
B) Paste Formulas
C) Paste Formats
D) Transpose
E) Paste Link
Answer: A
Q38. "Sparklines" in Excel are:
A) Tiny charts embedded within a single cell.
B) Large lines.
C) Gridlines.
D) Borders.
E) Animation.
Answer: A
Q39. Alt + Enter in an Excel cell allows you to:
A) Calculate the sum.
B) Insert a Line Break within the same cell (Multiple lines in one cell).
C) Move to next cell.
D) Open properties.
E) Save.
Answer: B
Q40. In Word, a red wavy line under a word indicates:
A) Grammar error.
B) Spelling error.
C) Contextual error.
D) Correct word.
E) Hyperlink.
Answer: B (Blue is Grammar/Context).
Q41. Which chart type is best for comparing parts of a whole (percentage)?
A) Column
B) Pie
C) Area
D) Scatter
E) Line
Answer: B
Q42. To group selected shapes in PowerPoint, use:
A) Ctrl + G
B) Ctrl + U (Ungroup)
C) Ctrl + B
D) Alt + G
E) Shift + G
Answer: A
Q43. Which Excel function returns the current Date AND Time?
A) TODAY()
B) NOW()
C) DATE()
D) TIME()
E) CURRENT()
Answer: B
Q44. To quickly "Center" text in Word, use:
A) Ctrl + C
B) Ctrl + E
C) Ctrl + R
D) Ctrl + M
E) Ctrl + L
Answer: B
Q45. "Slide Master" in PowerPoint is used to:
A) Edit one slide.
B) Apply a consistent layout/theme/logo to all slides at once.
C) View thumbnails.
D) Print handouts.
E) Add animation.
Answer: B
Q46. Which feature allows you to "Freeze" the top row in Excel so it stays visible while scrolling?
A) Split Window
B) Freeze Panes
C) Lock Row
D) Hold Headers
E) Viewport
Answer: B
Q47. Ctrl + Y is the shortcut for:
A) Undo
B) Redo
C) Paste
D) Cut
E) Find
Answer: B
Q48. In Word, Ctrl + [ (Open Bracket) decreases font size by:
A) 1 point
B) 2 points
C) 10 points
D) 5 points
E) Half point
Answer: A
Q49. Which logical function in Excel returns TRUE if all conditions are met?
A) OR
B) AND
C) IF
D) NOT
E) XOR
Answer: B
Q50. "Animation" vs "Transition" in PowerPoint:
A) Transition moves objects; Animation moves slides.
B) Transition is for Slide entry; Animation is for Object movement (text/images) on the slide.
C) They are the same.
D) Transition adds sound only.
E) Animation is for video only.
Answer: B
Q51. The "Quick Access Toolbar" is located:
A) At the bottom status bar.
B) Above or below the Ribbon (Top left corner).
C) On the right side.
D) In the File menu.
E) It is hidden.
Answer: B
Q52. Which Excel error means "Invalid Cell Reference" (e.g., cell was deleted)?
A) #VALUE!
B) #REF!
C) #NAME?
D) #DIV/0!
E) #NULL!
Answer: B
Q53. To create a "New Slide" in PowerPoint, press:
A) Ctrl + N
B) Ctrl + M
C) Ctrl + Enter
D) Shift + N
E) Alt + N
Answer: B (Ctrl + N creates a new Presentation file).
Q54. "Header and Footer" options are found in which tab?
A) Home
B) Insert
C) Layout
D) View
E) Review
Answer: B
Q55. In Excel, Ctrl + ; (Semicolon) inserts:
A) Current Time
B) Current Date
C) A new row
D) A formula
E) A comment
Answer: B (Ctrl + Shift + ; is Time).
Q56. Which Word feature tracks all edits (insertions/deletions) made by a user?
A) Comments
B) Track Changes
C) Compare
D) History
E) Versioning
Answer: B
Q57. "SmartArt" allows you to insert:
A) Videos.
B) Visual diagrams like Organization Charts, Process Cycles, Pyramids.
C) Audio.
D) Internet links.
E) Games.
Answer: B
Q58. To "Justify" text means:
A) Align to left only.
B) Align to right only.
C) Align text to both Left and Right margins (adding space between words).
D) Center it.
E) Bold it.
Answer: C
Q59. The file extension .xlsm indicates:
A) Standard Excel Workbook.
B) Excel Template.
C) Excel Macro-Enabled Workbook.
D) Excel Binary Workbook.
E) Excel Backup.
Answer: C
Q60. Alt + Tab is used to:
A) Close windows.
B) Switch between open applications/windows.
C) Open the Start menu.
D) Lock the PC.
E) Show Desktop.
Answer: B
0 Comments
Post a Comment