A Guide to Top 50 Excel Interview Questions & Answers in 2024
Updated on Nov 14, 2024 | 12 min read | 6.5k views
Share:
For working professionals
For fresh graduates
More
Updated on Nov 14, 2024 | 12 min read | 6.5k views
Share:
Excel is one of the most powerful tools used across various industries. For simple calculations or building meticulous reports, more than 80% of global businesses reportedly use Excel in some way or another, making it an office essential.
On that note, here are the top 50 MS Excel interview questions and answers for freshers and experienced candidates to help them land their dream job.
The following list highlights some basic MS Excel interview questions and answers, specifically for beginners, to help them prepare for their interview!
Ans: Microsoft Excel can be described as an electronic spreadsheet or computer application that stores information, or data, in the form of a table. It is compatible with various operating systems such as Windows, Android, IOS, and macOS.
Ans: Here are some of the top features of Microsoft Excel
Ans: To put it simply, cells refer to the area where you can store the data. It is situated at the intersection of a row and a column, and a single excel sheet comprises 1,048,576*16.384 cells.
Ans: A cell address refers to the address that is primarily used to identify a particular cell in a worksheet. It is a combination of the row number and the column alphabet.
Ans: A spreadsheet can be defined as a collection of cells, with the help of which you can manage any data. It consists of various rows and columns
Learn data science courses online from the World’s top Universities. Earn Executive PG Programs, Advanced Certificate Programs, or Masters Programs to fast-track your career.
Ans: Yes, Excel allows the addition of multiple cells for the user’s convenience. The process is fairly straightforward. You have to simply click on the cell you want to add to and then select Insert from the cell menu. You will be presented with various options, such as Shift cells down or Shift cells right, among others. Make your selection and click on Ok.
Ans: There are primarily six format cell options that can be used to format a cell. These include-
Ans: Yes, you can enter comments into a cell by following the process below.
You can also delete comments by right-clicking on the cell and selecting the Delete Comment option from the cell menu.
Ans: Ribbon can be defined as a replacement for the toolbar and menu in Excel. It is usually present right at the top of the screen and can be accessed via CTRL+F1. The primary function of Ribbon is to help users operate some of the most important functions directly.
Ans: To restrict someone from copying a cell of your worksheet, follow the below steps.
Ans: Excel provides three different types of report formats to their users, namely, Compact, Tabular and Report.
Ans: Formula in Excel sheet is basically used to simplify complex calculations. Furthermore, with the help of Formula, you can automatically calculate a number replaced by another number or digit.
Ans: Freeze Panes allow users to view the headings of rows or columns even after scrolling down a long way in the sheet. In order to activate this feature, you must first select the rows and columns you wish to freeze. It is usually the top row or the first column. Following this, go to the View tab, where you can find the Freeze Panes option. You will be presented with three options. Click on any one according to your preference.
Formula | Function |
In Excel, Formula is used to accomplish any mathematical calculation according to the user’s choice. | Function, on the other hand, is a predefined formula that is in-built into Excel. |
It is time-consuming since the user has to manually type out a formula every time they need to calculate. | With the help of Function, you can simplify complicated calculations quickly and comfortably. |
Ans: Yes, you can add a filter in a spreadsheet with the help of Ctrl+Shift+L. The filter allows you to view only specific data without making any alterations to the entire database.
Ans: A column in Excel can be resized in two ways,
Ans: A Pivot Table is one of the many tools offered by Excel to their users, with the help of which you can analyse, calculate and summarise large amounts of data in a simple and intelligent manner. It helps you to view the current trends, comparisons and patterns in your data.
Ans: In order to create a Pivot Table in Excel, you must follow three simple steps.
Ans: LOOK UP function is mainly used when you want to return a value from an array.
Ans: You can protect your workbook im Excel in three ways.
Ans: You can create shortcuts with the help of the Quick Access Toolbar, which is present right above the Home button.
Ans: In order to disable this function, you need to click on the Dropdown menu in the Row Labels or Column Labels. Following this, you will get to see More Sort Options. Click on that, and the Sort dialogue box will appear. From there, click on More Options, and unselect Sort Automatically.
Ans: What If condition is basically used to change data in Excel formulas so that they can generate different answers.
Ans: Macro in Excel is an action or a set of instructions that can be recorded or executed as often as we want.
Ans: The five types of COUNT functions in Excel are, namely,
Ans: In order to create a hyperlink, you first need to select the cell or the text, press CTRL+ K. Fill in the dialogue box with the address, and click on OK.
Ans: Slicer in Excel is used to filter the Pivot Tables quickly and efficiently. In order to insert a Slicer, you need to first click on any cell present inside the pivot table. Following this, go to Analyze, select Filter, and finally, Insert Slicer.
Ans: Asterix (*), Question mark (?), and Tilde (~) are the three wildcards in Excel that can be used in formulas.
Ans: The SUM function in Excel adds up all the numbers in a defined cell range. For example, =SUM(A1:G1) adds all the numbers within the range of A1 to G1.
Ans: Similar to the SUM function, SUMIF only works when a certain condition is met. For example, =SUMIF(E1:G1, ‘<10) adds all the numbers that are less than ten within the range of E1 to G1.
Ans: We can use ExcelLibrary, an open-source, small C# library, to create an Excel file in C# without installing Microsoft Office. Another way can be via EPPLus, which also provides support for Pivot Tables.
Ans: Yes, we can fetch the current date in Excel using the TODAY function, which helps to return the current date in the Excel date format. The syntax for the same is TODAY().
Ans: IF function is mainly used in Excel to check whether a certain condition is true or false. If it is true, it will generate the result accordingly, and if it is false, it will give a different result.
Ans: Using the F8 key will help to debug a VBA code line by line. Alternatively, you can also create a breakpoint for the termination of the execution.
Function | Subroutine |
In VBA, a function is used to return the value of the task it performs. | Subroutine, on the other hand, does not return the value of the task it is performing. |
Ans: You can pass arguments as a reference or value to VBA functions.
Ans: VLOOKUP function is used to return a value from different columns present in the same row. The formula is
=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
Ans: Relative Cell Referencing refers to the exact position of a cell that contains a value or a formula. It automatically changes when a formula is copied to another cell.
Ans: Unlike Relative Cell Referencing, Absolute reference denotes a specific address. This means they will always remain constant, no matter where they are copied.
Ans: Yes, simply select the Worksheet Tab, and then click on ‘Select all Sheets Tab’. This way, the same formatting will be applied to every workbook sheet.
Ans: PEMDAS refers to the order of operations in Excel, namely,
Ans: The SUBSTITUTE function helps to substitute any old text with new text in a string. REPLACE function helps replace a part of the text string with another text set.
Ans: Using CTRL+ PgUp will navigate you to the previous sheet. To move to the next sheet, you need to press CTRL + PgDown.
Ans: The Name Box in Excel helps to return to a specific area in a worksheet. Simply fill in the name box with the specific address or range name.
Ans: PivotTableUpdate, present in the worksheet, is typically used to check whether the pivot table is modified or not.
Ans: The three types of What IF analysis tools are as follows
Ans: As the name suggests itself, HLOOKUP is used to perform a horizontal lookup. The syntax for the same is
HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])
You can also check out our free courses offered by upGrad in Management, Data Science, Machine Learning, Digital Marketing, and Technology. All of these courses have top-notch learning resources, weekly live lectures, industry assignments, and a certificate of course completion – all free of cost!
Ans: The AVERAGE function is typically used to calculate the average of data in Excel. The syntax for the same is
AVERAGE(number1, number2, …)
Ans: The FV function is generally used to calculate compound interest in Excel. It follows the FV(rate, nper, pmt, pv, type) syntax.
Ans: Yes, in order to achieve a result other than the Sum, you need to right-click on the Sum of Amount Values. Following this, select the Value Field Setting, choose any value from the given list and then press OK.
With this, we come to an end of the top 50 Excel interview questions and answers. Learning Excel has become an utmost necessity in today’s world. Especially if you’re aiming to become a part of the rapidly expanding Data Science industry. Data science heavily leverages Excel to seek assistance for its data-driven approaches. Hence knowing your way through Excel can significantly grow your chances of success in Data Science.
While learning Excel plays an imperative role, having the right credentials and skill set is equally significant to bag a Data Science role. upGrad’s Master of Science in Data Science program can be that much-needed push to your career demands to kickstart a successful Data Science journey.
Offered under the guidance of expert faculty at Liverpool John Moores University, this course enables candidates to hone in-demand skills such as Deep Learning, Data Analytics, Natural Language Processing, Data Engineering and more. So, what are you waiting for?
Enrol now and start your journey to success with upGrad!
Get Free Consultation
By submitting, I accept the T&C and
Privacy Policy
Start Your Career in Data Science Today
Top Resources