Question bank

Chapter-1   Excel
Q-1 Fill in the blanks
(a) Median is the number in the middle, when the __________ are listed in order.
(b) Mode is another type of average that you want to know in a different ________________ .
(c) Range is the difference between the lowest and __________ values.
(d) Mean is the most common type of _____________ and generally refers to the arithmetic mean.
Q-2

Answer the following questions:

1. What do you mean by mean, median, mode?

2. What is range?

3. What do you mean by Excel?

4. What is calculation process?

5. How would you calculate the median in case there are even list of numbers?

Q-3

Write the formulae for the following:

a. Mean ----------------------------

b. Median ---------------------------------

C. Mode -------------------------

d. Range ----------------------------

Multiple Choice Questions
Q-1 The formula to calculate the most common type of average:

(i)

Median

(ii)

Mean

(iii)

Mode
Q-2 The function to calculate arithmetic mean for a given set of numbers:

(i)

= Avg (number1, number2, ............. )

(ii)

= Mean (number1, number2, .............)

(iii)

= Ave (number1, number2, .............)
Q-3 The function to calculate median for a given set of numbers:

(i)

= Median(number1, number2, .............)

(ii)

= Med(number1, number2, .............)

(iii)

Both a & b
Chapter-2   Advance Charting in Excel
Q-1 Fill in the blanks
(a) In a pie chart, the _________ of each sector is proportional to the quantity it represents.
(b) The Chart Wizard icon is present on the ______________.
(c) Chart Option is present in ____________ menu.
(d) The legends showing different colours represented by each subject is displayed over the right side of the pie _____________.
Q-2

Answer the following questions:

1. What do you understand by a pie chart?

2. In which sections the pie chart is divided?

Multiple Choice Questions
Q-1 A pie chart is a circular chart divided into _______.

(i)

tracks

(ii)

sectors

(iii)

Blocks
Q-2 In a zoo, there are 5 tigers, 5 lions and 5 deer. The pie chart for this data is divided into several sectors of different __________.

(i)

Sizes

(ii)

Colours

(iii)

shapes
Q-3 The Chart Wizard icon is present on the ____________.

(i)

Standard toolbar

(ii)

Formatting toolbar

(iii)

Drawing toolbar
Chapter-3   Photoshop
Q-1 Fill in the blanks
(a) Tools group menu command and pallets function are mainly used to ___________ digital image in Photoshop.
(b) The canvas size of image can be changed by changing its __________.
(c) Lasso tool is primarily used to create ____________ shape selection.
(d) All pixels of an image can be selected through a _______________ command.

(e) ________________ is used to trim any image.

(f) By using Move tool, selection can be shifted from one place to another.

(g) ________________  Tool helps in filling after copying one area of image.

(h) Marquee tool is used to select ______________  area of an image.

Q-2 True Or False
(a) Option bar displays the control to customize the tools selected through toolbox.
(b) Size of full image cannot be changed on monitor.
(c) Crop tool is used to trim any image.
(d) Marquee tool is used to select circular area of an image.

(e) You can change image visibility with the help of zoom tool.

Q-3

Answer the following questions:

1. Which company developed Adobe Photoshop?

2. Which tool is used to colour the images?

3. For which purpose Screen Mode is used?

4. What can we do by using Magic Wand tool?

5. What can we do with the help of the Eraser tool?

6. What can we do with the help of the Pencil tool?

7. Explain in brief about the Dodge tool.

8. Explain in brief about the JPEG format.

Q-4

Match the following:
Chapter-4   Flash
Q-1 True Or False
(a) Static text updates automatically at run time.
(b) Frame -by- Frame animation changes the contents of every frame.
(c) Keyframe allows you to play an animation.
(d) Press Ctrl+Enter to test the movie.

(e) Shape Tween changes the shape of an object.

(f) A password displays text in as text (********).

(g) Multiline displays font in multiple lines.

Q-2

Answer the following questions:

1. What do you mean by Tween? What are the different types of Tweens?

2. How will you insert frame, keyframe and blank keyframe in the timeline?

3. What are the different types of texts in Flash?

Q-3

Match the following:
Multiple Choice Questions
Q-1 

 ------------------- is the space between the pairs of characters.

(i)

Character Spacing

(ii)

Kerning

(iii)

Character Position

Q-2 

 ------------------- uses automatic kerning between texts.

(i)

Character Position

(ii)

Kerning

(iii)

Auto Kern

Q-3 

 ------------------- uses a single line to display text as one line.

(i)

Single Line

(ii)

Multiline

(iii)

Password

Q-4 

 ------------------ places the text on the baseline.

(i)

Subscript

(ii)

Superscript

(iii)

Normal

Q-5 

 ------------------ creates a text box in which a user can enter text.

(i)

Password

(ii)

Dynamic Text

(iii)

Input Text

Chapter-5   Computer Programming
Q-1 Fill in the blanks

(a) _____________ reads a program written in a source language and translates it into an _________.

(b) ________________ removes all comments, tabs, blank spaces and machine characters.

(c) ________________ checks and reports syntax errors.

(d) _________________ monitors the progress of the computation as the program executes.

(e) ____________  is a temporary stepping point within a program.

Q-2 True Or False
(a) Pseudo Code obeys the syntax rules of any particular language.
(b) Object Code contains binaries.
(c) Semantic analysis reports the syntax error.
(d) Syntax analysis does type checking.

(e) Debugging only detects an error in a program.

(f) Flow chart and Pseudo Code are two forms of algorithm.

(g) Compilation produces an error message in the source program.

Q-3

Answer the following questions:

1. What do you mean by Source Code?

2. What do you mean by Object Code?

3. What is Pseudo Code?

4. Write an algorithm in Pseudo Code to find the sum and average marks of three numbers.

5. What do you mean by Debugging?

Q-4

Define the following terms:

1. Tracing :  -------------------------------

2. Stepping : --------------------------

3. Break point : -----------------------

4. Compiler : ---------------------------

5. Flow chart : -----------------------

6. Lexical analysis: ------------------------

7. Syntax analysis: -----------------------

8. Debugging : ----------------------------

Q-5

Match the following:
Chapter-6   HTML
Q-1 Fill in the blanks

(a) _________________________ divides the section of text.

(b) _________________________ adds a block of text.

(c) _________________________ adds bullets and numbers.

(d) ____________and ___________ are the two types of lists.

Q-2

Answer the following questions:

1. What is meant by a table?

2. What are the different parts of a table?

3. What are ordered and unordered lists?

4. What is the use of a list tag?

Q-3

Define the following:

1. Heading : -------------------

2. Table : -----------------------

3. Table data : ------------------------

4. Paragraph : -----------------------

Q-4

Match the following:
Chapter-7   Visual Basic
Q-1 Fill in the blanks
(a) Not, And, Or are all ____________________ operators.
(b) __________________________ operator joins two or more strings.
(c) =<>,=are all __________________________ operators.
(d) The _________________________________ is used for joining two words.

(e) ______________  store some value while your program is running.

(f) _______________  and ________________  are three types of variable scopes.

(g) A _______________  specifies a list of values.

(h) +,-,x,/, are all ________________  operators.

Q-2

Answer the following questions:

1. What is meant by a control?

2. How will you insert a picture on the form?

3. How will you write a code editor window?

4. What are the different categories of operators in VB?

5. How will you declare a variable? Write about a syntax.

Q-3

Write short notes on the following:

1. Picture box ------------------------

2. Command button ----------------------

3. Frames --------------------------

4. Shape --------------------------

5. Text box -------------------------

Q-4

Match the following:
Multiple Choice Questions
Q-1 This tool allows the user to enter text at runtime.

(i)

List box

(ii)

Text box

(iii)

Check box
Q-2 This tool causes an action to occur when it is clicked.

(i)

Label

(ii)

Command button

(iii)

List box
Q-3 This tool allows you to display a picture on the form.

(i)

List box

(ii)

Picture

(iii)

Label
Q-4 This tool allows the user to display different shapes.

(i)

Label

(ii)

Shape

(iii)

Text box
Q-5 

This tool allows the user to specify a list of values.

(i)

List box

(ii)

Text box

(iii)

Label

Q-6 

This tool allows you to contain other objects.

(i)

Option box

(ii)

List box

(iii)

Frames

Q-7 

This tool allows you to choose either of the options.

(i)

Frames

(ii)

Text box

(iii)

Optional box

Chapter-8   C++ Programming
Q-1 Fill in the blanks

(a) Alt+F9 is the shortcut -------------------- option.

(b) Alt+F is the shortcut of ------------------ option.

(c) Control is a special type of an object on a ------------------  so as to enable a user's interaction.

(d) To display multiple lines or to create scrollable text box, set its multiline property ----------------- from properties window.

(e) ----------------------- is the shortcut of Run option.

(f) ------------------------------ receives input through the keyboard.

(g) Cin represents data coming from the --------------------------- .

(h) --------------------------- contains the declaration that are needed by cout and cin identifiers.

(i) END takes the cursor in the ------------------------ line.

(j) IDE stand for --------------------------- .

(k) -------------------------is the extension of C++ file.

(l) The user may type into a ------------------- box at runtime.

(m) To customize the Scroll bar, click over the Scroll bar option of the text box and change the

(n) In Visual Basic,---------------- is a graphics control which is used for displaying text.

Q-2 True Or False
(a) C++ program consists of one or more modules called functions.
(b) All variables must be declared after executing the statements.
(c) An expression represents a number or a character.
(d) Cout receives input through the mouse.

(e) Alt+F9 is the keyboard shortcut for compiler option.

(f) An array is a list of data elements of some types of.

(g) In VB, you may change the font, size and style of the label by clicking over Font Property.

(h) In C++, a declaration is a group of variables with a specific data type.

(i) In C++, an expression represents a number or a character.

(j) When you run a C++ program, the first executed statement will be at the beginning of a function known as Main().

Q-3

Answer the following questions:

1. What is meant by a declaration? Give an example.

2. What is meant by the term 'expressions'? Give an example.

3. Write down the steps of the compilation and execution of a program?

4. Write a program in C++ to add the two numbers.

Q-4

Match the following:
Q-5

Define the following terms:

1. Cout

2. Cin

3. Preprocessor Directive

4. Array

Multiple Choice Questions
Q-1 In C++, the operator ______ is known as the insertion or put to operator.

(i)

<<

(ii)

>

(iii)

<
Q-2 Data Base Management System (DBMS ) is a software which allows access to ______ contained in a database.

(i)

item

(ii)

program

(iii)

data
Q-3 The structure of database is divided into ______ levels.

(i)

one

(ii)

three

(iii)

four
Q-4 Data independence means that it may be possible to change the storage structure without affecting the ______

(i)

application

(ii)

operating

(iii)

four
Q-5 

The language used for defining data in the database is known as

(i)

program definition language (PDL)

(ii)

basic definition language (BDL)

(iii)

data definition language (DDL)

Q-6 

.E-commerce stands for --------------------- that means business on the Internet.

(i)

Electric Commerce

(ii)

Elephant Commerce

(iii)

Electronic Commerce

Q-7 

 ------------------ is one of the forms of friendly atmosphere for any type of business at a very low expenditure.

(i)

Mall

(ii)

Shop

(iii)

Cyberspace

Q-8 

Customers may check the --------------- Interent. of their bank accounts through the Interent.

(i)

health

(ii)

anger

(iii)

balance

Chapter-9   DBMS
Q-1 Fill in the blanks
(a) ________________________contains data portion of the database.
(b) The Disk manager performs all ______________ and ____________ operators.
(c) ____________takes the responsibility for the structure of the files.
(d) ____________is the lowest level of database implementation.

(f) _______________  and _____________ are the two levels of data independence.

(g)  _____________  allows the user to control the data and to access them.

(h) ATM stands for _______________ .

(i) ______________  and _______________ are programming languages.

 (j) ___________________  converts the data definition statement into a set of tables.

(k)  _________________  interperts the online users' queries.

Q-2 True Or False
(a) DBMS allows only to create a database.
(b) DDL stands for data definition.
(c) Conceptual level describes the records in the conceptual view.
(d) External level is the highest level of database implementation.
Q-3

Answer the following questions:

1. What does DBMS stand for?

2. What are the three levels of database structure?

3. What are the different types of DBMS users?

4. What are the major components of DBMS?

Q-4

Write short notes on the following:

1. DDL: ---------------------

2. DML: ---------------------

3. Application Programmer: ---------------

4. Data Independence: --------------------

5. Data Manager: -------------------

Q-5

Match the following:
Q-6

Give the example of each of the following:

1. DDL -------------------------

 ---------------------------------------

 ---------------------------------------

2. DML --------------------------------

 -------------------------------------------

 ------------------------------------------

Chapter-10   E-Commerce
Q-1 Fill in the blanks
(a) The customer can check the balance of his ___________ through the Internet.

(b) E-commerce maintains friendly relations with _____________________.

(c) The sales department maintains __________ records.
(d) E-commerce stands for ____________________ commerce.

(e) People can buy ____________ online.

(f) Home delivery of ______________  is also possible.

Q-2 True Or False
(a) People cannot purchase clothes, jewellery, etc. through the Internet.
(b) E-commerce stands for bank electric commerce.
(c) We can reserve railway tickets online.
(d) People can check the balance of their account through the Internet.

(e) People can buy books online.

(f) Cyberspace is one of the forms of friendly atmospheres for any type of business.

Q-3

Answer the following questions:

1. What is E-commerce?

2. What are the different types of E-commerce?

3. What are the advantages of E-commerce?

4. How can you buy books online? Write the steps.

5. Is E-commerce useful to us? If yes, then how?

Q-4

Write short notes on the following:

1. E-business: ------------------------

2. E-shopping : ---------------------

3. E-ticketing : ----------------------

Chapter-11   Computer Ethics
Q-1 Fill in the blanks
(a) ____________ is an act of giving permission to use confidential document.
(b) ___________________ enables to prevent unauthorized Internet users from accessing private networks connected to the Internet.
(c) _______________ is the right to those who have legal right to use software

(d) Computer crimes take place because they are not taken seriously by the _________ and________.

Q-2 True Or False
(a) One must copy legal software into other computers.
(b) The user must not enter the correct password and username.
(c) Trademark means companies must have their names, symbols.
(d) One must be an unauthorized user to use confidential information.

(e) Unauthorized changing of data is a computer crime.

(f) Well-defined law is the main reason of a computer crime.

Q-3

Answer the following questions:

1. What is software piracy?

2. What is soft lifting?

3. What is meant by uploading and downloading?

4. What is counterfeiting?

5. What are the crimes related to the use of computers?

Q-4

Write short notes on the following:

1. Copyright -------------------

2. Patent --------------------

3. Trademark ------------------

Q-5

Match the following:
Chapter-12   Cyber Crime
Q-1 Fill in the blanks

(a) --------------------- sends bulk mail by known or unknown sources.

(b) Sweeper deletes all the ------------------  from the system.

(c) ---------------------  crimes connected with money.

(d) --------------------------- employees hack the systems of their employers.

(e) Always use ----------------- and ---------- antivirus software to guard against viruses.

(f)  -------------------------- describes naked people.

(g) Viruses are the programs that cause ------------------------------ to data. 

(h) --------------------------- hackers are employed to hack the site and gain valuable information.

Q-2 True Or False
(a) One must avoid sending any photograph online.
(b) Always keep a watch on the sites when children are surfing the Internet.
(c) Organized hackers and professional hackers are cyber criminals.
(d) One must take certain precautions while using the Internet.

(e) One must always keep back up data.

Q-3

Answer the following questions:

1. What do you understand by the term 'cyber crime'?

2. Who are cyber criminals and what are their objectives?

3. What are the reasons of cyber crime?

4. Describe various kinds of crimes in cyberspace.

Q-4

Write one word for each of the following sentences:

1. The act of sending bulk mail by known or unknown sources.

2. Virus that performs the function of deleting or damaging files.

3. Virus that produces the exact copies of its own program.

4. Hackers who mostly hack sites and get valuable information.

5. It is the latest and most complicated problem in the world.

6. Hackers who use computers to fulfil their political and fundamental obiectives

7. The crime that describes naked people.

8. The crime of copying money, documents, etc. in order to deceive people.

9. The crime of following and watching a person over a long period of time.

Q-5

Match the following:
Chapter-13   Java
Q-1 Fill in the blanks
(a) Once downloaded, Java can be installed like any other _____________ (.exe) on Windows.
(b) To set env variable in windows XP, right click on "My Computer" icon and select _______________ .
(c) To check whether Java is installed properly or not, open _______________ prompt in Windows OS.
(d) _______________ decide which operator will be evaluated first and which operator will be evaluated last, if more than one operator is present in the same calculation.

(e) If two operators of the same precedence exist in the same calculation then _________________ of the operators will be used to decide which operator will be executed first.

Q-2 True Or False
(a) To define a variable, data type for the variable is required.
(b) Instance variables are used by Objects for storing their states.
(c) Any variable which is declared with STATIC keyword inside class (Outside any method) is known as Class variable / Static variable.
(d) Parameters are those variables which are passed as parameter in methods.

(e) Operators are used for performing specific kinds of operation.

Q-3

Answer the following questions:

1. What is Java?

2. How do you download Java?

3. What are the environments in Java?

4. How can you check whether Java installed on your system is up to date or not?

5. What are the four types of variables in Java?

Q-4

Match the following:
Chapter-14   Dot Net
Q-1 True Or False
(a) While developing applications, developers had to develop an eye on system resources like memory.
(b) COM components require registration in the system registry.
(c) .NET components do not require any kind of registration in system registry.
(d) The CLR environment is also referred to as a managed environment, in which common services, such as garbage collection and security, are automatically provided.

(e) .NET applications are compiled to a common language known as Microsoft Intermediate Language or "IL".

Q-2 Fill in the blanks
(a) ____________ compact framework is a sub set of entire .NET framework.
(b) Microsoft Mobile Internet Toolkit (MMIT) is designed to develop ____________ side applications for mobile devices, such as cell phones, PDAs and pagers.
(c) MMIT mainly uses ____________ as a technology for delivering markup to a wide variety of mobile devices.
(d) ASP.NET is a technology available on .NET platform for developing dynamic and data driven ____________ applications.

(e) .NET ---------------- provides a rich set of functionalities out of the box.

Q-3

Answer the following questions:

1. What do you know about the history of.NET?

2. Describe the flavours of.NET.

3. What type of applications can be developed by using.NET?

4. Describe the dot net framework SDK.

5. What is meant by Microsoft Mobile Internet Toolkit?

6. Describe the features of.NET.

Q-4

Match the Following:
Chapter-15   Cloud & Mobile Computing
Q-1 Fill in the blanks

(a) The term " ......................... ", as used in this white paper, appears to have its origins in network diagrams that represented the internet, or various parts of it, as schematic clouds.

(b) Uses a virtualized software ........................., enabling the sharing of physical services, storage, and networking capabilities.
(c) Microsoft is expanding its involvement in this area, and as part of the cloud computing option for Microsoft® Office ..........................
(d) ......................... and infrastructure is abstracted, and can deployed and managed with less effort.

(e) --------------------------- its application set for its customers in a cloud, and its Force.com and Vmforce.

(f) Consumers purchase the ability to -------------------------- and use an application or service that is hosted in the cloud.

(g) Enduser -------------------------- is delivered as a service.

(h) ---------------------- using multiple redundant sites can support business continuity and disaster recovery.

(i) Mobile workers have increased productivity due to---------------------------- accessible in an infrastructure available from anywhere.

(j) ------------------------ can reduce their capital expenditures and use operational expenditures for increasing their computing capabilities.

(k) Microsoft Mobile Internet Toolkit (MMIT) is designed to develop ----------------------------- side applications for mobile devices, such as cell phones, PDAs and pagers.

(l) MMIT mainly uses ----------------- as a technology for delivering markup to a wide variety of mobile devices.

(m) . NET --------------------- provides a rich set of functionalities out of the box.

(n) ASP.NET is a technology available on .NET platform for developing dynamic and data driven -----------------  applications.

Q-2 True Or False
(a) The cloud infrastructure is available to the public on a commercial basis by a cloud service provider.
(b) Mobile computing systems are computing systems that may be easily moved physically and whose computing capabilities may be used while they are being moved.
(c) A personal digital assistant (PDA), also known as a palmtop computer, or personal data assistant, is a mobile device that functions as a personal information manager.
(d) Tablet computers are larger than a mobile phone or personal digital assistant.

(e) The first-generation UMPCs were just simple PCs with Linux or an adapted version of Microsoft's tablet PC operating system.

(f) Apple released the iPad with operating system and touchscreen technology in 2010 and became the first successful mobile computer tablet to achieve worldwide commercial purposes.

Q-3

Answer the following questions:

1. What do you understand by cloud computing?

2. Describe the communications in the cloud.

3. What do you understand by mobile computing?

4. What is another name of the personal digital assistant?

5. What is a smartphone?

6. What is a tablet computer?

Q-4

Explain the following editing tools:

1. How to use communications services?

2. What is cloud computing?

3. Explain three delivering services form the cloud?

4. What is service models?

5. What is dynamic provisioning?

6. What is PaaS?

7. Define deployment models?

8. Hohat is mobile computing?

Multiple Choice Questions
Q-1 ______________ infrastructure is abstracted to provide computing, storage, and networking as a service, avoiding the expense and need for dedicated systems.

(i)

Physical

(ii)

Social

(iii)

Educational
Q-2 Application platform onto which custom applications and ________________ can be deployed.

(i)

services

(ii)

idea

(iii)

mater
Q-3 The cloud infrastructure has been deployed, and is maintained and operated for a specific _____________.

(i)

company

(ii)

organization

(iii)

is right
Q-4 The cloud infrastructure is shared among a ______________ of organizations with similar interests and requirements.

(i)

number

(ii)

time

(iii)

hours