Computerised Accounting PYQ — Page 4

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

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:

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

Every accounting software ensures the following: (A) Password Security (B) Data Audit (C) Data Leakage (D) Data Vault

__________ 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.

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:

By default cell reference is

Array formulas are enclosed between __________.

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

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

A graph is a pictorial representation of data, which has at least ______ dimensional relationship.

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

\$C4 or C$4 is an example of __________ reference.

Which of the following is an example of sequential code?

The Sales and Accounts Receivable Subsystems deals with:

The components of Computerised Accounting System are:

The common fields used in a relationship between tables are called:

Which command reverse the last action performed in the worksheet?

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

Where are amounts owed by customers for credit purchases found :

The need of codification is :

The key combination which collapses the ribbon is :

The current version of Excel 2007 is now designed with a series of horizontal tables knows as ______

The components of Computerised Accounting system are :