REVATHI HIGH SCHOOL SHANKERPALLY

Time: 2 Hours IT -SLIP TEST-OCT- 2024-2025 Maximum Marks: 50

Instructions:
 Please read the instructions carefully.
 This Question Paper consists of 21 questions in two sections: Section A & Section B.
 Section A has Objective Type Questions whereas Section B contains Subjective Type Questions.
 Out of the given (5 + 16 = 21) questions, a candidate has to answer (5 + 10 = 15) questions in the allotted
(maximum) time of 2 hours.
 All questions of a particular section must be attempted in the correct order.
 Section A: Objective Type Questions (24 Marks)

 This section has 5 questions.

 Marks allotted are mentioned against each question/part.
 There is no negative marking.
 Do as per the instructions given.
Section B: Subjective Type Questions (26 Marks)
 This section has 16 questions.
 A candidate has to do 10 questions.
 Do as per the instructions given.
 Marks allotted are mentioned against each question/part.

Section A - Objective Type Questions

Question 1. Answer any 4 out of the given 6 questions based on Employability Skills. (4 × 1 = 4)
1. _ is a command of calculation that collage collate the data from different ranges and places it in a worksheet.
a) consolidate b) combining c) subtitles d) scenario
2. The ____________is an important feature of calc that you use to test the ‘what if’ questions
a) scenarios b) solver c) calculate d) consolidate
3. ____________is used to set a goal to find the optimum value for one or more target variables.
a) scenarios b) goal seek c) Detective d) solver
4. In the following formula the phrase record of students refers to a: = SUM ($ records of students B4: D4)
a) sheet name b) range c) database d) file name
Question 2. Answer any 5 out of the given 6 questions. (5 × 1 = 5)
1. The hyperlink options is available in the ____________menu
a) insert b) view c) data d) tools
2. Which of the following is a keyboard shortcut to open the data source view pane?
a) control + shift + F4 b) ctrl + F4 c) shift + F4 d) f4
3. Which of the following menu contains the share document option?
a) tools b) edit c) file d) share
4. Which dialogue box allows you to accept or reject changes in a spreadsheet
a) manage changes b) so changes c) record changes d) track changes
5. Which dialogue box helps you to fix conflicts changes in a spreadsheet.
a) manage changes b) resolve conflicts c) correct conflicts d) fix conflicts
Question 3. Answer any 5 out of the given 6 questions. (5 × 1 = 5)
1. The ____________option is used to start recording a macro
a) record macro b) macro viewer c) recorder d) micro creator
2. Which of the following action cannot be recorded while creating a macro?

1
 a) windows switching b) entering data c) entering formulas d) copying data
3. Which of the following keyword is used to define a macro as function?
a) function b) macro c) module d) define
4. A ____________is a line of code that excludes when you call it
a) name b) function c) parameter d) values
5. ____________automate the recorded actions and save your time and effort
a) function b) macro c) keystroke d) module
Question 4. Answer any 5 out of the given 6 questions. (5 × 1 = 5)
1. The ____________feature of calc, select the content of sales from several worksheets and maintains the
collected data in a master worksheet
a) subtotals b) consolidate c) data provider d) merge data
2. Which may know has a sub total command in calc
a) to b) sheet c) data d) total
3. To which awesome to a particular scenario in Kalsi, you can use the ____________
a) navigator b) navigation toolbar c) forward Arrow d) backward arrow
4. The ____________command is used to record the changes made by multiple users in a spreadsheet for letter
review later review
a) Edit changes record b) edit track changes c) edit changes track d) edit record changes
5. The cell reference for cell range of G2 to M12 is ____________
a) G2 M12 b) G2M12 c) G2M12 d) G2m12
Question 5. Answer any 5 out of the given 6 questions. (5 × 1 = 5)
1. Which of the following is an example of absolute hyperlink?
a) \capture.jpg b) https://kips.in/index.php/books
c) C:\\capture.jpg d) D://image.png
2. In a spreadsheet the authors and their reviews can add their own _________
to the changes that they have made to explain why they have made this change.
a) comment b) reviews c) tracks d) copies
3. In which programming languages that calc records the macro code.
a) Basic b) PHP c) COBOL d) Python
4. Which function cannot be performed through subtotals in a spreadsheet?
a) sum b) product c) average d) percentage

Section B - Subjective Type Questions

Answer any 3 out of the given 5 qs based on Employability Skills. Answer each question in 20-30 Words. (3×2= 6)
6. Why do you consolidate data?
7. List any two benefits of linking spreadsheet
8. Define goal seek?

Answer any 4 out of the given 6 questions in 20-30 words each. (4 × 2 = 8)

9. How do you insert a new sheet in a workbook?
10. What are hyperlinks in calc?
11. What is a purpose of external data dialogue box?
12. How do you view registered data in calc?

Answer any 3 out of the given 5 questions in 50-80 words each. (3 × 4 = 12)
13. What is macro? What are the uses of macro?
14. What do mean by subtotal? Explain its use with the help of an example?
2
15. What is a solver? How is it different from goal seek in calc?
The ______________is the collection of data is stored in a systematic manner
a database be data where C information d software
Record in a table refers to a ______________value in
a field B single field C set of related fields d 2 common fields
Which of the following is not true about the primary key.
a primary key uniquely identify record
b a table can have only one primary key
C a primary key field can be null
d a primary key can have duplicate value.
A ______________enable the user to store data in several tables .
a. Data redundancy composite key null relational model
______________means many users can access and modified the shared data at the same time without violating
the data consistency
A data read tendency be data concurrency C composite key d relational model
Which of the following is not a database object ?
A tables be hand out see report d queries
Which of the following wizard open when you launch OpenOffice on your computer
A table wizard be database wizard C paste wizard d data wizard

The dash field types holds number with decimals

A float (FLOAT) BOOLEAN C text TEXT D number NUMERIC

A DASH DETERMINES WHAT TYPE OF DATA YOU CAN ENTER INTO A FIELD OF A TABLE
A DATA TYPE B DATABASE C FORMS D TABLES

A DASH IS JUST LIKE A CONTAINER THAT HOLDS VARIOUS OBJECTS TO CREATE AND MANIPULATE DATA.
A DATA TYPE B RECORD C FORMS D TABLES
THE DASH ARE THE BUILDING BLOCKS OF A DATABASE THAT STORE DATA ITEMS IN THE FORM OF ROWS AND
COLUMNS
A DATA TYPE B DATABASE C FORMS D TABLES RECORD

WHICH OF THESE OPTIONS IS USED TO CREATE A TABLE IN OPENOFFICE BASE A TABLE WIZARD BE TABLE DESIGN
VIEW SEE BOTH A AND B D DESIGN TABLE VIEW
DASH OPTION ENABLES YOU TO DELETE THE SELECTED RECORDS FROM A TABLE IN THE TABLE DATA VIEW
A. EDIT DELETE RECORD
B. FILE DELETE RECORD
C.TABLE DELETE RECORD
D DELETE EDIT RECORD
WHICH OF THE FOLLOWING IS TRUE ABOUT A REFERENTIAL INTEGRITY.
A ALL DIFFERENCES MUST BE VALID .
B USES CANNOT ACCIDENTALLY DELETE OR AMEND THE DATA
C. ENSURES THE ACCURACY AND CONSISTENCY
D ALL THE ABOVE.
WHICH OF THE FOLLOWING DIALOGUE BOX ALLOWS YOU TO ADD TABLES THE QUERIES IN THE QUERY DESIGN
PANE.
A ADD TABLE A QUERY BE QUADRI DIALOGUE BOXY QUERY DESIGN

3
D ADD QUERY
WHICH OF THE FOLLOWING OPTION IS USED WITH WILD CARDS.
A like. B where. C. Similar. D. Same
What does SQL stand for
A structure query language
B standard query language
C structured question language
D standard question language
It is a convenient and interactive way of entering data.
A. Form b. report c query d document
It is an effective way to organise and summarise the data from a database for viewing and printing a table B form
c query D report
It is a type of report that always dis place the same data from the time when it is created.
A dynamic B static c From form d. From table
In a database information is stored in the form of dash a rows be column C table D forms
Which of the following is not as characteristics of DBMS
A holds data in a standard format be increased data redundancy c ensures data security the maintain data
consistency
In which of the following database can you retrieve the data from the related table
A database management system be relational database management system C not file data is D big file data base
A table can have ....
Only one primary ke more than one primary key c. Two primary key D multiple primary key s
It confess of one or more fields whose value matches a primary key in another table a foreign key composite
primary key C composite sheet B candidate key
It is a data type that is used to show data or time or a combination of both a date or time we time see a d text
varchar

It is a rule in RDBMS that ensure the accuracy and consistency of data within a relationships and prevents the
uses from entering the inconsistent data.
Hey referential integrity B data integrity C data concurrency D data consistency
In this type of relationship a record in a table can have only one matching record in another table and vice versa.
A121 b12 mini see many to many to one
Which of the following is not a field property
[12:03 PM, 11/11/2024] Eshwar: A121 b12 mini see many to many to one
Which of the following is not a field property
Auto value be text varchar see default value field value
It is a DML command a select B create C draw D alter
Every – in a form has a set of properties a control be feel tired see data type b data set
True false a primary key can contain any duplicate data
True or false you cannot edit a relationship in a database
Question answers describe the database give any two real life example of it
Who uses database
What is data redundancy
Describe data inconsistency
What are the rules for defining a primary key
What are field types
What is referential integrity.

4
What is a query where is is the result of the query sorted in a OpenOffice base

How can you create a table in OpenOffice database using the table wizard.