Basic Excel Interview Questions and Answers for Freshers 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. Q1. Define Excel in your own words Excel is a software of the type spreadsheet, that helps in storing data by arranging the information into rows and columns. Q2. Excel was developed by which company? 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. Q3. List any three operating systems that support Excel. Q4. Name some important features of Microsoft Excel. The most important features one would notice in Microsoft Excel are: Q5. Name some characteristics of Microsoft Excel. Here are a few characteristics of Microsoft Excel. Q6. Name the languages and tools used in developing Microsoft Excel. Q7. List the file formats Microsoft Excel uses. Q8. Which excel type is the smallest of all? The Excel Binary Workbook with an extension of .xlsb is considered as the smallest one among all the supportive extensions. Q9. Tell us a few ways you use to reduce the size of an excel. Here are a few ways using which we can reduce the size of Excel. Q10. How will you clear formatting in 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. Q11. Define Macro. 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. Q12. What is the key that helps in debugging the formulas, quickly? In Microsoft Excel, selecting a function and clicking the F9 key on the keyboard helps in checking the formulas and debugging them, quickly. Q13. What does the F12 key do in Excel? 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. Q14. Explain the basic cells present in Microsoft Excel. 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… Q15. Coming to the Excel formulas, What is their order of precedence of operations? Excel follows the ‘PEMDAS’ rule, i.e., (We can use BODMAS rule too) Q16. Is it possible to rearrange the cells in Excel? In Excel, we can perform the insertion and deletion operations in the following ways Q17. List the data formatting ways for cells, in Excel. In excel, the cells can be formatted using the main attributes and their elements such as: Q18. How to add a comment in a cell, in Excel. 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. Q19. How can the cell with a comment differ from the cell with the data? 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. Q20. Define Ribbon. 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. Q21. What are the major components you find in the ribbon? Mainly, there are 4 basic components present in the ribbon, namely: Q22. Name the tabs that are present in the ribbon. On one sight, we find 7 tabs in the ribbon. However, each tab has several other commands within. The 7 tabs are: Q23. How does