HYE-QUESTION BANK

Grade: VII Subject: Computer

Studies
Chapter 2: Functions and Charts in Calc

Q. I Choose the correct option

1. This feature of Calc is used to display cell values with a particular colour or background depending
on the specified conditions.
(a) auto fill (b) data validation
(c) conditional formatting (d) auto complete

2. Which of the following will correctly convert the text “DUBBAI” to lowercase letters?
(a) =lower(“DUBAI”) (b)=lower(DUBAI)
(c) =low(“DUBAI) (d) lower(DUBAI)

3. Which chart can be used in OpenOffice Calc for comparing individual items in a set of data?
(a) line chart (b) column chart
(c) pie chart (d) bar chart

4. In OpenOffice Calc, a type of cell reference that is specified using a dollar sign ($) in front of a row
and column.
(a) Range (b) relative cell reference
(c) absolute cell reference (d) mixed cell reference

5. Which of the following syntax will correctly display the current date?
(a) today(date) (b) =TODAY()
(c)=TODAY(“ “) (d) =today

6. Identify the correct syntax of the function in Calc used to convert the text “ASIA” into lowercase
letters.
(a) lower(ASIA) (b) =lower(“ASIA”)
(c) =lower(ASIA) (d) =low(“ASIA)

7.Which of the following syntax is correct when converting a text “MUMBAI” to lowercase letters?
(a) lower(MUMBAI) (b) =LOWER(“MUMBAI”)
(c) =lower(MUMBAI) (d) =low(“MUMBAI)

8. What will be the output of the following function in Calc? =TIME (18; 40 ;22)
(a) 18:40:22 AM (b) 6:40:22 AM
(c) 6:40:22 PM (d) 18:40:22 PM

9.A logical function in Calc that first evaluates the condition specified and returns one value if the
condition is met and another value if the condition is not met.
(a) upper () (b) if()
(c) GCD () (d) len ()
 10 .Identify the type of cell reference used in the following. = $D$1 + $E$1
(a) Absolute (b) Relative
(c) both i and ii (d) none of these

11. Identify the correct syntax for displaying the current date in OpenOffice Calc?
(a) =TODAY() (b) =TODAY(“ “)
(c) =today (d) today(date)

12. What will be the output of the following function in Calc? =LEN(“Very Happy”)
(a) 6 (b) 8
(c) 10 (d) 9

13. This error occurs in OpenOffice Calc when the formula has the wrong type of arguments.
(a) #DIV/0! (b) ######
(c) ‘#VALUE?’ (d) none of these

14. What will be the output of the following function in OpenOffice Calc? =GCD(6;18;24)
(a) 6 (b) 7
(c) 5 (d) 9

15.This feature quickly extracts data from the spreadsheet that meets certain criteria.
(a) Sorting (b) Filtering
(c) Conditional formatting (d) Both (i) and (ii)

16. This type of chart is used to illustrate changes in a value over a period of time.
(a) Line (b) Bar
(c) Pie (d) Column

17. This feature in Calc allows us to make the worksheet more interesting by highlighting data based
on certain conditions
(a) Filtering (b) Sorting
(c) Conditional formatting (d) None of these

Q.II Fill in the blanks

1. The _______________ error means that there is an error in the formula, range or name of the
function.
2. The _______________is a location-based cell reference.
3. The _______________ chart is used to illustrate the changes in a value over a period of time.

4. The _______________feature of the Calc worksheet allows you to rearrange data in an efficient
manner

5. The _______________ feature helps to quickly extract data from the spreadsheet that meets
certain criteria.

Q. III Answer the following question in short

1. Identify the type of cell reference.
a. = C1 + D1
b. = $A$1 + $B$1
c. = A2 + B2+ C2
d. = B$1 + C$1

2. What will be the output of the following functions in Calc?

a. =UPPER(“Mango”)
b. =LEN(“Social Studies”)
c. =ROUND(855456666; 3)
d. =TIME(22;30;25)
e. =GCD(80;6;8)
f. =LCM(68;4)
g. =LEN(“PLANET EARTH”)
h. =POWER(8, 2)
i. =TIME(22;15;30)
j. =PRODUCT(3, 4, 5)
k. =ROUND(78.5555556)

3.Identify the types of charts shown below.

1.

2.

4 .Why do we use charts in OpenOffice Calc?

 5. Explain the following charts. Give an example of where they can be used.
(a) Pie chart
(b) Line chart

6. Kajal has performed addition using the sum () function on two different sets of data in
OpenOffice Calc. She got the following errors. What do these errors mean?
(a) ‘#Name?’
(b) ‘#VALUE?’

Q. IV Answer the following questions.

1. What are the different errors that can occur while using functions in Calc?
2. You have maintained the record of students marks in OpenOffice Calc to show how many students
have passed or failed.

(a)The formula ‘=B2+C2+D2+E2’ is used to find the total marks of Umesh. Which type of cell
reference is used in the formula?
(b) Write down the function to assign ‘Good’ to the students who have scored total more than 200
and ‘Fair’ to students who have scored less than 150 in the cell H2.
iii What type of chart will be most suitable to compare the marks scored in different subjects by
each student?

3. Differentiate between relative cell reference and absolute cell reference.

4. Observe the spreadsheet and answer the following questions.
 1.Which feature of Calc will you use to view the records of students with ‘Total Marks’ less than
130 and hide the remaining records?

(b) Which feature will you use to arrange the records of the students in ascending order of ‘Total
Marks’?

(c) Write a function to assign ‘Excellent’ to all those who have scored ‘Total Marks’ more than or
equal to 150. It should also assign ‘Good’ to those who have scored Total Marks less than 150.

***********************************************************************************