Target Exam

CUET

Subject

-- Accountancy Part C

Chapter

Spreadsheet

Question:

Match the following lists.

LIST I (Movement) LIST II Key Stroke (Press key)
A) One cell down I) Left arrow key
B) One cell up II) Enter key
C) One cell left III) Tab key
D) One cell right IV) Up arrow key

Choose the correct answer from the options given below.

Options:

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

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

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

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

Correct Answer:

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

Explanation:

The correct answer is option 4- A-II, B-IV, C-I, D-III.

LIST I (Movement) LIST II Key Stroke (Press key)
A) One cell down II) Enter key 
B) One cell up IV) Up arrow key
C) One cell left I) Left arrow key
D) One cell right III) Tab key

 

The mouse is used for all the operations required and for navigation in worksheet (or workbook) except data entry; but some of the important operations and common navigations can be performed by using key strokes. It is better to understand and know all the keys of keyboard and key strokes. Pressing a key is called key stroke but to fulfill one command for operation in the worksheet sometime we require pressing two keys together to get one key stroke.

A) One cell down → Enter key (II)
Pressing the Enter key moves the selection down to the cell directly below the current one. Commonly used after typing data in a cell, to enter the data and move to the next row for more input.

B) One cell up → Up arrow key (IV)
Pressing the Up Arrow (↑) key moves the selection up by one cell. Useful for navigating upward through cells, especially when reviewing or editing data.

C) One cell left → Left arrow key (I)
Pressing the Left Arrow (←) key moves the selection one cell to the left. Used to move horizontally left across cells in the same row.

D) One cell right → Tab key (III)
Pressing the Tab key moves the selection one cell to the right. Often used when entering data across a row (e.g., filling in forms or tables).