Explanation

• The Excel SORT function has 4 arguments in its full syntax.
• Syntax: SORT(array, [sort_index], [sort_order], [by_col])
• Only the array argument is required.
• The other three arguments are optional.

Last verified on 25-08-2026

Explanation

• Ctrl + 1 opens the Format Cells dialog box in MS Excel.
• It provides options for Number, Alignment, Font, Border, Fill, and Protection.
• It is a useful shortcut for quickly formatting selected cells.

Additional information:

• Ctrl + 5 — Strikethrough
• Ctrl + 6 — Show/Hide objects
• Ctrl + F10 — Maximize/restore active window

Last verified on 25-08-2026

Explanation

• A word processor is software used to create, edit, format, and print text documents.
• Common uses include typing letters, reports, applications, and other documents.
• Examples include Microsoft Word, Google Docs, and LibreOffice Writer.

Last verified on 25-08-2026

Explanation

• .pptx is the standard file format for saving a Microsoft PowerPoint presentation.
• It is the default presentation format in modern versions of PowerPoint.
• The X in .pptx indicates the XML-based Office Open XML format.

Last verified on 24-08-2026

Explanation

• An animation scheme is a predefined set of visual effects applied to text or objects on PowerPoint slides.
• It controls how text or objects appear, move, or disappear.

Additional information:

• Transitions are effects used when moving from one slide to another.
• Layout determines the arrangement of content placeholders on a slide.

Last verified on 24-08-2026

Explanation

• The slide that is used to introduce a topic and set the tone for the presentation is called Title Slide.
• The title slide is the first slide of a presentation.
• It usually contains a title and a subtitle.

Last verified on 24-08-2026

Explanation

• In MS PowerPoint, Ctrl + Home takes you to the first slide of the presentation.
• It is useful when working with a presentation containing many slides.
• Ctrl + End takes you to the last slide.
• These shortcuts help navigate quickly through a presentation.

Additional information:

• Page Up — Previous slide
• Page Down — Next slide
• Home — Go to first slide during Slide Show

Last verified on 24-08-2026

Explanation

• In MS Excel, double-clicking a chart object opens the chart for editing.
• You can then modify its data, design, layout, titles, and formatting.
• A single click generally selects the chart.
• Clicking and dragging is mainly used to move the chart.

Last verified on 24-08-2026

Explanation

• CAD Chart is not a standard MS Excel chart type.
• Bar Chart is a standard Excel chart type.
• Waterfall Chart is also available in modern versions of Excel.
• Scatter Chart is a standard Excel chart type.

Last verified on 24-08-2026

Explanation

• AVERAGE is the built-in Excel function used to calculate the arithmetic mean.
• It adds the values and divides their sum by the number of values.
• Example: =AVERAGE(A1:A5) calculates the average of cells A1 through A5.

Last verified on 24-08-2026