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: -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-3: -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.