New Exam Question for AICITSS New Syllabus Exam Question for CA Exam | CA Final | CA Inter | Important Question for Exam | Must Do Questions | Online Exam Question 2024
Question and Answer
S.No | Questions | Answer |
1 | In different data types in excel, which is used to represent boolean type ? | |
2 | _________ function returns true if majority conditions is false | not() |
3 | In the cells A1 and A2 , we have the values 20 and 10 respectively. In the cell A3 we have the formula A3= A1/A2, if we copy the cell A3 and paste it in B1, what is the resuilt? | #REF |
4 | How many number of price lists can be created in Tally ERP 9? | any number |
5 | Rapid encryption of sensitive files on a corporate network is best known as ? | Ransomware |
6 | What is the default extension of latest Excel versions? | .xlsx |
7 | The ______returns the serial number of the last day of the month before or after a specified number of months | eomonth() |
8 | which of the following has the lowest priority? | imp |
9 | Which option is used to paste ceertain attributes such as values, formulas, formatting etc.? | paste special |
10 | When companies receive a job work from third party for manufacturing of electronic cooker, which process will take place? | job work in |
11 | _______ voucher is used to transfer the goods from one location to another location. | stock journel voucher |
12 | The TCS report the contains the details of collectee(s) and challan details relating to deposit of tax with the income tax department is | form 27eq |
13 | Array formula should be entered in ______ | {} |
14 | Which function is used to return the future value of an annuity based on periodic fixed paymets and fixed interest rate? | PMT() |
15 | ____ is the process of conversion of raw materials/ components into finished goods ? | Manufaturing Journal |
16 | We can check the interest calculation report from ? | display -statement of accounts-outstandings |
17 | Unadjusted Forex Gain/Loss is reflected under_______account head | Current Liabilities |
18 | For these items we donot need BOM | Trade items |
19 | Which of the following flag is a symptom of early warning signal? | red flag |
20 | After exporting e-TCS form, the text file created must be validated through? | file validation utility |
21 | Inner join returns … | records with common data in both tables |
22 | Remove duplicates option is in _____group of data tab in Excel | Data Tools |
23 | ______is monthly Income Tax Return generated in Tally | ITR I |
24 | Which of the following funtion extracts the name of the month from the data time functions ? | MonthName() |
25 | for enabling Tally Audit Features_____ | COMPANY INFO MENU-ALTER-YES TO AUDIT AND COMPLIENCE OR USER SECURITY TO YES |
26 | Idea AgeTime function is used to _________ | Returns the number of seconds between two times. |
27 | What is the default column data format in function Text to Columns | General |
28 | Which option should be use to delete any file in IDEA Software? | |
29 | If a formula is having the following address =A$2 then this cell reference has the type ? | Mixed Addressing |
30 | To accept all the transactions by the administrator while doing Audit, the short cut key is | F7 |
31 | Path to view the Income Tax Reports in Payroll | DISPLAY -PAYROLL REPORTS – STATUTARY REPORTS-INCOMETAX |
32 | This Forensic accounting technique or methodology is used for detecting errors and also heightlights all unusual fluctutions which may be routed from fraud or genuine errors | TRUE |
33 | The result of Right(“Accoutant”) is _________ | t |
34 | The function in IDEA Software begins with the | @ |
35 | Which of the following tab is not visible by default in the Ribbon in MS Excel? | Developer Tab |
36 | It is the rate at which the Foreign Currency is traded in te market | STANDARD |
37 | Timelines can be applied of which type of fields? | date/time data type fields |
38 | In a VLOOKUP formula what does the argument Column Index number mean ? | return value column no. |
39 | It is used to Compare trends over a perioed of time | LINE OR AREA CHART |
40 | Job work registeR under the job work out reports does not give details about | |
41 | Which filter gives a different filtered value every day? | DATE FILTER TODAY() |
42 | In this type of Synchronization, the client and sever companies need not be online at the same time | ON DEMAND SYNC |
43 | This function sums a range of cells based on more than one condition or criteria | Sumifs() |
44 | Cost Estimation is a statement that gives a value of the cost incurred in the manufacturing of______ | FINISHED GOOD |
45 | The criteria Expression like a* means | Starting with a and remaining any letters |
46 | Job work charges are under the group | DIRECT EXP |
47 | Which function converts a text string into a cell reference ? | Indirect() |
48 | Steps to create Security Controls for a Tally .Net User | ALT+F3 |
49 | Sequence of steps in Data-to-Decision Framework for BADIR Framework | Business questions, analysis plan, data collection, derive insights, recommendations |
50 | In Table data, Excel uses a special formula syntax called | structured references |
51 | In Stratification, a value band represents | A RANGE |
52 | By Default Microsoft Excel uses________advanced Encryption | DES or AES |
53 | The PayHead type for children Education Allowence must be set to____ | earnings to employees |
54 | every worksheet has _________rows and _________columns | 1048576 ROWS AND XFD (16384 COLS) |
55 | Which of the following factor is a part of the Fraud Dimond | Incentive, capability,opportunity and rationalisation |
56 | Which report is not available through job work out reports? | |
57 | By Default Microsoft Excel Macro recorder records _______steps | |
58 | To Protect a workbook you can supply a password of up to ____ characters | 255 |
59 | The exported e-TDS file from Tally can be validated through NSDL’s freeely downloadable utility called _____ | validation utility |
60 | ____stops all currently running macros. | |
61 | Full form of CAAT __ | Computer Aided Audit Tools |
62 | Stock report under the Job Work Out Reports displays details about? | AGING ANALYSIS AND WITH JOB WORKER REPORTS |
63 | The Excel____ feature allows you to set up rules that restrict or validate what can be entered into a cell. | DATA VALIDATION |
64 | Proffessional Tax Report is divided into which two types of reports? | COMPUTATION REPORT AND STATEMENT |
65 | Which of the following is not included in Optimization Model which can be specified using the Solver? | |
66 | Which operator is used instead of Concatenate ()? | & |
67 | Equation editor option is available in which tab? | insert |
68 | Employee salary details are shown in ___? | payroll |
69 | In order to compute TDS liability under the salary every month, by default the tax calculation basis under income tax configuration has to be set to ____ | on projected value |
70 | Which one of the following is not a valid cell reference? | |
71 | How many V’s are there in Big Data? | 3 |
72 | In DGET() , if number of records match the criterion the DGET() returns ___ error | #NUM |
73 | In case of Multi User Lisence, Number of Tally .Net Users which can be configured for remote access | 10 |
74 | Which of the following is not a type of relate feature in IDEA Software? | join, visual connector, compare and append are anything which is not is to be selected |
75 | Price list generally used by organizations which deal in ___ | WHOLE SALE AND RETAIL SALES |
76 | We can use Senario Manager to perform analysis by varying as many as____ input cells | 32 |
77 | It is a tool used for graphical analysis of data | chart tool |
78 | How to enable TCS feature in Tally ? | F11-F3-TCS -YES |
79 | _____ is a Microsoft Office Access Form that facilitates navigation in MS Access and access to different parts of an application | NAVIGATION FORM |
80 | Salary projection provides projection of ____and displays the actual if payroll is already processed for any given month | earnings and deductions |
81 | This can be used to filter the contents of the pivot table on more than one fields | slicers |
82 | Strcomp(“Access”,”Excel”) will return __ | FALSE |
83 | Which function in IDEA can return all numbers (leading or trailing ) from the specified value | @JUSTNUMBERS() |
84 | Unmatched query is used for _____ | find the record from one table that do not have corresponding values in the second table |
85 | _____function returns the nearest integer for a negative number | round() |
86 | What function ought to be utilized to round the number248.3546 to 248.36 | roundup() |
87 | Bank frauds may not include___ | |
88 | You can create a graphical representation of data from options available under the____ tab of Excel | insert |
89 | In order to configure House Rent Declaration, Name and PAN of the Landlord are mandatory, if the rent declared is more than ___ | MORE THAN 100000 |
90 | Which Income Tax Challan is used to deposit TCS? | ITNS 281 |
91 | In which formats,IDEA can make output reports? | |
92 | Switchboard Manager only allows a maximum of ______command buttons on the switchboard | 8 |
93 | Price List is referred at the time of making _____ | SALES |
94 | _____ function checks a value and if it is #N/A, then it will return true else it will return false | ISNA() |
95 | ______represents the data in Spreadsheet form | datasheet view |
96 | ________is used to generalize the population drawing inference from the samples | INFERENCIAL STATISTICS |
97 | Which report displays the employee wise income tax computation details in form 16 format | DISPLAY-PAYROLL REPORTS -STATUTARY REPORTS-INCOME TAX – E -RETURNS |
98 | BOM represents | Bills Of Materials |
99 | The extraction task is used to ____ records that meet the specified criteria from an existing database and place them in another database | COPY |
100 | Letter E in ETL (in Data Analysis ) stands for____ | EXTRACT |
101 | Frequency functions | count how many numbers fall into each set of categories |
102 | goal seek | data tab |
103 | accept all interest parameters | |
104 | iserror(100000/0) returns | TRUE |
105 | form 16 | annual |
106 | TSS full form | Tally software services |
107 | calculate interest | Accounts info |
108 | Unadjusted Forex Gain/Loss journal | journal voucher class |
109 | projected value for | 12months |
110 | filter which gives a new everyday | |
111 | default join | inner join |
112 | drop down list | combo box |
113 | Strcomp(“Access”,”Training”) | -1 |
114 | Gateway of Tally> F11: Features >F3: Statutory> | TDS |
115 | As per the income tax act, the details of payment of TDS are required to be furnished in the TDS certificate issued to the deductee | Tally allows us to enter all the required information as specified by the statutes, by using the challan reconciliation facility |
116 | tiger group | test the quality of a control by endeavouring to break it. |
117 | excel encryption | aes 256bit |