Question ID: 5376 3/11
PREVIOUS QUESTION NEXT QUESTION

Rename the sheets of the active workbook as follows:

Sheet1: Income

Sheet2: Expenses

Sheet3: Total

Insert the value 1000 in cell A1 of the Income worksheet.

Insert the value 500 in cell A1 of the Expenses sheet.

 

Display the difference between the value appearing in cell A1 of the Income worksheet and the value in cell A1 of the Expenses worksheet (NOT 1000-500), in A1 cell of the Total worksheet.

 

If a cell value in Income or in Expenses worksheet changes, the value displayed on the Total worksheet should change as well.

 

 

Other versions
OpenOffice.org Calc 3.3LibreOffice Calc 4.0

 

 

 


Rename the sheets of the active workbook as follows: 
Sheet1: Income
Sheet2: Expenses
Sheet3: Total
Insert the value 1000 in cell A1 of the Income worksheet. 
Insert the value 500 in cell A1 of the Expenses sheet.
 
Display the difference between the value appearing in cell A1 of the Income worksheet and the value in cell A1 of the Expenses worksheet (NOT 1000-500), in A1 cell of the Total worksheet.
 
If a cell value in Income or in Expenses worksheet changes, the value displayed on the Total worksheet should change as well.