Computerised Accounting

Spreadsheet

Easy

Computerised Accounting

Arrange the following in sequence while calculating depreciation using straight line method.

(A) Life of Asset

(B) Salvage Value of Asset

(C) Cost of Asset

Choose the correct answer from the options given below:

(A), (B), (C)

(C), (B), (A)

(B), (A), (C)

(B), (C), (A)

✅ Correct Option: 2

The spreadsheet function is $\text{SLN(cost, salvage, life)}$ , and its arguments must be supplied in that order.

So the sequence is cost of asset (C), salvage value (B), then life of asset (A), matching $\text{Depreciation}=\frac{\text{Cost}-\text{Salvage}}{\text{Life}}$ .

2025: 4 June Shift 2

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

2025: 4 June Shift 2

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

2025: 15 May Shift 1

Where is the address of the active cell displayed?

2026: 21 May Shift 2

Match the LIST-I with LIST-II

LIST-I (Movement)		LIST-II (Key Stroke (Press key))
A.	Beginning of the Row	I. CTRL + D
B.	Moving consecutively to the first and the last filled cells of a cluster of filled cells in a column by pressing of	II. HOME key
C.	The cell at the intersection of the last row and last column containing data	III. CTRL + Down arrow key
D.	Short-cut key to drag down	IV. CTRL + END keys

Choose the correct answer from the options given below:

2025: 22 May Shift 1

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:

2025: 3 June Shift 1

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?

Arrange the following in sequence while calculating depreciation using straight line method. (A) Life of Asset (B) Salvage Value of Asset (C) Cost of Asset Choose the correct answer from the options given below:

Solution

Related questions:

Keyboard Shortcuts

CUET Accountancy Past Year Questions (Topic-Wise)

Arrange the following in sequence while calculating depreciation using straight line method.

(A) Life of Asset

(B) Salvage Value of Asset

(C) Cost of Asset

Choose the correct answer from the options given below: