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.
Which of the following is the default page setup orientation of slide in PowerPoint?
Vertical
Landscape
Portrait
None of above
Correct answer is B
No explanation has been provided for this answer.
Which of the following can be an example of a database in Access?
Address book of all the suppliers of a company
Salary sheet of all the employees of a company
Records of daily sales transactions of a company
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.
Want a PowerPoint photo album slide show to play continuously?
Use random slide transitions
Launch an online broadcast
Loop continuously
All of the above
Correct answer is C
Slide Show>Set Up Slide Show and check Loop Continuously Until Esc
Open the table, click on the field on which the sorting is to be done, then click Sort button on database toolbar
Open the table, click Sort button on database toolbar, choose field based on which to sort, click OK
Click the field heading to sort it ascending or descending
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.
Which of the following method can insert a new slide in current presentation?
Right click on the Slide panel and choose New Slide
From Insert menu choose New Slide
Click on New Slide button on toolbar
All of above
Correct answer is D
No explanation has been provided for this answer.