Microsoft Office MCQ Quiz - Objective Question with Answer for Microsoft Office - Download Free PDF

The correct answer is Quick Access Toolbar

Key PointsQuick Access Toolbar -

• Positioned just above the Ribbon, the Quick Access Toolbar in MS-PowerPoint 2016 provides commands you are likely to use frequently. It's customizable and by default, it includes commands such as Save, Undo, and Redo. It remains constant no matter which tab/menu in the Ribbon you are currently accessing.

​

Additional Information

Status Bar - Located at the bottom of the PowerPoint window, the status bar displays information about the current presentation such as the number of slides, slide number being viewed, theme, etc. It can also have view buttons and a zoom slider.

Title Bar - This is the uppermost part of the application window where the name of your presentation is displayed. It also contains buttons to close, minimize, or maximize the window.

Scroll Bar - It's situated on the right and sometimes bottom side of the PowerPoint window, the scroll bar allows you to navigate through your slides or if zoomed in, throughout different parts of a single slide, by clicking and dragging the scroll bar or clicking the arrows at its end.

The correct answer is i - True, ii - False

Key Points

• Statement i: This is true. MS-Word 365 allows you to insert tables, images, and charts into a document.
• Statement ii: This is false. The 'Find and Replace' feature in MS-Word 365 is used to search for specific text and replace it with another text, but it does not automatically correct misspelled words. The spelling and grammar check feature is used for identifying and correcting spelling errors.

So, the statements are: i - True ii - False

The correct answer is Bottom Right.

Key Points

• In Microsoft Word, the zoom controller is a tool that allows users to adjust the zoom level of the document they are viewing.
• The zoom controller is located in the bottom right corner of the MS Word screen.
• This tool helps users to zoom in for a closer view or zoom out for a broader view of their document.

Additional Information

• Top Right: This area typically contains the window control buttons (minimize, maximize, and close) and may also contain the ribbon display options in MS Word.
• Bottom Left: This area generally contains the status bar which shows information like the page number, word count, etc., but not the zoom controller.
• Top Left: This area usually has the Quick Access Toolbar and the File tab, but not the zoom controller.

The correct answer is Themes.

Key Points

•  Themes:- The overall appearance of your document is determined by a theme, which is a combination of colors, fonts, and effects.

Additional Information

• Page setup:- The user-defined settings for a page's setup govern how a printed page will look.
• Page background:- When using Word, select the "Design" option from the Ribbon to alter the page backdrop. Then select "Page Color" from the drop-down menu in the button group for "Page Background."

The correct answer is Format Painter.

Key Points

Format painter: 

• The Format Painter is a tool in Word and PowerPoint that lets you copy some formatting from one object and apply it to another one.
• Think of it as copying and pasting for formatting.

Important Points

• Auto Correct:​​
  • This feature can automatically correct common misspelled words, finish a short phrase into a full sentence, or even pop up a full form of an abbreviation.
  • This option will not only correct the spellings of the words but also autocorrect the capitalization of the first word after a full stop.
  • Click File > Options > Proofing > Auto Correct ​
• Mail Merge:
  • It consists of combining mail, letters, and addressed envelopes or mailing labels for mass mailings from a form letter.
  • This feature is usually employed in a word processing document that contains fixed text and variables.
  • Mail Merge is a useful tool that allows you to produce multiple letters, labels, and envelopes.

The correct answer is CTRL + N.

Key Points

• Create a new document with Ctrl+N. 

Additional Information

• Basic computer shortcut keys
  • Ctrl + M -- Indent the paragraph.
  • Ctrl + B -- Bold highlighted selection.
  • Ctrl + D -- Font options.
  • Alt + F--File menu options in the current program.
  • Alt + E--Edits options in the current program.
  • F1--Universal help (for any sort of program).
  • Ctrl + A--Selects all text.
  • Ctrl + X--Cuts the selected item.
  • Ctrl + Del--Cut selected item.
  • Ctrl + C--Copy the selected item.
  • Ctrl + Ins-- Copy the selected item.
  • Ctrl + V--Paste the selected item.
  • Shift + Ins -- Paste the selected item.
  • Home -- Takes the user to the beginning of the current line.
  • Ctrl + Home--Go to the beginning of the document.
  • End -- Go to the end of the current line.
  • Ctrl + End -- Go to the end of a document.
  • Shift + Home -- Highlight from the current position to the beginning of the line.
  • Shift + End -- Highlight from the current position to the end of the line.
  • Ctrl + (Left arrow) -- Move one word to the left at a time.
  • Ctrl + (Right arrow) -- Move one word to the right at a time.

The correct answer is Shift + Space.

• Short-cut key to Select entire row in M.S. Excel Worksheet is Shift + Space.

Key Points

• This table lists the most frequently used shortcuts in Excel.

The correct answer is Ctrl + F2.

• Ctrl + F2 function key displays the Print Preview window in Microsoft Office.

Key Points

• Print Preview function lets users see the pages that are about to print and allows the users to see exactly how the pages will look when they are printed.
• This feature allows you to see exactly how your pages will look when they are printed.
• We can print directly from the Print Preview page by clicking on the print button  or printer icon .

Additional Information

The correct answer is the Title bar.

Key Points

• Microsoft Excel consists of basic components like an Active cell, title bar Column headings, a Formula bar, a Name box, a mouse pointer, Row headings, Sheet tabs, a Taskbar, Tab scrolling buttons, and Toolbars.
• The title bar displays both the name of the application and the name of the spreadsheet.​

Additional Information

• A toolbar is just a collection of icons that provides a shortcut to using a drop-down menu.
• A quick access toolbar shows the options that are frequently used.
  • The user can add favorite options by adding new options to the quick access toolbar.
• The Menu Bar at the top of the screen gives access to different commands that are used for tasks such as opening and closing files, printing documents, formatting data, and other operations.

​

The correct answer is Text.

• The 'LEN' function in MS-Excel belongs to text.

Key Points

• LEN function in excel is taken from the length and is used to count the number of characters is there in a cell.
• It considers special characters, spaces and alphabets and counts all these values if there is a selected cell.
• LEN function only counts the character length for only one cell.
• Example to use LEN function:

​   

Additional Information

• Financial functions in EXCEL are FV Function, IPMT, XIRR in Excel, PMT Function, IRR Excel Function, RATE Function, NPV Function, etc.
• Logical functions in EXCEL are AND Function, NOT, OR Excel Function, TRUE Function, IFERROR Excel Function, Excel XOR Function and Excel Lo
• Math functions in EXCEL are EVEN Excel Function, SUM Function, POWER Function, SUMIF and LOG Excel Function.

The correct answer is Moves the cursor to the beginning of the document.

Key Points

•  Ctrl + Home is a shortcut key used in MS Word to move the cursor to the beginning of the document.

Additional Information

Shortcuts in MS Word

The correct answer is Bullets and Numbering.

• Bullets and Numbering feature of MS Word help to create a list in a document.

Key Points

• Bullets and Numbering are used to create a list in documents in MS word.
• To create a list in MS Word:
  • Select the text required to format as a list.
  • Click on the Bullets or Numbering drop-down option on the Home tab.
  • Select the bullet or numbering style required, and it will appear in the document.

Additional Information

• Word wrap is a word processing feature that automatically transfers a word that has no insufficient space from the end of one line of text to the beginning of the next.
• Scaling in MS Word is another text effect to make the text larger or smaller.
• WordArt is used to create decorative effects to the text styles

The correct answer is Ctrl + click on a sentence to select it.

• Triple-click (Ctrl + click) on a sentence to select it is used to select a sentence in a paragraph in MS Word.

Mistake Points

• Double click can only select a single word but Ctrl+Click on a statement can select complete statement. Hence option 3 is correct and 4 is incorrect.

Key PointsShortcut in MS word for selection:

• To select the current word, double-click on it.
• To select the current paragraph, triple-click on the paragraph.
• To select a sentence and not just a line, hold down [Ctrl] and click once in any place within the sentence.
• To select a vertical block of text, click at the start of the block. Later, hold down the [Shift] key and click a second time at the opposite end of the block. This trick is used when only want to copy one column of a tabular list

Approach (to find the difference in the shortcut)

These can be easily understood if you do it practically on MS word as it has very minute differences which you need to see while performing and reading each point. 

The correct answer is Ctrl + M.

Key Points

The keyboard shortcut to add a new slide to your MS PowerPoint presentation is Ctrl + M.

Keyboard shortcuts for creating PowerPoint presentations

An MS Excel worksheet contains rows 1,048,576 rows and 16,384 columns to store the text and numbers and merged into a single workbook knows as a File. ​Workbooks are the Excel files that one can open and share, while Excel worksheets are individual spreadsheets within them. Function Key Shortcuts:

• F2: Edit Cells
• F4: Anchor Cells
• F7: Spell Check
• F11: Generates a bar graph from the values entered
• F12: Save As
• SHIFT + F2: Insert a Comment
• SHIFT + F8: Add to Selection
• SHIFT + F10: Right Click
• SHIFT+F11:  Insert a new worksheet
• CTRL +F2: Switch to Print Preview
• CTRL + F3: Name a Cell
• CTRL+F9 Minimize the workbook window
• CTRL +N :Create a new workbook
• CTRL +W :Close a workbook
• Windows Flag + D: Minimize Programs
• ALT+N: Open the Insert tab
• ALT+H: Go to the Home tab