MS Office MCQs

Correct Answer: pptx

.pptx is the default file extension for Microsoft PowerPoint presentations created in modern versions of the software.

Correct Answer: Opens the Clip Art task pane

The correct answer is Opens the Clip Art task pane, as asked in this question on MS Office.

Correct Answer: File

The correct answer is File, as asked in this question on MS Office.

Correct Answer: AutoSave

The correct answer is AutoSave, as asked in this question on MS Office.

Correct Answer: Regular

While Regular is a common font weight/style, terms like 'Super Script' are typically classified as text effects rather than core font styles in many applications.

Correct Answer: Repetitive task automatically

A macro is a sequence of commands or instructions used to automate repetitive tasks.

Correct Answer: Font group on home tab

The font group on the Home tab contains tools to adjust font style, size, and color.

Correct Answer: Page Orientation

Page orientation determines whether a page is set to portrait or landscape mode for viewing and printing.

Correct Answer: Home tab

In Microsoft PowerPoint, the 'New Slide' button is primarily located on the Home tab (and also available via the Insert tab).

Correct Answer: Ctrl+Shift++

In MS Word, the keyboard shortcut Ctrl+Shift++ (Control, Shift, and Plus sign) turns on the superscript format.

Correct Answer: To preview and control the slide show

The Slide Show tab provides tools to set up, start, control, and preview a presentation as the audience will view it.

Correct Answer: Ctrl+S

Ctrl + S is the universal keyboard shortcut to save a document or presentation in most software.

Correct Answer: All of these

The 'Paste Special' dialogue gives you explicit control over whether to paste just formulas, values, formatting, or data validation rules.

Correct Answer: Document view

Microsoft PowerPoint features views like Normal, Slide Sorter, Outline, and Slide Show. 'Document view' is a term typically associated with Word.

Correct Answer: 72

In Microsoft Word, the preset font size drop-down menu goes up to a maximum of 72 points (though you can manually type larger sizes).

Correct Answer: No outline

In MS Office applications, shapes have outlines. Selecting "No Outline" removes the visible border around the object.

Correct Answer: Ctrl+M

Ctrl+M is the universal Microsoft shortcut used to insert a new slide into a PowerPoint presentation.

Correct Answer: Format Painter

Format Painter allows users to copy formatting from one piece of text and apply it to another.

Correct Answer: MS PowerPoint

MS PowerPoint is the component of the Microsoft Office suite specifically designed for creating presentations.

Correct Answer: Macros

Macros are automated sequences of commands and instructions that can be executed to perform repetitive tasks.

Correct Answer: Auto save

AutoSave (or AutoRecover) is a feature that periodically saves a version of your document to prevent data loss.

Correct Answer: Format Painter

The Format Painter tool copies formatting from one part of the document and applies it to another.

Correct Answer: To copy formatting from one place and paste it to another

Format Painter is a productivity tool used to apply the same formatting style to different sections of a document.

Correct Answer: Repeat the last action

In programs like MS Excel, F4 toggles absolute referencing or repeats the user's most recent action.

Correct Answer: ppt

.ppt (or .pptx) is the standard file extension for Microsoft PowerPoint presentations.

Correct Answer: Insert

The 'Insert' tab/menu houses all tools required to place external objects like images, charts, and shapes into a document.

Correct Answer: None of these

To open a file in standard applications, one must access the 'File' menu, which is not listed among the given options.

Correct Answer: Font style

While technically 'Typefaces' or 'Font families', in basic computing terminology (like MS Word exams), they are widely accepted as Font Styles/Faces.

Correct Answer: None of these

In MS PowerPoint, the Header & Footer button is found within the 'Text' group on the Insert tab.

Correct Answer: Space

To prevent Excel from auto-formatting a fraction (like 1/2) into a date, you prefix it with a zero and a space (e.g., '0 1/2').

Correct Answer: View

In MS PowerPoint, the Slide Sorter option, which gives a thumbnail view of all slides, is located under the View tab.

Correct Answer: All of these

During a PowerPoint slideshow, you can advance to the next slide using the enter key, spacebar, or a mouse click.

Correct Answer: 8,72

In the standard MS Word font size dropdown menu, the minimum default value is 8 and the maximum is 72.

Correct Answer: MS PowerPoint

Microsoft PowerPoint is a standard presentation software program used to create slideshows.

Correct Answer: View > Window > Split

In applications like MS Word, splitting a window is done by navigating to the View tab, selecting Window, and then clicking Split.

Correct Answer: All of these

Action buttons are built-in shape buttons in MS PowerPoint that can be programmed to navigate to Home, End, or execute other actions.

Correct Answer: Slide

Individual presentation screens or pages in Microsoft PowerPoint are referred to as slides.

Correct Answer: Double clicking the format painter button

Double-clicking the Format Painter in MS Office locks it on, allowing you to apply formatting to multiple selections.

Correct Answer: 03

In classic versions of MS Excel (like Excel 2003, 2010), new workbooks opened with 3 default worksheets (Sheet1, Sheet2, Sheet3).

Correct Answer: Selection pane

In Office applications, the Selection Pane is used to view a list of all objects (like images or shapes) on the current page or slide.

Correct Answer: MS Excel

Microsoft Excel is the standard software application utilized for creating and managing spreadsheets.

Correct Answer: To automate repetitive tasks

Macros are recorded sequences of commands or keystrokes used to automate frequent, repetitive tasks efficiently.

Correct Answer: None of these

Standard Microsoft PowerPoint usually offers 9 to 11 default slide layouts, not the higher numbers listed.

Correct Answer: All of these

In Microsoft PowerPoint, a user can advance to the next slide by pressing Enter, the Spacebar, or clicking the Mouse.

Correct Answer: Formula Bar

The Formula Bar in Excel displays the data or formula stored in the currently selected active cell.

Correct Answer: With the copy and paste buttons on the standard toolbar

Simply using standard copy and paste buttons does not create a 'link' to the original data (which updates when changed); it merely embeds static data.

Correct Answer: Notes

In standard PowerPoint views, the left panel typically shows the 'Slides' or 'Outline' tabs, while the 'Notes' pane is located at the bottom.

Correct Answer: Insert tab

In MS Office applications like PowerPoint, Header and Footer features are accessed via the Insert tab on the ribbon.

Correct Answer: MS Word

Microsoft Word is a dedicated word processing software used to create text documents.

Correct Answer: Standard Toolbar

The Standard Toolbar contains icons for commonly used functions like saving, opening, or printing documents in classical UI software.

Correct Answer: Save as

The 'Save As' command in Microsoft Word allows users to choose different formats, including PDF, for the output file.

Correct Answer: Text group

In Microsoft PowerPoint, the Header & Footer option is located under the Text group on the Insert tab[cite: 690, 691, 692].

Correct Answer: CTRL+K

The keyboard shortcut to insert a hyperlink in Microsoft Word is CTRL+K[cite: 693, 696].

Correct Answer: Spreadsheet

Microsoft Excel is a premier software application specifically designed for creating and managing spreadsheets[cite: 706, 708].

Correct Answer: To allow page headers and footers to appear on document when it is printed

Headers and footers are explicitly used to ensure consistent information (like page numbers) appears on every printed page[cite: 715, 718].

Correct Answer: 8 and 72

In standard MS Office applications, the default font size drop-down ranges from a minimum of 8 to a maximum of 72[cite: 719, 723].

Correct Answer: Insert -> Chart

In presentation software like PowerPoint, a user can construct and embed visual data charts by selecting the Insert tab and then clicking Chart[cite: 324, 326].

Correct Answer: Notes

By default, the left viewing pane displays thumbnails in 'Slides' or 'Outline' mode, whereas the 'Notes' pane is normally situated below the main slide window[cite: 334, 337].

Correct Answer: All of these

PowerPoint can be initialized via standard GUI menu clicks, or by directly typing its executable filename (powerpnt.exe) into the Windows Run dialog[cite: 340, 348].

Correct Answer: Animations

A slide layout dictates the static positional arrangement of content placeholders (like text, charts, and lists), whereas animations are dynamic effects applied subsequently[cite: 348].

Correct Answer: Equal sign

Microsoft Excel requires every formula and computational function to be prefixed with an equal sign (=) to trigger calculation mechanics[cite: 348].

Correct Answer: Convert your input text to proper case

The PROPER() function in Excel is utilized to capitalize the initial letter of every word in a selected text string, setting the rest to lowercase[cite: 348].

Correct Answer: F5

Pressing the F5 function key in MS PowerPoint automatically initiates the presentation mode starting from the very first slide[cite: 348].

Correct Answer: $

In spreadsheet software, appending a dollar sign ($) before a column letter and row number locks the reference, creating an absolute coordinate[cite: 350].

Correct Answer: Winword.exe

'Winword.exe' is the designated primary executable application file utilized by Windows to boot up the Microsoft Word program[cite: 350].

Correct Answer: Macros

A macro is a recorded sequence of commands and instructions grouped together as a single command to automate repetitive tasks.

Correct Answer: MS Photo Editor

MS Photo Editor was removed from MS Office after Office XP and replaced by Microsoft Office Picture Manager; it is not considered a core standard application.

Correct Answer: Triple

In MS Word, Single, Double, and Multiple are standard named line spacing options, but 'Triple' is not a default named dropdown option.

Correct Answer: Layout Tab

In modern versions of Microsoft Word, Page Orientation (Portrait/Landscape) is adjusted via the 'Layout' or 'Page Layout' tab.

Correct Answer: Page Orientation

Portrait (vertical) and Landscape (horizontal) are the two primary Page Orientations used in document formatting.

Correct Answer: All of these

All these provided methods are historical or valid ways to launch MS PowerPoint in various Windows environments.

Correct Answer: Orientation View

Microsoft PowerPoint features views like Normal View, Slide Sorter View, and Slide Show View. 'Orientation View' is not an actual view setting in the application.

Correct Answer: The word document contains a reference to the original source application

Linking creates a dynamic connection; the destination file (Word) holds a reference to the source file (Excel) rather than a separate copy of the data.

Correct Answer: Open Find and replace Dialog box with activating Go to Tab

The CTRL + G shortcut opens the 'Find and Replace' dialog box and automatically switches to the 'Go To' tab.

Correct Answer: Thesaurus

The Thesaurus tool acts as an integrated dictionary in MS Office, allowing users to find synonyms and antonyms.

Correct Answer: .wav files and .mid files

PowerPoint natively supports embedding various audio files, including wave (.wav) and MIDI (.mid) files for sound effects and music.

Correct Answer: DELETE

Selecting a cell containing a formula and pressing the DELETE key will clear the cell's contents, removing the embedded formula.

Correct Answer: In Line with Text

By default, MS Word places newly inserted images "In Line with Text", treating the image like a large text character.

Correct Answer: All of these

Microsoft PowerPoint allows users to create new files through a blank template, by modifying an existing presentation, or by applying a pre-made design template.

Correct Answer: Formulas

Formulas in Excel are expressions that operate on values in a range of cells or a single cell, computing mathematical outcomes and returning results.

Correct Answer: Value

Excel fundamentally stores dates as sequential serial numbers so they can be used in calculations, classifying them as numeric values rather than mere text.

Correct Answer: A new slide is inserted as third slide in presentation

In presentation software, clicking 'New Slide' inserts a single blank slide immediately following the lowest currently selected slide index.

Correct Answer: Work sheet

An Excel file is a 'Workbook' which is composed of grid-based calculation areas called 'Work sheets'.

Correct Answer: Referencing

Cell referencing is the method used to identify and fetch the value of a cell from another location or worksheet for use in a formula.

Correct Answer: =

An equals sign (=) is required as the first character in an Excel cell to trigger the software's calculation engine.

Correct Answer: Ctrl+M

In MS PowerPoint, Ctrl+M is the dedicated shortcut used to insert a new slide into the current presentation.

Correct Answer: A Spreadsheet Program

MS Excel is a robust spreadsheet program used for data organization, analysis, and mathematical calculations.

Correct Answer: In Line with Text

By default, Microsoft Word treats inserted images as text characters, placing them 'In Line with Text'.

Correct Answer: PowerPoint

Microsoft PowerPoint is a dedicated presentation program used to create slideshows.

Correct Answer: Dialog box

This item is vague as printed in the book and is retained with its printed answer.