MS Excel is the most popular Microsoft spreadsheet app all over the world, with billions of users using it to perform several functions. Most offices hence rely on the application for many day-to-day tasks.
Consequently, every job nowadays requires you to have functional knowledge of Excel.
Anytime you are applying for any job that needs any form of data entry, analysis, or calculations; chances are you will be required to have, at least, a basic knowledge of MS Excel.
Below are 7 Common MS Excel Questions Interviewer Asks, and which you should expect at an interview.
- What is MS Excel and what core functions does it perform?
Microsoft Excel is a spreadsheet app which you can use to record, manipulate, analyze and store data. The sections in which data is stored are called cells. Each cell is uniquely identified, depending on its column and row value. The cells can be manipulated arithmetically using core and complex functions and operations. Besides its standard spreadsheet feature, MS Excel provides programming support through VBA (Visual Basic Applications), as well as extensive charting and graphics capabilities.
- What do you know about Excel Pivot table?
Pivot tables are Excel’s powerful features that allow a user to extract the significant from a large detailed data set. It provides an excellent way of summarizing, analyzing, exploring and presenting data. It is also very simple to create. However, when you add either a new row or new column to any of the source data, the pivot table is not updated because the lately added data lies outside the range of the underlying data of the Pivot table. You can overcome this limitation by either manually refreshing the source data or providing a dynamic range to the pivot table. To provide a dynamic range create a Named range by use of Offset function, and use the Named range to base the pivot table.
- What role do Dashboards play in MS Excel?
Dashboards track metrics, KPIs, among other data points in a single visual, central place. Therefore, besides giving you a high-level view of work, dashboards help you make fast decisions while at the same time helping you keep everyone updated. Its visual nature gives you an at-a-glance view of performance in real-time and simplifies complex data. They are composed of charts, tables, numbers, and gauges. You can use dashboards in spreadsheets for a variety of purposes in a wide range of industries including making marketing dashboards, financial dashboards, project dashboards, and much more.
- How can you add cells, rows, and columns in Excel?
To insert a row, column or cell in Excel, right click on what you would like to add to and select Insert from the menu. The insert menu enables you to add a cell, row or column, and shifts the cell affected down or right. You can add a comment to the newly added cell to clarify any formula used, its purpose, or leave notes for other users by right-clicking on the cell and, choosing insert comment from the resulting menu.
- Explain some data formats in MS Excel
The most common data formats are currency, numbers, and dates. The currency format is a specialized number presentation that stores data in a particular currency form. Number format stores info as a number, and can include decimal values as well as separators for big numbers exceeding 999. Date format, on the other hand, allows you to store data as dates for purposes of calculations and formulas.
- What is the Ribbon as used in MS Excel?
A Ribbon refers to a section that runs along the top of the app containing toolbars and menu items available in the Excel. It has various tabs that in turn include groups of commands to be used in the application. You can maximize or minimize the Ribbon by just pressing CTRL F1.
- How can you use MS Excel to analyze a group of data?
MS Excel allows us to create various types of charts, such as column and line charts, or even adding a small graph. You can also create a Pivot Table, insert totals quickly, apply table styles or even use conditional formatting to come up with useful features of the data you are analyzing. For instance, you can quickly label all values less than a particular value, say average, in your data by using the IF function. This feature enables you to perform analysis of information in the shortest time possible.
These are some of the common Excel interview questions that you are better off knowing if you have mentioned as one of your strong skills.