gNAP Services Interview Questions and Answers

Q1. What is VBA in Excel
Ans. 
VBA in Excel stands for Visual Basic for Applications, a programming language used to automate tasks and create custom functions in Excel.
• VBA allows users to write macros to automate repetitive tasks in Excel.

• It can be used to create custom functions and procedures to enhance Excel's functionality.

• VBA code can be written directly within Excel's Visual Basic Editor.

• Example: Writing a VBA macro to automatically format da...read more
Answered by AI
Add your answer
Q2. What is Vlookup and Hlookup
Ans. 
Vlookup and Hlookup are Excel functions used to search for a value in a table and return a corresponding value.
• Vlookup stands for vertical lookup and searches for a value in the first column of a table and returns a value in the same row from a specified column.

• Hlookup stands for horizontal lookup and searches for a value in the first row of a table and returns a value in the same column from a specified row.

• Both funct...read more
Answered by AI
Add your answer

Q1. What are the difference between the fact and dimension tables
Ans. 
Fact tables store quantitative data for analysis, while dimension tables store descriptive attributes related to facts.
• Fact tables contain measurable, quantitative data (e.g., sales revenue, quantity sold).

• Dimension tables contain descriptive attributes (e.g., product name, customer details).

• Fact tables often have foreign keys linking to dimension tables.

• Example: A sales fact table might include total sales, while a pr...read more
Answered by AI
Add your answer
Q2. What kind of filters we have differentiate it
Ans. 
Filters in Power Apps help to refine and differentiate data based on specific criteria.
• 1. **Text Filters**: Use 'StartsWith', 'EndsWith', or 'Search' to filter text fields. Example: Filter by names starting with 'A'.

• 2. **Numeric Filters**: Apply conditions like '>', '<', or '=' for numeric fields. Example: Filter records where age > 30.

• 3. **Date Filters**: Use date functions like 'Today()', 'DateAdd()' to filt...read more
Answered by AI
Add your answer

Q1. What is IFRS 15 ?
Ans. 
IFRS 15 is a global accounting standard that outlines how revenue from contracts with customers should be recognized.
• IFRS 15 replaces all existing revenue recognition guidance under IFRS

• It provides a single, principles-based five-step model for revenue recognition

• The standard applies to all contracts with customers, except for leases, insurance contracts and financial instruments

• The core principle of IFRS 15 is that re...read more
Answered by AI
Add your answer
Q2. What is Varinace anaylsis
Ans. 
Variance analysis is a statistical technique used to identify the difference between planned and actual performance.
• It involves comparing actual results to budgeted or expected results.

• It helps in identifying the reasons for the difference between actual and planned performance.

• It is commonly used in financial analysis to evaluate the performance of a company.

• Variance analysis can be used to identify areas where cost s...read more
Answered by AI
Add your answer

Basic Aptitude and IQ test

Q1. You explain everything you know and have learnt or what projects you have worked on and the experience you have.
Add your answer