Explore topic-wise MCQs in Microsoft Certification.

This section includes 37 Mcqs, each offering curated multiple-choice questions to sharpen your Microsoft Certification knowledge and support exam preparation. Choose a topic below to get started.

1.

Microsoft Office Accounting is

A. A tool for managing business finances
B. Project management software to keep track of events and to create network charts and Gantt charts
C. Diagram and flowcharting software
D. None of these
Answer» B. Project management software to keep track of events and to create network charts and Gantt charts
Discussion
2.

Microsoft Office is an office suite, for the

A. Microsoft Windows operating systems
B. Mac OS X operating systems
C. Both A and B are true
D. None is true
Answer» D. None is true
Discussion
3.

A competitor to the dominant Lotus 1-2-3 is

A. Microsoft Excel
B. Microsoft Word
C. Microsoft PowerPoint
D. None of these
Answer» B. Microsoft Word
Discussion
4.

The word processor in MS office suite is

A. Microsoft Word
B. Microsoft Excel
C. Microsoft PowerPoint
D. None of these
Answer» B. Microsoft Excel
Discussion
5.

It is software for creating newsletters, busi-ness cards, flyers, greeting cards or post- cards.

A. Microsoft Publisher
B. Microsoft PowerPoint
C. Microsoft Access
D. None of these
Answer» B. Microsoft PowerPoint
Discussion
6.

Microsoft Project is

A. A WYSIWYG HTML editor and web de- sign program for customizing Share Point applications, it replaces Microsoft Office FrontPage
B. Project management software to keep track of events and to create network charts and Gantt charts
C. Diagram and flowcharting software
D. None of these
Answer» C. Diagram and flowcharting software
Discussion
7.

Microsoft Office Picture Manager is

A. Basic photo management software
B. An application that supports editing scanned documents
C. A scanning and OCR application
D. None of these
Answer» B. An application that supports editing scanned documents
Discussion
8.

The very first version of Microsoft Office was released for

A. Windows operating system
B. Apple Macintosh OS
C. Unix
D. None of these
Answer» C. Unix
Discussion
9.

Microsoft Word is a word processor that saves in its proprietary————format.

A. .doc
B. .pdf
C. .txt
D. None of these
Answer» B. .pdf
Discussion
10.

For Database management one uses

A. Microsoft Access
B. Microsoft PowerPoint
C. Microsoft Access
D. None of these
Answer» B. Microsoft PowerPoint
Discussion
11.

Microsoft Office is

A. Desktop applications
B. Operating system
C. Command window
D. None of these
Answer» B. Operating system
Discussion
12.

Microsoft Word, Microsoft Excel, and Microsoft PowerPoint are the part of

A. Microsoft Office Suite
B. Microsoft Windows
C. Mac OS X
D. None of these
Answer» B. Microsoft Windows
Discussion
13.

A popular presentation program for Windows and Mac in Microsoft Office is

A. Microsoft Word
B. Microsoft PowerPoint
C. Microsoft Access
D. None of these
Answer» C. Microsoft Access
Discussion
14.

To create slideshows, composed of text, graphics, movies and other objects, which can be displayed on-screen and navigated through by the presenter or printed out on transparencies or slides one uses

A. Microsoft Word
B. Microsoft PowerPoint
C. Microsoft Access
D. None of these
Answer» C. Microsoft Access
Discussion
15.

The first version of MS Office to be released for the Microsoft Windows operating system is

A. Microsoft Office 3.0
B. Microsoft Office 2003
C. Microsoft Office 2007
D. Microsoft Office XP
Answer» B. Microsoft Office 2003
Discussion
16.

Microsoft Office SharePoint Designer is used for

A. A WYSIWYG HTML editor and web de- sign program for customizing SharePoint applications, it replaces Microsoft Office FrontPage
B. Project management software to keep track of events and to create network charts and Gantt charts
C. Diagram and flowcharting software
D. None of these
Answer» B. Project management software to keep track of events and to create network charts and Gantt charts
Discussion
17.

Microsoft Office Communicator is

A. Integrated communications client for conferences and meetings in real time
B. Project management software to keep track of events and to create network charts and Gantt charts
C. Diagram and flowcharting software
D. None of these
Answer» B. Project management software to keep track of events and to create network charts and Gantt charts
Discussion
18.

Microsoft Office Document Scanning is

A. An application that supports editing scanned documents
B. A scanning and OCR application
C. Diagram and flowcharting software
D. None of these
Answer» C. Diagram and flowcharting software
Discussion
19.

It is a Note-taking software for use with tab- let PCs or regular PCs.

A. Microsoft OneNote
B. Microsoft PowerPoint
C. Microsoft Access
D. None of these
Answer» B. Microsoft PowerPoint
Discussion
20.

Microsoft Office Document Imaging is

A. An application that supports editing scanned documents
B. A scanning and OCR application
C. Diagram and flowcharting software
D. None of these
Answer» B. A scanning and OCR application
Discussion
21.

Microsoft Office Suite spreadsheet programis

A. Microsoft Excel
B. Microsoft Word
C. Microsoft Powerpoint
D. None of these
Answer» B. Microsoft Word
Discussion
22.

Microsoft Office Groove is

A. A proprietary peer-to-peer software pack- age aimed at businesses
B. An application that supports editing scanned documents
C. A scanning and OCR application
D. Diagram and flowcharting software
Answer» C. A scanning and OCR application
Discussion
23.

Microsoft Office InterConnect is

A. Business-relationship database
B. An application that supports editing scanned documents
C. A scanning and OCR application
D. None of these
Answer» B. An application that supports editing scanned documents
Discussion
24.

A personal information manager and e-mail communication software in MS Office is

A. Microsoft Outlook
B. Microsoft Word
C. Microsoft PowerPoint
D. None of these
Answer» B. Microsoft Word
Discussion
25.

Microsoft Visio is a

A. A WYSIWYG HTML editor and web de- sign program for customizing SharePoint applications, it replaces Microsoft Office FrontPage
B. Project management software to keep track of events and to create network charts and Gantt charts
C. Diagram and flowcharting software
D. None of these
Answer» D. None of these
Discussion
26.

You use Visual Studio .NET to create an assembly, called XYZAssembly, that will be used by other applications, including a standard COM client application._x005F_x000D_ You must deploy your assembly on the COM application to a client computer. You must ensure that the COM application can instantiate components within the assembly as COM components._x005F_x000D_ What should you do?

A. Create a strong name of the assembly by using the Strong Name tool (Sn.exe).
B. Generate a type library for the assembly by using the Type Library Importer (Tlbimp.exe). Register the file on the client computer.
C. Generate a registry file for the assembly by using the Assembly Registration tool (Regasm.exe) Register the file on the client computer.
D. Deploy the assembly to the global assembly cache on the client computer. Add a reference to the assembly in the COM client application.
Answer» D. Deploy the assembly to the global assembly cache on the client computer. Add a reference to the assembly in the COM client application.
Discussion
27.

You work as software developer at XYZ inc. You need to develop a Windows form that provides online help for users. You want the help functionality to be available when users press the F1 key._x005F_x000D_  _x005F_x000D_ Help text will be displayed in a pop-up window for the text box that has focus._x005F_x000D_  _x005F_x000D_ To implement this functionality, you need to call a method of the HelpProvider control and pass the text box and the help text._x005F_x000D_  _x005F_x000D_ What should you do?_x005F_x000D_

A. SetShowHelp
B. SetHelpString
C. SetHelpKeyword
D. ToString
Answer» C. SetHelpKeyword
Discussion
28.

You use Visual Studio .NET to create a Windows-based application. The application includes a form named XYZProcedures (EXP). EXP allows users to enter very lengthy text into a database. When users click the Print button located on EXP, this text must be printed by the default printer._x005F_x000D_  _x005F_x000D_ You implement the printing functionality by using the native .NET System Class Libraries with all default settings._x005F_x000D_  _x005F_x000D_ Users report that only the first page of the text is being printed._x005F_x000D_ How should you correct this problem?

A. In the BeginPrint event, set the HasMorePages property of the PrintEventArgs object to True.
B. In the EndPrint event, set the HasMorePages property of the PrintEventArgs object to True.
C. In the PrintPage event, set the HasMorePages property of the PrintPageEventArgs object to True.
D. In the QueryPageSettings event, set the HasMorePages property of the QueryPageSettingEventArgs object to True.
Answer» D. In the QueryPageSettings event, set the HasMorePages property of the QueryPageSettingEventArgs object to True.
Discussion
29.

You develop an inventory management application called XYZManagement that will call a Microsoft SQL Server stored procedure named sp_GetDailyXYZSales. The stored procedure will run a query that returns your daily sales total as an output parameter. This total will be displayed to users in a message box._x005F_x000D_ Your application uses a SqlCommand object to run sp_GetDailyXYZSales. You write thefollowing code to call sp_GetDailyXYZSales:SqlConnection cnn = new SqlConnection(myConnString);SqlCommand cmd = new SqlCommand(“sp_GetDaily XYZ Sales”, cnn);cmd.CommandType = CommandType.StoredProcedure;SqlParameter prm = cmd.Parameters.Add(“@ItemTotal”,SqlDbType.Int);prm.Direction = ParameterDirection.Output;cnn.Open();cmd.ExecuteNonQuery();_x005F_x000D_ Now you must write additional code to access the output parameter. Which code segment should you use?

A. MessageBox.Show(?Total is: ? + cmd.Parameters[?@Output?].Value.ToString());
B. MessageBox.Show(?Total is: ? + cmd.Parameters[?@Output?].ToString());
C. MessageBox.Show(?Total is: ? + cmd.Parameters[?@ItemTotal?
D. MessageBox.Show(?Total is: ? + cmd.Parameters[?@ItemTotal?
Answer» D. MessageBox.Show(?Total is: ? + cmd.Parameters[?@ItemTotal?
Discussion
30.

You develop an enterprise application, called XYZApplication that includes a Windows Form presentation layer, middle-tier components for business logic and data access, and a Microsoft SQL Server database._x005F_x000D_ You are in the process of creating a middle-tier component that will execute the data access routines in your application. When data is passed to this component, the component will call several SQL Server stored procedures to perform database updates. All of these procedure calls run under the control of a single transaction._x005F_x000D_ The code for the middle-tier component will implement the following objects:SqlConnection cn = new SqlConnection();SqlTransaction tr;_x005F_x000D_ If two users try to update the same data concurrently, inconsistencies such as phantom reads will occur. You must now add code to your component to specify the highest possible level of protection against such inconsistencies.Which code segment should you use?

A. tr = cn.BeginTransaction(?ReadCommitted?);
B. tr = cn.BeginTransaction(IsolationLevel.ReadCommitted);
C. tr = cn.BeginTransaction(IsolationLevel.Serializable);
D. tr = cn.BeginTransaction(?Serializable?);
Answer» D. tr = cn.BeginTransaction(?Serializable?);
Discussion
31.

You responsible for maintaining an application that was written by a former colleague at XYZ._x005F_x000D_  _x005F_x000D_ The application reads from and writes to log files located on the local network. The original author included the following debugging code to facilitate maintenance:_x005F_x000D_ try {Debug.WriteLine(“Inside Try”);throw(new IOException());}catch (IOException e) {Debug.WriteLine (“IOException Caught”);}catch (Exception e) {Debug.WriteLine(“Exception Caught”);}.finally {Debug.WriteLine (“Inside Finally”);}Debug.WriteLine (“After End Try”);_x005F_x000D_  _x005F_x000D_ Which output is produced by thus code?

A. Inside Try Exception Caught IOException Caught Inside Finally After End Try
B. Inside Try Exception Caught Inside Finally After End Try
C. Inside Try IOException Caught Inside Finally After End Try
D. Inside Try IOException Caught Inside Finally
Answer» D. Inside Try IOException Caught Inside Finally
Discussion
32.

You develop a Windows-based application that enables to enter product sales. You add a subroutine named XYZ._x005F_x000D_  _x005F_x000D_ You discover that XYZ sometimes raises an IOException during execution. To address this problem you create two additional subroutines named LogError and CleanUp. These subroutines are governed by the following rules:_x005F_x000D_ • LogError must be called only when XYZ raises an exception.• CleanUp must be called whenever XYZ is complete._x005F_x000D_  _x005F_x000D_  You must ensure that your application adheres to these rules. Which code segment should you use?

A. try { XYZ(); LogError(); } catch (Exception e) { CleanUp(e); }
B. try { XYZ(); } catch (Exception e) { LogError(e); CleanUp(); }
C. try { XYZ(); } catch (Exception e) { LogError(e); } finally { CleanUp(); }
D. try { XYZ(); } catch (Exception e) { CleanUp(e); } finally { LogError(); }
Answer» D. try { XYZ(); } catch (Exception e) { CleanUp(e); } finally { LogError(); }
Discussion
33.

You create an assembly by using Visual Studio .NET. The assembly is responsible for writing and reading order entry information to and from an XML data file. The assembly also writes and reads values to and from the Windows registry while it is being consumed._x005F_x000D_  _x005F_x000D_ The assembly will be distributed to client computers by using your company, XYZ, intranet. All client computers are configured to implement the default .NET security policy._x005F_x000D_  _x005F_x000D_ You need to implement security in the assembly. What should you do?

A. Implement declarative security and execute the permission demand to allow access to the file system and Windows registry.
B. Implement declarative security and execute the minimum permission request to allow access to the file system and Windows registry.
C. Implement imperative security and execute the permission demand to allow access to the file system and Windows registry.
D. Implement imperative security and execute the minimum permission request to allow access to the file system and Windows registry.
Answer» C. Implement imperative security and execute the permission demand to allow access to the file system and Windows registry.
Discussion
34.

Paint programs keep track of every __________ placed on the screen.

A. Object
B. Image
C. Color
D. Pixel
Answer» E.
Discussion
35.

Programs from the same developer, sold bundled together, that provide better integration and share common features, toolbars and menus are known as_________ ?

A. integrated software packages
B. personal information managers
C. software processing packages
D. software suites
Answer» E.
Discussion
36.

You are a developer for a XYZ Inc that provides free software over the Internet. You are developing en e-mail application that users all over the world can download._x005F_x000D_  _x005F_x000D_ The application displays text strings in the user interface. At run time, these text strings must appear in the language that is appropriate to the locale setting of the computer running the application._x005F_x000D_  _x005F_x000D_ You have resources to develop versions of the application for only four different cultures.You must ensure that your application will also be usable by people of other cultures.How should you prepare the application for deployment?

A. Package a different assembly for each culture.
B. Package a different executable file for each culture.
C. Package a main assembly for source code and the default culture. Package satellite assemblies for the other cultures.
D. Package a main assembly for source code. Package satellite assemblies for each culture.
Answer» D. Package a main assembly for source code. Package satellite assemblies for each culture.
Discussion
37.

Both Joyel and Susy share a Windows 10 tablet with different user accounts. Joyel needs to access some files in Susy’s Documents folder. How can he do this ?

A. Joyel can access the files only if he has administrative rights
B. Susy must choose to make the Documents folder Public for Joyel to see them
C. Joyel can, by default, see and access the files in any Documents folder on this computer
D. Joyel cannot access those files without Susy moving them to another folder
Answer» B. Susy must choose to make the Documents folder Public for Joyel to see them
Discussion