Target Exam

CUET

Subject

-- Accountancy Part C

Chapter

Spreadsheet

Question:

Given below are some shortcut keys for navigating through a excel work book.

Which of the following is NOT correctly matched?

Options:

Shift +Home= Cell A1

HOME key = Beginning of the Row

Cntl+ End = The cell at the intersection of the last row and last column containing data

None of the above

Correct Answer:

Shift +Home= Cell A1

Explanation:

The correct answer is option 1- Shift +Home= Cell A1.

Shift + Home: This shortcut selects the range of cells from the current position to the beginning of the row (not to Cell A1). It does not go to Cell A1, but instead to the first cell in the row.

 

  • HOME key = Beginning of the Row: This is correct. Pressing the HOME key takes you to the beginning of the current row (column A).
  • Ctrl + End = The cell at the intersection of the last row and last column containing data: This is correct. Pressing Ctrl + End takes you to the last cell that contains data, at the intersection of the last row and last column with data.

Therefore, Shift + Home = Cell A1 is the incorrect match.