Answer for common question in Excel test for interview

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

How to use if function with multiple conditions and outcomes in Excel

Excel If Statement with multiple condition

This paragraph is original in English. From my last blog, we have introduced the if function in Excel where following is the syntax: Syntax: if function with multiple conditions and outcomes What if we have multiple conditions? Can we use the if function with multiple conditions? The answer is “Yes”. There are two ways to … 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 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

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