Excel is that commendable computer program without which no computer operations and computations are getting completed in any work out there. A piece of strong knowledge in 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 in stockings, rating analyzing, etc.<\/p>\r\n
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 the 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.<\/p>\r\n\r\n
<\/i><\/i>Define Excel in your own words<\/a><\/h4>\r\n<\/div>\r\n\r\n\r\nExcel is a software of the type spreadsheet, that helps in storing the data by arranging the information into the rows and columns.<\/p>\r\n\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n
\r\n\r\n<\/i><\/i>Excel was developed by which company?<\/a><\/h4>\r\n<\/div>\r\n\r\n\r\nExcel 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.<\/p>\r\n\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n
\r\n\r\n<\/i><\/i>List any three operating systems that support Excel.<\/a><\/h4>\r\n<\/div>\r\n\r\n\r\n\r\n \t- Windows<\/li>\r\n \t
- macOS<\/li>\r\n \t
- Android<\/a><\/li>\r\n \t
- iOS<\/a><\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n
<\/i><\/i>Name some important features of Microsoft Excel.<\/a><\/h4>\r\n<\/div>\r\n\r\n\r\nThe most important features one would notice in the Microsoft Excel are:<\/p>\r\n\r\n
\r\n \t- Graphing tools<\/li>\r\n \t
- Visual Basic<\/li>\r\n \t
- Calculations are done using predefined functions<\/li>\r\n \t
- Pivot tables, etc.<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n
<\/i><\/i>Name some characteristics of Microsoft Excel.<\/a><\/h4>\r\n<\/div>\r\n\r\n\r\nHere are the few characteristics of Microsoft Excel.<\/p>\r\n\r\n
\r\n \t- Workbooks, worksheets to arrange the data.<\/li>\r\n \t
- Rows and columns making work easier.<\/li>\r\n \t
- Pre-defined functions like count, sum, subtotal, date, etc. make computations easier.<\/li>\r\n \t
- A supportive hand to microprogramming through the application, Visual Basic.<\/li>\r\n \t
- Filters, tables, and graphs make data visualization and understanding easy.<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n
<\/i><\/i>Name the languages and tools used in developing Microsoft Excel.<\/a><\/h4>\r\n<\/div>\r\n\r\n\r\n\r\n \t- C#<\/li>\r\n \t
- C++<\/a><\/li>\r\n \t
- Microsoft Foundation Class Library<\/li>\r\n \t
- .NET<\/a> Framework<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n
<\/i><\/i>List the file formats Microsoft Excel uses.<\/a><\/h4>\r\n<\/div>\r\n\r\n\r\n\r\n \t- Excel Workbook – .xlsx<\/li>\r\n \t
- Excel Macro-Enabled Workbook for code – .xlsm<\/li>\r\n \t
- Excel Binary Workbook – .xlsb<\/li>\r\n \t
- Template – .xltx<\/li>\r\n \t
- Template for code – .xltm<\/li>\r\n \t
- Excel 97- Excel 2003 Workbook – .xls<\/li>\r\n \t
- Excel 97- Excel 2003 Template .xlt<\/li>\r\n \t
- Microsoft Excel 5.0\/95 Workbook – .xls<\/li>\r\n \t
- XML Spreadsheet 2003 – .xml<\/li>\r\n \t
- XML Data – .xml<\/li>\r\n \t
- Excel Add-In – .xlam<\/li>\r\n \t
- Excel 97-2003 Add-In – .xla<\/li>\r\n \t
- Excel 4.0 Workbook – .xlw<\/li>\r\n \t
- Works 6.0-9.0 spreadsheet – .xlr, etc.<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n
<\/i><\/i>Which excel type is the smallest of all?<\/a><\/h4>\r\n<\/div>\r\n\r\n\r\nThe Excel Binary Workbook<\/strong> with an extension of .xlsb<\/strong> is considered as the smallest one among all the supportive extensions.<\/p>\r\n\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n<\/i><\/i>Tell us a few ways you use to reduce the size of an excel.<\/a><\/h4>\r\n<\/div>\r\n\r\n\r\nHere are a few ways using which we can reduce the size of Excel.<\/p>\r\n\r\n
\r\n \t- Compress the size of images.<\/li>\r\n \t
- Remove the extra or hidden spreadsheets.<\/li>\r\n \t
- Remove conditional formatting<\/li>\r\n \t
- Clear data formatting.<\/li>\r\n \t
- Clear watches.<\/li>\r\n \t
- Remove rows and columns that are hidden or not needed.<\/li>\r\n \t
- Remove unnecessary function usages (formulas).<\/li>\r\n \t
- Converting the excels of other extensions to the .xlsb (binary) format.<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n
<\/i><\/i>How will you clear formatting in Excel? <\/a><\/h4>\r\n<\/div>\r\n\r\n\r\nFirst 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:<\/p>\r\n
Home -> Editing group -> Clicking the arrow next to clear button<\/strong> -> selecting clear format <\/strong>from the dropdown. These are the commonly asked Excel Interview Questions and Answers <\/strong>for Freshers and Experienced candidates in an Interview.<\/p>\r\n\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n<\/i><\/i>Define Macro.<\/a><\/h4>\r\n<\/div>\r\n\r\n\r\nIn Excel, 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.<\/p>\r\n\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n
\r\n\r\n<\/i><\/i>What is the key that helps in debugging the formulas, quickly?<\/a><\/h4>\r\n<\/div>\r\n\r\n\r\nIn Microsoft Excel, selecting a function and clicking the F9 key<\/strong> on the keyboard helps in checking the formulas and debugging them, quickly.<\/p>\r\n\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n<\/i><\/i>What does the F12 key do in Excel?<\/a><\/h4>\r\n<\/div>\r\n\r\n\r\nIn 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 \u201cSave as\u201d<\/strong> button.<\/p>\r\n\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n<\/i><\/i>Explain the basic cells present in Microsoft Excel.<\/a><\/h4>\r\n<\/div>\r\n\r\n\r\nEach 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 with a unique address, and as the columns are named as A, B, C\u2026 while rows are assigned with labels 1, 2, 3\u2026, by default, the first cell\/junction\u2019s address is A1, the next one is B1, and so on\u2026<\/p>\r\n\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n
![\"Excel](\"\/wp-content\/themes\/zeft\/images\/Excel-Interview-Questions-and-Answers-chennai.jpg\")
<\/a><\/div>\r\n\r\n\r\n<\/i><\/i>Coming to the Excel formulas, What is their order of precedence of operations?<\/a><\/h4>\r\n<\/div>\r\n\r\n\r\nExcel follows the \u2018PEMDAS\u2019 rule, i.e., (We can use BODMAS rule too)<\/p>\r\n\r\n
\r\n \t- 1st priority to the Parentheses \u2018()\u2019<\/li>\r\n \t
- 2nd priority to the Exponent \u2018^\u2019<\/li>\r\n \t
- 3rd and equal priority to the Division \u2018\/\u2019 and the Multiplication \u2018*\u2019<\/li>\r\n \t
- 4th and equal priority to the Addition \u2018+\u2019 and the Subtraction \u2018-\u2019<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n
<\/i><\/i>Is it possible to rearrange the cells in Excel?<\/a><\/h4>\r\n<\/div>\r\n\r\n\r\nIn Excel, we can perform the insertion and deletion operations in the following ways<\/p>\r\n\r\n
\r\n \t- Shifting cells to the right<\/li>\r\n \t
- Shifting cells up<\/li>\r\n \t
- Shifting cells to left<\/li>\r\n \t
- Shifting cells down<\/li>\r\n \t
- Inserting\/Deleting entire row<\/li>\r\n \t
- Inserting\/Deleting entire column<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n
<\/i><\/i>List the data formatting ways for cells, in Excel.<\/a><\/h4>\r\n<\/div>\r\n\r\n\r\nIn excel, the cells can be formatted using the main attributes and their elements such as:<\/p>\r\n\r\n
\r\n \t- Number<\/li>\r\n \t
- Alignment<\/li>\r\n \t
- Font<\/li>\r\n \t
- Border<\/li>\r\n \t
- Fill<\/li>\r\n \t
- Protection<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n
<\/i><\/i>How to add a comment in a cell, in Excel.<\/a><\/h4>\r\n<\/div>\r\n\r\n\r\nIn Excel, to add a comment to a cell, all you need to do is to give a right-click on the cell and then select the \u2018insert the comment\u2019 option. You can always edit or delete the comment you entered.<\/p>\r\n\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n
\r\n\r\n<\/i><\/i>How can the cell with a comment differ from the cell with the data?<\/a><\/h4>\r\n<\/div>\r\n\r\n\r\nTo 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.<\/p>\r\n
The cell with the red mark in the L column represents that the cell has a comment.<\/p>\r\n\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n
\r\n\r\n<\/i><\/i>Define Ribbon.<\/a><\/h4>\r\n<\/div>\r\n\r\n\r\nIn Microsoft Excel, 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<\/strong> for the fresher candidate in the Interview.<\/p>\r\n\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n<\/i><\/i>What are the major components you find in the ribbon?<\/a><\/h4>\r\n<\/div>\r\n\r\n\r\nMainly, there are 4 basic components present in the ribbon, namely:<\/p>\r\n\r\n
\r\n \t- Tabs<\/li>\r\n \t
- Dialog launchers<\/li>\r\n \t
- Groups<\/li>\r\n \t
- Command Buttons<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n
<\/i><\/i>Name the tabs that are present in the ribbon.<\/a><\/h4>\r\n<\/div>\r\n\r\n\r\nOn one sight, we find 7 tabs in the ribbon. However, each tab has several other commands within. The 7 tabs are:<\/p>\r\n\r\n
\r\n \t- Home<\/li>\r\n \t
- Insert<\/li>\r\n \t
- Page Layout<\/li>\r\n \t
- Formulas<\/li>\r\n \t
- Data<\/li>\r\n \t
- Review<\/li>\r\n \t
- View<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n
<\/i><\/i>How does the freeze pane help us in excel?.<\/a><\/h4>\r\n<\/div>\r\n\r\n\r\nThe 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.<\/p>\r\n\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n
\r\n\r\n<\/i><\/i>How do you apply the freeze pane to a cell?<\/a><\/h4>\r\n<\/div>\r\n\r\n\r\nSelect the cell which you want to lock up so that it could be visible on the sheet even if you scroll down. Then follow the path:<\/p>\r\n
Select View -> Go to Freeze Panes -> Choose Freeze Panes.<\/p>\r\n\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n
\r\n\r\n<\/i><\/i>What are the forms in which protection can be applied to an excel?<\/a><\/h4>\r\n<\/div>\r\n\r\n\r\nBy using the following techniques, we can enable security to Excel.<\/p>\r\n\r\n
\r\n \t- Via password to open a workbook<\/li>\r\n \t
- Against the manipulations being done on the worksheet.<\/li>\r\n \t
- Protecting the window positions\/ sizes from getting modified.<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n
<\/i>
Excel is a software of the type spreadsheet, that helps in storing the data by arranging the information into the rows and columns.<\/p>\r\n\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n
<\/i><\/i>Excel was developed by which company?<\/a><\/h4>\r\n<\/div>\r\n\r\n\r\nExcel 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.<\/p>\r\n\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n
\r\n\r\n<\/i><\/i>List any three operating systems that support Excel.<\/a><\/h4>\r\n<\/div>\r\n\r\n\r\n\r\n \t- Windows<\/li>\r\n \t
- macOS<\/li>\r\n \t
- Android<\/a><\/li>\r\n \t
- iOS<\/a><\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n
<\/i><\/i>Name some important features of Microsoft Excel.<\/a><\/h4>\r\n<\/div>\r\n\r\n\r\nThe most important features one would notice in the Microsoft Excel are:<\/p>\r\n\r\n
\r\n \t- Graphing tools<\/li>\r\n \t
- Visual Basic<\/li>\r\n \t
- Calculations are done using predefined functions<\/li>\r\n \t
- Pivot tables, etc.<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n
<\/i><\/i>Name some characteristics of Microsoft Excel.<\/a><\/h4>\r\n<\/div>\r\n\r\n\r\nHere are the few characteristics of Microsoft Excel.<\/p>\r\n\r\n
\r\n \t- Workbooks, worksheets to arrange the data.<\/li>\r\n \t
- Rows and columns making work easier.<\/li>\r\n \t
- Pre-defined functions like count, sum, subtotal, date, etc. make computations easier.<\/li>\r\n \t
- A supportive hand to microprogramming through the application, Visual Basic.<\/li>\r\n \t
- Filters, tables, and graphs make data visualization and understanding easy.<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n
<\/i><\/i>Name the languages and tools used in developing Microsoft Excel.<\/a><\/h4>\r\n<\/div>\r\n\r\n\r\n\r\n \t- C#<\/li>\r\n \t
- C++<\/a><\/li>\r\n \t
- Microsoft Foundation Class Library<\/li>\r\n \t
- .NET<\/a> Framework<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n
<\/i><\/i>List the file formats Microsoft Excel uses.<\/a><\/h4>\r\n<\/div>\r\n\r\n\r\n\r\n \t- Excel Workbook – .xlsx<\/li>\r\n \t
- Excel Macro-Enabled Workbook for code – .xlsm<\/li>\r\n \t
- Excel Binary Workbook – .xlsb<\/li>\r\n \t
- Template – .xltx<\/li>\r\n \t
- Template for code – .xltm<\/li>\r\n \t
- Excel 97- Excel 2003 Workbook – .xls<\/li>\r\n \t
- Excel 97- Excel 2003 Template .xlt<\/li>\r\n \t
- Microsoft Excel 5.0\/95 Workbook – .xls<\/li>\r\n \t
- XML Spreadsheet 2003 – .xml<\/li>\r\n \t
- XML Data – .xml<\/li>\r\n \t
- Excel Add-In – .xlam<\/li>\r\n \t
- Excel 97-2003 Add-In – .xla<\/li>\r\n \t
- Excel 4.0 Workbook – .xlw<\/li>\r\n \t
- Works 6.0-9.0 spreadsheet – .xlr, etc.<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n
<\/i><\/i>Which excel type is the smallest of all?<\/a><\/h4>\r\n<\/div>\r\n\r\n\r\nThe Excel Binary Workbook<\/strong> with an extension of .xlsb<\/strong> is considered as the smallest one among all the supportive extensions.<\/p>\r\n\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n<\/i><\/i>Tell us a few ways you use to reduce the size of an excel.<\/a><\/h4>\r\n<\/div>\r\n\r\n\r\nHere are a few ways using which we can reduce the size of Excel.<\/p>\r\n\r\n
\r\n \t- Compress the size of images.<\/li>\r\n \t
- Remove the extra or hidden spreadsheets.<\/li>\r\n \t
- Remove conditional formatting<\/li>\r\n \t
- Clear data formatting.<\/li>\r\n \t
- Clear watches.<\/li>\r\n \t
- Remove rows and columns that are hidden or not needed.<\/li>\r\n \t
- Remove unnecessary function usages (formulas).<\/li>\r\n \t
- Converting the excels of other extensions to the .xlsb (binary) format.<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n
<\/i><\/i>How will you clear formatting in Excel? <\/a><\/h4>\r\n<\/div>\r\n\r\n\r\nFirst 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:<\/p>\r\n
Home -> Editing group -> Clicking the arrow next to clear button<\/strong> -> selecting clear format <\/strong>from the dropdown. These are the commonly asked Excel Interview Questions and Answers <\/strong>for Freshers and Experienced candidates in an Interview.<\/p>\r\n\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n<\/i><\/i>Define Macro.<\/a><\/h4>\r\n<\/div>\r\n\r\n\r\nIn Excel, 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.<\/p>\r\n\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n
\r\n\r\n<\/i><\/i>What is the key that helps in debugging the formulas, quickly?<\/a><\/h4>\r\n<\/div>\r\n\r\n\r\nIn Microsoft Excel, selecting a function and clicking the F9 key<\/strong> on the keyboard helps in checking the formulas and debugging them, quickly.<\/p>\r\n\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n<\/i><\/i>What does the F12 key do in Excel?<\/a><\/h4>\r\n<\/div>\r\n\r\n\r\nIn 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 \u201cSave as\u201d<\/strong> button.<\/p>\r\n\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n<\/i><\/i>Explain the basic cells present in Microsoft Excel.<\/a><\/h4>\r\n<\/div>\r\n\r\n\r\nEach 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 with a unique address, and as the columns are named as A, B, C\u2026 while rows are assigned with labels 1, 2, 3\u2026, by default, the first cell\/junction\u2019s address is A1, the next one is B1, and so on\u2026<\/p>\r\n\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n
<\/a><\/div>\r\n\r\n\r\n<\/i><\/i>Coming to the Excel formulas, What is their order of precedence of operations?<\/a><\/h4>\r\n<\/div>\r\n\r\n\r\nExcel follows the \u2018PEMDAS\u2019 rule, i.e., (We can use BODMAS rule too)<\/p>\r\n\r\n
\r\n \t- 1st priority to the Parentheses \u2018()\u2019<\/li>\r\n \t
- 2nd priority to the Exponent \u2018^\u2019<\/li>\r\n \t
- 3rd and equal priority to the Division \u2018\/\u2019 and the Multiplication \u2018*\u2019<\/li>\r\n \t
- 4th and equal priority to the Addition \u2018+\u2019 and the Subtraction \u2018-\u2019<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n
<\/i><\/i>Is it possible to rearrange the cells in Excel?<\/a><\/h4>\r\n<\/div>\r\n\r\n\r\nIn Excel, we can perform the insertion and deletion operations in the following ways<\/p>\r\n\r\n
\r\n \t- Shifting cells to the right<\/li>\r\n \t
- Shifting cells up<\/li>\r\n \t
- Shifting cells to left<\/li>\r\n \t
- Shifting cells down<\/li>\r\n \t
- Inserting\/Deleting entire row<\/li>\r\n \t
- Inserting\/Deleting entire column<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n
<\/i><\/i>List the data formatting ways for cells, in Excel.<\/a><\/h4>\r\n<\/div>\r\n\r\n\r\nIn excel, the cells can be formatted using the main attributes and their elements such as:<\/p>\r\n\r\n
\r\n \t- Number<\/li>\r\n \t
- Alignment<\/li>\r\n \t
- Font<\/li>\r\n \t
- Border<\/li>\r\n \t
- Fill<\/li>\r\n \t
- Protection<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n
<\/i><\/i>How to add a comment in a cell, in Excel.<\/a><\/h4>\r\n<\/div>\r\n\r\n\r\nIn Excel, to add a comment to a cell, all you need to do is to give a right-click on the cell and then select the \u2018insert the comment\u2019 option. You can always edit or delete the comment you entered.<\/p>\r\n\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n
\r\n\r\n<\/i><\/i>How can the cell with a comment differ from the cell with the data?<\/a><\/h4>\r\n<\/div>\r\n\r\n\r\nTo 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.<\/p>\r\n
The cell with the red mark in the L column represents that the cell has a comment.<\/p>\r\n\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n
\r\n\r\n<\/i><\/i>Define Ribbon.<\/a><\/h4>\r\n<\/div>\r\n\r\n\r\nIn Microsoft Excel, 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<\/strong> for the fresher candidate in the Interview.<\/p>\r\n\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n<\/i><\/i>What are the major components you find in the ribbon?<\/a><\/h4>\r\n<\/div>\r\n\r\n\r\nMainly, there are 4 basic components present in the ribbon, namely:<\/p>\r\n\r\n
\r\n \t- Tabs<\/li>\r\n \t
- Dialog launchers<\/li>\r\n \t
- Groups<\/li>\r\n \t
- Command Buttons<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n
<\/i><\/i>Name the tabs that are present in the ribbon.<\/a><\/h4>\r\n<\/div>\r\n\r\n\r\nOn one sight, we find 7 tabs in the ribbon. However, each tab has several other commands within. The 7 tabs are:<\/p>\r\n\r\n
\r\n \t- Home<\/li>\r\n \t
- Insert<\/li>\r\n \t
- Page Layout<\/li>\r\n \t
- Formulas<\/li>\r\n \t
- Data<\/li>\r\n \t
- Review<\/li>\r\n \t
- View<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n
<\/i><\/i>How does the freeze pane help us in excel?.<\/a><\/h4>\r\n<\/div>\r\n\r\n\r\nThe 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.<\/p>\r\n\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n
\r\n\r\n<\/i><\/i>How do you apply the freeze pane to a cell?<\/a><\/h4>\r\n<\/div>\r\n\r\n\r\nSelect the cell which you want to lock up so that it could be visible on the sheet even if you scroll down. Then follow the path:<\/p>\r\n
Select View -> Go to Freeze Panes -> Choose Freeze Panes.<\/p>\r\n\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n
\r\n\r\n<\/i><\/i>What are the forms in which protection can be applied to an excel?<\/a><\/h4>\r\n<\/div>\r\n\r\n\r\nBy using the following techniques, we can enable security to Excel.<\/p>\r\n\r\n
\r\n \t- Via password to open a workbook<\/li>\r\n \t
- Against the manipulations being done on the worksheet.<\/li>\r\n \t
- Protecting the window positions\/ sizes from getting modified.<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n
<\/i>
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.<\/p>\r\n\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n
<\/i><\/i>List any three operating systems that support Excel.<\/a><\/h4>\r\n<\/div>\r\n\r\n\r\n\r\n \t- Windows<\/li>\r\n \t
- macOS<\/li>\r\n \t
- Android<\/a><\/li>\r\n \t
- iOS<\/a><\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n
<\/i><\/i>Name some important features of Microsoft Excel.<\/a><\/h4>\r\n<\/div>\r\n\r\n\r\nThe most important features one would notice in the Microsoft Excel are:<\/p>\r\n\r\n
\r\n \t- Graphing tools<\/li>\r\n \t
- Visual Basic<\/li>\r\n \t
- Calculations are done using predefined functions<\/li>\r\n \t
- Pivot tables, etc.<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n
<\/i><\/i>Name some characteristics of Microsoft Excel.<\/a><\/h4>\r\n<\/div>\r\n\r\n\r\nHere are the few characteristics of Microsoft Excel.<\/p>\r\n\r\n
\r\n \t- Workbooks, worksheets to arrange the data.<\/li>\r\n \t
- Rows and columns making work easier.<\/li>\r\n \t
- Pre-defined functions like count, sum, subtotal, date, etc. make computations easier.<\/li>\r\n \t
- A supportive hand to microprogramming through the application, Visual Basic.<\/li>\r\n \t
- Filters, tables, and graphs make data visualization and understanding easy.<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n
<\/i><\/i>Name the languages and tools used in developing Microsoft Excel.<\/a><\/h4>\r\n<\/div>\r\n\r\n\r\n\r\n \t- C#<\/li>\r\n \t
- C++<\/a><\/li>\r\n \t
- Microsoft Foundation Class Library<\/li>\r\n \t
- .NET<\/a> Framework<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n
<\/i><\/i>List the file formats Microsoft Excel uses.<\/a><\/h4>\r\n<\/div>\r\n\r\n\r\n\r\n \t- Excel Workbook – .xlsx<\/li>\r\n \t
- Excel Macro-Enabled Workbook for code – .xlsm<\/li>\r\n \t
- Excel Binary Workbook – .xlsb<\/li>\r\n \t
- Template – .xltx<\/li>\r\n \t
- Template for code – .xltm<\/li>\r\n \t
- Excel 97- Excel 2003 Workbook – .xls<\/li>\r\n \t
- Excel 97- Excel 2003 Template .xlt<\/li>\r\n \t
- Microsoft Excel 5.0\/95 Workbook – .xls<\/li>\r\n \t
- XML Spreadsheet 2003 – .xml<\/li>\r\n \t
- XML Data – .xml<\/li>\r\n \t
- Excel Add-In – .xlam<\/li>\r\n \t
- Excel 97-2003 Add-In – .xla<\/li>\r\n \t
- Excel 4.0 Workbook – .xlw<\/li>\r\n \t
- Works 6.0-9.0 spreadsheet – .xlr, etc.<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n
<\/i><\/i>Which excel type is the smallest of all?<\/a><\/h4>\r\n<\/div>\r\n\r\n\r\nThe Excel Binary Workbook<\/strong> with an extension of .xlsb<\/strong> is considered as the smallest one among all the supportive extensions.<\/p>\r\n\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n<\/i><\/i>Tell us a few ways you use to reduce the size of an excel.<\/a><\/h4>\r\n<\/div>\r\n\r\n\r\nHere are a few ways using which we can reduce the size of Excel.<\/p>\r\n\r\n
\r\n \t- Compress the size of images.<\/li>\r\n \t
- Remove the extra or hidden spreadsheets.<\/li>\r\n \t
- Remove conditional formatting<\/li>\r\n \t
- Clear data formatting.<\/li>\r\n \t
- Clear watches.<\/li>\r\n \t
- Remove rows and columns that are hidden or not needed.<\/li>\r\n \t
- Remove unnecessary function usages (formulas).<\/li>\r\n \t
- Converting the excels of other extensions to the .xlsb (binary) format.<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n
<\/i><\/i>How will you clear formatting in Excel? <\/a><\/h4>\r\n<\/div>\r\n\r\n\r\nFirst 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:<\/p>\r\n
Home -> Editing group -> Clicking the arrow next to clear button<\/strong> -> selecting clear format <\/strong>from the dropdown. These are the commonly asked Excel Interview Questions and Answers <\/strong>for Freshers and Experienced candidates in an Interview.<\/p>\r\n\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n<\/i><\/i>Define Macro.<\/a><\/h4>\r\n<\/div>\r\n\r\n\r\nIn Excel, 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.<\/p>\r\n\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n
\r\n\r\n<\/i><\/i>What is the key that helps in debugging the formulas, quickly?<\/a><\/h4>\r\n<\/div>\r\n\r\n\r\nIn Microsoft Excel, selecting a function and clicking the F9 key<\/strong> on the keyboard helps in checking the formulas and debugging them, quickly.<\/p>\r\n\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n<\/i><\/i>What does the F12 key do in Excel?<\/a><\/h4>\r\n<\/div>\r\n\r\n\r\nIn 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 \u201cSave as\u201d<\/strong> button.<\/p>\r\n\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n<\/i><\/i>Explain the basic cells present in Microsoft Excel.<\/a><\/h4>\r\n<\/div>\r\n\r\n\r\nEach 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 with a unique address, and as the columns are named as A, B, C\u2026 while rows are assigned with labels 1, 2, 3\u2026, by default, the first cell\/junction\u2019s address is A1, the next one is B1, and so on\u2026<\/p>\r\n\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n
<\/a><\/div>\r\n\r\n\r\n<\/i><\/i>Coming to the Excel formulas, What is their order of precedence of operations?<\/a><\/h4>\r\n<\/div>\r\n\r\n\r\nExcel follows the \u2018PEMDAS\u2019 rule, i.e., (We can use BODMAS rule too)<\/p>\r\n\r\n
\r\n \t- 1st priority to the Parentheses \u2018()\u2019<\/li>\r\n \t
- 2nd priority to the Exponent \u2018^\u2019<\/li>\r\n \t
- 3rd and equal priority to the Division \u2018\/\u2019 and the Multiplication \u2018*\u2019<\/li>\r\n \t
- 4th and equal priority to the Addition \u2018+\u2019 and the Subtraction \u2018-\u2019<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n
<\/i><\/i>Is it possible to rearrange the cells in Excel?<\/a><\/h4>\r\n<\/div>\r\n\r\n\r\nIn Excel, we can perform the insertion and deletion operations in the following ways<\/p>\r\n\r\n
\r\n \t- Shifting cells to the right<\/li>\r\n \t
- Shifting cells up<\/li>\r\n \t
- Shifting cells to left<\/li>\r\n \t
- Shifting cells down<\/li>\r\n \t
- Inserting\/Deleting entire row<\/li>\r\n \t
- Inserting\/Deleting entire column<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n
<\/i><\/i>List the data formatting ways for cells, in Excel.<\/a><\/h4>\r\n<\/div>\r\n\r\n\r\nIn excel, the cells can be formatted using the main attributes and their elements such as:<\/p>\r\n\r\n
\r\n \t- Number<\/li>\r\n \t
- Alignment<\/li>\r\n \t
- Font<\/li>\r\n \t
- Border<\/li>\r\n \t
- Fill<\/li>\r\n \t
- Protection<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n
<\/i><\/i>How to add a comment in a cell, in Excel.<\/a><\/h4>\r\n<\/div>\r\n\r\n\r\nIn Excel, to add a comment to a cell, all you need to do is to give a right-click on the cell and then select the \u2018insert the comment\u2019 option. You can always edit or delete the comment you entered.<\/p>\r\n\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n
\r\n\r\n<\/i><\/i>How can the cell with a comment differ from the cell with the data?<\/a><\/h4>\r\n<\/div>\r\n\r\n\r\nTo 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.<\/p>\r\n
The cell with the red mark in the L column represents that the cell has a comment.<\/p>\r\n\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n
\r\n\r\n<\/i><\/i>Define Ribbon.<\/a><\/h4>\r\n<\/div>\r\n\r\n\r\nIn Microsoft Excel, 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<\/strong> for the fresher candidate in the Interview.<\/p>\r\n\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n<\/i><\/i>What are the major components you find in the ribbon?<\/a><\/h4>\r\n<\/div>\r\n\r\n\r\nMainly, there are 4 basic components present in the ribbon, namely:<\/p>\r\n\r\n
\r\n \t- Tabs<\/li>\r\n \t
- Dialog launchers<\/li>\r\n \t
- Groups<\/li>\r\n \t
- Command Buttons<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n
<\/i><\/i>Name the tabs that are present in the ribbon.<\/a><\/h4>\r\n<\/div>\r\n\r\n\r\nOn one sight, we find 7 tabs in the ribbon. However, each tab has several other commands within. The 7 tabs are:<\/p>\r\n\r\n
\r\n \t- Home<\/li>\r\n \t
- Insert<\/li>\r\n \t
- Page Layout<\/li>\r\n \t
- Formulas<\/li>\r\n \t
- Data<\/li>\r\n \t
- Review<\/li>\r\n \t
- View<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n
<\/i><\/i>How does the freeze pane help us in excel?.<\/a><\/h4>\r\n<\/div>\r\n\r\n\r\nThe 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.<\/p>\r\n\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n
\r\n\r\n<\/i><\/i>How do you apply the freeze pane to a cell?<\/a><\/h4>\r\n<\/div>\r\n\r\n\r\nSelect the cell which you want to lock up so that it could be visible on the sheet even if you scroll down. Then follow the path:<\/p>\r\n
Select View -> Go to Freeze Panes -> Choose Freeze Panes.<\/p>\r\n\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n
\r\n\r\n<\/i><\/i>What are the forms in which protection can be applied to an excel?<\/a><\/h4>\r\n<\/div>\r\n\r\n\r\nBy using the following techniques, we can enable security to Excel.<\/p>\r\n\r\n
\r\n \t- Via password to open a workbook<\/li>\r\n \t
- Against the manipulations being done on the worksheet.<\/li>\r\n \t
- Protecting the window positions\/ sizes from getting modified.<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n
<\/i>
- \r\n \t
- Windows<\/li>\r\n \t
- macOS<\/li>\r\n \t
- Android<\/a><\/li>\r\n \t
- iOS<\/a><\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n
\r\n\r\n<\/i><\/i>Name some important features of Microsoft Excel.<\/a><\/h4>\r\n<\/div>\r\n
\r\n\r\nThe most important features one would notice in the Microsoft Excel are:<\/p>\r\n\r\n
- \r\n \t
- Graphing tools<\/li>\r\n \t
- Visual Basic<\/li>\r\n \t
- Calculations are done using predefined functions<\/li>\r\n \t
- Pivot tables, etc.<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n
<\/i><\/i>Name some characteristics of Microsoft Excel.<\/a><\/h4>\r\n<\/div>\r\n
\r\n\r\nHere are the few characteristics of Microsoft Excel.<\/p>\r\n\r\n
- \r\n \t
- Workbooks, worksheets to arrange the data.<\/li>\r\n \t
- Rows and columns making work easier.<\/li>\r\n \t
- Pre-defined functions like count, sum, subtotal, date, etc. make computations easier.<\/li>\r\n \t
- A supportive hand to microprogramming through the application, Visual Basic.<\/li>\r\n \t
- Filters, tables, and graphs make data visualization and understanding easy.<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n
<\/i><\/i>Name the languages and tools used in developing Microsoft Excel.<\/a><\/h4>\r\n<\/div>\r\n
\r\n\r\n- \r\n \t
- C#<\/li>\r\n \t
- C++<\/a><\/li>\r\n \t
- Microsoft Foundation Class Library<\/li>\r\n \t
- .NET<\/a> Framework<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n
\r\n\r\n<\/i><\/i>List the file formats Microsoft Excel uses.<\/a><\/h4>\r\n<\/div>\r\n
\r\n\r\n- \r\n \t
- Excel Workbook – .xlsx<\/li>\r\n \t
- Excel Macro-Enabled Workbook for code – .xlsm<\/li>\r\n \t
- Excel Binary Workbook – .xlsb<\/li>\r\n \t
- Template – .xltx<\/li>\r\n \t
- Template for code – .xltm<\/li>\r\n \t
- Excel 97- Excel 2003 Workbook – .xls<\/li>\r\n \t
- Excel 97- Excel 2003 Template .xlt<\/li>\r\n \t
- Microsoft Excel 5.0\/95 Workbook – .xls<\/li>\r\n \t
- XML Spreadsheet 2003 – .xml<\/li>\r\n \t
- XML Data – .xml<\/li>\r\n \t
- Excel Add-In – .xlam<\/li>\r\n \t
- Excel 97-2003 Add-In – .xla<\/li>\r\n \t
- Excel 4.0 Workbook – .xlw<\/li>\r\n \t
- Works 6.0-9.0 spreadsheet – .xlr, etc.<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n
<\/i><\/i>Which excel type is the smallest of all?<\/a><\/h4>\r\n<\/div>\r\n
\r\n\r\nThe Excel Binary Workbook<\/strong> with an extension of .xlsb<\/strong> is considered as the smallest one among all the supportive extensions.<\/p>\r\n\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n
\r\n\r\n<\/i><\/i>Tell us a few ways you use to reduce the size of an excel.<\/a><\/h4>\r\n<\/div>\r\n
\r\n\r\nHere are a few ways using which we can reduce the size of Excel.<\/p>\r\n\r\n
- \r\n \t
- Compress the size of images.<\/li>\r\n \t
- Remove the extra or hidden spreadsheets.<\/li>\r\n \t
- Remove conditional formatting<\/li>\r\n \t
- Clear data formatting.<\/li>\r\n \t
- Clear watches.<\/li>\r\n \t
- Remove rows and columns that are hidden or not needed.<\/li>\r\n \t
- Remove unnecessary function usages (formulas).<\/li>\r\n \t
- Converting the excels of other extensions to the .xlsb (binary) format.<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n
<\/i><\/i>How will you clear formatting in Excel? <\/a><\/h4>\r\n<\/div>\r\n
\r\n\r\nFirst 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:<\/p>\r\n
Home -> Editing group -> Clicking the arrow next to clear button<\/strong> -> selecting clear format <\/strong>from the dropdown. These are the commonly asked Excel Interview Questions and Answers <\/strong>for Freshers and Experienced candidates in an Interview.<\/p>\r\n\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n
\r\n\r\n<\/i><\/i>Define Macro.<\/a><\/h4>\r\n<\/div>\r\n
\r\n\r\nIn Excel, 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.<\/p>\r\n\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n
\r\n\r\n<\/i><\/i>What is the key that helps in debugging the formulas, quickly?<\/a><\/h4>\r\n<\/div>\r\n
\r\n\r\nIn Microsoft Excel, selecting a function and clicking the F9 key<\/strong> on the keyboard helps in checking the formulas and debugging them, quickly.<\/p>\r\n\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n
\r\n\r\n<\/i><\/i>What does the F12 key do in Excel?<\/a><\/h4>\r\n<\/div>\r\n
\r\n\r\nIn 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 \u201cSave as\u201d<\/strong> button.<\/p>\r\n\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n
\r\n\r\n<\/i><\/i>Explain the basic cells present in Microsoft Excel.<\/a><\/h4>\r\n<\/div>\r\n
\r\n\r\nEach 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 with a unique address, and as the columns are named as A, B, C\u2026 while rows are assigned with labels 1, 2, 3\u2026, by default, the first cell\/junction\u2019s address is A1, the next one is B1, and so on\u2026<\/p>\r\n\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n
<\/a><\/div>\r\n\r\n\r\n<\/i><\/i>Coming to the Excel formulas, What is their order of precedence of operations?<\/a><\/h4>\r\n<\/div>\r\n
\r\n\r\nExcel follows the \u2018PEMDAS\u2019 rule, i.e., (We can use BODMAS rule too)<\/p>\r\n\r\n
- \r\n \t
- 1st priority to the Parentheses \u2018()\u2019<\/li>\r\n \t
- 2nd priority to the Exponent \u2018^\u2019<\/li>\r\n \t
- 3rd and equal priority to the Division \u2018\/\u2019 and the Multiplication \u2018*\u2019<\/li>\r\n \t
- 4th and equal priority to the Addition \u2018+\u2019 and the Subtraction \u2018-\u2019<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n
<\/i><\/i>Is it possible to rearrange the cells in Excel?<\/a><\/h4>\r\n<\/div>\r\n
\r\n\r\nIn Excel, we can perform the insertion and deletion operations in the following ways<\/p>\r\n\r\n
- \r\n \t
- Shifting cells to the right<\/li>\r\n \t
- Shifting cells up<\/li>\r\n \t
- Shifting cells to left<\/li>\r\n \t
- Shifting cells down<\/li>\r\n \t
- Inserting\/Deleting entire row<\/li>\r\n \t
- Inserting\/Deleting entire column<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n
<\/i><\/i>List the data formatting ways for cells, in Excel.<\/a><\/h4>\r\n<\/div>\r\n
\r\n\r\nIn excel, the cells can be formatted using the main attributes and their elements such as:<\/p>\r\n\r\n
- \r\n \t
- Number<\/li>\r\n \t
- Alignment<\/li>\r\n \t
- Font<\/li>\r\n \t
- Border<\/li>\r\n \t
- Fill<\/li>\r\n \t
- Protection<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n
<\/i><\/i>How to add a comment in a cell, in Excel.<\/a><\/h4>\r\n<\/div>\r\n
\r\n\r\nIn Excel, to add a comment to a cell, all you need to do is to give a right-click on the cell and then select the \u2018insert the comment\u2019 option. You can always edit or delete the comment you entered.<\/p>\r\n\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n
\r\n\r\n<\/i><\/i>How can the cell with a comment differ from the cell with the data?<\/a><\/h4>\r\n<\/div>\r\n
\r\n\r\nTo 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.<\/p>\r\n
The cell with the red mark in the L column represents that the cell has a comment.<\/p>\r\n\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n
\r\n\r\n<\/i><\/i>Define Ribbon.<\/a><\/h4>\r\n<\/div>\r\n
\r\n\r\nIn Microsoft Excel, 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<\/strong> for the fresher candidate in the Interview.<\/p>\r\n\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n
\r\n\r\n<\/i><\/i>What are the major components you find in the ribbon?<\/a><\/h4>\r\n<\/div>\r\n
\r\n\r\nMainly, there are 4 basic components present in the ribbon, namely:<\/p>\r\n\r\n
- \r\n \t
- Tabs<\/li>\r\n \t
- Dialog launchers<\/li>\r\n \t
- Groups<\/li>\r\n \t
- Command Buttons<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n
<\/i><\/i>Name the tabs that are present in the ribbon.<\/a><\/h4>\r\n<\/div>\r\n
\r\n\r\nOn one sight, we find 7 tabs in the ribbon. However, each tab has several other commands within. The 7 tabs are:<\/p>\r\n\r\n
- \r\n \t
- Home<\/li>\r\n \t
- Insert<\/li>\r\n \t
- Page Layout<\/li>\r\n \t
- Formulas<\/li>\r\n \t
- Data<\/li>\r\n \t
- Review<\/li>\r\n \t
- View<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n
<\/i><\/i>How does the freeze pane help us in excel?.<\/a><\/h4>\r\n<\/div>\r\n
\r\n\r\nThe 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.<\/p>\r\n\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n
\r\n\r\n<\/i><\/i>How do you apply the freeze pane to a cell?<\/a><\/h4>\r\n<\/div>\r\n
\r\n\r\nSelect the cell which you want to lock up so that it could be visible on the sheet even if you scroll down. Then follow the path:<\/p>\r\n
Select View -> Go to Freeze Panes -> Choose Freeze Panes.<\/p>\r\n\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n
\r\n\r\n<\/i><\/i>What are the forms in which protection can be applied to an excel?<\/a><\/h4>\r\n<\/div>\r\n
\r\n\r\nBy using the following techniques, we can enable security to Excel.<\/p>\r\n\r\n
- \r\n \t
- Via password to open a workbook<\/li>\r\n \t
- Against the manipulations being done on the worksheet.<\/li>\r\n \t
- Protecting the window positions\/ sizes from getting modified.<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n
<\/i>
- iOS<\/a><\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n