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

Explanation

• The SUM function adds all numerical values in a specified range.
• =SUM(A1:A5) adds the values in cells A1, A2, A3, A4, and A5.

Additional information:

• SUM — Calculates total
• AVERAGE — Calculates average
• MAX — Finds maximum value
• MIN — Finds minimum value
• COUNT — Counts numerical cells

Last verified on 24-08-2026

Explanation

• In MS Excel, the asterisk (*) is used as the multiplication operator.
• To multiply the values in C1 and D1, use the formula =C1*D1.

Additional information:

• / — Division
• ^ — Exponentiation

Last verified on 24-08-2026

Explanation

• In MS Word, pictures can be inserted through the Insert tab/menu.
• The Pictures option is available under the Insert tab.
• You can insert pictures from your device or other available sources.
• Clip Art was available in older versions of Microsoft Office.

Last verified on 24-06-2026

Explanation

• To add the values in A1 and A2, enter =A1+A2.
• In Excel, the plus (+) operator is used to add values from cells.
• Excel calculates the result automatically.
• The SUM function can also be used: =SUM(A1,A2).

Last verified on 24-08-2026

Explanation

• To add a new row, right-click the row number where you want the new row.
• Select Insert from the context menu.
• Excel inserts a new row above the selected row.
• You can also use Home → Insert → Insert Sheet Rows.

Last verified on 24-08-2026

Explanation

• Excel's Fill Handle recognizes common series such as months.
• When Jan is entered and the Fill Handle is dragged, Excel automatically continues the series.
• The resulting cells will contain Jan, Feb, Mar, Apr, ...
• This feature saves time when creating sequential data.

Last verified on 24-08-2026