Explanation

IMSUM() function in Excel is used to add two or more complex numbers.

Syntax:

IMSUM(number1, [number2], …)

Example:

=IMSUM("3+4i","1+2i")→"4+6i"

It handles complex numbers in the form a+bi or a+bj in Excel.

Last updated 15-feb-2026

Explanation

{VLOOKUP} (Vertical Lookup) in Excel searches for a specific value in the leftmost column of a table and returns a corresponding value from another column in the same row

Last updated 15-feb-2026

Explanation

Explanation

• The value '01-01-2020 11:30' includes both date and time.
• The Date & Time datatype is best suited to store and manipulate such information in databases or spreadsheets.

Last verified on 10-02-2026

Explanation

• Microsoft Excel is Microsoft's spreadsheet program that can be used to organize, format, and calculate data.
• Microsoft Excel is a spreadsheet application used for calculations, charts, and data analysis

Last verified on 10-02-2026

Explanation

• In MS Excel, a single page where data is entered is called a worksheet.
• Multiple worksheets make up an Excel workbook.
• Worksheets contain cells arranged in rows and columns for data entry and calculations.

Last verified on 09-02-2026

Explanation

The AutoSum feature, activated by clicking the Sigma AutoSum button on the Home/Formulas tab or pressing Alt + =,

It is the fastest way to automatically total a column or row in Excel.

It uses the SUM function to intelligently select and sum adjacent numerical data. 

All important questions about " MS EXCEL"

Microsoft Excel is a spreadsheet application launched in 1985 by the Microsoft Corporation.

MS-Excel uses the _____ function when creating a data table.

spreadsheet

****

Which of the following functions in Microsoft Excel is used to count items in a cell range?

Count

***

MS Excel's function arguments are always written in----------?

Parenthesis

***

In MS Excel, which function automatically totals a column or row of values?

SUM

****

Columns in MS Excel are called?

Fields

***

Constant value in excel also called?

Number

***

Ctrl +D in MS Excel?

Fill down in the selection

***

Ctrl+R is used in Excel too?

Fill the selection with active cells to the right

***

MOD () function is used in MS Excel to get

Remainder

****

ND30-4-2023

Explanation

• Short key use for Date and Time 
• Date: Ctrl+;
• Time: Ctrl+ Shift+ ;

Additional information

shortcut key in  MS Excell:

Which key is used to help in MS Excel?

F1

***

Shift+Backspace

**

Which key is used to enter the current date in Excel?

 Ctrl+;

Explanation

In spreadsheets or programming, a function is a pre-defined formula that calculates values in a specific order.

Functions simplify calculations by automating repetitive tasks.

They are used in Excel, Google Sheets, and programming languages.

Additional information:

• Examples of functions: SUM(), AVERAGE(), MAX() in Excel.
• Pre-defined formulas save time and reduce errors compared to manual calculations.

Last verified on 16-01-2026

Explanation

A pie chart is best suited for showing the proportion of parts to a whole.

As it visually represents data as slices of a circle.

It highlighting the relative sizes of components.