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 |
