Computerised Accounting Questions

In MS Excel spreadsheet software, the shortcut key combination that toggles (collapses or expands) the ribbon is:

In data visualization tools and chart utilities within spreadsheet software, the "Legend" block can be repositioned:

In relational database schemas, the common field columns used to establish a logical link or relationship between two different tables are called:

Which of the following best describes the primary purpose of accounting codification?

Which view in spreadsheet applications displays document margins and horizontal/vertical rulers?

Which key combination is used to collapse or expand the ribbon bar in modern office/spreadsheet tools?

In which cell is the rate parameter for the PMT function located given the formula = PMT(C8, C9, C10, C11, C12)?

The term 'Field' applied to a database table means:

__________ secures financial data by converting it into an unreadable format, ensuring that even if unauthorized users access the file, they cannot decode or interpret its contents without a decryption key.

Arrange the following mathematical operations in the correct sequence order in which an electronic spreadsheet (MS Excel) processes equations from highest priority to lowest priority (PEMDAS/BODMAS):(A) * Multiplication(B) + Addition(C) ( ) Brackets(D) / DivisionChoose the correct answer from the options given below:

______ is the number 0 or 1 and indicates when payments are due.

Which of the following is NOT considered a core component of a Computerized Accounting System?

In standard classic spreadsheet formats (such as Excel 97-2003), how many total "Rows" are available within a single worksheet?

__________ is the function which adds the cells as per given specified criteria.

The LOOKUP function has two syntax forms:

The best way to get started in Excel 2007 is to click the ____.

Which type of code assigns numbers or letters in a consecutive order to documents like invoices or cheques?

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 reportsChoose the correct answer from the options given below:

Which of the following is NOT a valid method to create a drop-down list for data validation in Excel?

The default extension of MS Access (2007) file is:

What is the maximum number of columns that a data validation form in Excel can display?

The need for Codification is :

Doughnut charts:(A) Contains More than one data series(B) Comparable with Pie Chart(C) Comparable with bar graph(D) Comparable with Line ChartChoose the correct answer from the options given below:

Which Excel spreadsheet function returns the cumulative interest paid on a loan between two periods?

How many blank worksheet(s) are shown, by default when a new workbook is created in classic spreadsheet software like Microsoft Excel 2007/2010?

Which of the following options should NOT typically be a structural feature of an accounting package selected for a small-scale business enterprise?

Every standard commercial accounting software ensures the following security and reliability characteristics:(A) Password Security(B) Data Audit(C) Data Leakage(D) Data VaultChoose the correct answer from the options given below:

The components of Computerised Accounting system are:

This specialized subsystem processes system inputs to generate the final Profit and Loss accounts, Balance Sheets, and Cash Flow statements for external corporate reporting:

The __________ sub-system automates the calculation and payment of employee wages, salaries, statutory deductions, and incentives.

$C4orC$ 4 is an example of a __________ reference.

For optimal clarity and readability, data visualization guidelines suggest that pie charts should generally not contain more than ______ categories.

By default, a spreadsheet cell reference is:

The computerised Accounting System refers to:

What is the expanded form of the accounting equation when incorporating revenues and expenses?

Which of the following elements is NOT used in a company's payroll calculation system?

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 CodeChoose the correct answer from the options given below:

What is the role of codification in the grouping of accounts within a CAS?

What shape is the Fill Handle in Microsoft Excel UI?

Which spreadsheet workspace view displays data page margins, page headers/footers, and rulers simultaneously?

______ feature allows us to create a cross tabulation summary of data in which headings can subsequently be moved to give different views of the data.

A _________ is a special key word which can be entered into a cell in order to perform and process the data which is appended within brackets.

A _____ is a range of cells that shows the results of substituting different values in one or more formulas.

How many blank worksheets are shown by default when a new workbook is created in classic spreadsheet systems like Microsoft Excel (older default versions typically referred to in standard curriculum textbooks)?

Which function is used to remove leading, trailing, and duplicate spaces from a text string?

The data that is entered in a cell may be either:A. NumericB. Alpha-NumericC. DateD. LabelChoose the correct answer from the options given below:

Which keyboard shortcut command reverses the last action performed in a spreadsheet worksheet?

Which software category is characterized by providing full functionality, but its installation or distribution is illegal and poses significant data corruption risks?

Sequential codes are applied primarily to source documents such as ...........?

Match List-I with List-II:List-I (Movement)List-II (Keystroke)(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 keyChoose the correct answer from the options given below:

"A system of letter or figure with arbitrary meaning for brevity and for machine processing of information".Above statement refers to the term :

Which key combination collapses the ribbon?

Select out of the following that primary structural driver that leads to the need of codification within a database or computerised accounting framework.

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:

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.Choose the correct answer from the options given below:

Identify the fundamental security element that acts as a verification key to allow authorized user access to an accounting information system.

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:

What type of coding uses abbreviations or letter combinations to represent specific info like "SJ" for Sales Journal?

Which among the following is not a COUNT function in Excel:

The term _____ means "a system of letter or figure with arbitrary meaning for brevity and for machine processing of information".

The best way to get started in Excel 2007 was to click the:

This accounting sub-system deals explicitly with recording different inventory items purchased and issued, tracking their respective prices, quantities, and transaction dates:

Modern spreadsheet applications like Excel 2007 organize commands into a series of horizontal tabs known as the:

The CAS should be :

Which of the following correctly represents the five foundational components of a Computerised Accounting System (CAS)?

Which of the following is NOT an inherent operational advantage of using a Computerised Accounting System (CAS)?

Microsoft Access (MS Access) is classified as a:

__________ are numbered numerically from top to bottom while __________ are referred by alpha characters from left to right.

'DBMS' stands for:

Where are amounts owed by customers for credit purchases found:

The feature of CAS that ensures better planning and access to vital information, leading to improved daily business operations, is:

A cell reference identifies the location of a cell or group of cells in the spreadsheet, also referred to as a:

Arrange the basic steps to create a spreadsheet chart in MS Excel in the correct logical order from start to finish:(A) On clicking the Start symbol, select the Programs option.(B) Click on the Insert tab to access chart tools.(C) Click on the computer screen's Start Icon.(D) Selecting the MS Excel program opens a blank workbook with a Ribbon displayed at the top.Choose the correct answer from the options given below:

Which of the following arguments in a financial function represents the total number of payments

Which of the following is NOT a mathematical function?

Which of the following is NOT an element of a chart or graph in a spreadsheet software?

______ is the total number of payment periods in an annuity in a financial function.

How does Data Vault (encryption) enhance the security of CAS data?

Which of the following is not a types of graphs and charts

Which of the following statement is not correct?

Why is proper classification of data necessary in a growing business using a Computerised Accounting System?

Arrange the steps in the correct chronological sequence to add the Data Form button to Excel's Quick Access Toolbar after clicking the Quick Access Toolbar arrow:(A) Add(B) All Commands(C) Form(D) More CommandsChoose the correct answer from the options given below:

A graph is a pictorial representation of data, which exhibits at least a _________ dimensional relationship.

How is an absolute cell reference indicated in spreadsheet software formulas?(A) With a # sign before the cell(B) With a $signbeforethecolumnand/orrow(C)Withparenthesesaroundthecell(D)Witha$ sign before the column and/or rowChoose the correct answer from the options given below:

A __________ code consists of alphabets or abbreviations as symbols to codify a piece of information.

Which of the following correctly represents the sequence of steps in the accounting cycle, as followed in both manual and computerised accounting systems?

What does a standard alphanumeric "cell reference" address identifier in a spreadsheet formula typically consist of?

Where is the address of the active cell displayed?

How many blank worksheets are shown when a new workbook is created.

What happens when you select "Warning" style in the Error Alert tab during Data Validation in Excel?

The method of Codification should be:

A ________ is a dialog box that displays one complete record at a time and can be used to add, change, locate, and delete records.

Which of the following is not a standard feature of CAS?

The primary accounting document entity used to record individual transactional records and financial data points in Tally ERP / Prime is a:

The term 'field' as applied to database table means.

What are the internal controls designed to do ?

Modern Accounting is based on :

Identify the chart element that details the data values and categories below the chart.

Match List - I with List - II.
$$\begin{array}{ll}\text{List - I (System)}& \text{List - II (Applications)}\\ \text{(A) AIS}& \text{(I) Communicate the accounting information sub category of Accounting system}\\ \text{(B) DBMS}& \text{(II) Grouping of accounts in logical structure}\\ \text{(C) CAS}& \text{(III) Loan Repayment Scheduling, and Payroll Accounting}\\ \text{(D) Spreadsheet}& \text{(IV) Storing, capturing, processing and retrieval of data}\end{array}$$
Choose the correct answer from the options given below:

In digital or computerized accounting, a transaction record comprises specific baseline data elements which include:(A) Name of Account(B) Accounting Code(C) Date of Transaction(D) AmountChoose the correct answer from the options given below: