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

Explanation

• To adjust a column width to fit its contents in Excel, you can:
• Double-click the boundary to the right of the column heading.
• This action automatically resizes the column width to match the longest entry in that column.
• This ensuring that all data is visible without manually adjusting the width.

Last verified on 10-08-2026

Explanation

• =SUM(A1:A10) is the formula used to calculate the sum of cells A1 through A10.
• The SUM function adds values in a specified range of cells.
• It is one of the most commonly used spreadsheet functions.
• The colon (:) indicates a continuous range of cells.
• It works in spreadsheet software like Excel and Google Sheets.

Last verified on 08-06-2026

Explanation

• The thin black cross-shaped pointer in MS Excel is used to complete lists and fill patterns.
• It is known as the Fill Handle.
• The Fill Handle appears at the bottom-right corner of the selected cell.
• Dragging it can automatically fill adjacent cells with data, formulas, numbers, dates, or patterns.
• It can extend sequences such as 1, 2, 3, 4... or Monday, Tuesday, Wednesday...
• It saves time by automatically completing repetitive data.

Last verified on 10-08-2026

Explanation

• Data, sort is used for arranging data in ascending/descending order in MS Excel.
• Sort A to Z to perform an ascending sort (A to Z or smallest number to largest).
• Sort Z to A to perform a descending sort (Z to A or largest number to smallest).

Last verified on 10-08-2026

Explanation

• Spreadsheet software is used for calculations and data organization.
• MS Excel is a widely used spreadsheet program.
• It works with rows, columns, and formulas.

Last verified on 11-04-2026

Explanation

• MS Excel allows data to be sorted in both Ascending and Descending order.
• Ascending order: Smallest to largest, A to Z, or oldest to newest.
• Descending order: Largest to smallest, Z to A, or newest to oldest.
• Excel can sort numbers, text, dates, and other data types.
• The Sort command is available under the Data tab in Excel.

Last verified on 09-08-2026

Explanation

• A Workbook is a collection of related worksheets in spreadsheet software such as MS Excel.
• A workbook can contain multiple worksheets, each with rows and columns.
• A worksheet is an individual spreadsheet page within a workbook.
• For example, a workbook may contain separate worksheets for Sales, Expenses, and Profit.

Last verified on 09-08-2026