And then excel had mostly questions on power query, power view, power pivot, data modelling,

There were questions in access on macros, forensic had questions on contrasting between
forensic vs statutory audit
Then on denial of service fraud, sector most prone to fraud all that
Then in tally there were questions on tds, TCS, income tax filing forms like matching challan and
all
And then on the bill of materials, manufacturing journal, stock transfer
BADIR framework
Then payroll extraction of provident report
13. What does transpose function do?
B. Data analysis and Excel
1. After text to column what is format of data?

2. In which group is data validation

3. What is inferential analysis?

4. How many V's in Big data?

5. What is the process of BADIR framework?

6. How many rows and columns in excel sheet?

7. Command to stop all macros.

8. What are the tabs in data validation dialogue box?

9. How to paste only cell value without formatting.

10. Tab not present on ribbon by default ( developer tab)

11. How to sort dates from April to March (there's a custom option for filter/sort)
12. Which of the following is not graphical representation:
a. Pivot chart

b. Chart

c. View

d. Pivot table

15. If cell A1 and A2 have the values 20,000 and 10,000 respectively. And A3 has formula
=(A1/A2). Which error will you get if you copy and paste the formula to cell B1?

Good afternoon sir,

I will just mention a few questions I remember:

A. Forensic Audit

1. Probability of fraud from corruption 1/3

2. What is fraud

3. TGTBT

4. Bank fraud

5. Fraud triangle

16. Symbol for concatenate?

14. Feature that enables using more than one criteria in pivot table
a. Slicer
b. Dicer
C. Cutter
D. Sliver

17. If we use trim function on "a ce ss" what will be the result:

a. "a cess"
b. "acess"
c. " ac ess"
18. Which function returns the serial number of the last day of the month before or after
a specified number of months?

A. Eomonth
B. Edited
C. Date
D. Datedif
20. Function returns a value or reference of the cell at the intersection of a particular row
and column in a given range?
A. Match
B. Index
C. Hookup
D. Vlookup

19. Which function to use to sum based on more than one criteria

A. Sumif
B. Sumifs
C. Sumproduct
D. Product

24. How many cells can you vary in scenario manager?

A. 8
B. 16
C. 32
D. 38

21. When using DGET, if there is no data matching criteria what is the error received?

A. #Num
B #Value
C. Criterion
D. Null

22. Which is not a filter type:

A. Text
B. Number
C. Date
D. Alphabetical

26. Full form of CAAT?

23. What is default status of cell?

A. Unlock
B. Lock
C. Hidden and locked
D. Unhidden and locked. (Correct)

27. On which tab can you find gap detection and Benford law?
A. File
B. Smart analyser
C. Analysis
D. Macro
25. Default version of new excel files?
A. .xls
B. .xlsx
C. .xlsm
D. .xlsd

29. A type of chart present in excel and caat

A. Scatter
B. Sparkline
C. Pivot table
D. (Can't remember the last option)

28. Files can be exported from idea in following formats:

1. PDF and word

2. Pdf and png
3. Word and Png
4. PDF, word and png

Which does not provides graphical representation ??? Chart or pivot table or dashboard

BIADR full form

Left outer join
Data validation path
ILFS fraud main reason
Benford law path
Right fx of excel
Text to column path, data type
Shortcut of flash fill
Pricing list in tally
Shortcut of interest in tally

Fraud diamond
Statutory reports
Idea fx start with ?
OR or AND meaning in same row, column
Scenerio maneger max limit
Path to protect sheet

What does inner joint of data mean?

A. All data from left table and matching from right.

B. All data from right and matching from left.

C. Only matching data from both tables.

D. All data from both tables.

Some were related to EPF like related to contributions…8.33% and 3.67%

29. A type of chart present in excel and caat

A. Scatter
B. Sparkline
C. Pivot table
D. (Can't remember the last option)

Haan kafi kuch tha but it was so difficult…

Some 2-3 questions were related to DATEDIF and other 2-3 formulas

Some of the questions I could remmember:-

1) Questions from Tally- Realted to Simple Interest/Compond Interest Like:-

a) Pathway to activate interest calculation feature
b) Ways of providing floating rates
c)Debit note/credit note applicable.

2) Shortcut to reconcile Income Tax Payment Challans in Tally

3)Which of the follwing is not Excel file extension:-
a).xlsx
b).xlsb
c).xlsm
d).xlsk

4)Qtrly return for Tds

a)Other than salary(Resident)
b)Other than salary(Non resident)

5)Data type of Excel365 thay can be used to find out latitude/longitude of a city
a)Rich Datatype
b)GPS Datatype
c) Geography Datatype
d) Area datatype

6)Which of the following is not a spreadsheet programme:-

a) Googlesheet
b)Openoffice Calc
c)MS Excel
d)Ms Outlook

7)TDS deducted deposied within ____days

8)Excel numbers are precise upto___digits

9)Certificate issued for TDS from Income under head salary

a)12BA
b)24Q
 c)16
d)E24Q

10)If you want to see all sheets of excel workbook in one go:-
-Right click any of the worksheet
- Left click on left scroll button
-Right click on right scroll button
-Home>All worksheets

11)With reference to Excel file extension choose the incorrect option:-

a).xlsx is default file extension
b).xlsx is very secure
c)size of .xlsx is smaller than .xlsb
d).xlsm uses open Xml standard

12)Short command for hiding/unhiding the Ribbon in Excel

Questions were also asked regarding Error during Data Validation....

Question was tough and only 2-3 questions were related to practical part of Excel

Shortkey to connect tally.net with remote access

a. F5
b. F4
c. F3
d. F2

Rates of EPF, EDLI

Incorrect statement for Sub Query -

()
[]

I stands for.... In BADIR

EDLI contribution

Hi!
These are some topics I remember from today's exam:
1. Data modelling
2. Full form of ETL
3. BADIR
4. Fraud types
5. Difference between power pivot & power query
6. Systematic sampling
7. Difference between Advance filter n AutoFilter
8. Types Data Analysis (Text, Statistical, Exploratory, Diagnostic, Prescriptive, Predictive)
9.TDS quarterly return,TDS certificate for salaried
10. Google sheet Vs Spreadsheet
11. PF deduction rate
12. In Tally, Job work register ,Payroll report, Statutory report, Maximum No. Of multi users that
can be connected through remote login
13. Excel functions: Datedif, EDate, EOMONTH
14. In excel, Ribbon can be hidden or made visible to toggle the Ribbon’s visibility, press
Ctrl+F1
15. In Access, step to use MACROS

31. Which of the following is not a probability based sampling?

A. Random
B. Systematic
C. Stratified random
D. Scientific

C. Ms Access

1. In And compound criteria an answer will be returned if:

A. None of criteria are met

B. If either criteria are met.
C. If all criteria are met.
D. None of the above

33. What symbol is to be used when entering a function in Idea?

A. =
B. @
C. +
D. If

32. When using Benford law test on Idea which of the following test can't be conducted?

A. 1st digit test

B. 2nd digit test
C. 3rd digit test
D. Last three digit test

3. What is full form of BOM?

Ans. Bill of Material

3. What are the maximum number of commands on switch board?

A. 4
B. 6
C. 8
D. 12

8. In which type of synchronisation the client and server company need not be online at
same time?

A. Online
B. On demand
C. Offline
D. None

4. What is the function of bill of material?

A. To get info of by-product
B. To get info of scrap
C. It facilitates in getting information regarding the amount of raw materials used in production
and reduce from inventory automatically.

Ans C.

9. In which year was the concept of TDS introduced?

A. 1949
B. 1961
C. 1962
D. 1987

Ans B

7. In tally multi user how many users can access through remote access at a time?

A. 1
B. 5
C. 2
D. 10

5. Which voucher is used to transfer stock from one location to another?

A. Journal
B. Contra
C. BOM
D. Stock vouchers

Ans D.

D. Tally Questions

1. What is the pathway to check outstanding interest?

2. Where does the unadjusted forex gain/loss appear in balance sheet?

A. Current asset
B. Current liability
C. Indirect expense
D. Indirect income.

6. When a job order is received which voucher is to be used?

A. Job work order out

B. Job work order in

C. Materials in

D. Materials out

Ans B

10. When TDS deposited into any of the designated branches of banks authorized to
collect taxes on behalf of the government accompanied by income tax what is the
challan to be submitted?

A. ITNS 281
B. ITNS 280
C. Form 24Q
D. Form 24EQ

Ans A

11. Which report can be used to reconcile challan payments?

A. Challan consolidation

B. Challan reco report

C. TDS report

D. --

Ans B.
14. What is the nature of the Leave travel assistance ledger?

12. Under which section of Income Tax, Tax is collected at source?

A. 205C
B. 206C
C. 206D
D. 207C

Ans b.