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: -The active cell is the selected cell in which data is entered when you begin typing. Only one cell is active at a time. The active cell is the cell surrounded by a black border. Data can only be entered into the active cell.

Detailed explanation-5: -To reference a cell or range of cells in another worksheet in the same workbook, put the worksheet name followed by an exclamation mark (!) before the cell address. For example, to refer to cell A1 in Sheet2, you type Sheet2!A1. For example, to refer to cells A1:A10 in Sheet2, you type Sheet2!A1:A10.