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

Format Cell

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

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

Example of sumifs function

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

New Excel file

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