In the corporate world, MS Excel is one of the important tools which is often used by professionals. While preparing for interviews candidates one should know the technical terminology associated with this. Apart from the basic, there are few advanced level functions, which require a special attention. Given below is the list of thirty- five such questions, which covers up the basic and advance learning in MS Excel.
Candidate should try to know the importance and other uses of the application and should never forget to the emphasis on the fact that with passing years the advancement in the learning has taken place in MS Excel and work can be completed easily and effectively. From storing data to calculating various components, this application covers all the functions required.
Stated below is the list of few Microsoft Excel questions, which will help the candidates to prepare for interviews.
Go to Menu bar > click on Review > select Protect Sheet > set a Password. Hence, by setting a password, sheets can be secured from getting copied.
Click on more Sort Options > Right Click on ‘Pivot tables’ > Select ‘sort menu’ > select ‘More Options’ > deselect ‘Sort automatically’.
And the automatic sorting will be disabled.
Firstly, there is a need to change the width of one column and drag it towards the boundary on the right side of the column heading till the required width.
Secondly, it can also be done by selecting the Format from the home tab, and in Format, one has to select AUTOFIT COLUMN WIDTH that is under cell section. Directly by clicking on this, the cell size will be formatted as required.
Syntax: SUBSTITUTE (text, old Text, new Text, [instance Number])
Whereas the REPLACE function swaps the part of the text string with another set of text. The Syntax for this is:
Syntax: REPLACE (old Text, start Number, Number Characters, new Text)
COUNTA or Count All is such a function that is used to count any cell value containing numbers, text, logical values, etc.
COUNTBLANK is cell or cells with an empty string.
COUNTIF and COUNTIFS count cells matching any particular criteria.
Never Miss an Articles from us.