FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -You can enter formulas that reference cells on other worksheets in the workbook. You can use the ENTER key to complete a paste operation. You must enter the first three numbers in a series so that Excel can determine the increment amount when using the fill handle to increment a series by two.

Detailed explanation-2: -Select the cell in the current workbook where you need the reference. Type the formula till you need the reference (or an equal-to sign if you just want the reference) Select the sheet to which you need to refer to. Select the cell/range that you want to refer to.

Detailed explanation-3: -To reference a cell or a cell range in another worksheet in the same workbook, simply put the “worksheet name” followed by an exclamation mark “!”, then the cell reference. In this example, I have my 2020 sales data in another sheet in the same workbook.

Detailed explanation-4: -Click the cell where you want to enter a reference to another cell. Type an equals (=) sign in the cell. Click the cell in the same worksheet you want to make a reference to, and the cell name is automatically entered after the equal sign. Press Enter to create the cell reference.