Accountancy Computerised Accounting questions from CUET UG 2025.
\$C4 or C$4 is an example of __________ reference.
A cell reference identifies the location of a cell or group of cells in the spreadsheet also referred as a
A graph is a pictorial representation of data, which has at least ______ dimensional relationship.
A _____ is a range of cells that shows the results of substituting different values in one or more formulas.
__________ are numbered numerically from top to bottom while __________ are referred by alpha characters from left to right.
Array formulas are enclosed between __________.
By default cell reference is
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:
__________ 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.
Every accounting software ensures the following: (A) Password Security (B) Data Audit (C) Data Leakage (D) Data Vault
______ feature allows us to create a cross tabulation summary of data in which heading can subsequently moved to give different views of the data.
Following are the steps related to preparation of charts, arrange them in a correct sequence. (A) Save a chart. (B) Create a basic chart using the pattern from the panel available on top of the worksheet in 'Chart groups' option. (C) Change the layout or style of chart (D) Enter data on a worksheet with proper column and row titles. Choose the correct answer from the options given below:
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
How do you display or hide the horizontal and vertical axes in a chart?
How does Data Vault (encryption) enhance the security of CAS data?
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:
How is the Net Salary (NS) of an employee determined?
How many blank worksheets are shown when a new workbook is created?
In a chart, what do data points represent?
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:
In Excel terminology, what is the area that contains the entire chart called?
Intersection of row and column is referred as _______?
_______ is a dialog box that displays one complete record at a time and can be used to add, change, locate, and delete records.
__________ is the function which adds the cells as per given specified criteria.
______ is the number 0 or 1 and indicates when payments are due.
______ is the total number of payment periods in an annuity in financial function.
Match List-I with List-II: | List-I | List-II | |---|---| | Movement | Keystroke (Press key) | | (A) One cell down | (I) Left arrow key | | (B) One cell up | (II) Right arrow key or Tab key | | (C) One cell left | (III) Down arrow key or Enter key | | (D) One cell right | (IV) Up arrow key | Choose the correct answer from the options given below:
Method of Codification should be :
Order of mathematical operations in solving data in electronic spreadsheet (A) * Multiplication (B) + Addition (C) ( ) Brackets (D) / Division Choose the correct answer from the options given below:
Provident Fund (PF) is calculated as a percentage of which component(s)?
PV function returns the present value of an investment. The syntax of the function is PV (rate, nper, pmt, fv, type). What does NPER stands for?
Sequential codes are applied primarily to source documents such as ...........?
__________sub system deals with payment of wages and salary to employees.
The best way to get started in Excel 2007 is to click the ____.
The error ##### occurs when? (A) Column is not wide enough (B) Negative date (C) Negative time (D) Row is not wide enough Choose the correct answer from the options given below:
The feature of CAS that ensures better planning and access to vital information, leading to improved daily business operations, is:
The following elements are important for salary computation and its payment: (A) Grade Pay (GP) (B) Dearness Allowance (DA) (C) Transport Allowance (TRA) (D) Goods and Service Tax (GST) Choose the correct answer from the options given below:
The LOOKUP function has two syntax forms:
The need for Codification is :
The primary account which records all the financial transactions in a tally is
The term _____ means "a system of letter or figure with arbitrary meaning for brevity and for machine processing of information".
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.
Using MS Excel, we can create a basic chart by the following steps. (A) On clicking of Start symbol we will get Programs option (B) Click on Insert tab to get tools for chart (C) On the screen of the computer mouse click on Start Icon (D) On selecting MS Excel 2007 program it will provide a blank workbook with a Ribbon displayed at the top. Choose the correct answer from the options given below:
What allows you to reposition or change the size of a chart on the worksheet?
What does Dearness Allowance (DA) compensate for?
What does OLE stands for?
What does the "cell reference" in a formula typically consist of?
What element can you show or hide to improve clarity in the background of the chart?
What happens when you select "Warning" style in the Error Alert tab?
What is the correct formula for calculating total depreciation on an asset?
What is the difference between TODAY() and NOW() Function?
What is the expanded form of the accounting equation when incorporating revenues and expenses?
What is the formula for calculating Basic Pay Earned (BPE)?
What is the maximum number of columns that a data validation form in Excel can display?
What is the purpose of the Data Audit feature in CAS software? (A) To generate financial reports (B) To identify changes made in the original data and by whom (C) To detect viruses in the system (D) To allow access to confidential reports Choose the correct answer from the options given below:
What is the role of codification in the grouping of accounts within a CAS?
What kind of data is best displayed with a bar chart?
What shape is the Fill Handle in Excel?
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:
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:
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?
Where is the address of the active cell displayed?
Which combination is true in respect of using a graph/chart? (A) Quicker and easier to create a chart immediately to see the possible relationship of variables to one another, rather than paging through raw data. (B) Provide information in as little time as possible. (C) Graphs do not have the ability to take large amounts of information and make them into exhibitions that are easily used to persuade (D) A graph may be either a single line graph or a multi-line graph.
Which Element is not used in Payroll Calculation -
Which Excel function is commonly used to calculate loan repayment instalments?
Which Excel function is used to calculate depreciation under Straight Line Method (SLM)?
Which formula can be used to prevent leading or trailing spaces in a data validation rule?
Which function is used to remove spaces before and after the text?
Which function returns the cumulative interest paid between two periods?
Which is not the Elements of a Chart/graph-
Which of the following correctly represents the five foundational components of a Computerised Accounting System (CAS)?
Which of the following correctly represents the sequence of steps in the accounting cycle, as followed in both manual and computerised accounting systems?
Which of the following is not a feature of CAS ?
Which of the following is not a mathematical function:
Which of the following is NOT a method to create a drop-down list for data validation?
Which of the following is not a sub-system of Accounting Information System?
Which of the following is not a types of graphs and charts
Which of the following is not considered a component of Computerized Accounting System?
Which of the following is not the advantage of Computerised Accounting System (CAS):
Which of the following should not be an accounting package feature, when considering for Small- Business?
Which of the following software is full functional, but its use is illegal and data can be corrupted.
Which type of code assigns numbers or letters in a consecutive order to documents like invoices or cheques?
Which view shows margins and the rulers?
Why is proper classification of data necessary in a growing business using a Computerised Accounting System?