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.
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 _____________.
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.
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.
Chapter-4   Flash
Q-1 Fill in the blanks
(a) __________________________is the space between the pairs of characters.
(b) _________________________uses automatic kerning between texts.
(c) ____________________________uses a single line to display text as one line.
(d) _____________________________places the text on the baseline.
Q-2 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.
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.
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.
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.
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.
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
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.
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.
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
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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