Trusted by millions of Kenyans
Study resources on Kenyaplex

Get ready-made curriculum aligned revision materials

Exam papers, notes, holiday assignments and topical questions – all aligned to the Kenyan curriculum.

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

Answer Attachments

Exams With Marking Schemes

Related Questions