Data Executive Interview Questions and Answers for Freshers

Yes, I am familiar with formulas in Excel.

• I am proficient in using basic formulas such as SUM, AVERAGE, and IF statements.

• I can also work with more advanced formulas like VLOOKUP, INDEX-MATCH, and CONCATENATE.

• I have experience creating complex formulas to analyze data and generate reports.

• I am comfortable using functions like COUNTIF, SUMIF, and IFERROR to manipulate data in Excel.

Yes, I am proficient in using MS Office tools such as Word, Excel, and PowerPoint.

• Proficient in using MS Word for creating documents

• Skilled in using MS Excel for data analysis and calculations

• Experienced in creating presentations using MS PowerPoint

Excel formulas are used to perform calculations and manipulate data in Excel spreadsheets.

• Use SUM formula to add up a range of cells: =SUM(A1:A10)

• Use IF formula to perform conditional calculations: =IF(A1>10, "Yes", "No")

• Use VLOOKUP formula to search for a value in a table: =VLOOKUP(A1, B1:C10, 2, FALSE)