Q1. In Microsoft Word, which specific feature allows you to type continuously without pressing the 'Enter' key at the end of each line?
A) Auto Correct
B) Auto Format
C) Word Wrap
D) Line Break
E) Text Alignment
Answer: C
Q2. Which keyboard shortcut is universally used in Microsoft Office applications to "Redo" an action that was previously undone?
A) Ctrl + Z
B) Ctrl + R
C) Ctrl + Y
D) Ctrl + U
E) Ctrl + D
Answer: C
Q3. In an Excel spreadsheet, what is the correct result of the function =FLOOR(19, 5), which rounds a number down to the nearest multiple of significance?
A) 20
B) 15
C) 19
D) 5
E) 18
Answer: B (Rounds 19 down to the nearest multiple of 5, which is 15).
Q4. When using the Mail Merge feature in Word, the document that contains the main body of the text which stays the same for all copies is called the:
A) Data Source
B) Main Document
C) Merged Document
D) Address Block
E) Form Letter
Answer: B
Q5. In Microsoft PowerPoint, which specific view would you use to see all your slides as small thumbnails to easily rearrange their order?
A) Normal View
B) Reading View
C) Slide Master
D) Slide Sorter View
E) Notes Page
Answer: D
Q6. Which symbol must be entered first in a cell to inform Excel that the user is about to type a formula or a function?
A) $ (Dollar)
B) @ (At)
C) = (Equal)
D) # (Hash)
E) & (Ampersand)
Answer: C
Q7. What is the technical term for the distance between the written text and the edge of the paper in a Word document?
A) Gutter
B) Indent
C) Margin
D) Spacing
E) Tab Stop
Answer: C
Q8. Which function key is used to start the PowerPoint Slide Show from the very first slide of the presentation?
A) F1
B) F2
C) F5
D) F7
E) F12
Answer: C
Q9. In Excel, if you want to create an "Absolute Reference" so that a cell address does not change when copied, which symbol do you add?
A) %
B) $
C) *
D) &
E) !
Answer: B (Example:
𝐴
A
1)
Q10. Which keyboard shortcut allows you to quickly "Center Align" the selected paragraph of text in Microsoft Word?
A) Ctrl + C
B) Ctrl + E
C) Ctrl + L
D) Ctrl + R
E) Ctrl + J
Answer: B (Ctrl+C is Copy; Ctrl+E is Center)
Q11. The "Gutter Margin" in Microsoft Word refers to the extra margin space added specifically for:
A) Making the document look artistic.
B) The binding side of the page to ensure text isn't hidden by the binding.
C) The footer area.
D) The right-hand side of every page.
E) Formatting images.
Answer: B
Q12. Which file extension represents a "Macro-Enabled" workbook in Microsoft Excel?
A) .xlsx
B) .xlsm
C) .xlsb
D) .xltx
E) .xml
Answer: B (The 'm' stands for Macro).
Q13. In PowerPoint, "Motion Paths" are a type of animation that allow the user to:
A) Change the color of the slide.
B) Move an object along a specific line or curve drawn on the slide.
C) Move from one slide to the next.
D) Add sound effects to the slide.
E) Delete the slide.
Answer: B
Q14. What is the maximum number of columns that can be supported in a modern Excel worksheet (Excel 2016 and later)?
A) 256
B) 16,384
C) 65,536
D) 1,048,576
E) Unlimited
Answer: B (Rows are 1,048,576; Columns are 16,384).
Q15. If you press "Ctrl + H" in a Microsoft Word document, which dialog box will open?
A) Find and Replace
B) Header and Footer
C) Hyperlink
D) History
E) Help
Answer: A
Q16. Which chart type in Excel is best suited for showing the relationship of parts to a whole (percentages)?
A) Bar Chart
B) Line Chart
C) Pie Chart
D) Scatter Plot
E) Radar Chart
Answer: C
Q17. In MS Word, "Portrait" and "Landscape" are terms that refer to the:
A) Paper Size
B) Page Orientation
C) Page Margins
D) Font Style
E) Text Alignment
Answer: B
Q18. Which feature in Excel allows you to automatically narrow down the data in a table to show only rows that meet certain criteria?
A) Sorting
B) Filtering
C) Merging
D) Pivot Tables
E) Validating
Answer: B
Q19. To create a "Hanging Indent" in MS Word (where the first line is normal but subsequent lines are indented), the shortcut is:
A) Ctrl + T
B) Ctrl + M
C) Ctrl + I
D) Ctrl + H
E) Ctrl + G
Answer: A
Q20. In MS Excel, the intersection of a row and a column is technically known as a:
A) Grid
B) Box
C) Cell
D) Square
E) Pixel
Answer: C
Q21. Which specific keyboard shortcut is used to insert a "Hyperlink" for the selected text in Word, Excel, or PowerPoint?
A) Ctrl + H
B) Ctrl + K
C) Ctrl + L
D) Ctrl + M
E) Alt + K
Answer: B
Q22. What happens if you press "Shift + F3" on a selected text in Microsoft Word?
A) It saves the document.
B) It changes the Case of the text (Uppercase / Lowercase / Sentence case).
C) It opens the Thesaurus.
D) It finds the next occurrence of a word.
E) It prints the document.
Answer: B (Toggle Case)
Q23. In PowerPoint, what is the difference between "Slide Transition" and "Custom Animation"?
A) They are the same.
B) Transition is for text; Animation is for pictures.
C) Transition applies to the movement of the slide itself; Animation applies to objects on the slide.
D) Animation applies to the whole slide; Transition applies to text.
E) Transition adds sound; Animation adds video.
Answer: C
Q24. The default file extension for a standard PowerPoint presentation created in versions 2007 and later is:
A) .ppt
B) .pptx
C) .ppsx
D) .potx
E) .pdf
Answer: B
Q25. Which function in Excel would you use to combine the text from two different cells into one single cell?
A) MERGE()
B) COMBINE()
C) CONCATENATE()
D) JOIN()
E) ADDTEXT()
Answer: C (Or CONCAT in newer versions).
Q26. A "Watermark" in a Word document is best described as:
A) A stain on the paper.
B) A faint text or image placed behind the main content of the document.
C) A footer at the bottom of the page.
D) A border around the text.
E) A blue hyperlink.
Answer: B
Q27. In MS Word, the "Thesaurus" tool is primarily used for:
A) Checking spelling errors.
B) Finding synonyms and antonyms for a selected word.
C) Translating text to another language.
D) Counting the number of words.
E) Grammar checking.
Answer: B
Q28. Which Excel feature allows you to summarize large amounts of data into a compact, interactive table?
A) Data Validation
B) Pivot Table
C) Goal Seek
D) VLOOKUP
E) Scenario Manager
Answer: B
Q29. Pressing the "F12" key in Microsoft Word will typically:
A) Save the document immediately.
B) Open the "Save As" dialog box.
C) Open the "Open" dialog box.
D) Print the document.
E) Close the document.
Answer: B (Ctrl+S is Save; F12 is Save As).
Q30. Which Ribbon tab in MS Word contains the tools for creating a Table of Contents?
A) Home
B) Insert
C) References
D) Layout
E) View
Answer: C
Q31. In an Excel formula, if you see the error message ##### in a cell, it usually indicates that:
A) The formula has a syntax error.
B) The column is not wide enough to display the content (usually numbers or dates).
C) You divided a number by zero.
D) The cell reference is invalid.
E) The file is corrupted.
Answer: B
Q32. To select the entire document or the entire worksheet contents at once, the shortcut is:
A) Ctrl + A
B) Ctrl + S
C) Ctrl + All
D) Alt + A
E) Shift + A
Answer: A
Q33. Which component of the MS Office interface displays the name of the file currently being worked on?
A) The Ribbon
B) The Title Bar
C) The Status Bar
D) The Scroll Bar
E) The Quick Access Toolbar
Answer: B (Located at the very top center).
Q34. In Excel, the feature "Text to Columns" is used to:
A) Combine multiple columns into one text.
B) Split the contents of a single cell into multiple columns based on a delimiter (like a comma).
C) Change the color of the text.
D) Convert numbers into text format.
E) Rotate the text vertically.
Answer: B
Q35. What is the function of the "Format Painter" tool in MS Word?
A) It paints the background of the page.
B) It draws shapes.
C) It copies the formatting from one piece of text and applies it to another.
D) It changes the font color to red.
E) It clears all formatting.
Answer: C
Q36. In PowerPoint, which key do you press to stop a Slide Show and return to the editing view?
A) Enter
B) Spacebar
C) Esc (Escape)
D) Backspace
E) Delete
Answer: C
Q37. Which Excel function is used to find a specific value in the first column of a table and return a value in the same row from another column?
A) SEARCH()
B) FIND()
C) VLOOKUP()
D) MATCH()
E) INDEX()
Answer: C (Vertical Lookup).
Q38. "Drop Cap" is a formatting feature in Word that:
A) Capitalizes every word in a sentence.
B) Makes the first letter of a paragraph very large, spanning several lines.
C) Drops the text to the next page.
D) Adds a caption below an image.
E) Underlines the text.
Answer: B
Q39. To insert a "New Slide" in an existing PowerPoint presentation, the keyboard shortcut is:
A) Ctrl + N
B) Ctrl + M
C) Ctrl + S
D) Ctrl + Enter
E) Alt + N
Answer: B (Ctrl+N creates a New Presentation file; Ctrl+M makes a New Slide).
Q40. The shortcut "Ctrl + =" (Ctrl and Equal sign) in MS Word is used for:
A) Superscript (𝑋2X2)
B) Subscript (𝐻2𝑂H2O)
C) Strikethrough
D) Double Underline
E) Increase Font Size
Answer: B (Subscript).
Q41. Which tab in Excel contains the buttons for "Sort & Filter"?
A) File
B) Insert
C) Data
D) Formulas
E) Review
Answer: C (Also found on the Home tab, but Data is the primary location).
Q42. In Word, the feature that automatically corrects common spelling errors as you type is called:
A) AutoFormat
B) AutoCorrect
C) AutoFill
D) Smart Tags
E) AutoComplete
Answer: B
Q43. What is the smallest and largest font size available in the Font Size tool on the formatting toolbar (the dropdown list) in MS Word?
A) 8 and 72
B) 10 and 100
C) 1 and 1638
D) 12 and 96
E) 5 and 50
Answer: A (Note: You can manually type numbers larger or smaller, but the dropdown list shows 8 to 72).
Q44. Which chart in Excel is known as an "XY Chart"?
A) Area Chart
B) Scatter Chart
C) Stock Chart
D) Doughnut Chart
E) Surface Chart
Answer: B
Q45. The "Zoom" slider is located in which part of the MS Office window?
A) Top Left
B) Top Right
C) Bottom Left
D) Bottom Right (Status Bar)
E) Center
Answer: D
Q46. In MS Word, what is the default file format for saving a document as a template?
A) .docx
B) .dotx
C) .txt
D) .rtf
E) .wpd
Answer: B
Q47. If you want to check the spelling and grammar in your document, which Function key should you press?
A) F1
B) F5
C) F7
D) F9
E) F11
Answer: C
Q48. In Excel, the "COUNT" function will only count cells that contain:
A) Text
B) Numbers
C) Errors
D) Formulas
E) Blank spaces
Answer: B (Use COUNTA to count text/non-empty cells).
Q49. "SmartArt" in MS PowerPoint is used to:
A) Insert internet memes.
B) Create visual representations of information like organizational charts or process cycles.
C) Draw freehand.
D) Edit photographs.
E) Insert videos.
Answer: B
Q50. Which shortcut key is used to "Justify" the paragraph alignment in MS Word (align text to both left and right margins)?
A) Ctrl + J
B) Ctrl + L
C) Ctrl + R
D) Ctrl + E
E) Ctrl + Q
Answer: A
Q51. In an Excel worksheet, if you need to select multiple cells that are NOT next to each other (non-adjacent), which key must you hold down while clicking?
A) Shift
B) Alt
C) Ctrl
D) Tab
E) Caps Lock
Answer: C (Shift selects a continuous range; Ctrl selects individual, scattered cells).
Q52. Which specific feature in Microsoft Word allows you to apply different page formatting (like changing from Portrait to Landscape) in the middle of the same document?
A) Page Break
B) Section Break
C) Column Break
D) Text Wrapping Break
E) Line Break
Answer: B (Section Breaks isolate formatting; Page Breaks just move text to the next page).
Q53. If you want to change the font style, logo, or footer on every slide in your PowerPoint presentation simultaneously, where should you make the change?
A) On the first slide only.
B) In the Slide Master view.
C) In the Slide Sorter view.
D) In the Handout Master.
E) In the Notes Master.
Answer: B (The Slide Master controls the look of the entire presentation).
Q54. In Excel, which specific symbol is used to concatenate (join) text strings from two different cells (an alternative to the CONCATENATE function)?
A) + (Plus)
B) # (Hash)
C) & (Ampersand)
D) @ (At)
E) % (Percent)
Answer: C (Example: =A1 & B1 joins the text).
Q55. What is the keyboard shortcut to double-space the lines of a selected paragraph in Microsoft Word?
A) Ctrl + D
B) Ctrl + 2
C) Ctrl + S
D) Shift + 2
E) Alt + 2
Answer: B (Ctrl+1 is single space; Ctrl+2 is double space; Ctrl+5 is 1.5 space).
Q56. Which error code does Excel display if a formula refers to a cell that has been deleted or is no longer valid?
A) #VALUE!
B) #NAME?
C) #REF!
D) #DIV/0!
E) #NULL!
Answer: C (Reference Error).
Q57. To quickly select an entire sentence in a Word document without dragging the mouse, you can simply:
A) Double-click the sentence.
B) Triple-click the sentence.
C) Hold Ctrl and click anywhere in the sentence.
D) Hold Shift and click the sentence.
E) Right-click the sentence.
Answer: C (Double-click selects a word; Triple-click selects a paragraph; Ctrl+Click selects a sentence).
Q58. Which feature in Excel allows you to keep the top row (headers) visible on the screen while you scroll down through a long list of data?
A) Split Window
B) Freeze Panes
C) Lock Cells
D) Hold Row
E) Viewport Lock
Answer: B
Q59. During a PowerPoint Slide Show presentation, pressing the "B" key on the keyboard will cause the screen to:
A) Go back to the previous slide.
B) Turn completely Black (to pause and focus attention on the speaker).
C) Turn completely Blue.
D) End the show.
E) Brighten the screen.
Answer: B (Pressing 'W' turns it White).
Q60. Which Word feature automates the creation of a bibliography by managing the sources you cite within your document?
A) Citations & Bibliography
B) Mail Merge
C) Cross-reference
D) Indexing
E) Captions
Answer: A (Found in the References tab).
Q61. In Excel, the shortcuts "Ctrl + ;" (Semicolon) and "Ctrl + Shift + ;" (Colon) are used to insert, respectively:
A) Current Time and Current Date.
B) Current Date and Current Time.
C) A new Row and a new Column.
D) A border and a shading.
E) A comment and a note.
Answer: B (Ctrl+; is Date. Ctrl+Shift+; is Time).
Q62. What is the maximum number of items that the Office Clipboard can hold at one time before it starts overwriting the oldest ones?
A) 1
B) 10
C) 12
D) 24
E) 50
Answer: D
Q63. If you want to print a document on paper that measures 8.5 inches by 14 inches, which paper size option should you select?
A) A4
B) Letter
C) Legal
D) Executive
E) A3
Answer: C (Legal is longer than standard Letter/A4).
Q64. Which specific Excel function would you use to return the current date and time, which updates every time the worksheet recalculates?
A) =TODAY()
B) =DATE()
C) =NOW()
D) =CURRENT()
E) =TIME()
Answer: C (TODAY gives only date; NOW gives date and time).
Q65. In Microsoft Word, the "Superscript" format places text slightly above the line (
𝑋
2
X
2
). What is the keyboard shortcut for this?
A) Ctrl + =
B) Ctrl + Shift + +
C) Ctrl + Shift + S
D) Alt + Up Arrow
E) Ctrl + Up Arrow
Answer: B (Ctrl and Shift and Plus).
Q66. Which view in PowerPoint allows you to see the speaker's notes on one screen while the audience sees only the full slide on the projector?
A) Slide Sorter View
B) Reading View
C) Presenter View
D) Master View
E) Outline View
Answer: C
Q67. In Excel, Conditional Formatting is primarily used to:
A) Change the formula of a cell based on its value.
B) Automatically change the font/color of a cell based on specific rules (e.g., color numbers red if less than 50).
C) Format the print area.
D) Sort data alphabetically.
E) Check for spelling errors.
Answer: B
Q68. Which "Wildcard" character is used in Excel or Word search to represent any number of characters?
A) ? (Question Mark)
B) * (Asterisk)
C) ~ (Tilde)
D) # (Hash)
E) @ (At)
Answer: B (? represents a single character; * represents a sequence).
Q69. A "Drop-Cap" in Word can be formatted to drop a maximum of how many lines?
A) 3
B) 5
C) 10
D) 20
E) Unlimited
Answer: C (Default is 3, maximum is 10).
Q70. If you accidentally delete a sheet in an Excel workbook, how can you recover it using Undo (Ctrl+Z)?
A) Press Ctrl+Z immediately.
B) Press Ctrl+Z twice.
C) You cannot recover it; deleting a sheet is a permanent action that cannot be undone.
D) Check the Recycle Bin.
E) Use the File Recovery tool.
Answer: C (This is a classic trick question. Deleting a worksheet cannot be Undone).
Q71. Which ribbon tab would you use to password protect a Word document or an Excel workbook?
A) Home
B) View
C) File (Info)
D) Insert
E) Layout
Answer: C (File > Info > Protect Document).
Q72. In a Word Table, which key moves the cursor to the next cell to the right (and adds a new row if you are in the very last cell)?
A) Enter
B) Spacebar
C) Tab
D) Alt + Right Arrow
E) Shift + Enter
Answer: C
Q73. The file extension ".xltx" refers to which type of Excel file?
A) A standard workbook.
B) An Excel Template.
C) An Excel Add-in.
D) A backup file.
E) A macro-enabled workbook.
Answer: B (Template).
Q74. In PowerPoint, "Rehearse Timings" is a feature that helps you:
A) Record your voice over the slides.
B) Practice the presentation and automatically record how much time you spend on each slide.
C) Check for spelling errors.
D) Set up a loop for a kiosk display.
E) Connect to a projector.
Answer: B
Q75. Which type of Page Break is inserted automatically by Word when you reach the bottom of a page?
A) Hard Page Break
B) Soft Page Break
C) Section Break
D) Column Break
E) Manual Page Break
Answer: B (Soft is automatic; Hard is forced by the user).
Q76. To toggle the display of the Ribbon (hide/show) in any Office application, the shortcut is:
A) Ctrl + F1
B) Ctrl + F4
C) Alt + F1
D) Shift + F1
E) Ctrl + R
Answer: A
Q77. What does the "Format Painter" button look like on the Home ribbon?
A) A Bucket
B) A Pencil
C) A Paintbrush
D) A Roller
E) An Eraser
Answer: C
Q78. In Excel, which function allows you to count cells based on a single condition (e.g., count how many cells contain "Apple")?
A) COUNT()
B) COUNTA()
C) COUNTIF()
D) SUMIF()
E) COUNTBLANK()
Answer: C
Q79. Which specialized Word feature creates a large capital letter at the beginning of a paragraph that sits in the margin area?
A) Drop Cap - Dropped
B) Drop Cap - In Margin
C) Hanging Indent
D) First Line Indent
E) Gutter Text
Answer: B
Q80. When you copy a formula in Excel, relative references change. To prevent a column letter from changing but allow the row number to change, you would use:
A) 𝐴1𝐵)𝐴A1
B)A1
C) 𝐴A1
D) A1
E) #A1
Answer: A (The $ before the A locks the column).
Q81. The "Outline View" in PowerPoint is primarily used for:
A) Viewing only the text of the slides (titles and bullets) to edit content quickly.
B) Seeing thumbnails.
C) Viewing the presentation in full screen.
D) Printing handouts.
E) Adding animations.
Answer: A
Q82. Which shortcut is used to close the currently active document window (but not the entire application)?
A) Alt + F4
B) Ctrl + F4 (or Ctrl + W)
C) Shift + F4
D) Ctrl + Q
E) Esc
Answer: B (Alt+F4 closes the whole program; Ctrl+F4 closes just the file).
Q83. In Excel, the logical function that returns one value if a condition is true and another value if it is false is:
A) AND
B) OR
C) IF
D) NOT
E) WHATIF
Answer: C
Q84. Which Word feature tracks every insertion, deletion, and formatting change made by a user?
A) Comments
B) Compare Documents
C) Track Changes
D) AutoCorrect
E) Version History
Answer: C
Q85. What is the smallest unit of a PowerPoint presentation?
A) A Presentation
B) A Slide
C) A Placeholder
D) An Object
E) A Layout
Answer: B
Q86. To insert a Line Break within the same cell in Excel (typing on a new line inside one box), you must press:
A) Enter
B) Shift + Enter
C) Alt + Enter
D) Ctrl + Enter
E) Tab
Answer: C
Q87. In Word, "Ctrl + Shift + >" is the keyboard shortcut to:
A) Decrease Font Size
B) Increase Font Size
C) Select Next Word
D) Indent Paragraph
E) Align Right
Answer: B
Q88. Which Excel chart feature helps to visualize the trend of data in a single cell (a mini-chart inside a cell)?
A) Sparklines
B) Trendlines
C) PivotChart
D) SmartArt
E) Slicer
Answer: A
Q89. The "Document Map" or "Navigation Pane" in Word relies on the use of:
A) Bold Text
B) Heading Styles (Heading 1, Heading 2, etc.)
C) Large Fonts
D) Page Breaks
E) Hyperlinks
Answer: B (It navigates based on Heading styles).
Q90. In a mail merge, the placeholders that tell Word where to put the data (like <<FirstName>>) are called:
A) Data Tags
B) Merge Fields
C) Input Codes
D) Variable Blocks
E) Smart Tags
Answer: B
Q91. Which Excel error means the column is not wide enough to display the number?
A) #NAME?
B) #VALUE!
C) ######
D) #NUM!
E) #N/A
Answer: C
Q92. To group multiple selected objects (shapes/images) into one single unit in PowerPoint, the shortcut is:
A) Ctrl + G
B) Ctrl + U
C) Ctrl + B
D) Alt + G
E) Shift + G
Answer: A
Q93. The "Thesaurus" shortcut in MS Word is:
A) F7
B) Shift + F7
C) Ctrl + F7
D) Alt + F7
E) F1
Answer: B
Q94. Which function key allows you to edit the contents of a cell in Excel without clicking in the formula bar?
A) F1
B) F2
C) F4
D) F9
E) F11
Answer: B
Q95. In Word, standard page margins are usually set to:
A) 0.5 inch all around
B) 1 inch all around
C) 1.5 inch on left, 1 inch elsewhere
D) 2 inches at top
E) No margins
Answer: B (This is the default for modern versions).
Q96. Which Excel tool allows you to visually filter data in a Pivot Table or Pivot Chart (buttons that you can click to filter)?
A) Sparkline
B) Timeline
C) Slicer
D) Cutter
E) Filter Key
Answer: C
Q97. To quickly calculate the sum of a column of numbers in Excel without typing a formula, you can use the AutoSum shortcut:
A) Ctrl + S
B) Alt + = (Alt and Equal)
C) Shift + =
D) Ctrl + A
E) Alt + S
Answer: B
Q98. What is the term for text that appears faintly behind the document text, often used to indicate "Confidential" or "Draft"?
A) Ghost Text
B) Watermark
C) Background Fill
D) Texture
E) Transparency
Answer: B
Q99. In PowerPoint, if you want a sound to play continuously throughout the entire presentation until you stop it, you must set the audio to:
A) Play Across Slides
B) Loop until Stopped
C) Rewind after Playing
D) Fade In/Out
E) Auto Play
Answer: B
Q100. Which "Paste Special" option in Excel would you use to copy a formula result (like "100") but remove the underlying formula (like "=50+50")?
A) Paste Formulas
B) Paste Values
C) Paste Formats
D) Transpose
E) Paste Link
Answer: B (Values).
0 Comments
Post a Comment