Page 37 - Viva ICSE Computer Studies 8 : E-book

D. State whether the following statements are true or false.
1. Arithmetic operators give the result in true or false. _________

2. The user might get errors while performing calculations. _________

3. Mixed reference is a combination of relative reference and absolute reference. _________
4. The Divide function returns the sum total of the range values. _________
5. The Max function returns the largest value in the given range. _________

E. Write the steps to perform the following tasks.

1. Use a basic formula.
2. Enter a compound formula.
3. Use circular reference.

4. Use Sum and Average functions.

5. Use LCM and GCD functions.

F. Answer the following questions.
1. Diff erentiate between relative, absolute and mixed references.

2. How are functions diff erent from formulae?

3. Defi ne the commonly used functions in Excel.
4. Enlist the rules to use functions.

5. Write the steps to insert a function.

Building Values and Life Skills

Reena has been given the result of the entire class. She has been asked by her teacher to calculate
the maximum and minimum marks acquired in science. Suggest her the functions she should use
to accomplish the task.

Testing Knowledge

1. Can you calculate the principal amount in Excel if the compound interest, time and rate is
given using the compound formula? Justify your answer.
2. Nidhi has created a worksheet in MS Excel. By mistake she has typed the same information in
the 3rd and 4th rows. She wants to rectify her mistake by deleting the 4th row. How should she
do it?

25