MS | MCQs

Explanation

In Excel, the term "filter" refers to temporarily hiding certain data based on specific criteria.

This helps in focusing on specific subsets of data without deleting or altering the original dataset.

Explanation

The small squares arranged in rows and columns in Excel are called cells.

Each cell is the intersection of a row and a column and can hold data.

Explanation

The Excel feature that allows you to freeze rows and columns so they remain visible while scrolling is Freeze Panes.

This feature enhances navigation by keeping important headings in view.

Explanation

In MS Excel, a selected cell is indicated by a wide bold line around the cell.

Explanation

If you need to collect numerical data from different sources and perform computations on it,

you would typically use spreadsheet software like Microsoft Excel or Google Sheets.

These tools are specifically designed for organizing, analyzing, and manipulating numerical data. 

Explanation

Word fields are special codes in Microsoft Word that act as placeholders for data that can change (like footnotes, endnotes, indexes).

These fields update automatically.

They are used to manage references and formatting efficiently.

Explanation

Multilevel lists combine numbers, letters, and symbols to create a hierarchical structure.

They are often used for outlines, legal documents, and technical writing.

Explanation

Key Points

• Bold, Italic, and Regular are collectively referred to as Font Styles.
• Font styles allow for different visual representations of text, enhancing readability and emphasis.
• These styles are commonly used in word processing and design software to modify the appearance of text.

Additional Information

• Font Effects - 
  • Font effects like underline, strikethrough, and shadow add extra emphasis or decoration to text.
  • These effects are used to highlight or distinguish text without changing its fundamental style.
• ​Font Sizes - 
  • Font sizes determine the size of the text on a page.
  • Commonly measured in points (pt), the size affects readability and layout.
• Text Effects - 
  • Text effects include various visual enhancements like glow, reflection, and 3D effects.
  • These are typically used in graphic design to make text stand out.

Explanation

Explanation