Explanation

• Purpose: Prevents text from being hidden in the binding
• Location: Can be added to left or top depending on binding type
• Adjustable in: Layout > Margins > Custom Margins > Gutter

Explanation

• PNG, JPEG, and GIF are image file formats used to store pictures.
• They are widely used in websites, graphics, and digital media.
• Each format has different compression and quality features.
• JPEG is best for photos.
• PNG for high-quality images.
• GIF for animations.

Last verified on 19-04-2026

Explanation

The size of information in the computer is measured in: 

• 1024 kilobytes (KB) is equal to 1 megabyte (MB).
• One Megabyte (MB) = 1024 Kilobytes (KB
• One Gigabyte (GB) =  1024 Megabytes MB
• One Terabyte (TB)= 1024 gigabytes (GB).

Explanation

Line spacing shortcuts:

• Ctrl + 1 → 1.0
• Ctrl + 2 → 2.0
• Ctrl + 5 → 1.5

Last verified on 07-03-2026

Explanation

• AutoContent Wizard helps users create presentations quickly by providing predefined templates and content suggestions.
  • It guides the user through slides, layout, and structure automatically.
  • Useful for beginners or fast preparation of presentations.

Last verified on 06-03-2026

Explanation

• Superscript raises the text slightly above the normal line, often used for exponents, footnotes, or ordinal numbers.
• Shortcut in MS Word: Ctrl + Shift + =
• Example: x² (2 is superscript)

Additional information:

• Subscript: Ctrl + = (text goes below the line)
• Bold: Ctrl + B
• Italic: Ctrl + I
• Underline: Ctrl + U

Last verified on 06-03-2026

Explanation

An Excel workbook is a collection of worksheets 

It can also contain charts, macros, and other data

A workbook is the Excel file itself, typically with an .xlsx extension.

Contents: It holds one or more worksheets (grid-based spreadsheets).

Last updated 15-feb-2026

Explanation

• In Microsoft PowerPoint 2003 and earlier versions, Slide Design and Slide Layout are found in the Format menu.
• PowerPoint 2003 uses a menu-based interface.
• From PowerPoint 2007 onward, Microsoft introduced the Ribbon interface.
• In newer versions, Slide Design is under the Design tab, while Slide Layout is under the Home tab.
• Therefore, Format Menu is the correct answer for PowerPoint 2003 and earlier.

Last verified on 28-07-2026

Explanation

The AutoSum feature, activated by clicking the Sigma AutoSum button on the Home/Formulas tab or pressing Alt + =,

It is the fastest way to automatically total a column or row in Excel.

It uses the SUM function to intelligently select and sum adjacent numerical data. 

All important questions about " MS EXCEL"

Microsoft Excel is a spreadsheet application launched in 1985 by the Microsoft Corporation.

MS-Excel uses the _____ function when creating a data table.

spreadsheet

****

Which of the following functions in Microsoft Excel is used to count items in a cell range?

Count

***

MS Excel's function arguments are always written in----------?

Parenthesis

***

In MS Excel, which function automatically totals a column or row of values?

SUM

****

Columns in MS Excel are called?

Fields

***

Constant value in excel also called?

Number

***

Ctrl +D in MS Excel?

Fill down in the selection

***

Ctrl+R is used in Excel too?

Fill the selection with active cells to the right

***

MOD () function is used in MS Excel to get

Remainder

****

ND30-4-2023

Explanation

The primary key to take a screenshot on Windows is PrtScn (Print Screen)

PrtScn: Captures the full screen to the clipboard.

Windows Key + PrtScn: Saves the full screen automatically to Pictures > Screenshots.