FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Range: A range is a group of cells in a spreadsheet that have been selected. If the cells are all together in a rectangular or square shape, it is an adjacent range. An adjacent range is identified by the cell reference in the upper left and lower right corners of the selection separated by a colon. (Example: A3:B5).

Detailed explanation-2: -Row. A row is a group of cells that runs from the left of the page to the right. In Excel, rows are identified by numbers.

Detailed explanation-3: -By default, Excel uses the A1 reference style, which refers to columns as letters (A through IV, for a total of 256 columns), and refers to rows as numbers (1 through 65, 536). These letters and numbers are called row and column headings.

Detailed explanation-4: -Rows are referenced by numbers that appear on the left and then run down the Excel screen. The first row is named row 1, while the last row is named 65536.

Detailed explanation-5: -Pressing an arrow key while SCROLL LOCK is on will scroll one row up or down or one column left or right. To use the arrow keys to move between cells, you must turn SCROLL LOCK off. To do that, press the Scroll Lock key (labeled as ScrLk) on your keyboard.