FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Answer. Answer: When you open a new Excel spreadsheet for the first time, the first cell is selected by default, which is A1 (the first cell of row A and column one). If you’ve worked on an Excel spreadsheet in the past, the active cell is the last active cell position.

Detailed explanation-2: -A1 is the default style used most of the time. In this style, columns are defined by letters and rows by numbers, i.e. A1 designates a cell in column A, row 1.

Detailed explanation-3: -Double clicking on a cell will simply activate and make it editable. You can also make a cell editable by clicking in the formula bar. This method works only if the cell you want to edit is active.

Detailed explanation-4: -There is always one active cell in a selection-whether this is a range, row, or column. By pressing the Enter or Tab key, you can change the location of the active cell, which by default is the first cell in a row.

Detailed explanation-5: -This means that a simple cell reference, used within an Excel cell, will be adjusted when copied to other cells. For example, in the spreadsheet below, cell A1 contains a reference to cell E1. The spreadsheet on the right shows the result of cell A1 being copied to cells A1-C3.