## Answer for common question in Excel test for interview

This page list answers for some common question in an Excel test for interview. This page will be updated regularly to ensure it’s most updated accuracy. Please come back regularly or consider to have this page bookmarked. Common question in an Excel test for interview 1) What is Microsoft Excel? Microsoft Excel is software that … Read more

## Getpivotdata – an easier and better way to reference a pivot table in Excel

From my other blog I have illustrated how to create a pivot table. How to read information from a pivot table Now I am going to mention how to refer information from a pivot table. There are two ways to do the job refer to the corresponding cells  (e.g. = a10) using the “GetPivotData” function … Read more

## How to write an if statement in excel?

The IF function in Excel is one of the most popular conditional formula functions, and it allows you to make logical comparisons between a value and what you expect.

Syntax:

[vtftable cols=”{0}0:fff2cc;{/}”]
=if(Condition , Result when matched, result when not matched);nn;
[/vtftable]

For Example:

Meaning:

If A2 is less than 10, (exclude 10), then the value for B2 is “<10”, else the value for B2 is “>=10”.

As now A2 is nothing, in Excel, it will be considered as 0. Therefore, the result for B2 is “<10”.

## How to define a range in Excel dynamically

From my previous blog – How to define a range in Excel, I have illustrated how to name a range. We can also define a range in Excel dynamically using the offset excel function. To create a dynamic range, we will use the “offset” function” in Excel offset excel function The Offset excel function returns … Read more

## How to manipulate worksheets in Excel

How to manipulate worksheets in Excel? As mentioned from my other blogs – How to create a new excel file? – an Excel spreadsheet can have multiple sheets in one file. You can add, rename, move, delete, hide, unhide entire spreadsheet as long as to change colour of the spreadsheet. If you are using Excel … Read more

## How to Add/Update or delete a comment to a cell in Excel

Excel allow users to make comments for any cells in the spreadsheet. By default, those comments are visual only when the cell have been hovered by the mouse. Other time, Excel simply place a red triangle on the top-right corner to indicate there is a comment for the cell. ADD COMMENT Following is the steps … Read more

## How to do summation or counting in Excel with multiple wildcard criteria? – new excel functions

We can use the following functions to do summation or counting in Excel with multiple wildcard criteria Summation or counting in Excel with multiple wildcard criteria However, both Sumif and Countif only allows single criteria. SUMIFS & COUNTIFS Since Excel 2007, Microsoft have introduced two new functions called SUMIFS & COUNTIFS They are close to sumif and … Read more