IT

REVISION TEST 1
SECTION A
Question 1. Answer any 4 out of the given 6 questions based on Employability Skills. (4 × 1 = 4)
(i) What is a file?
(a) A file is a section of main storage used to store data.
(b) A file is a collection of information that has been given a name and has an extension.
(c) A file is the part of a program that is used to describe what the program should do.
(d) A file can be saved only on CDs.
(ii) In _______, we change from our normal activities to silence.
(a) meditation (c) worries
(b) stress (d) survival
(iii) _______ is a common response to danger in all people and animals.
(a) Internal stress (c) Survival stress
(b) Environmental stress (d) Fatigue related stress
(iv) Effective communication involves
(a) Speaking only (c) Speaking and listening
(b) Listening only (d) Writing and reading
(v) To find a suitable market an entrepreneur performs the functions of
(a) advertisement and publicity
(b) appointment of selling agents
(c) new organization structure
(d) Both (a) and (b)
(vi) What is the meaning of sustainable development?
(a) Development that focuses on economic growth only
(b) Development that meets the needs of the present without compromising future
generations
(c) Development that prioritizes social progress over environmental protection
(d) Development that relies solely on renewable energy sources
Question 2. Answer any 5 out of the given 6 questions. (5 × 1 = 5)
(i) Safari is a web browser developed by _______
(a) Google (c) Apple
(b) Microsoft (d) None of these
(ii) When you define a field for a table, in which of the following parameters is access always
considered optional?
(a) Field name (c) Field size
(b) Data type (d) Description
(iii) A _______ is a language that enables users to access and manipulate data in a database.
(a) DML (b) DCL (c) TCL (d) DDL
(iv) _______ include fonts, alignment, borders, background, number formats (for example, currency,
date, number), and cell protection in the document.
(a) Cell style (c) Paragraph style
(b) Numbering style (d) Character style
(v) When you apply a _______, you apply a group of formatting effects together in one single
step.
(a) effect (b) template (c) style (d) format
(vi) Akshat wants to store a huge amount of information about his firm in a database.
Which type of table organization would be most suitable for this purpose?
(a) Relational (c) Either relational or flat file
(b) Flat file (d) Hierarchical
Question 3. Answer any 5 out of the given 6 questions. (5 × 1 = 5)
(i) Select _______ → Track changes →
Record from the menu bar. Thereafter, every change you record on the spreadsheet will
have a red border around it.
(a) File (c) Format
(b) Edit (d) Layout
(ii) Calc considers any data that it does not recognize as a number, date, time, or formula,
as:
(a) Expression (c) Text
(b) Equation (d) Function
(iii) In _______ topology, each node is connected to two and only two neighbouring nodes.
(a) star (c) mesh
(b) ring (d) tree
(iv) State True or False.
‘Goal seek in Calc, helps us to find the desired result by adjusting an input value.’
(a) True
(b) False
(v) Rajiv was asked to highlight the cells with green colour where the value entered is either
greater than or equal to 120 in the worksheet containing thousands of data entries. Which
feature of Calc should he use to get this work done within seconds?
(a) Conditional formatting (c) Sorting
(b) Filtering (d) Simple formatting
(vi) Which of the following tools will help Swati, if she wants to arrange the height of
students in her class in ascending order?
(a) Ordering data (b) Sorting data (c) Presenting data (d) Referring data
Question 4. Answer any 5 out of the given 6 questions. (5 × 1 = 5)
(i) In URL, http://www.arihant.com/index.htm, which component identifies the path of a web
page?
(a) http (c) /index, htm
(b) www.arihant.com (d) All of the above
(ii) What dialog box opens on choosing File → Templates → Manage Templates in Writer?
(a) The File dialog box
(b) The Manage Templates dialog box
(c) The Templates dialog box
(d) The Record Template dialog box
(iii) _______ are the ways to produce the data stored in databases and tables in a printed
form.
(a) Forms (b) Queries (c) Reports (d) Data
(iv) Arnab learned about the software that gets installed on the computer without the user’s
knowledge. Help him to find the name of the same.
(a) Spyware (c) Adware
(b) Malware (d) None of these
(v) Tamanna wants to know the name of the kind of software that seems useful in the
beginning but will cause damage to the computer once installed. What is such a kind of
software called?
(a) Trojan horse (b) Worm (c) Malware (d) Virus
(vi) Which shortcut key is used to make the selected text italic?
(a) Ctrl + I (c) FI + I
(b) Shift + I (d) None of these
Question 5. Answer any 5 out of the given 6 questions. (5 × 1 = 5)
(i) If the two departments (HR and IT) access the data simultaneously then only one
department will see the updates by the other department. DBMS solves this issue. Thus,
DBMS helps to avoid _______ which means if a single database is used by multiple users
then it also ensures that the same data is present for all the users.
(a) Data redundancy (c) Data piracy
(b) Data inconsistency (d) Data modification
(ii) Line or paragraph spacing is measured in terms of lines or points, which is referred as
_______
(a) text wrapping (b) PDF (c) XPS (d) leading
(iii) Rinky wants to know about the Number data type in Calc. Which of the following
statement(s) is/are TRUE about it?
(a) Numbers are generally raw numbers or dates.
(b) Numbers can be started with a dollar sign ($) or with some other currency symbols to
display as currency.
(c) By default, the number and date data are aligned to the right in Calc.
(d) All of the above
(iv) How much space does the DATE/TIME data type hold in Base?
(a) 2 bytes (b) 4 bytes (c) 8 bytes (d) 10 bytes
(v) Which tab is used to create a Table of Contents in a document?
(a) File tab (c) Insert tab
(b) Format tab (d) Styles tab
(vi) _______ is a form of electronic commerce that allows customers to directly buy goods or
services from a seller on the Internet.
(a) E-Shopping (c) E-buying
(b) E-ticketing (d) E-Delivery
SECTION B
Answer any 4 out of the given 6 questions in 20-30 words each. (4 × 2 = 8)
Q11 . What do you mean by template?
Q12 . What is the difference between absolute and relative hyperlinks as used in Calc?
Q13 . What is the role of a foreign key in a database management system (DBMS)?
Q14 . Write the steps to insert a record in a Datasheet View.
Q15 . Elucidate the following terms: (i) PAN (ii) WiMAX
Q16 . State any two practices for internet security.
SECTION C
Answer any 3 out of the given 5 questions in 50-80 words each. (3 × 4 = 12)
Q17 . Rita is working on a spreadsheet. She wants to know about the use of the
following terms: (a) Quick Sort (b) Filtering Data
Q18 . Riddhima wants to know about mailing labels in a word processor. Help her to
find the answers to the given questions.
(a) What is a mailing label?
(b) What are the ways to prepare and print mailing labels?
Q19 . Consider the following table PRODUCT
TABLE: PRODUCT

(i) How many fields and records are there in the PRODUCT table?
(ii) (ii) Write SQL queries for the following:
(a) Display all Products whose Qty is between 100 and 400.
(b) Display S_Name, P_Name, and Cost for all the Products whose Qty is
less than 300.
(c) Display all the records alphabetically by S_Name.
Q20 . Shubham is learning about DBMS. He wants to know about the following: (4)
(a) The purpose of DBMS
(b) Any two uses of DBMS