Question

12.What is “IF” function in Excel? (2)
13.How cell reference is useful in the
calculation? (2)
14.What is handout master and action button
in PowerPoint? (2)
15. Write shortcut keys used for

Answer 1

Answer:

1) IF function in Excel is best suited for situations where you check whether a condition is TRUE or FALSE. If it’s TRUE, the function returns a specified value/reference, and if not then it returns another specified value/reference.

2) Cell references are helpful in two ways:

1) They provide an easy way to locate a specific

Value within a spreadsheet.

2) they are used in creating formulas.

3) Handouts are documents you can print from within PowerPoint that include slide representations from your presentation.

An action button is an object on a slide that performs an action when clicked or pointed to, such as jumping to another slide or playing a sound.