Page 33 - Touchpad_Plus_V3.2_Class 7
P. 33
F. Long answer type questions.
1. What do you mean by Formula? Explain with examples.
.....................................................................................................................................................................................
.....................................................................................................................................................................................
.....................................................................................................................................................................................
2. What are the certain rules of precedence that Calc follows?
.....................................................................................................................................................................................
.....................................................................................................................................................................................
.....................................................................................................................................................................................
3. What is the use of the CONACTENATE function? Explain with example.
.....................................................................................................................................................................................
.....................................................................................................................................................................................
.....................................................................................................................................................................................
4. What are rules to enter a function?
.....................................................................................................................................................................................
.....................................................................................................................................................................................
.....................................................................................................................................................................................
5. Differentiate between Column chart and Bar chart.
.....................................................................................................................................................................................
.....................................................................................................................................................................................
.....................................................................................................................................................................................
Mind Boggler
A. Competency-based/Application-based questions. Century #Technology Literacy
21 st
1. Suman wants to present the information in the form of a chart. She Skills
has a data of single series and the graph must show relative circular size of each
value. Which chart type must she use?
2. Ankita has made a spreadsheet for the marks obtained by the students of her
class indifferent subjects. Which feature should she use to keep the marksheet
updated if she has to change marks in one of the subjects for any student?
B. Solve the crossword using the given clues. 21 st
Century #Critical Thinking
Down Skills
1. Cell address that is to be used in a calculation
2. Function used to display current date
4. Function used to add values in cells
6. Predefined formula in Calc
7. Chart type in which data is displayed in the form of vertical bars
Formulas, Functions and Charts in Calc 31

