Computerised Accounting PYQ — Page 3

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

Which formula can be used to prevent leading or trailing spaces in a data validation rule?

In Excel terminology, what is the area that contains the entire chart called?

Provident Fund (PF) is calculated as a percentage of which component(s)?

In a chart, what do data points represent?

What does Dearness Allowance (DA) compensate for?

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

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?

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:

What does OLE stands for?

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:

How is the Net Salary (NS) of an employee determined?

What kind of data is best displayed with a bar chart?

Which Excel function is commonly used to calculate loan repayment instalments?

What is the correct formula for calculating total depreciation on an asset?

How do you display or hide the horizontal and vertical axes in a chart?

What element can you show or hide to improve clarity in the background of the chart?

What allows you to reposition or change the size of a chart on the worksheet?

Which is not the Elements of a Chart/graph-

Which Element is not used in Payroll Calculation -

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

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

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

Which view shows margins and the rulers?