EF Information Systems Accountant Interview Questions and Answers

Q1. Why should you hire mee
Add your answer

Q1. What is VLOOKUP?
Ans. 
VLOOKUP is a function in Excel that searches for a value in the first column of a table and returns a value in the same row from a specified column.
• Used to retrieve data from a specific column in a table based on a lookup value.

• Syntax: VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]).

• Example: =VLOOKUP(A2, B2:D10, 3, FALSE) looks for the value in A2 within the first column of B2:D10 and returns the corr...read more
Answered by AI
Add your answer
Q2. How do you calculate the percentage in Excel?
Ans. 
Calculating percentages in Excel involves simple formulas using cell references to derive the desired percentage value.
• Use the formula: =Part/Total to calculate the percentage.

• Example: To find 20% of 50, use =20/100*50.

• To calculate percentage change: =((New Value - Old Value)/Old Value)*100.

• Example: For a price increase from $100 to $120, use =((120-100)/100)*100.
Answered by AI
Add your answer
Q3. What is a pivot table?
Ans. 
A pivot table is a data processing tool used to summarize and analyze data in spreadsheets.
• Allows users to reorganize and summarize selected columns and rows of data to obtain a desired report.

• Can perform calculations like sums, averages, and counts on data fields.

• Example: Summarizing sales data by product category and region.

• Facilitates quick data analysis without altering the original dataset.

• Interactive features all...read more
Answered by AI
Add your answer

The test was good and paced

Q1. What is an array
Add your answer
Q2. How it is used
Add your answer

Q1. Give ur introduction in star format
Ans. 
Experienced accountant with a strong background in financial analysis and reporting.
• Over 5 years of experience in accounting roles

• Proficient in financial statement preparation and analysis

• Skilled in budgeting and forecasting

• Strong knowledge of GAAP and financial regulations

• Excellent communication and problem-solving skills
Answered by AI
Add your answer

Q1. Basics introduction your past experience about you all over
Add your answer
Q2. Tell me about yourself Basics about iit and neet
Ans. 
I have a background in IIT and NEET exams.
• I have successfully cleared the IIT entrance exam and secured admission in a prestigious IIT.

• I have also appeared for the NEET exam and have a good understanding of medical entrance exams.

• My experience with IIT and NEET has given me a strong foundation in problem-solving, critical thinking, and time management.

• I have gained valuable knowledge in subjects like physics, chemistry...read more
Answered by AI
Add your answer