Question

what are the steps to calculate Data cross worksheet


plz tell me in very easy way tommorrow is my exam​

Answer 1

Answer:

Click the worksheet with the data you would like included, and select the cell or cell range that you would like to use. Enter the operator (+, -, /, *, etc.) that you would like to use. Click the next worksheet with the additional data you would like to use, and select the cell or cell range to be included.

Answer 2

1. create a sheet 1 name it as year 1

2. create a sheet 2 name it as year 2

3. for using sheet 1 or sheet 2 data in any of the sheets use year 1! or year 2!

for example:- if you want to add B1:B3 range of sheet 1 in sheet 2 use =SUM(year1!B1:B3)

Explanation:

Note:- using this feature,we can use a value of a cell located at one sheet in the another sheet