Knowledge of macros and VBA language make you a competitive applicant because you can automate frequently occurring tasks.Įxample: “Yes, I know macros and VBA language. Grab this opportunity to showcase your intellectual, analytical and coding skills to the interviewer. Never answer such advanced-technical questions in one word. I used Pivot tables to help the FMCG company decode the age group and states where their cold cream performed the best.” They ran a campaign from November to February and handed the data set to me for giving useful insights. The FMCG company wanted to know the age group and states where their new cold cream made most sales during the winter. I have vast experience using pivot tables as a data analyst with an FMCG company in New Delhi. It extracts important information from complex and vast data sets. It summarises, reorganises, aggregates, counts, groups, sorts and computes an extensive data set. The answer you give showcases your resourcefulness with Excel.Įxample: “Pivot tables provide an interactive view of a large data set. Pivot table is a critical concept and often asked by interviewers. As the question gauges your Excel familiarity, you increase your chance of cracking the interview when you explain how you used it in your previous job. Interview questions that are direct and ask whether you know something is an excellent opportunity to give examples from your experience. Related: How To Use The IF Function In Excel (With Helpful Steps) 4. Select the 'Freeze Panes' option and choose an option that suits your requirement.” For freezing a pane, select the column header or row header and click on the 'View' tab. However, you cannot freeze columns and rows if your worksheet is protected. These frames do not scroll and the other areas remain unaffected. It lets you keep the row and column heading locked when scrolling up and down to the other parts of the worksheet. It is one of the basic excel interview questions requiring excellent foundational knowledge.Įxample: “Freeze pane allows locking of the column or row headers. As you scroll down the excel sheet, the heading disappears and this could make your analysis wrong. Through this question, an interviewer wants to understand how you deal with a large table of information under one heading. Your job may require crunching thousands of numbers for analysis. Why is the freeze pane important in Microsoft Excel? Related: Essential MS Excel Interview Questions For A Data Analyst 3. However, COUNTA does not count blank cells.” COUNTA function counts all the cells irrespective of whether it has string values or special characters. COUNTBLANK function counts only the number of blank cells. It does not count blank cells, cells with special characters and string value. Interviewers ask this question to understand your knowledge of Excel functions as they might help you in the job.Įxample: “The COUNT function in Excel counts the number of cells containing a numeric value. Answering this question showcases your Excel and technical prowess. Explain the difference between COUNT, COUNTBLANK and COUNTA?Īpart from crunching numbers, you may have to count cells with and without values for in-depth analysis. This was something not expected from me and I could provide valuable insights to the management.” 2. This gave me insights into the number of months required for the on-hand inventory to finish. It helped me save so much time that I could calculate the months on hand for each product. Using VLOOKUP, I could achieve the goal successfully without wasting too much time. This helped me develop creative solutions for slow-moving inventory and ensured that I could manage the faster-moving inventory without facing issues. After each month, I had to go through the on-hand inventory and inventory usage data and separate it using the product's code. It is an essential function because it provides valuable insights and relationships between the data set.Īs a purchasing and inventory supervisor, I worked with Excel to optimise inventory quantities and levels to meet customer demand. When answering such advanced concepts, always use your personal experience to showcase your knowledge and familiarity with the concept.Įxample: “VLOOKUP helps find data in a large spreadsheet using the lookup value in another spreadsheet. VLOOKUP is an important Excel function and is widely used across different job roles. Questions that are directed toward a formula or function help the interviewer understand your proficiency with Excel. Here are 9 common excel interview questions with example answers: 1. Upload your resume on Indeed Let employers find you when you create an Indeed Resume Common Excel interview questions and answers
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |