Computerised Accounting

Spreadsheet

Easy

Computerised Accounting

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:

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

(A) - (II), (B) - (III), (C) - (I), (D) - (IV)

(A) - (III), (B) - (I), (C) - (II), (D) - (IV)

(A) - (III), (B) - (II), (C) - (IV), (D) - (I)

(A) - (III), (B) - (IV), (C) - (I), (D) - (II)

✅ Correct Option: 4

In spreadsheet applications, cell navigation follows intuitive directional keystrokes:

(A) One cell down → Down arrow key or Enter key are used to move to the cell below the current cell → (III)

(B) One cell up → Up arrow key moves to the cell above the current cell → (IV)

(C) One cell left → Left arrow key moves to the cell on the left of the current cell → (I)

(D) One cell right → Right arrow key or Tab key moves to the cell on the right of the current cell → (II)

The correct matching is: (A) - (III), (B) - (IV), (C) - (I), (D) - (II)

Correct Answer: Option 4

2026: 12 May Shift 1

By default how many worksheets are available in "workbook" (Excel)?

2025: 13 May Shift 1

Order of mathematical operations in solving data in electronic spreadsheet

(A) * Multiplication

(B) + Addition

(D) / Division

Choose the correct answer from the options given below:

2025: 4 June Shift 2

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

2026: 12 May Shift 1

The arithmetic operations which we perform by using spreadsheets follow what order of mathematical (expression) operations rules?

(A) Brackets

(B) Division or multiplication

(D) Exponents

Choose the correct answer from the options given below:

2025: 27 May Shift 1

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

2025: 30 May Shift 2

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

Match List-I with List-II: List-IList-IIMovementKeystroke (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: