MS Office and Productivity Tools PYQs

Question 1

Which feature allows you to create a multi-level numbered list (e.g., 1.1, 1.2) in MS Word 2019?

Accepted Answer

Define New Multilevel List

Answer

Increase Indent button

Answer

Format Painter

Answer

Change Styles option

Question 2

What is the primary purpose of the 'Formula Bar' in MS Excel?

Accepted Answer

To display and edit the contents of a cell

Answer

To insert charts and images

Answer

To navigate between worksheets

Answer

To change the background color of cells

Question 3

In an MS Excel spreadsheet, what does the cell address B5 represent?

Accepted Answer

Column B and Row 5

Answer

Row B and Column 5

Answer

The value 'B5' stored in a cell

Answer

A formula referencing another cell

Question 4

In MS Excel, which feature ensures that only a specified portion of the spreadsheet is printed?

Accepted Answer

Print Area

Answer

Page Break Preview

Answer

Margin Settings

Answer

Page Orientation

Question 5

If you want your audience to NOT see your notes in the MS PowerPoint 365 slides, which view should you use during slide show?

Accepted Answer

Presenter View

Answer

Slide Show View

Answer

Reading View

Answer

Outline View

Question 6

How do we customise bullets in MS Word?

Accepted Answer

Home → Bullets → Define New Bullet

Answer

Insert → Picture

Answer

Layout → Margins

Answer

View → Zoom

Question 7

Which of the following scenarios would most effectively necessitate the use of a 'Keep with Next' paragraph formatting option in MS Word?

Accepted Answer

Ensuring that a heading and the paragraph immediately following it always appear on the same page

Answer

Automatically indenting the first line of every paragraph in a document

Answer

Applying a consistent bullet point style to a list of items

Answer

Preventing a long paragraph from being split across multiple pages

Question 8

Which of the following best describes the function of a 'Section Break (Next Page)' in MS Word?

Accepted Answer

It ends the current section and starts a new section on the subsequent page.

Answer

It creates a visual divider between different parts of the document on the same page.

Answer

It inserts a manual line break within the same paragraph.

Answer

It starts a new paragraph while maintaining the same formatting.

Question 9

Considering the fundamental operations of a computer, what is the immediate effect of pressing the Tab key within a command-line interface (CLI) or terminal?

Accepted Answer

It attempts to auto-complete the currently typed command or filename.

Answer

It deletes the last typed character.

Answer

It executes the currently typed command.

Answer

It switches to a different virtual terminal or console.

Question 10

Which of the following is the keyboard shortcut to save an MS Excel workbook?

Accepted Answer

Ctrl + S

Answer

Tab + S

Answer

Ctrl + K

Answer

Alt + S

Question 11

Which of the following actions is performed when the Ctrl + V shortcut is used in most computer applications?

Accepted Answer

Paste the copied or cut content

Answer

Opens the new file creation dialog box

Answer

Opens the Find dialog box

Answer

Saves the current document

Question 12

Which of the following is an example of a mixed cell reference in MS Excel?

Accepted Answer

$A1

Answer

=SUM(A1:A5)

Answer

A1

Answer

$A$1

Question 13

Which shortcut key combination is used to insert a hyperlink in MS PowerPoint 365?

Accepted Answer

Ctrl + K

Answer

Ctrl + N

Answer

Alt + X

Answer

Ctrl + Shift + X

Question 14

In MS PowerPoint, which of the following keys must be pressed to start a new line while typing inside a text box?

Accepted Answer

Enter

Answer

Spacebar

Answer

Shift

Answer

Tab

Question 15

In MS Word 2019, which of the following features can you use to change the page orientation of your document?

Accepted Answer

Page Layout → Orientation

Answer

View → Print Layout

Answer

Insert → Page Number

Answer

Review → Spelling & Grammar

Question 16

In MS Word, if you want to duplicate a selected text without removing it from its original location, which set of commands should you use?

Accepted Answer

Copy → Paste

Answer

Cut → Paste

Answer

Select → Move

Answer

Delete → Undo

Question 17

In MS Word 365, which feature allows users to set specific spacing before and after paragraphs to control the vertical space between paragraphs and improve document readability?

Accepted Answer

Paragraph Spacing

Answer

Indentation

Answer

Page Layout

Answer

Line Spacing

Question 18

On the MS PowerPoint 2019 home screen, which option or section should you click to start a new blank presentation when the 'Start Screen' is enabled?

Accepted Answer

The tile labeled 'Blank Presentation' on the right panel

Answer

The Design tab from the ribbon

Answer

The Open button at the bottom left corner

Answer

The Recent tab in the left sidebar

Question 19

Which of the following keyboard shortcuts is used to insert a new slide in PowerPoint 2019?

Accepted Answer

Ctrl + M

Answer

Ctrl + N

Answer

Ctrl + D

Answer

Ctrl + K

Question 20

Which of the following is NOT a valid way to save a workbook in Microsoft Excel?

Accepted Answer

Using 'File' → 'Close'

Answer

Pressing 'Ctrl + S'

Answer

Clicking 'File' → 'Save'

Answer

Selecting 'File' → 'Save As'

Question 21

Which action best describes the effect of applying bullets or numbering to a selection of text in MS Word?

Accepted Answer

It converts the selected text into a structured list with symbols or numbers for better organization.

Answer

It hides the selected content to protect it from being viewed.

Answer

It automatically splits the document into multiple sections.

Answer

It applies a background color to highlight important paragraphs.

Question 22

In applications with multiple tabs (like browsers or MS Word), what does Ctrl + Tab do?

Accepted Answer

Switches to the next tab

Answer

Closes the current tab

Answer

Opens a new tab

Answer

Refreshes the tab

Question 23

Which of the following scenarios would most likely result in a '#REF!' error in an MS Excel formula?

Accepted Answer

Deleting a row or column that contains cells referenced by a formula in another worksheet

Answer

Entering a formula that exceeds the maximum allowed length in Excel

Answer

Attempting to divide a number by zero within a cell

Answer

Referring to a cell that contains a text value in a mathematical operation

Question 24

Which feature in MS-PowerPoint 2019 allows you to reuse slides from another presentation without copying content manually?

Accepted Answer

Reuse Slides (under the Home tab)

Answer

Animation Painter

Answer

Slide Master

Answer

Format Painter

Question 25

When applying a watermark to an MS Word document, which of the following settings offers the LEAST control over its precise placement and size on each page?

Accepted Answer

Utilising a predefined watermark template from the 'Watermark' gallery

Answer

Inserting a graphic as a header or footer and positioning it behind the text

Answer

Inserting a custom picture watermark and adjusting its scale and wash-out settings

Answer

Inserting a custom text watermark with specific layout options

Question 26

What is the main advantage of saving an MS PowerPoint presentation as a .pdf file?

Accepted Answer

It reduces file size and prevents unwanted editing.

Answer

It allows all MS PowerPoint animations to run.

Answer

It automatically translates text into different languages.

Answer

It enables users to modify slides in any PDF viewer.

Question 27

What is the purpose of the Find and Replace feature (Ctrl + H) in MS Word 2019?

Accepted Answer

To search for specific text and replace it with other text

Answer

To adjust paragraph spacing

Answer

To change the font of the selected text

Answer

To insert hyperlinks

Question 28

Which element of the MS Excel interface displays the name of the currently active cell or the selected range of cells?

Accepted Answer

The Name Box

Answer

The Formula Bar

Answer

The Status Bar

Answer

The Ribbon

Question 29

Which of the following accurately describes the function of the 'Spill Range' feature introduced in newer versions of MS Excel?

Accepted Answer

It dynamically resizes a formula's output range when the formula returns multiple values.

Answer

It restricts data entry within a specific range of cells based on predefined criteria.

Answer

It automatically saves the workbook to a cloud location at predefined intervals.

Answer

It allows multiple users to simultaneously edit different ranges within the same worksheet.

Question 30

In MS PowerPoint 2019, when you press the Enter key while typing in a text box, what happens?

Accepted Answer

The cursor moves to the next line within the same text box.

Answer

The text is deleted.

Answer

The text is entered into a new slide.

Answer

The text box is automatically resized.

Question 31

In MS Word 2019, if you want to select an entire paragraph quickly, which of the following actions should you perform?

Accepted Answer

Triple-click on any word within the paragraph.

Answer

Press and hold Alt while clicking the paragraph.

Answer

Right-click and choose 'Paragraph' from the available menu options.

Answer

Double-click anywhere in the paragraph.

Question 32

When utilising the 'Paste Special' function in MS Word to insert content copied from a spreadsheet, which of the following paste options would preserve the original formula calculations while displaying the calculated values in the Word document?

Accepted Answer

MS Excel Worksheet Object

Answer

HTML Format

Answer

Unformatted Text

Answer

Picture (Enhanced Metafile)

Question 33

What happens when you press F5 in MS PowerPoint 2019?

Accepted Answer

Starts the slide show from the beginning

Answer

Saves the presentation

Answer

Opens the 'Print' dialog box

Answer

Inserts a new slide

Question 34

What happens when you press Ctrl + S while working on a document in computer system?

Accepted Answer

Saves the current document

Answer

Searches the document

Answer

Starts a slide show

Answer

Sends the document

Question 35

A user wants to have a bulleted list in MS PowerPoint. After typing a list item and pressing Enter, they want to create a sub-bullet point (a lower-level bullet). Which of the following actions will reliably achieve this?

Accepted Answer

Clicking the 'Increase List Level' button in the Paragraph group

Answer

Pressing Alt + Enter

Answer

Clicking the 'Decrease List Level' button in the Paragraph group

Answer

Pressing Ctrl + Tab

Question 36

Which keyboard shortcut opens File Explorer in Windows 11 OS to navigate and create files/folders?

Accepted Answer

Windows Key + E

Answer

Ctrl + Shift + N

Answer

Ctrl + E

Answer

Alt + Tab

Question 37

Which of the following best describes the underlying data structure that forms the basis of an electronic spreadsheet like MS Excel?

Accepted Answer

A two-dimensional grid composed of rows and columns intersecting to form cells

Answer

A linear sequence of data entries, similar to a text document

Answer

A hierarchical tree structure organizing data into nodes and branches

Answer

Relational database model with interconnected tables and fields

Question 38

Which keyboard shortcut is used to quickly save a workbook in MS-Excel 365?

Accepted Answer

Ctrl + S

Answer

Ctrl + V

Answer

Ctrl + P

Answer

Ctrl + C

Question 39

Which of the following statements accurately describes the behavior of continuing numbering from a previous list when inserting a new numbered list within the same document in MS Word?

Accepted Answer

MS Word provides an option upon creating the new list to 'Continue from previous list', which needs to be explicitly selected.

Answer

Continuing numbering is only possible if both lists use the exact same numbering style and level.

Answer

MS Word automatically continues the numbering sequence from the previous list by default.

Answer

MS Word automatically restarts the numbering from 1 for the new list, and there is no direct way to continue the previous sequence.

Question 40

Which keyboard shortcut is used to make the selected text bold in MS Word 365?

Accepted Answer

Ctrl + B

Answer

Ctrl + D

Answer

Ctrl + I

Answer

Ctrl + U

Question 41

In MS Word 365, which feature allows users to customise the appearance of bulleted lists by selecting different bullet styles or symbols and modifying their size and color?

Accepted Answer

Bullet Library

Answer

Line Spacing

Answer

Format Painter

Answer

List Style

Question 42

What does setting a Page Break in MS Excel 365 allow you to control?

Accepted Answer

Where the worksheet splits across printed pages

Answer

Whether formulas are recalculated before printing

Answer

The maximum size of printable margins

Answer

Where headers appear on each page

Question 43

What happens when you use the Format Painter tool in MS Word?

Accepted Answer

It copies formatting (e.g., font, color) from one piece of text to another.

Answer

It deletes the selected text.

Answer

It changes the page orientation.

Answer

It inserts a hyperlink.

Question 44

What is the standard method to save your work in PowerPoint?

Accepted Answer

Use the File tab and select 'Save' or press Ctrl + S

Answer

Exit the program without saving

Answer

Select 'Save' from the Design tab

Answer

Click on the Insert tab

Question 45

Which function key can be used with Alt to close the current application in Windows applications?

Accepted Answer

F4

Answer

F6

Answer

F10

Answer

F1

Question 46

Which keyboard shortcut opens the Print dialog box in MS Excel 365?

Accepted Answer

Ctrl + P

Answer

Ctrl + N

Answer

Ctrl + O

Answer

Ctrl + S

Question 47

If you want to save a workbook in MS Excel 365 so that only viewing is allowed and editing is restricted, which feature should you use?

Accepted Answer

Read-Only Mode

Answer

Freeze Panes

Answer

Print Layout

Answer

Read Aloud

Question 48

Which method CANNOT be used to create a new slide in MS PowerPoint 365?

Accepted Answer

Pressing Ctrl + N

Answer

Clicking 'New Slide' on the Home tab

Answer

Right-clicking in the slide sorter pane and selecting 'New Slide'

Answer

Pressing Ctrl + M

Question 49

Which of the following is the correct way to add a new slide in an MS-PowerPoint 2019 presentation?

Accepted Answer

Go to the Home tab → Click New Slide

Answer

Press Ctrl + N

Answer

Press Alt + F4

Answer

Right-click the slide → Select Copy

Question 50

You have applied a specific character style to several instances of a product name throughout a lengthy MS Word document. If you need to change the font and color of all these instances, what is the most efficient method?

Accepted Answer

Modifying the definition of the character style

Answer

Using the 'Find and Replace' function with formatting options

Answer

Manually selecting each instance and applying the new formatting

Answer

Copying the formatting from one instance using the 'Format Painter' and applying it to others

Question 51

Which tab in MS Word 365 contains options to change page margins, orientation and size?

Accepted Answer

Layout

Answer

Home

Answer

Insert

Answer

Review

Question 52

Which of the following best describes the 'Gutter' margin in MS Word 2019?

Accepted Answer

Extra space added for document binding

Answer

A margin applied only to odd-numbered pages

Answer

The blank space on all four sides of the page

Answer

The space at the top of the page for a header

Question 53

When working with text wrapping around an image in MS Word, which 'Layout Option' provides the most flexibility in precisely positioning the image relative to the text and other elements, ignoring the text flow?

Accepted Answer

Behind Text or In Front of Text

Answer

Tight

Answer

Square

Answer

Through

Question 54

If you move text using 'Cut and Paste', where does the text go before being pasted in MS Office?

Accepted Answer

To the Clipboard

Answer

To the Recycle Bin

Answer

Stored in a temporary document

Answer

Disappears permanently until pasted

Question 55

What happens if you paste text into MS-PowerPoint 2019 with the Keep Source Formatting option?

Accepted Answer

The text retains its original formatting from the source.

Answer

The text adopts the destination slide’s theme fonts/colors.

Answer

The text is converted into an image.

Answer

The text size automatically adjusts to fit the slide.

Question 56

What is the shortcut to open an MS PowerPoint file directly from the application?

Accepted Answer

Ctrl + O

Answer

Ctrl + N

Answer

Ctrl + P

Answer

Ctrl + S

Question 57

What is the primary function of Alt + Tab in most modern operating systems?

Accepted Answer

Switches between open applications

Answer

Opens a new tab in the current application

Answer

Opens Task Manager directly

Answer

Minimises the active window

Question 58

Which of the following shortcut keys can be used to quickly open a presentation in PowerPoint?

Accepted Answer

Ctrl + O

Answer

Shift + O

Answer

Alt + O

Answer

Tab + O

Question 59

Which of the following methods is the quickest way to open an existing MS Excel spreadsheet?

Accepted Answer

Double-click the .xlsx file in File Explorer

Answer

Open MS Excel and click Blank Workbook

Answer

Use the Alt + F4 shortcut

Answer

Press Ctrl + N

Question 60

Which of the following elements is NOT inherently part of a basic 'Blank Presentation' upon its initial creation in MS PowerPoint?

Accepted Answer

Pre-defined theme colours

Answer

At least one slide

Answer

Placeholders for content

Answer

A default slide layout

Q101. Which feature allows you to create a multi-level numbered list (e.g., 1.1, 1.2) in MS Word 2019?

Q102. What is the primary purpose of the 'Formula Bar' in MS Excel?

Q103. In an MS Excel spreadsheet, what does the cell address B5 represent?

Q104. In MS Excel, which feature ensures that only a specified portion of the spreadsheet is printed?

Q105. If you want your audience to NOT see your notes in the MS PowerPoint 365 slides, which view should you use during slide show?

Q106. How do we customise bullets in MS Word?

Q107. Which of the following scenarios would most effectively necessitate the use of a 'Keep with Next' paragraph formatting option in MS Word?

Q108. Which of the following best describes the function of a 'Section Break (Next Page)' in MS Word?

Q109. Considering the fundamental operations of a computer, what is the immediate effect of pressing the Tab key within a command-line interface (CLI) or terminal?

Q110. Which of the following is the keyboard shortcut to save an MS Excel workbook?

Q111. Which of the following actions is performed when the Ctrl + V shortcut is used in most computer applications?

Q112. Which of the following is an example of a mixed cell reference in MS Excel?

Q113. Which shortcut key combination is used to insert a hyperlink in MS PowerPoint 365?

Q114. In MS PowerPoint, which of the following keys must be pressed to start a new line while typing inside a text box?

Q115. In MS Word 2019, which of the following features can you use to change the page orientation of your document?

Q116. In MS Word, if you want to duplicate a selected text without removing it from its original location, which set of commands should you use?

Q117. In MS Word 365, which feature allows users to set specific spacing before and after paragraphs to control the vertical space between paragraphs and improve document readability?

Q118. On the MS PowerPoint 2019 home screen, which option or section should you click to start a new blank presentation when the 'Start Screen' is enabled?

Q119. Which of the following keyboard shortcuts is used to insert a new slide in PowerPoint 2019?

Q120. Which of the following is NOT a valid way to save a workbook in Microsoft Excel?

Q121. Which action best describes the effect of applying bullets or numbering to a selection of text in MS Word?

Q122. In applications with multiple tabs (like browsers or MS Word), what does Ctrl + Tab do?

Q123. Which of the following scenarios would most likely result in a '#REF!' error in an MS Excel formula?

Q124. Which feature in MS-PowerPoint 2019 allows you to reuse slides from another presentation without copying content manually?

Q125. When applying a watermark to an MS Word document, which of the following settings offers the LEAST control over its precise placement and size on each page?

Q126. What is the main advantage of saving an MS PowerPoint presentation as a .pdf file?

Q127. What is the purpose of the Find and Replace feature (Ctrl + H) in MS Word 2019?

Q128. Which element of the MS Excel interface displays the name of the currently active cell or the selected range of cells?

Q129. Which of the following accurately describes the function of the 'Spill Range' feature introduced in newer versions of MS Excel?

Q130. In MS PowerPoint 2019, when you press the Enter key while typing in a text box, what happens?

Q131. In MS Word 2019, if you want to select an entire paragraph quickly, which of the following actions should you perform?

Q132. When utilising the 'Paste Special' function in MS Word to insert content copied from a spreadsheet, which of the following paste options would preserve the original formula calculations while displaying the calculated values in the Word document?

Q133. What happens when you press F5 in MS PowerPoint 2019?

Q134. What happens when you press Ctrl + S while working on a document in computer system?

Q135. A user wants to have a bulleted list in MS PowerPoint. After typing a list item and pressing Enter, they want to create a sub-bullet point (a lower-level bullet). Which of the following actions will reliably achieve this?

Q136. Which keyboard shortcut opens File Explorer in Windows 11 OS to navigate and create files/folders?

Q137. Which of the following best describes the underlying data structure that forms the basis of an electronic spreadsheet like MS Excel?

Q138. Which keyboard shortcut is used to quickly save a workbook in MS-Excel 365?

Q139. Which of the following statements accurately describes the behavior of continuing numbering from a previous list when inserting a new numbered list within the same document in MS Word?

Q140. Which keyboard shortcut is used to make the selected text bold in MS Word 365?

Q141. In MS Word 365, which feature allows users to customise the appearance of bulleted lists by selecting different bullet styles or symbols and modifying their size and color?

Q142. What does setting a Page Break in MS Excel 365 allow you to control?

Q143. What happens when you use the Format Painter tool in MS Word?

Q144. What is the standard method to save your work in PowerPoint?

Q145. Which function key can be used with Alt to close the current application in Windows applications?

Q146. Which keyboard shortcut opens the Print dialog box in MS Excel 365?

Q147. If you want to save a workbook in MS Excel 365 so that only viewing is allowed and editing is restricted, which feature should you use?

Q148. Which method CANNOT be used to create a new slide in MS PowerPoint 365?

Q149. Which of the following is the correct way to add a new slide in an MS-PowerPoint 2019 presentation?

Q150. You have applied a specific character style to several instances of a product name throughout a lengthy MS Word document. If you need to change the font and color of all these instances, what is the most efficient method?

Q151. Which tab in MS Word 365 contains options to change page margins, orientation and size?

Q152. Which of the following best describes the 'Gutter' margin in MS Word 2019?

Q153. When working with text wrapping around an image in MS Word, which 'Layout Option' provides the most flexibility in precisely positioning the image relative to the text and other elements, ignoring the text flow?

Q154. If you move text using 'Cut and Paste', where does the text go before being pasted in MS Office?

Q155. What happens if you paste text into MS-PowerPoint 2019 with the Keep Source Formatting option?

Q156. What is the shortcut to open an MS PowerPoint file directly from the application?

Q157. What is the primary function of Alt + Tab in most modern operating systems?

Q158. Which of the following shortcut keys can be used to quickly open a presentation in PowerPoint?

Q159. Which of the following methods is the quickest way to open an existing MS Excel spreadsheet?

Q160. Which of the following elements is NOT inherently part of a basic 'Blank Presentation' upon its initial creation in MS PowerPoint?

Q161. In MS PowerPoint 2019, which of the following tabs must you first select to access the 'Open' option for loading a saved PowerPoint file?

Q162. In MS Word, which feature allows users to set the margins of a document, affecting the space between the text and the edges of the page?

Q163. In MS Word, which command allows users to duplicate a selected block of text and place the copy at a different location within the same document or another document?

Q164. In MS Word 365, what is the shortcut to remove manual character formatting from selected text?

Q165. What is the purpose of pressing Alt + Tab on the keyboard of a computer system?

Q166. Which keyboard shortcut permanently deletes a file without sending it to the Recycle Bin in Windows OS?

Q167. Which keyboard shortcut is used to save an MS Excel workbook?

Q168. Which of the following is the correct way to start a new blank presentation in MS PowerPoint?

Q169. When using the 'Replace' function (Ctrl + H) in MS PowerPoint, which of the following options allows users to replace only whole words and not parts of words?

Q170. How do you add text to a slide in MS PowerPoint?

Q171. Which of the following elements, when poorly implemented, is most likely to undermine the credibility and impact of an otherwise well-researched MS PowerPoint presentation?

Q172. Which one is NOT the method to search for and replace text in Microsoft Word?

Q173. What is the difference between dragging text with the mouse (left-click) and Ctrl + dragging text in MS Word 365?

Q174. When navigating through options in a dialog box or menu using the keyboard, what is the primary function of the Tab key?

Q175. What is the purpose of the Slide Master in MS PowerPoint?

Q176. What happens if you try to open a MS PowerPoint presentation created in a newer version (e.g., MS PowerPoint 2021) in an older version (e.g., MS PowerPoint 2010)?

More Computer chapters