PT-II Examination -- IX (IT)

Last updated over 5 years ago

33 questions

0

1

2

3

5

Library

PT-II Examination -- IX (IT)

Last updated over 5 years ago

33 questions

                                   Class IX (IT)- PT-II Examination-2020
Instructions:-
A. This Question paper contains following two COMPULSORY parts:-
      i)PART 1-OBJECTIVE-(Ques no 1 to 20)- 20 Marks, (No Negative Marking)
      ii)PART 2- SUBJECTIVE -(Ques no 21 to 30)-20 Marks
B. Part 1 - Objective must be attempt in form of online quiz, Tick correct options of ques 1 to 20 and finally click 
     on submit button. Once a quiz has been submitted then you can not change your answers.
C. Part 2- Subjective is in format of pen paper test. You have to write answers in here or in notebook and scan 
     the answer by mobile after writing in notebook and upload file in one PDF format in "show your work" 
     questions.

0

Name of Student

0

Roll No. of Student

0

PART-A (Objective section)

1

PART-B (Subjective section)
From Question no. 21 to 24 attempt any 3 questions.

2

Q. 21 Aadya is working on a spreadsheet. Help her with the solutions for the following :
(a) Identify the following symbol/toolbar and mention its use: $
(b) Renaming a worksheet from sheet1 to Cost Sheet.

2

Q. 22 Mention any four parts of LibreOffice Calc.

2

Q. 23 What are the steps to
(i) insert a colum left to the position of the cursor
(ii) insert a row right to the position of the cursor

2

Q.24: - Give any two uses of the fill handle.

From Question no. 25 to 28 attempt any 3 questions.

3

Q. 25 Consider the following data :
a) Write the formula to find the sum of all subjects of Kerry and Risha.
b) Write the formula to find the average of marks of John.
c) Write the formula to find total marks in science by all the students.

3

Q. 26 Give the syntax and example of any three mathematical functions in spreadsheet.

3

Q. 27 What are the three types of referencing in LibreOffice Calc.

3

Q. 28 Mention and explain three different types of data that can be entered in a worksheet.

From Question no. 29 to 30 attempt any 1 question.

5

Q. 29 Write steps for the following:

5

Q. 30 Write the steps to insert a chart in Calc.

                                   Class IX (IT)- PT-II Examination-2020
Instructions:-
A. This Question paper contains following two COMPULSORY parts:-
      i)PART 1-OBJECTIVE-(Ques no 1 to 20)- 20 Marks, (No Negative Marking)
      ii)PART 2- SUBJECTIVE -(Ques no 21 to 30)-20 Marks
B. Part 1 - Objective must be attempt in form of online quiz, Tick correct options of ques 1 to 20 and finally click 
     on submit button. Once a quiz has been submitted then you can not change your answers.
C. Part 2- Subjective is in format of pen paper test. You have to write answers in here or in notebook and scan 
     the answer by mobile after writing in notebook and upload file in one PDF format in "show your work" 
     questions.

Name of Student

Roll No. of Student

Class and Sec of Student

IX E

IX F

PART-A (Objective section)

Q:-1 A function should start with __________________

a) '=' sign

b) alphabets

c) numbers

d) all of these

Q:-2 Which of the following technique can be used to allow only data value in cell ?

a) Data formatting

b) Data sorting

c) Data filtering

d) Data validation

Q:-3 What is the name of mechanism to arrange the data in a particular order ?

a) Sorting

b) Searching

c) Filtering

d) Validating

Q:-4 Which of the following type of package does Calc refer to ?

a) Spreadsheet

b) Double sheet

c) Multi-sheet

d) Cannot determine

Q:-5 How many axes does charts in Calc have ?

a) Two

b) Three

c) Two or three

d) Four

Q:-6 A cell is a combination of ________________________.

a) row

b) column

c) row and column

d) none of the above 

Q:-7 $A1$B2 is an example of ____________________.

a) Relative Referencing

b) Mixed Referencing

c) Absolute Referencing

d) All of the above

Q.8 Which of the following is an extension of a worksheet created in Calc ?

a) .ods

b) .odd

c) .xls

d) .obj

Q:-9 We can replace multiple occurences of a word using which of the following facilities of Calc ?

a) Find and replace

b) By replace only

c) By copy command

d) By preview command

Q:-10 Which of the following option is used to print a chart ?

a) Insert --> Chart

b) File --> View

c) File --> Print

d) View --> Chart

Q:-11 The column immediately next to column "Z" is __

a) AA

b) A

c) ZA

d) None of the above

Q:-12 Numbers entered into a cell are automatically ___________ aligned.

a) Right

b) Left

c) Center

d) Justified

Q:-13 The spreadsheet feature used to continue the series is called as ______________.

a) File Handle

b) Fill Handle

c) Both

d) None of Above

Q:-14 How can one calculate the total of values entered in a worksheet column of ?

a) By manual entry

b) By auto sum

c) By formula

d) By sum function

Q:-15 In _____________ referencing, the reference changes rows and columns automatically when it is copied to a new cell.

a) Relative

b) Mixed

c) Absolute

d) All of these

Q:-16 The numerical data consisting of only numbers are called ____________.

a) Label

b) Values

c) Formulae

d) Data

Q:-17 A block of adjacent cells in a worksheet which is highlighted or selected is called ________________

a) range of cells

b) row range

c) column range

d) row and column range

Q:-18 ________________________ search the function from the list of available functions.

a) Toolbars

b) Name box

c) Function Wizard

d) Worksheet

Q:-19 Which of following is not an example of a spreadsheet softwares?

a) Microsoft Excel

b) LibreOffice Calc

c) Internet Explorer

d) OpenOffice Calc

Q:-20 ______________ is the any text entered by using a keyboard.

a) Label

b) Formulae

c) Values

d) Alphabets

PART-B (Subjective section)
From Question no. 21 to 24 attempt any 3 questions.

Q. 21 Aadya is working on a spreadsheet. Help her with the solutions for the following :
(a) Identify the following symbol/toolbar and mention its use: $
(b) Renaming a worksheet from sheet1 to Cost Sheet.

Q. 22 Mention any four parts of LibreOffice Calc.

Q. 23 What are the steps to
(i) insert a colum left to the position of the cursor
(ii) insert a row right to the position of the cursor

Q.24: - Give any two uses of the fill handle.

From Question no. 25 to 28 attempt any 3 questions.

Q. 25 Consider the following data :
a) Write the formula to find the sum of all subjects of Kerry and Risha.
b) Write the formula to find the average of marks of John.
c) Write the formula to find total marks in science by all the students.

Q. 26 Give the syntax and example of any three mathematical functions in spreadsheet.

Q. 27 What are the three types of referencing in LibreOffice Calc.

Q. 28 Mention and explain three different types of data that can be entered in a worksheet.

From Question no. 29 to 30 attempt any 1 question.

Q. 29 Write steps for the following:

Q. 30 Write the steps to insert a chart in Calc.

Class and Sec of Student

IX E

IX F

Q:-1 A function should start with __________________

a) '=' sign

b) alphabets

c) numbers

d) all of these

Q:-2 Which of the following technique can be used to allow only data value in cell ?

a) Data formatting

b) Data sorting

c) Data filtering

d) Data validation

Q:-3 What is the name of mechanism to arrange the data in a particular order ?

a) Sorting

b) Searching

c) Filtering

d) Validating

Q:-4 Which of the following type of package does Calc refer to ?

a) Spreadsheet

b) Double sheet

c) Multi-sheet

d) Cannot determine

Q:-5 How many axes does charts in Calc have ?

a) Two

b) Three

c) Two or three

d) Four

Q:-6 A cell is a combination of ________________________.

a) row

b) column

c) row and column

d) none of the above 

Q:-7 $A1$B2 is an example of ____________________.

a) Relative Referencing

b) Mixed Referencing

c) Absolute Referencing

d) All of the above

Q.8 Which of the following is an extension of a worksheet created in Calc ?

a) .ods

b) .odd

c) .xls

d) .obj

Q:-9 We can replace multiple occurences of a word using which of the following facilities of Calc ?

a) Find and replace

b) By replace only

c) By copy command

d) By preview command

Q:-10 Which of the following option is used to print a chart ?

a) Insert --> Chart

b) File --> View

c) File --> Print

d) View --> Chart

Q:-11 The column immediately next to column "Z" is __

a) AA

b) A

c) ZA

d) None of the above

Q:-12 Numbers entered into a cell are automatically ___________ aligned.

a) Right

b) Left

c) Center

d) Justified

Q:-13 The spreadsheet feature used to continue the series is called as ______________.

a) File Handle

b) Fill Handle

c) Both

d) None of Above

Q:-14 How can one calculate the total of values entered in a worksheet column of ?

a) By manual entry

b) By auto sum

c) By formula

d) By sum function

Q:-15 In _____________ referencing, the reference changes rows and columns automatically when it is copied to a new cell.

a) Relative

b) Mixed

c) Absolute

d) All of these

Q:-16 The numerical data consisting of only numbers are called ____________.

a) Label

b) Values

c) Formulae

d) Data

Q:-17 A block of adjacent cells in a worksheet which is highlighted or selected is called ________________

a) range of cells

b) row range

c) column range

d) row and column range

Q:-18 ________________________ search the function from the list of available functions.

a) Toolbars

b) Name box

c) Function Wizard

d) Worksheet

Q:-19 Which of following is not an example of a spreadsheet softwares?

a) Microsoft Excel

b) LibreOffice Calc

c) Internet Explorer

d) OpenOffice Calc

Q:-20 ______________ is the any text entered by using a keyboard.

a) Label

b) Formulae

c) Values

d) Alphabets

PT-II Examination -- IX (IT)

PT-II Examination -- IX (IT)

Name of Student

Roll No. of Student

Q. 21 Aadya is working on a spreadsheet. Help her with the solutions for the following :(a) Identify the following symbol/toolbar and mention its use: $(b) Renaming a worksheet from sheet1 to Cost Sheet.

Q. 22 Mention any four parts of LibreOffice Calc.

Q. 23 What are the steps to (i) insert a colum left to the position of the cursor(ii) insert a row right to the position of the cursor

Q.24: - Give any two uses of the fill handle.

Q. 25 Consider the following data :a) Write the formula to find the sum of all subjects of Kerry and Risha.b) Write the formula to find the average of marks of John.c) Write the formula to find total marks in science by all the students.

Q. 26 Give the syntax and example of any three mathematical functions in spreadsheet.

Q. 27 What are the three types of referencing in LibreOffice Calc.

Q. 28 Mention and explain three different types of data that can be entered in a worksheet.

Q. 29 Write steps for the following:

Q. 30 Write the steps to insert a chart in Calc.

Name of Student

Roll No. of Student

Class and Sec of Student

Q:-1 A function should start with __________________

Q:-2 Which of the following technique can be used to allow only data value in cell ?

Q:-3 What is the name of mechanism to arrange the data in a particular order ?

Q:-4 Which of the following type of package does Calc refer to ?

Q:-5 How many axes does charts in Calc have ?

Q:-6 A cell is a combination of ________________________.

Q:-7 $A1$B2 is an example of ____________________.

Q.8 Which of the following is an extension of a worksheet created in Calc ?

Q:-9 We can replace multiple occurences of a word using which of the following facilities of Calc ?

Q:-10 Which of the following option is used to print a chart ?

Q:-11 The column immediately next to column "Z" is __

Q:-12 Numbers entered into a cell are automatically ___________ aligned.

Q:-13 The spreadsheet feature used to continue the series is called as ______________.

Q:-14 How can one calculate the total of values entered in a worksheet column of ?

Q:-15 In _____________ referencing, the reference changes rows and columns automatically when it is copied to a new cell.

Q:-16 The numerical data consisting of only numbers are called ____________.

Q:-17 A block of adjacent cells in a worksheet which is highlighted or selected is called ________________

Q:-18 ________________________ search the function from the list of available functions.

Q:-19 Which of following is not an example of a spreadsheet softwares?

Q:-20 ______________ is the any text entered by using a keyboard.

Q. 21 Aadya is working on a spreadsheet. Help her with the solutions for the following :(a) Identify the following symbol/toolbar and mention its use: $(b) Renaming a worksheet from sheet1 to Cost Sheet.

Q. 22 Mention any four parts of LibreOffice Calc.

Q. 23 What are the steps to (i) insert a colum left to the position of the cursor(ii) insert a row right to the position of the cursor

Q.24: - Give any two uses of the fill handle.

Q. 25 Consider the following data :a) Write the formula to find the sum of all subjects of Kerry and Risha.b) Write the formula to find the average of marks of John.c) Write the formula to find total marks in science by all the students.

Q. 26 Give the syntax and example of any three mathematical functions in spreadsheet.

Q. 27 What are the three types of referencing in LibreOffice Calc.

Q. 28 Mention and explain three different types of data that can be entered in a worksheet.

Q. 29 Write steps for the following:

Q. 30 Write the steps to insert a chart in Calc.

Q. 21 Aadya is working on a spreadsheet. Help her with the solutions for the following :
(a) Identify the following symbol/toolbar and mention its use: $
(b) Renaming a worksheet from sheet1 to Cost Sheet.

Q. 23 What are the steps to
(i) insert a colum left to the position of the cursor
(ii) insert a row right to the position of the cursor

Q. 25 Consider the following data :
a) Write the formula to find the sum of all subjects of Kerry and Risha.
b) Write the formula to find the average of marks of John.
c) Write the formula to find total marks in science by all the students.

Q. 21 Aadya is working on a spreadsheet. Help her with the solutions for the following :
(a) Identify the following symbol/toolbar and mention its use: $
(b) Renaming a worksheet from sheet1 to Cost Sheet.

Q. 23 What are the steps to
(i) insert a colum left to the position of the cursor
(ii) insert a row right to the position of the cursor

Q. 25 Consider the following data :
a) Write the formula to find the sum of all subjects of Kerry and Risha.
b) Write the formula to find the average of marks of John.
c) Write the formula to find total marks in science by all the students.