Basic Excel Interview Questions and Answers for Freshers: Excel or Microsoft Excel is one of the most crucial tools, a spreadsheet, that is almost strong-handedly ruling the software and business workplaces around. In the competitive world, the more you know about the tool, the more the chances of you getting recruited. As we know that Excel increases the weightage of your resume, here we are presenting the compilation of 101 Important Excel Interview Questions and Answers that help the freshers ace the Interview. Ready?
Excel is a commendable computer program without which no computer operations and computations are getting completed in any work out there. A piece of strong knowledge of Excel can place you in any kind of industry, as almost every industry is using Excel somewhere. It enriches the process of business be it stockings, rating analyzing, etc.
So, we know that it is a bit tough to crack interviews, although you have a good knowledge of this particular skill. To boost up confidence levels in you, we strongly suggest you go through our predicted and reliable compilation of 101 Excel Interview Questions and Answers which helps in polishing the basic knowledge you have, much stronger.
Excel is a software of the type spreadsheet, that helps in storing data by arranging the information into rows and columns.
Excel was developed by the Multinational Technological Company, Microsoft Corporation. It was launched by them in the year 1985. Since then, Excel is prominently known as Microsoft Excel.
The most important features one would notice in Microsoft Excel are:
Here are a few characteristics of Microsoft Excel.
The Excel Binary Workbook with an extension of .xlsb is considered as the smallest one among all the supportive extensions.
Here are a few ways using which we can reduce the size of Excel.
First of all, we need to select the rows and columns which we want to de-format. Then, the path we need to follow to clear the formatting is:
Home -> Editing group -> Clicking the arrow next to the clear button -> selecting a clear format from the dropdown.
In Excel, a Macro is a code or a set of actions that we use to perform certain tasks repeatedly. In such a case, we record the action or actions as a unit, called macro, to automate the tasking. Now, we can run the tasks numerous times with just a click.
In Microsoft Excel, selecting a function and clicking the F9 key on the keyboard helps in checking the formulas and debugging them, quickly.
In Excel, clicking a simple F12 key on the keyboard pops up a dialog box telling you to save the current file. Simply, It just works exactly like a “Save as” button.
Each basic cell is nothing but the junction where a cell of each row and column meets. It is where we can fill with an element of the data to be stored. Each cell is assigned a unique address, and as the columns are named A, B, C… while rows are assigned with labels 1, 2, 3…, by default, the first cell/junction’s address is A1, the next one is B1, and so on…
Excel follows the ‘PEMDAS’ rule, i.e., (We can use BODMAS rule too)
In Excel, we can perform the insertion and deletion operations in the following ways
In excel, the cells can be formatted using the main attributes and their elements such as:
In Excel, to add a comment to a cell, all you need to do is to give right-click on the cell and then select the ‘insert the comment’ option. You can always edit or delete the comment you entered.
To make it easy for recognition, the cell in which you add a comment will be marked with a red/purple flag on the top right corner of the cell.
The cell with the red mark in the L column represents that the cell has a comment.
In Microsoft Excel, a Ribbon is a header or topmost part that contains a set of buttons and tabs through which you can navigate to perform certain commands. They help in understanding and using the commands easily and quickly, and each component is further divided into a group of commands making up a category. These are the generally asked Excel Interview Questions and Answers for the fresher candidate in the Interview.
Mainly, there are 4 basic components present in the ribbon, namely:
On one sight, we find 7 tabs in the ribbon. However, each tab has several other commands within. The 7 tabs are:
The freeze pane helps in locking the cells which may be the headers of the rows or columns or any other data in any of the cells such that, even when we roll down the sheet to a larger extent, the frozen cells are always visible up there displaying on the sheet.
Select the cell that you want to lock up so that it could be visible on the sheet even if you scroll down. Then follow the path:
Select View -> Go to Freeze Panes -> Choose Freeze Panes.
By using the following techniques, we can enable security to Excel.
Relative Cell Address is the address or reference of the cell which has been modified and replaced either by using an automatic filling feature or by copying.
In some cases, the cell address should remain unchanged, when the autofill or copy happens. Such an address is called an absolute cell address and ‘$’ is used to keep the cell’s address constant.
To protect the worksheet’s cells from being copied, all you need to do is to go for the menu bar of ‘Review’, click on the Protect Sheet, and then give a password to the worksheet.
File tab -> Options -> Trust Center -> Trust Center Settings -> Macro Settings -> (Choose the selections based on your need) -> Click OK
The path goes as:
Select a range to be named -> formulae from ribbon -> Define name -> Provide the name.
Data in Ribbon -> Data Validation -> From Allow dropdown, select the List option -> Add the values as per your choice to the list under the source field.
A pivot table can be simply called a summary table of the data of a table with huge data. It helps you to report and explore the data based on the information given.
Pivot tables help us in keeping a track of the comparisons and statistics like summarize, group, count, total, sum, averages, sort, etc. of the table that contains a huge amount of data. The tables on which a pivot table can be made can be a database or a spreadsheet. The pivot table helps in transposing the data of the table too.
Excel is a vast topic, an ocean. We have tried to cover almost every topic with the motto of preparing you to face the Interview Questions in ‘Excel topic, strongly. However, these 101 questions are the most popular and are predicted to be asked in the interview, by our team. We think that these lists of Interview Questions will help you. Hope you will ace the basic knowledge of excel for interview asked in ‘Excel’ with your answers. Good luck!
Leave a Reply