 Search:

Interview FAQs

Submit Interview FAQ

How do we define name in Excel? What is the use of defining names?

If you have information stored on one worksheet that you want to use on other sheets, you can create a name that describes the cell or range. A descriptive name in a formula can make it easier to understand the purpose of the formula. For example, th...
Posted By:Shruti Sharma      Posted On: Jan 20

What is a template? Explain the use of template.

You can create a template to use when you want several workbooks or worksheets to have similar formatting and styles, or content and functionality. The spread sheet which can be used as basis for those styles, format or functionality is called templa...
Posted By:Shruti Sharma      Posted On: Jan 20

What is the significance of the fill handle in Excel?

The small black square in the corner of the selection. When you point to the fill handle, the pointer changes to a black cross. To copy contents to adjacent cells or to fill in a series such as dates, drag the fill handle.

To display a shortcut me...
Posted By:Shruti Sharma      Posted On: Jan 20

Explain IF ,Vlookup, Hlookup function.

IF : The IF worksheet function checks a condition that must be either true or false. If the condition is true, the function returns one value; if the condition is false, the function returns another value. The function has three arguments: the condit...
Posted By:Shruti Sharma      Posted On: Jan 20

What is the different between SUM and SUMIF?

SUM : Adds all the numbers in a range of cells. E,g SUM(3, 2) equals 5, If cells A2:E2 contain 5, 15, 30, 40, and 50: SUM(A2:C2) equals 50, SUM(B2:E2, 15) equals 150.

SUMIF : The SUMIF worksheet function checks for a value within a range and then ...
Posted By:Shruti Sharma      Posted On: Jan 20