Microsoft Office questions and answers

Microsoft Office Questions and Answers

A basic knowledge of Microsoft Office applications such as MS Word, MS Excel and MS PowerPoint is often required for most jobs. Practise and prepare for your aptitude test with these frequently asked MS Office questions and answers.

96.

Which of the following is the default page setup orientation of slide in PowerPoint?

A.

Vertical

B.

Landscape

C.

Portrait

D.

None of above

Correct answer is B

No explanation has been provided for this answer.

97.

Which of the following can be an example of a database in Access?

A.

Address book of all the suppliers of a company

B.

Salary sheet of all the employees of a company

C.

Records of daily sales transactions of a company

D.

All of above

Correct answer is D

A database is a structured collection of data that is organized and stored in a way that allows for efficient retrieval, management, and manipulation of the data. It can include various types of information and can serve different purposes. All of the provided options are examples of databases:

Option A: An address book containing the contact details of all the suppliers of a company can be considered a database. It stores structured information about suppliers, allowing easy access and management of their contact information.
Option B: A salary sheet containing the salary details of all employees of a company is also an example of a database. It stores data related to employee salaries, which can be organized and manipulated for payroll processing and analysis.
Option C: The records of daily sales transactions of a company represent a database as well. This type of database stores information about sales transactions, which can be used for tracking sales performance and generating reports.
Option D: All of the above options are valid examples of databases. They each involve storing structured data for specific purposes, making them organized collections of information that can be queried, updated, and managed efficiently.

Therefore, the correct option is Option D: All of above.

98.

Want a PowerPoint photo album slide show to play continuously?

A.

Use random slide transitions

B.

Launch an online broadcast

C.

Loop continuously

D.

All of the above

Correct answer is C

Slide Show>Set Up Slide Show and check Loop Continuously Until Esc

99.

To sort records in a table

A.

Open the table, click on the field on which the sorting is to be done, then click Sort button on database toolbar

B.

Open the table, click Sort button on database toolbar, choose field based on which to sort, click OK

C.

Click the field heading to sort it ascending or descending

D.

All of above

Correct answer is D

You can sort records in a table in Microsoft Access using different methods. All of the provided options are valid ways to achieve sorting:

Option A: Open the table, click on the field on which you want to perform sorting, and then click the Sort button on the database toolbar. This method allows you to sort the table based on the selected field in ascending order.
Option B: Open the table and click the Sort button on the database toolbar. A dialog will appear where you can choose the field based on which you want to sort. After selecting the field, click OK to apply the sorting. This method provides you with more control over the sorting options.
Option C: Clicking on the field heading allows you to sort the data in ascending order by default. Clicking the same field heading again will change the sorting to descending order.
Option D: All of the above options are valid ways to sort records in a table. Depending on your preference and the complexity of the sorting criteria, you can choose the most suitable method.

Therefore, the correct option is Option D: All of above.

100.

Which of the following method can insert a new slide in current presentation?

A.

Right click on the Slide panel and choose New Slide

B.

From Insert menu choose New Slide

C.

Click on New Slide button on toolbar

D.

All of above

Correct answer is D

No explanation has been provided for this answer.