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

• The SUM function in MS Excel is used to add numbers from selected cells or ranges (e.g., =SUM(A1:A5)).
• It is one of the most commonly used functions for quick total calculations in spreadsheets.

Last verified on 26-05-2026

Explanation

To calculate the average in Excel, you can use the AVERAGE function: 

• Formula =AVERAGE(number1, [number2], …) 
• Arguments: Number1 is required, and Number2 is optional 
• Example =AVERAGE(A1:A20) returns the average of the numbers in the range A1:A20

Last verified on 10-08-2026

Explanation

• The COUNT function counts the number of cells containing numbers.
• Example: =COUNT(A1:A10) counts numeric entries in cells A1 through A10.

Additional information:

• COUNTA: Counts non-empty cells.
• COUNTBLANK: Counts blank cells.
• SUM: Adds numbers.
• AVERAGE: Calculates the average of numbers

Last verified on 10-08-2026

Explanation

• The =NOW() function in MS Excel returns the current date and time.
• It is updated automatically whenever the worksheet is opened or calculations are performed.

Additional information:

• =TODAY() - returns the current date (without time)
• =YEAR() - returns the year from a given date
• =MONTH() - returns the month from a given date
• =DAY() - returns the day from a given date
• =HOUR() - returns the hour from a given time
• =MINUTE() - returns the minute from a given time
• =SECOND() - returns the second from a given time

Last verified on 10-08-2026

Explanation

• The “Pivot Table” tool primarily allows users to summarize and analyze data.
• It can group, sort, filter, and calculate data.
• Common calculations include Sum, Count, Average, Maximum, and Minimum.
• Pivot Tables help identify patterns, comparisons, and trends in data.

Last verified on 10-08-2026