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

Explanation

• Freeze Panes is available under the View tab in MS Excel.
• It keeps selected rows or columns visible while scrolling through a worksheet.
• It is especially useful for large worksheets with headings.
• You can freeze the top row, first column, or selected rows/columns.

Last verified on 24-08-2026

Explanation

• In MS Excel, numbers are right-aligned automatically by default.
• Text is generally left-aligned automatically.
• Right alignment makes numerical values easier to compare and calculate.
• Users can change the alignment using the Alignment options.

Last verified on 24-08-2026

Explanation

• In MS Excel, hold the Ctrl key while selecting cells to select multiple nonadjacent cells or ranges.
• This allows you to select separate cells without selecting the cells between them.

Additional information:

• Shift is generally used to select a continuous range.

Last verified on 24-08-2026

Explanation

• Plagiarism Check is not traditionally considered a standard built-in proofing tool.
• Spelling and Grammar, Thesaurus, and Word Count are standard tools available in MS Word.
• Microsoft Word provides various tools to improve the accuracy and quality of documents.

Last verified on 24-08-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

• In MS Word, Spelling and Grammar is used to check spelling and grammatical errors.
• The option is available under the Review tab.
• Word can identify misspelled words and suggest corrections.
• In newer versions, the feature may appear as Editor.

Last verified on 24-08-2026

Explanation

• In MS Word, Header and Footer options are found in the Insert tab.
• Headers appear at the top of the page, while footers appear at the bottom.
• They are used for page numbers, dates, titles, and document information.
• This feature helps in professional document formatting.

Last verified on 29-05-2026

Explanation

• Landscape orientation is wider than Portrait orientation.
• It is best suited for tables, charts, graphs, and wide documents.
• In Landscape, the page is wider horizontally than vertically.
• Portrait is the standard vertical page orientation.

Last verified on 24-08-2026