CUET Accountancy: Computerised AccountingSpreadsheet. Free, no login required.

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 Excel function is used to calculate depreciation under Straight Line Method (SLM)?

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

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

What is the difference between TODAY() and NOW() Function?

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

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:

Which function returns the cumulative interest paid between two periods?

Which function is used to remove spaces before and after the text?

Intersection of row and column is referred as _______?

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?

______ 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?

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

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 does the "cell reference" in a formula typically consist of?