CUET UG Accountancy — Computerised Accounting previous year questions with solutions.
Every accounting software ensures the following: (A) Password Security (B) Data Audit (C) Data Leakage (D) Data Vault
How do you add the Data Form button to Excel's Quick Access Toolbar? Click Quick Access Toolbar arrow (A) Add (B) All Commands (C) Form (D) More Commands
What shape is the Fill Handle in Excel?
How is an absolute cell reference indicated? (A) With a # sign before the cell (B) With a $ sign before the column and/or row (C) With parentheses around the cell (D) With a $ sign before the column and/or row Choose the correct answer from the options given below:
Which of the following is NOT a method to create a drop-down list for data validation?
What would be the syntax for "IF" Function to get a result of Pass or Fail If Passing criteria is 40% and above. Further percentage of marks is available in Cell A1?
Array formulas are enclosed between __________.
______ is the total number of payment periods in an annuity in financial function.
What is the difference between TODAY() and NOW() Function?
Method of Codification should be :
In accounting, a transaction consists of data elements which includes: (A) Name of Account (B) Accounting Code (C) Date of Transaction (D) Amount Choose the correct answer from the options given below:
What type of coding uses abbreviations or letters to represent specific information like "SJ" for Sales Journal? (A) Sequential Code (B) Block Code (C) Mnemonic Code (D) Numerical Code Choose the correct answer from the options given below:
__________ ensures security of data even if it lands in wrong hands, because the receiver of data will not be able to decode and interpret it.
This sub system deals with the recording of different items purchased and issued specifying the price, quantity and date.
This subsystem deals with the preparation of Profit and Loss accounts, Balance Sheet and Cash Flow statements for reporting purposes.
__________sub system deals with payment of wages and salary to employees.
\$C4 or C$4 is an example of __________ reference.
__________ are numbered numerically from top to bottom while __________ are referred by alpha characters from left to right.
__________ is the function which adds the cells as per given specified criteria.
What is the expanded form of the accounting equation when incorporating revenues and expenses?
______ feature allows us to create a cross tabulation summary of data in which heading can subsequently moved to give different views of the data.
What is the maximum number of columns that a data validation form in Excel can display?
Doughnut charts: (A) Contains More than one data series (B) Comparable with Pie Chart (C) Comparable with bar graph (D) Comparable with Line Chart Choose the correct answer from the options given below:
What happens when you select "Warning" style in the Error Alert tab?