Bank Exams Exam  >  Bank Exams Tests  >  Computer Awareness for Competitive Exams  >  MCQ Test: MS Office - 2 - Bank Exams MCQ

MCQ Test: MS Office - 2 - Bank Exams MCQ


Test Description

20 Questions MCQ Test Computer Awareness for Competitive Exams - MCQ Test: MS Office - 2

MCQ Test: MS Office - 2 for Bank Exams 2024 is part of Computer Awareness for Competitive Exams preparation. The MCQ Test: MS Office - 2 questions and answers have been prepared according to the Bank Exams exam syllabus.The MCQ Test: MS Office - 2 MCQs are made for Bank Exams 2024 Exam. Find important definitions, questions, notes, meanings, examples, exercises, MCQs and online tests for MCQ Test: MS Office - 2 below.
Solutions of MCQ Test: MS Office - 2 questions in English are available as part of our Computer Awareness for Competitive Exams for Bank Exams & MCQ Test: MS Office - 2 solutions in Hindi for Computer Awareness for Competitive Exams course. Download more important topics, notes, lectures and mock test series for Bank Exams Exam by signing up for free. Attempt MCQ Test: MS Office - 2 | 20 questions in 20 minutes | Mock test for Bank Exams preparation | Free important questions MCQ to study Computer Awareness for Competitive Exams for Bank Exams Exam | Download free PDF with solutions
MCQ Test: MS Office - 2 - Question 1

Which MS Office application is commonly used for email management and communication?

Detailed Solution for MCQ Test: MS Office - 2 - Question 1

Microsoft Outlook is commonly used for email management and communication. It is an email client that integrates with various email services and allows users to send, receive, and organize emails efficiently.

MCQ Test: MS Office - 2 - Question 2

Which MS Office application is used for creating diagrams, flowcharts, and visual representations of information?

Detailed Solution for MCQ Test: MS Office - 2 - Question 2

Microsoft Visio is used for creating diagrams, flowcharts, and visual representations of information. It provides a wide range of shapes, connectors, and tools to create professional-looking visualizations for various purposes.

1 Crore+ students have signed up on EduRev. Have you? Download the App
MCQ Test: MS Office - 2 - Question 3

Which feature in Microsoft Word allows you to automatically adjust the width of a table column to fit its contents?

Detailed Solution for MCQ Test: MS Office - 2 - Question 3

The AutoFit feature in Microsoft Word allows you to automatically adjust the width of a table column to fit its contents. This feature ensures that the table looks visually appealing and that all the data within the column is displayed without being cut off or wrapped to multiple lines.

MCQ Test: MS Office - 2 - Question 4

In Microsoft Excel, which function allows you to return the largest value from a selected range of cells?

Detailed Solution for MCQ Test: MS Office - 2 - Question 4

The MAX function in Microsoft Excel allows you to return the largest value from a selected range of cells. It is commonly used in data analysis to find the maximum value within a dataset.

MCQ Test: MS Office - 2 - Question 5

Which of the following is a chart type available in Microsoft Excel that displays data points as slices of a circle?

Detailed Solution for MCQ Test: MS Office - 2 - Question 5

A pie chart is a chart type available in Microsoft Excel that displays data points as slices of a circle. It is useful for illustrating the proportionate distribution of data categories or percentages.

MCQ Test: MS Office - 2 - Question 6

Which feature in Microsoft PowerPoint allows you to rehearse timings for slide transitions and animations in a presentation?

Detailed Solution for MCQ Test: MS Office - 2 - Question 6

The Rehearse Timings feature in Microsoft PowerPoint allows you to practice and set timings for slide transitions and animations in a presentation. It helps you ensure that your presentation flows smoothly and is synchronized with your delivery.

MCQ Test: MS Office - 2 - Question 7

In Microsoft Word, which option allows you to customize the appearance and layout of a document by applying predefined combinations of fonts, colors, and effects?

Detailed Solution for MCQ Test: MS Office - 2 - Question 7

Themes in Microsoft Word allow you to customize the appearance and layout of a document by applying predefined combinations of fonts, colors, and effects. They provide a quick and consistent way to change the overall look of your document.

MCQ Test: MS Office - 2 - Question 8

Which MS Office application is commonly used for creating and managing budgets, financial records, and tracking expenses?

Detailed Solution for MCQ Test: MS Office - 2 - Question 8

Microsoft Excel is commonly used for creating and managing budgets, financial records, and tracking expenses. It offers powerful spreadsheet capabilities that enable users to perform calculations, analyze data, and create detailed financial models.

MCQ Test: MS Office - 2 - Question 9

Which feature in Microsoft Outlook allows you to categorize and prioritize your emails based on color-coded labels?

Detailed Solution for MCQ Test: MS Office - 2 - Question 9

The Categories feature in Microsoft Outlook allows you to categorize and prioritize your emails based on color-coded labels. By assigning categories to emails, you can easily identify and manage messages related to specific topics or projects.

MCQ Test: MS Office - 2 - Question 10

Which of the following is a database management system developed by Microsoft that is part of the MS Office Suite?

Detailed Solution for MCQ Test: MS Office - 2 - Question 10

Microsoft Access is a database management system developed by Microsoft that is part of the MS Office Suite. It provides a user-friendly interface to create and manage databases, build forms and reports, and perform data analysis.

MCQ Test: MS Office - 2 - Question 11

Which MS Office application is commonly used for collaborative document editing, allowing multiple users to work on a document simultaneously?

Detailed Solution for MCQ Test: MS Office - 2 - Question 11

Microsoft SharePoint is commonly used for collaborative document editing, allowing multiple users to work on a document simultaneously. It provides features such as version control, document sharing, and real-time co-authoring.

MCQ Test: MS Office - 2 - Question 12

In Microsoft Excel, which function allows you to calculate the future value of an investment based on a series of periodic payments and a constant interest rate?

Detailed Solution for MCQ Test: MS Office - 2 - Question 12

The FV (Future Value) function in Microsoft Excel allows you to calculate the future value of an investment based on a series of periodic payments and a constant interest rate. It is commonly used in financial analysis and planning.

MCQ Test: MS Office - 2 - Question 13

What action is performed by pressing Ctrl + E in MS Word?

Detailed Solution for MCQ Test: MS Office - 2 - Question 13

Pressing Ctrl + E in MS Word aligns the selected text or the current paragraph to the center of the page or text box. It is a formatting command used to modify the alignment of text within a document.

MCQ Test: MS Office - 2 - Question 14

Setting fonts for the text in your document is an example of:

Detailed Solution for MCQ Test: MS Office - 2 - Question 14

Setting fonts for the text in a document involves changing the appearance of the text, which is an example of formatting. Formatting refers to the visual styling of the content in a document, including aspects such as font type, size, color, style, and alignment.

MCQ Test: MS Office - 2 - Question 15

Which among the following is the shortcut key combination to copy formatting from text?

Detailed Solution for MCQ Test: MS Office - 2 - Question 15

Pressing Ctrl + Shift + C in MS Word allows you to copy the formatting from selected text or an object. After copying the formatting, you can then apply it to other text or objects using the paste formatting shortcut (Ctrl + Shift + V) or the Format Painter tool.

MCQ Test: MS Office - 2 - Question 16

Which of the following is a saving process?

Detailed Solution for MCQ Test: MS Office - 2 - Question 16

Saving a document refers to the process of copying the document from the computer's memory (RAM) to a storage medium, such as a hard drive, solid-state drive, or external storage device. This action ensures that the document is retained for future use and can be accessed even after closing the document or turning off the computer.

MCQ Test: MS Office - 2 - Question 17

Which PowerPoint view displays each slide of the presentation as a thumbnail and is useful for rearranging slides?

Detailed Solution for MCQ Test: MS Office - 2 - Question 17

In Slide Sorter view, PowerPoint displays a thumbnail preview of each slide in the presentation. This view provides an overview of the entire presentation and allows you to easily rearrange the slides by dragging and dropping them into the desired order. It is a convenient view to manage the sequence and flow of your presentation.

MCQ Test: MS Office - 2 - Question 18

Workbook is a collection of __________ in MS Excel?

Detailed Solution for MCQ Test: MS Office - 2 - Question 18

In MS Excel, a workbook is a collection of worksheets. A worksheet is a grid-based workspace where you can enter, organize, and analyze data. By default, a new workbook in Excel contains a single worksheet, but you can add or delete worksheets as needed to organize and structure your data efficiently. Each worksheet within a workbook has its own grid of cells and can be customized with data, formulas, formatting, and various other features.

MCQ Test: MS Office - 2 - Question 19

In Power Point, the Header & Footer button can be found on the Insert tab in what group?

Detailed Solution for MCQ Test: MS Office - 2 - Question 19

In PowerPoint, the Header & Footer button is used to add headers and footers to slides. It allows you to include information such as slide numbers, date and time, and additional text on your slides. This button is located in the Text group on the Insert tab, providing easy access to modify the header and footer settings for your presentation.

MCQ Test: MS Office - 2 - Question 20

Which feature helps to search the text through reference material such as dictionaries, encyclopedias and translation services?

Detailed Solution for MCQ Test: MS Office - 2 - Question 20

The Research feature in applications like MS Word allows users to search for information and references directly from within the application. It provides access to various online resources, including dictionaries, encyclopedias, and translation services. By using the Research feature, users can quickly look up definitions, find synonyms, access research articles, and gather relevant information to enhance their document or presentation.

31 videos|51 docs|82 tests
Information about MCQ Test: MS Office - 2 Page
In this test you can find the Exam questions for MCQ Test: MS Office - 2 solved & explained in the simplest way possible. Besides giving Questions and answers for MCQ Test: MS Office - 2, EduRev gives you an ample number of Online tests for practice

Up next

Download as PDF

Up next