Page 50 - Plus V4 with Adobe class 6
P. 50
Q Answer the following questions:
A
1. Explain any two components of the chart.
2. What is cell reference?
3. What is the use of the SUM( ) function?
4. What are the Text functions? Write the names of any two Mathematical functions.
5. What is the use of the IF function? Explain with example.
6. What are the rules to enter a function?
Scratch Your Brain. Century #Critical Thinking
21 st
Skills #Communication
1. Solve the crossword using the clues.
Across:
3. Symbols that specify 1 2
calculations to be performed
4
5. Function used to convert 3 E O S
text string into upper case
7. Numbers or text that do not
change
5 U R Y 6
8. Function used to convert
text string into lower case
9. Function used to multiply 7 C N
values in cells
8 O R
Down:
1. Cell address that is to be
used in a calculation
9 O T
2. Function used to display
current date
4. Function used to add values in cells
6. Predefined formula in Excel
48 Plus (Ver. 4.0)-VI

