Explanation

• A Chart is a feature used in MS Excel for data visualization.
• The same chart can also be inserted in PowerPoint presentations.
• It helps in showing data in graphical form (bar, line, pie, etc.).
• Excel and PowerPoint are both part of MS Office, so they share features.

Last verified on 26-05-2026

Explanation

• In MS PowerPoint, the Footer is used to display information at the bottom of slides.
• It can include slide number, date, and time.
• These elements help in organizing and tracking presentation slides.

Last verified on 26-05-2026

Explanation

• In MS PowerPoint, slide resolution and size settings are controlled from the Design tab.
• You can change slide size (Standard, Widescreen, Custom).
• Resolution affects how clear slides appear on screen or print.
• This option is found under “Slide Size” in Design.

Last verified on 26-05-2026

Explanation

• Start a presentation from the current slide: Shift+F5
• Start a presentation from the beginning: F5

Additional information

• Ctrl + N: Create a new presentation document
• Ctrl + M: Insert a new slide
• Ctrl + S: save a presentation

Last verified on 26-05-2026

Explanation

• Microsoft PowerPoint is used to create presentations.
• These presentations are made of slides.
• Each slide can contain text, images, charts, and videos.
• It is widely used in education and business meetings.

Last verified on 26-05-2026

Explanation

• In MS Excel, logical functions are used for decision-making (TRUE/FALSE).
• AND, OR, NOT are logical functions.
• SUM is a mathematical function used for addition, not logic.
• Therefore, SUM is NOT a logical function.

Last verified on 26-05-2026

Explanation

• VLOOKUP stands for Vertical Lookup.
• It is used to search for a value in the first column of a table.
• It is categorized under Lookup and Reference functions in Excel.

Last verified on 26-05-2026

Explanation

• In MS Excel, naming a cell or range gives it a fixed (absolute) reference.
• This name can be used instead of cell addresses like A1 or B2:B10.
• It makes formulas easier to read and understand.
• Named ranges always refer to the same data location.

Last verified on 26-05-2026

Explanation

• In MS Excel, letters (like B) represent columns, while numbers (like 3) represent rows.
• So, in cell address B3, B is the column number, and 3 is the row number.

Last verified on 26-05-2026

Explanation

• In Excel, a workbook is a file that contains multiple worksheets.
• A single workbook can hold many sheets (like Sheet1, Sheet2, etc.).
• Each worksheet works like an individual page for data.
• This structure helps organize large amounts of data easily.

Last verified on 26-05-2026