Get Started

MS Office Questions and Answers

8 months ago 1.5K Views

Welcome to the Mastering the Versatile Microsoft Office blog! This Microsoft Office Questions and Answers blog is designed to be your friendly guide, offering clear and concise answers to your burning MS Office questions. Whether you're a seasoned professional or a complete beginner, we'll tackle a wide range of topics, from the fundamentals to advanced functionalities. So, get ready to explore the depths of Word, Excel, PowerPoint, Outlook, and more! We'll equip you with the knowledge and skills to navigate these powerful tools with confidence and unlock their full potential. Let's embark on this learning journey together!

MS Office Questions and Answers

In this article MS Office Questions and Answers, we are sharing the latest and most important MS Office Questions and Answers under the Computer GK section for those learners who are preparing for upcoming competitive exams.

Also, Read Latest Current Affairs Questions 2023: Current Affairs Today

"Put your knowledge to the test and excel with our General Knowledge Mock Test and Current Affairs Mock Test!"  

MS Office Questions and Answers

Q :  

In which tab of MS Word 2010 Header and Footer option is available?

(A) Insert Tab

(B) View Tab

(C) Page Layout Tab

(D) Print Layout Tab

Correct Answer : A
Explanation :

Header and Footer options are available in the Insert tab of MS Word 2010. On the Insert tab, the Header and Footer options are found in the Headers and Footer group.


Q :  

Ink-jet printers or band printers are classified as –

(A) Character Printers

(B) Ink Printers

(C) Line Printers

(D) Off-Band Printers

Correct Answer : A
Explanation :

Ink-jet printers or band printers are classified based on the printing method.


Q :  

Mail merge is a component of which of the following?

(A) MS Word

(B) MS Excel

(C) Word Press

(D) MS Access

Correct Answer : A
Explanation :

Mail merge is a feature in Microsoft Word that allows you to create personalized documents, such as letters, envelopes, or labels, by combining a main document (containing generic content) with a data source (such as an Excel spreadsheet or a database) that contains specific information for individual recipients. This feature is commonly used for creating mass mailings or personalized communication materials.


Q :  

what is the default chart type in Microsoft excel?

(A) pie chart

(B) line chart

(C) surface chart

(D) column chart

Correct Answer : D
Explanation :

In Microsoft Excel, the default chart type for most data is the "Column Chart." When you create a new chart in Excel without specifying a specific type, it usually starts with a column chart where data points are represented as vertical bars. Of course, you can change the chart type later based on your preferences and the type of data you want to visualize.


Q :  

By using which tab can you add page numbers in an MS-Word 2019 document? 

(A) edit

(B) format

(C) insert

(D) Home

Correct Answer : C
Explanation :

In Microsoft Word 2019, you can add page numbers to your document by using the "Insert" tab. The "Insert" tab contains various options, including the "Page Number" option, which allows you to insert page numbers at different locations in your document.


Q :  

What is the key combination to move down one paragraph in MS PowerPoint? 

(A) down arrow

(B) shift+down arrow

(C) ctrl+down arrow

(D) Alt+Down Arrow

Correct Answer : C
Explanation :

Actually, in MS PowerPoint (and most other word processing applications), the key combination to move down one paragraph is "Enter". Pressing the "Enter" key moves the cursor to the next paragraph. If you want to move the cursor down one line within the same paragraph, you can use the "Down Arrow" key. There isn't a specific default key combination to move down one paragraph in PowerPoint; it's more about using the "Enter" key to start a new paragraph.


Q :  

The number of rows in Excel 2003 is ______.

(A) 65535

(B) 65536

(C) 65534

(D) 65533

Correct Answer : B
Explanation :

In Excel 2003, the number of rows is 65,536. Each worksheet in Excel 2003 consists of 65,536 rows and 256 columns.


Q :  

Modification of the work done in a cell is called-

(A) Editing

(B) range

(C) fixing

(D) none of the above

Correct Answer : B
Explanation :

Actually, the modification of the work done in a cell in Excel is typically referred to as "editing" the cell, not "range." Editing a cell means changing or modifying the data or formula within that specific cell. A "range" in Excel refers to a group of two or more cells on a worksheet. When you edit a cell, you are making changes to the content of that particular cell.


Q :  

The extension of MS Excel's workbook or file is-

(A) .DOC

(B) .XLX

(C) .XLC

(D) .XLSX

Correct Answer : D

Q :  

what is the key combination to open the 'Save As' dialog box in MS PowerPoint? 

(A) F12.

(B) Alt+F then D

(C) Alt+F then E

(D) Alt+F then O

Correct Answer : A
Explanation :

In MS PowerPoint, the key combination to open the 'Save As' dialog box is F12. Pressing F12 opens the 'Save As' dialog box directly, allowing you to save the current presentation with a new name or in a different location.


Related categories

Very important related articles. Read now

The Most Comprehensive Exam Preparation Platform

Get the Examsbook Prep App Today