answers to indeed spreadsheets with microsoft excel

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. Common Excel interview questions and answers

Answers to indeed spreadsheets with microsoft excel