Explanation

• In MS Excel 2016, a Line Chart displays data points connected by lines.
• It is ideal for showing trends, patterns, or changes over time.
• Multiple data series can be plotted on the same line chart for comparison.

Explanation

• In MS Excel 2016, a Column Chart displays data as vertical bars.
• It is especially useful for comparing values across categories clearly.
• Column charts make it easy to visualize differences and trends at a glance.

Last verified on 10-03-2026

Explanation

• In MS Word 2016, the Home Tab contains tools for text formatting and editing.
• Common options include Font, Font Color, and Styles.
• Columns is found under the Layout Tab, not Home Tab.

Last verified on 10-03-2026

Explanation

• In MS Word 2016, page margins define the space between the text and the edge of the page.
• Common margin types are: Top, Bottom, Left, Right.
• “Center” is not a page margin type.

Last verified on 10-03-2026

Explanation

• A hardcopy output device produces physical copies of data or information.
  • Printer converts digital documents into paper copies.
  • Examples: Plotter, Photocopier, Fax machine, Braille printer

Additional information:

Softcopy vs Hardcopy:

• Softcopy: Screen display, audio (Monitor, Speaker)
• Hardcopy: Physical form (Paper, Card, etc.)

Printers can be inkjet, laser, or dot-matrix.

Last verified on 09-03-2026

Explanation

In Microsoft PowerPoint 2016, a slide-title master pair consists of a specific

Slide Master (which controls the default layout, fonts, and colors for all slides)

Title Master (which specifically defines the layout for the presentation's title slide).

Last updated 15-feb-2026

Explanation

• AVERAGEIF calculates the average of cells that meet a specific condition.
• Formula: =AVERAGEIF(range, criteria, [average_range])
• Useful for conditional averaging in large datasets.

Last verified on 08-03-2026

Explanation

• Landscape is a page orientation, not a paper size.
• Common paper sizes in MS-Word 2016 include: Letter, Legal, Executive, A4, A3.

Additional information:

• Legal: 8.5 × 14 inches
• Executive: 7.25 × 10.5 inches
• A3: 297 × 420 mm
• Letter: 8.5 × 11 inches
• A4: 210 × 297 mm

Last verified on 08-03-2026

Explanation

• MS Excel 2016 can perform calculations using formulas like SUM, subtraction, multiplication, and division.
• However, a formula referring to a non-existent range or name will produce an error.

Additional information:

• =SUM(Sales)-A3: ❌ Produces an error if ‘Sales’ is not a defined range or named range.
• *=SUM(A1:A5)0.5: ✅ Multiplies the sum of A1:A5 by 0.5.
• =SUM(A1:A5)/(10-10): ✅ Produces #DIV/0! error (division by zero) but Excel can calculate it.
• =SUM(A1:A5)-10: ✅ Subtracts 10 from the sum of A1:A5.

Last verified on 07-03-2026

Explanation

• The MOD function in Excel returns the remainder after division of one number by another.
  • Syntax: =MOD(Number, Divisor)
  • Example: =MOD(10, 3) → Result = 1 (10 ÷ 3 leaves remainder 1)

Last verified on 07-03-2026