MS | MCQs

Explanation

In older versions of Excel (up to 2003), a worksheet contains 256 columns.

Newer versions have expanded this limit to 16,384 columns.

A single worksheet in Excel contains 65,536 rows.

Explanation

When we open a new workbook in MS Excel, the Title bar appears on the topmost portion of the screen.

It displays the name of the open document.

Explanation

In the Data ribbon of Microsoft Excel, the feature "PivotTable" cannot be found.

The PivotTable feature is located in the Insert ribbon.

The Data ribbon includes features such as What-If Analysis, Data Validation, and Text to Columns.

Explanation

Mail merge allows the insertion of personalized data (like names, addresses) into a template document, creating customized copies for each recipient.

It's commonly used for generating mass communications, such as letters or labels, based on data from a source like a spreadsheet or database.

Explanation

To password-protect a Microsoft Word document, follow these steps:

1. Go to the "File" menu
2. Click on "Info"
3. Click on "Protect Document"
4. Select "Encrypt with Password"
5. Enter a strong password and confirm it
6. Click "OK"

This will encrypt the document and require a password to open it.

You can also use the "File > Save As" method and select "Password" in the "Save As" dialog box, but the "File > Info > Protect Document" method provides more security options.

Explanation

In MS Word, font positioning options include:

• Normal (also known as "Baseline")
• Superscript (raised above the baseline)
• Subscript (lowered below the baseline)
• Raised (a specific amount above the baseline)

However, "Centered" is not a font positioning option in MS Word.

Text can be aligned center, but that's a paragraph alignment option, not a font positioning option.

Explanation

In MS Word, formatting like margins is not required in a Text Box.

A Text Box is a standalone container that allows you to enter text, and its margins are not affected by the page margins.

You can set individual margins for a Text Box, but they are not necessary.

In a Text Box, you can set individual formatting options, such as:

• Border
• Fill color
• Text alignment
• Font styles
• Size

Explanation

The Home tab is the default tab in Microsoft Word.

It has five groups of related commands; Clipboard, Font, Paragraph, Styles and Editing.

It helps you change document settings like font size, adding bullets, adjusting styles and many other common features.

Explanation

Calibri is a popular sans-serif typeface font designed by Lucas de Groot and commissioned by Microsoft.

It has been the default font in Microsoft Office since 2007.

It is widely used in various documents, presentations, and publications.

Explanation

The numeric key is considered a primary key on the keyboard.

It is used for direct input of numbers.

It often includes a separate numeric keypad for efficient numerical entry.