Explanation

• Pressing F11 instantly creates a chart from the selected data on a separate chart sheet.
• First, select the data range, then press F11 to generate the default chart.

Additional information:

• F1 → Open Help
• F2 → Edit the active cell
• F4 → Repeat the last action / Toggle absolute references in formulas
• Alt + F1 → Create a chart embedded in the current worksheet

Last verified on 23-07-2026

Explanation

• The 'Rehearse Timings' option is available in the Slide Show tab of PowerPoint 2016.
• It allows users to practice a presentation and automatically records the time spent on each slide.

Common PowerPoint Tabs:

• Home
• Insert
• Design
• Slide Show
• Review

Last verified on 23-07-2026

Explanation

• The default page orientation in MS Word is Portrait.
• Portrait orientation means the page height is greater than its width.
• This orientation is commonly used for documents, letters, and reports.

Additional information:

• Page orientation can be changed from Layout → Orientation.
• Landscape mode is mainly used for tables and wide content.

Last verified on 17-01-2026

Explanation

• CTRL + H is the shortcut key used in most software (like MS Word, Excel) to open the Find and Replace dialog box.
• It allows users to search for a word or phrase and replace it with another.

Additional information:

• CTRL + F: Only opens the Find dialog
• CTRL + G: Opens the Go To dialog
• CTRL + R: Aligns text to the right in word processors

Last verified on 10-06-2026

Explanation

• The correct formula to add values in Excel is =SUM(A1:A2).
• The SUM function adds numbers from the selected cell range.
• Excel formulas always begin with the =` (equal) sign.
• A1:A2 means all cells from A1 to A2.

Last verified on 14-07-2026