Question 1

Which menu option in MS PowerPoint is used to insert shapes, images, and text boxes into a slide?

Accepted Answer

The Insert Menu contains options to add shapes, images, text boxes, tables, and other objects to slides.

Question 2

Which of the following is the primary purpose of MS Access?

Accepted Answer

MS Access is a database management system designed to store, organize, and retrieve data in tables using relationships.

Question 3

In MS PowerPoint, what is the primary purpose of the 'Slide Master' view?

Accepted Answer

Slide Master allows you to define templates and apply uniform formatting across all slides in a presentation.

Question 4

In MS Excel, what does the cell reference 'C5' represent?

Accepted Answer

Cell references in Excel follow the format Column Letter + Row Number, so C5 means Column C, Row 5.

Question 5

What is the default number of slides created when you open a new blank presentation in MS PowerPoint?

Accepted Answer

A new blank PowerPoint presentation typically opens with a single title slide by default.

Question 6

What is the keyboard shortcut to start a PowerPoint presentation from the current slide?

Accepted Answer

Shift + F5 starts a slideshow from the currently selected slide, while F5 starts from the first slide.

Question 7

How many columns are available in a standard MS Excel worksheet?

Accepted Answer

MS Excel (2007 onwards) supports 16,384 columns (A to XFD) and 1,048,576 rows per worksheet.

Question 8

What is the purpose of the AutoSum feature in MS Excel?

Accepted Answer

AutoSum automatically detects and inserts a SUM formula for the selected range of numeric cells.

Question 9

Which function in MS Excel is used to find the total sum of a range of cells?

Accepted Answer

The SUM function calculates the sum of numeric values in a specified range of cells.

Question 10

Which feature in MS Word allows you to automatically generate a list of topics and page numbers?

Accepted Answer

The Table of Contents feature in MS Word automatically creates a list of headings with page numbers based on heading styles used in the document.

Question 11

What is the default line spacing in a new MS Word document?

Accepted Answer

The default line spacing in MS Word is 1.15 lines, which is slightly more than single spacing for improved readability.

Question 12

Which file format is the standard default format for saving a PowerPoint presentation?

Accepted Answer

.pptx is the default Microsoft PowerPoint 2007 and later file format for presentations.

Question 13

Which keyboard shortcut is used to save a document in MS Word?

Accepted Answer

Ctrl+S is the standard keyboard shortcut to save any open document in MS Word.

Question 14

In MS PowerPoint, which feature allows you to add animated transitions between slides during a presentation?

Accepted Answer

The Transitions tab in PowerPoint is used to add slide transition effects and control their timing.

Question 15

What is the default file extension for a MS Word 2007 and later document?

Accepted Answer

.docx is the default file format for MS Word documents from version 2007 onwards, replacing the older .doc format.

Question 16

What is the default file extension for a workbook saved in MS Excel 2016 or later?

Accepted Answer

.xlsx is the standard XML-based format for Excel workbooks in modern versions (2007 onwards).

Question 17

Which tab in MS Word contains the font formatting options like bold, italic, and underline?

Accepted Answer

The Home tab in MS Word ribbon contains all text formatting options including bold, italic, underline, and font selection.

Question 18

Which keyboard shortcut is used to save a file in MS Excel?

Accepted Answer

Ctrl + S is the standard shortcut to save an open document in MS Excel and most applications.

Question 19

How do you insert a page break in MS Word?

Accepted Answer

Pressing Ctrl+Enter inserts a page break at the cursor position in MS Word, moving content to the next page.

Question 20

In MS Access, what is a 'Table'?

Accepted Answer

A table in MS Access is the basic data storage unit with rows representing records and columns representing fields.

Agniveer Army Clerk SKT MS Office Questions

MS Office Practice Questions — Graded Difficulty