Explain the following concepts as used in spreadsheets: i) Automatic recalculation ii) ‘What if’ analysis iii) Sheet tabs

      

Explain the following concepts as used in spreadsheets:
i) Automatic recalculation
ii) ‘What if’ analysis
iii) Sheet tabs

  

Answers


Kavungya
i) Automatic recalculation
This is whereby an electronic spreadsheet will adjust the result of a formula automatically when the values are changed, so that they correspond with the different input.
ii) ‘What if’ analysis
‘What if’ analysis is a feature in spreadsheets that is used to find out the
effect of changing certain values in a worksheet on the other cells.
It involves changing the values of one of the arguments in a formula in
order to see the difference the change would make on the result of the calculation.
iii) Sheet tabs
These are names of the worksheets that appear at the bottom of the worksheet window. They enable the user to move from one worksheet to another.
Kavungya answered the question on April 17, 2019 at 06:29


Next: The table below represents rainfall and temperature figure for a town in Kenya .Use it to answer the questions that follow:-
Previous: Discuss on the systems of Stock Taking

View More Computer Studies Questions and Answers | Return to Questions Index


Exams With Marking Schemes

Related Questions