In case you’re searching for Excel Interview Questions and answers for Experienced or Freshers, you are at the correct place. There is a parcel of chances from many presumed organizations on the planet. The Excel advertise is relied upon to develop to more than $5 billion by 2020, from just $180 million, as per Excel industry gauges. In this way, despite everything you have the chance to push forward in your vocation in Excel Development. Gangboard offers Advanced Excel Interview Questions and answers that assist you in splitting your Excel interview and procure dream vocation as Excel Developer.
Best Excel Interview Questions and Answers
Do you believe that you have the right stuff to be a section in the advancement of future Excel, the GangBoard is here to control you to sustain your vocation. Various fortune 1000 organizations around the world are utilizing the innovation of Excel to meet the necessities of their customers. Excel is being utilized as a part of numerous businesses. To have a great development in Excel work, our page furnishes you with nitty-gritty data as Excel prospective employee meeting questions and answers. Excel Interview Questions and answers are prepared by 10+ years of experienced industry experts. Excel Interview Questions and answers are very useful to the Fresher or Experienced person who is looking for the new challenging job from the reputed company. Our Excel Questions and answers are very simple and have more examples for your better understanding.
In today’s trend, though we have tons of software and tools to perform various technical activities, still we make use of a few basic applications. One of them is Microsoft apps. Yes, MS Word, MS Excel, and MS PowerPoint are the best commonly utilized apps in various organizations and in different small scale and large scale businesses. Having a decent knowledge on MS Excel would help most of the candidates so perform activities on various reports required for business results. There are many jobs that require excel to be a major part daily. This document will provide you a brief idea of basic excel questions and answers.
Q1) Define Microsoft Excel
Answer: Microsoft Excel is said to be a spreadsheet application or an electronic worksheet that is helpful for storing, analyzing data, manipulating data, and organizing reports.
Q2) Provide the different types of data formats available in Excel
Answer: Accounting, Date, Percentage, Number, and Text are the different data formats available in Excel.
Q3) Define Format Painter
Answer: If you want to copy the format of a cell, text, image etc and apply on another text, the Format painter is used.
Q4) Define cells in Excel
Answer: The place where we store the data is called a cell.
Q5) Why to use comments in Excel?
Answer: Comments in Excel are used to describe a formula given in a cell and leave notes for the users for any extra/special information.
Q6) How will you add comments in Excel?
Answer: To add comments in Excel, perform the below actions:
- Right-click on the cell
- Select “Insert” from the toolbar
- Click “Comment”. Comment box appears. You can enter the required information here.
Q7) List out the charts available in MS Excel
Answer: Pie, Bar, Scatter, Line are some of the available charts in MS Excel, which is useful to provide graphical representation of a report/analysis.
Q8) Define Ribbon in Excel
Answer: A specific area that runs at the top of the application, comprised of toolbar and menu items is called a Ribbon. There are various tabs available in ribbon containing a set of commands to use in the application.
Q9) What is the shortcut key to hide the ribbon in Excel?
Answer: Ctrl+F1 is the shortcut key to hide the ribbon in Excel
Q10) How will you protect a sheet in Excel?
Answer: To protect the worksheet in Excel, navigate to Menu bar -> Review -> Protect sheet -> Password. Provide a password to protect the worksheet and avoid copying the data.
Q11) What is the function used to get the total of columns and rows in Excel?
Answer: To get the total of columns and rows in Excel, use the function ‘SUM’.
Q12) How many report formats are available in Excel?
Answer: Report, Compact and Tabular are the formats available in Excel.
Q13) What is the use of ‘IF’ function in Excel?
Answer: To verify whether the conditions are true or false, the function ‘IF’ is used in Excel.
Q14) Give the advantage of Look Up function in Excel
Answer: To return a value for array, you can use the function Look Up
Q15) What is the shortcut key to delete the blank columns?
Answer: To delete the blank columns in Excel, press Ctrl+-.
Q16) How many rows and columns are present in Microsoft Excel 2013?
Answer: There are 1048576 rows and 16384 columns in Microsoft Excel 2013.
Q17) Provide the syntax for VLookUp
Answer: The syntax for VLookUp is given below:
Q18) How the errors are highlighted in Excel?
Answer: The different errors displayed in Excel are #REF!, #DIV/0!, #NUM, #N/A, #NAME, and #VALUE!.
Q19) While evaluating formulas in Excel, what is the operations order used?
Answer: PEMDAS is the acronym given for the order of operations in Excel.
- P – Parenthesis/ Brackets
- E – Exponentiation (^)
- M – Multiplication
- D – Division
- A – Addition
- S – Subtraction
Q20) Provide the major functions performed in Excel
Answer: The major functions performed in Excel are SUMIF, INDEX/MATCH, VLOOKUP, IFERROR and COUNTIF.
Q21) In excel, what is the function used to get the length of a string?
Answer: Use the function ‘LEN’ to find the text string length.
Q22) Describe volatile functions
Answer: When there is a modification performed in the worksheet, make use of volatile function to recalculate the formula repeatedly.
Q23) Provide the list of volatile formulas
Answer: TODAY(), NOW(), and RAND() are the highly volatile formulas. INDIRECT(), OFFSET(), INFO(), and CELL() are the other volatile formulas.
Q24) Provide the shortcut for find and replace
Answer: Ctrl+F is the shortcut key to open the find tab and Ctrl+H is the shortcut to open find and replace tab.
Q25) How will you open the spellcheck dialog box using a shortcut key?
Answer: To open a spell-check dialog box, the shortcut key is F7.
Q26) To perform auto-sum on the rows and columns, what is the shortcut?
Answer: ‘ALT=’ is the shortcut to perform auto-sum on the rows and columns.
Q27) How will you open a new Excel workbook using a shortcut key?
Answer: Ctrl+N is the shortcut to open a new Excel workbook.
Q28) Can you give us the different sections in a Pivot Table?
Answer: Filter Area, Columns Area, Values Area, and Rows Area are the sections available in Pivot Table.
Q29) Define Slicer in Excel
Answer: The 2010 version Excel has the feature called Slicer in Pivot Table. With the help of Slicer in Pivot table, users can filter the data while selecting one or more options in slicer box.
Q30) Who designed the Bullet Chart?
Answer: Stephen Few is a dashboard expert who designed Bullet Charts and this chart has been extensively acknowledged as one of the topmost graphical representation to show the performance report.
Q31) What are the different types of data filter available in Excel?
Answer: Date filter, Text Filter and Number Filter are the different types of data filter available in Excel.
Q32) What are the popular methods to transpose a data set in Excel?
Answer: Using Transpose function and Paste Special Dialog Box are the two (2) methods to transpose a data set in Excel.
Q33) Is it possible to remove duplicates in Excel from a data set?
Answer: There is an in-built feature in Excel to remove duplicates from a data set. Steps to remove duplicates is given below:
Select Data -> Select ‘Data’ tab -> Click ‘Remove Duplicates’.
Q34) Provide the two macro languages available in MS Excel
Answer: Visual Basic Applications (VBA) and XLM are the two (2) macro languages available in MS Excel.
Q35) Mention the event used to check the status of a Pivot Table modification
Answer: Use the event ‘PivotTableUpdate’ to check the status of a Pivot Table modification in a worksheet.
Q36) What is the syntax of SUBSTITUTE function in Excel?
Answer: Syntax of SUBSTITUTE function in Excel:
‘SUBSTITUTE(text, oldText, newText, [instanceNumber])’
Q37) What is the syntax of REPLACE function in Excel?
Answer: Syntax of REPLACE function in Excel:
REPLACE(oldText, startNumber, NumberCharacters, newText)
Q38) What are the keys used to move to the previous worksheet in Excel?
Answer: The keys Ctrl + PgUp is used to move to the previous worksheet in Excel
Q39) What are the keys used to move to the next worksheet in Excel?
Answer: The keys Ctrl + PgDown is used to move to the previous worksheet in Excel
Q40) Which filter is used to analyse the list that is employed with database function?
Answer: Advanced Criteria Filter is used to analyse the list employed with database function.
Q41) What is the shortcut key to minimize the workbook?
Answer: The keys ‘Ctrl+F9’ is the shortcut key to minimize the workbook.
Q42) How will you cancel an entry using the shortcut key?
Answer: ‘Esc’ key is used to cancel the entry in Excel.
Q43) Will we be able to change the font and color of the multiple sheet tabs?
Answer: Yes, we can easily change the font and color of the sheet tabs in Excel.
Q44) What are the key elements to give a best dashboard?
Answer: The key elements such as Minimum distractions, visual presentation of information, easy to communicate, and provide useful data to the business stands out to be the best dashboard.
Q45) What are the new enhancements available in Excel latest version?
Answer: Slicers, Tables, IFERROR, Powerpivot, and Sparklines are the new enhancements available in Excel latest version.
Q46) Is it possible to close all the open excel files at a time?
Answer: Yes, it is possible to close all the open excel files at a time.
Q47) In Excel, what is Name Manager?
Answer: We give a name for a cell or a Range which is called Name Manager. Using the Name manager, Table gets managed.
Q48) Which symbol is used to lock or fix the reference?
Answer: The symbol ‘$’ is used to lock or fix the reference.
Q49) What is the advantage of Freeze panes in Excel?
Answer: If you want to lock a specific column or row, Freeze panes can be used.
Q50) Do you think we have unique address for each cell?
Answer: Yes, we have a unique address for each cell based on the value of the row and column.