CBSE, class 7, It computer, unit 2 functions and charts in calc

CBSE, class 7, It computer, unit 2 functions and charts in calc

Q.1 If we use =ROUND() formula, so what was the output.

a. =Round(45.22) 

Answer : 45

 

b. =Round(68.88)

Answer : 69

 

Q.2 If we use =GCD() formula, so what was the output.

 

c. =GCD(2;4;6;8;24)

Answer: 2

 

d. = gcd(6;12;24) 

Answer: 6

 

Q.3 If we use =LCM() formula, so what was the output. a. =LCM(3;6;9)

Answer : 18

 

Q.4 If we use =Date() formula, so what was the output. a. =Date(1994;5;4)

Answer: 5-4-1994

 

Q.5 A __________ reads each statement of the source program, converts it into the machine language and then executes.

Answer : Interpriter

 

Q.6 MS Excel is which type of application software?

Answer: General Purpose

 

Q.7 Which one is correct example of utility software?

Answer: WinZip

 

Q.8 Which one is correct example of Propitiatory software?

Answer: Microsoft Office

 

Q.9 Write Correct output of given below.

 

1. =LEN("Podar_# School")

Answer : 14

 

2. =upper("today is saturday")

Answer : TODAY IS SATURDAY

 

3. In date format which one is correct syntax. 

Answer: =date(yyyy;mm;dd)

 

4. which one is correct syntax for Round formula.

Answer : =Round(Number)

 

5.Function wizard icon placed in the ____________ toolbar.

Answer: Formula

 

Q.10 Write Correct Answer.

a. Write types of application software.

Answer : 1. General Purpose Software, 2. Customize Software

 

b. Write Time function syntax with appropriate example.

Answer : =time(hours; minutes; second)

 

c. Write any one example of FOSS.

Answer : Openoffice, PHP, Ubuntu