Practicing Success

Target Exam

CUET

Subject

Accountancy

Chapter

Spreadsheet

Question:

Match List – I with List – II.

LIST - I

LIST - II

 A. CTRL + HOME key

 I. Beginning of Row

 B. Home key

 II. Cell at intersection of last row and last column containing data 

 C. CTRL + Right Arrow (→) key 

 III. Top of worksheet

 D. CTRL + End key 

 IV. Moving consecutively to first and last filled cell of cluster of filled cells in a row 

Choose the correct answer from the options given below :

Options:

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

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

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

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

Correct Answer:

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

Explanation:

The correct answer is Option (3) - A-III, B-I, C-IV, D-II.

* CTRL + HOME key- Top of worksheet

* Home key- Beginning of Row

* CTRL + Right Arrow (→) key - Moving consecutively to first and last filled cell of cluster of filled cells in a row

* CTRL + End key - Cell at intersection of last row and last column containing data.

S no. Movement Stroke (Press key) Key Stroke (Press key)
1 Top of Worksheet (cell A1)

CTRL + HOME (i.e. Keep CTRL key pressed and then press HOME key

2 The cell at the intersection of the last row and last column containing data CTRL + END keys
3 Moving consecutively to the first and the last filled cells of clusters of filled cells in a row by successive pressing of CTRL + Right arrow key (→) or else END + Right arrow key ( →) CTRL + Right arrow key (→ ) or else END + Right arrow key (→ )
4 Moving consecutively to the first and the last filled cells of a cluster of filled cells in a column by successive pressing of CTRL + Down arrow key ( ↓) or else END + Down arrow key ( ↓) CTRL + Down arrow key (↓ ) or  else END + Down arrow key (↓ )
5 Beginning of the Row HOME key