Excel Interview Question – How to define a range in Excel

What is a range in Excel? And how to define a range in Excel? Why should we name a range in Excel? A range is simply a group of cells in Excel. By naming a range in Excel allows people to easily understand formulas that calling the range and also, in case of change, simply … Read more

How to do change font style in excel – Excel Interview question

How to do change font style in Excel One of the most common Excel interview question. How to change cell formatting in excel – Excel Interview question This blog will illustrate how to change cell formatting in excel. From my previous post,  I have already mentioned: How to change data format in Excel How many … Read more

How many data format available in Excel – Excel Interview Question

How many data format available in Excel – Excel Interview Question From my previous blog How to change data format in Excel, I mentioned that Excel can present values into following 11 different data format available in excel: [vtftable ]Format;;;Usage;;;Example;;;Actual Value;nn;General;;;Not specific number format;;;1.5;;;1.5;nn;Number;;;general display of numbers;;;1.50;;;1.5;nn;Currency;;;general monetary values;;;\$1.50;;;1.5;nn;Accounting;;;line up the currency symbols and decimal … Read more

How to change data format in Excel – Excel Interview Question

How to change data format in Excel?   [wpdevart_youtube]MjydYvzn_ts[/wpdevart_youtube] Excel can present values into following 11 different formats: [vtftable ]Format;;;Usage;;;Example;;;Actual Value;nn;General;;;Not specific number format;;;1.5;;;1.5;nn;Number;;;general display of numbers;;;1.50;;;1.5;nn;Currency;;;general monetary values;;;\$1.50;;;1.5;nn;Accounting;;;line up the currency symbols and decimal points in a column;;; \$1.50 ;;;1.5;nn;Date or Time;;;Date OR Time Format;;;1/01/1900 12:00:00 PM;;;1.5;nn;Precentage;;;multiply the cell value by 100 and display … Read more

Does Excel available in Ipad/Iphone & Android?

Does Excel Available in Ipad/Iphone & Android? Yes. Excel is available in Ipad/Iphone and Android devices since Office 365. How to get it? Please refer to following youtube video on how to get it.

How to present multiple lines in one cell?

Hi There, Can anyone tell me how to insert multiple lines in one single cell in Excel? Thanks!

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

How to create a new excel file? – File Ribbon

How to create a new excel file? Excel allows users to create a file from scratch ( blank workbook) or from templates using the file Ribbon. Microsoft allows users to create an excel file from template since long ago. To create a new excel file from scratch click the “new” button from the “File Ribbon” … Read more

What is a Ribbon in Excel – Excel Interview Questions

This blog is going to answer following questions regarding to Ribbon in Excel.   What is a Ribbon in Excel? is available since MS-Office 2007. Replaced menus and toolbars in previous Office version. Ribbon have the same functionality as as menus or toolbar. Ribbon reorganised those buttons in a more user friendly way. Ribbons have … Read more