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

The correct option is (2)

countif

Key Points

• Excel's COUNTIF function keeps track of how many cells in a range satisfy a given condition.
• Use the COUNTA function to count only cells in a range that contain values.
• When you count cells, sometimes you want to ignore any blank cells because only cells with values are meaningful to you.
• An Excel statistical function is the COUNT Function[1]. This function aids in counting both the number of parameters and the number of cells that contain numbers. Additionally, it counts the elements of any given array.

Additional Information

• Cells that are not empty will be counted using the COUNTA function. Any type of information in the cells is counted.

The correct answer is To view how the document will appear when printed.

Key Points

• Print Preview is a feature that displays on the screen what a hard copy would look like when printed.
  • Press Ctrl + F2 to open the print preview for the document.
  • By using the print preview, you can find any errors that may exist or fix the layout before printing, which can save ink or toner and paper by not having to print more than once.

Additional Information

• To open the print preview feature, click the print preview icon on the toolbar, like that shown in the picture, or click File and choose the Print Preview option.
• Some programs, like newer versions of Microsoft Office applications, show a print preview on the Print page.
• In these cases, there is no Print Preview option in the program's menu.
• Many programs do not have a shortcut key for the print preview feature.
• However, you can press Alt+F to open the file menu and press V, R, or the other underlined character (Mnemonic) for the Print Preview option.
• In programs like Microsoft Word, while in the print preview, you can change the page orientation from Portrait Orientation to Landscape.
• Orientation to view the page in landscape.
• Unfortunately, not all programs support this ability.
• If the program you're using has no settings or options in print preview, you cannot view how your page would print in landscape mode.

The correct answer is To provide assistance in creating documents.

Key Points

• ​The Help feature in Microsoft Word 365 serves several important functions to assist users in navigating the software and resolving issues. Here are 4-5 key points about its purpose:

• Access to Instructions and Guidance: The Help feature provides users with access to detailed instructions on how to use various tools and features within Microsoft Word, making it easier to learn and use the software effectively.

• Searchable Knowledge Base: Users can search for specific topics, keywords, or commands, and the Help feature provides relevant articles, tips, and troubleshooting guides related to their query.

• Contextual Help: It offers context-sensitive help, which means that when you're using a particular feature, the Help feature can suggest assistance specifically related to that task, enhancing efficiency.

• Training and Tutorials: The Help feature includes links to training materials, video tutorials, and other resources, helping both beginners and advanced users to master Word 365.

• Access to Online Support: It provides direct access to Microsoft's online support, where users can contact customer support, report issues, or get help from the community forums.

The correct answer is Microsoft.

• Computer tools such as Word, Excel, and PowerPoint are the products of Microsoft Corporation.
• These tools are collectively known as MS Office.
• MS Office was first announced by Microsoft in 1990.
• The current CEO of Microsoft is Satya Nadela.

Additional Information

CEOs and Headquarters of other companies:

The correct answer is 3.

Key Points

• When a new workbook is created in Microsoft Excel, it typically contains three blank worksheets by default.
• These worksheets are named Sheet1, Sheet2, and Sheet3.
• This default setting can be changed in Excel's options if needed.

Additional Information

In recent versions of Microsoft Excel (starting from Excel 2013), when a new workbook is created, it initially contains 1 blank worksheet by default. However, users can add more worksheets as needed. Earlier versions of Excel (before 2013) used to start with 3 blank worksheets by default.

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. 

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

The correct answer is Top

The default alignment for the paragraph in MS-Word is Left.

• The alignment buttons in the Home tab in the Paragraph section allows us to change the alignment.
  • Left
  • Right
  • Centre
  • Justified
• It also provides the alignment for other objects such as picture, symbol, shapes etc.
• 

Additional Information

Font Formatting:

• Ctrl+D opens the Font dialogue box for character formatting to format font type, style, size, colour etc.
• Ctrl+Shift+F moves directly to the Font type field in this dialogue box.
• Ctrl+Shift+P moves directly to the Font size field in this dialogue box.
• The keyboard commands for font styles are also the same as in previous Office versions:
• Ctrl+B Bold style
• Ctrl+I Italic style
• Ctrl+U Underline
• Ctrl+1 Single line spacing
• Ctrl+2 Double line spacing
• Ctrl+5 1.5 line spacing