Question

Which of the given options best matches the items of LIST-1 with the items of LIST-2 with reference to editing cells in a spreadsheet?

LIST-1 LIST-2

(i) Enter (a) moves you to the next cell to the right

(ii) Shift + tab (b) moves you to the next cell down

(iii) Tab (c) moves you in the direction of the arrow

(iv) Arrow key (d) moves you to the next cell to the left

1. (i) - b, (ii) - a, (iii) - d, (iv) - c
2. (i) - b, (ii) - d, (iii) - a, (iv) - c
3. (i) - c, (ii) - d, (iii) - a, (iv) - b
4. (i) - a, (ii) - d, (iii) - b, (iv) - c

Answer 1

Correct Answer - Option 2 : (i) - b, (ii) - d, (iii) - a, (iv) - c

The Correct Answer is "(i) - b, (ii) - d, (iii) - a, (iv) - c".

Function	Hot Key
To move to the next cell of the arrow direction key	Press Arrow Keys.
To move to the next cell	Press Enter
To move to the next cell to the right	Press TAB.
To move to the next cell to the left	Press SHIFT + TAB.
To move to the edge of a data region	Press CONTROL + Arrow Keys.
To move to the first cell in the row	Press HOME.
To move to the first cell	Press CONTROL + HOME.
To move to the last cell	Press CONTROL + END.
To scroll down	Press PAGE DOWN.
To scroll up	Press PAGE UP.
To scroll to the right	Press ALT + PAGE DOWN.
To scroll to the left	Press ALT + PAGE UP.
To move to the next worksheet	Press CONTROL + PAGE DOWN.
To move to the previous worksheet	Press CONTROL + PAGE UP