"A" Capturer – We share encouragement and knowledge
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
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? 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
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 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
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