Excel
Fill in the Blanks
-
1Fill 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.
-
Short Answer Questions
-
1
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?
-
True or False
-
1
The formula to calculate the most common type of average:
One Word Answer
-
1
Write the formulae for the following:
-
a. Mean ----------------------------
-
b. Median ---------------------------------
-
C. Mode -------------------------
-
d. Range ----------------------------
-
Advance Charting in Excel
Fill in the Blanks
-
1Fill 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 _____________.
-
Short Answer Questions
-
1
Answer the following questions:
-
1. What do you understand by a pie chart?
-
2. In which sections the pie chart is divided?
-
Photoshop
Fill in the Blanks
-
1Fill 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.
-
True or False
-
1True 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.
-
Short Answer Questions
-
1
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.
-
Match the Following
-
1
-
A.
-
A.
-
2
Match the following:
Flash
True or False
-
1True 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.
-
Short Answer Questions
-
1
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?
-
Match the Following
-
1
Match the following:
Fill in the Blanks
-
1Fill 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.
-
(e) --------------------------- creates a text box in which a user can enter text.
-
Computer Programming
Fill in the Blanks
-
1Fill 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.
-
True or False
-
1True 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.
-
Short Answer Questions
-
1
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?
-
One Word Answer
-
1
Define the following terms:
-
1. Tracing : -------------------------------
-
2. Stepping : --------------------------
-
3. Break point : -----------------------
-
4. Compiler : ---------------------------
-
5. Flow chart : -----------------------
-
6. Lexical analysis: ------------------------
-
7. Syntax analysis: -----------------------
-
8. Debugging : ----------------------------
-
Match the Following
-
1
Match the following:
HTML
Fill in the Blanks
-
1Fill 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.
-
Short Answer Questions
-
1
Answer the following questions:
-
1. What do you mean by Source Code?
-
1. What is meant by a table?
-
2. What do you mean by Object Code?
-
2. What are the different parts of a table?
-
3. What is Pseudo Code?
-
3. What are ordered and unordered lists?
-
4. Write an algorithm in Pseudo Code to find the sum and average marks of three numbers.
-
4. What is the use of a list tag?
-
5. What do you mean by Debugging?
-
One Word Answer
-
1
Define the following:
-
1. Heading : -------------------
-
2. Table : -----------------------
-
3. Table data : ------------------------
-
4. Paragraph : -----------------------
-
Match the Following
-
1
Match the following:
Visual Basic
Fill in the Blanks
-
1Fill 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.
-
Short Answer Questions
-
1
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.
-
One Word Answer
-
1
Write short notes on the following:
-
1. Picture box ------------------------
-
2. Command button ----------------------
-
3. Frames --------------------------
-
4. Shape --------------------------
-
5. Text box -------------------------
-
Match the Following
-
1
Match the following:
C++ Programming
Fill in the Blanks
-
1Fill 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.
-
True or False
-
1True 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().
-
Short Answer Questions
-
1
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.
-
Match the Following
-
1
Match the following:
One Word Answer
-
1
Define the following terms:
-
1. Cout
-
2. Cin
-
3. Preprocessor Directive
-
4. Array
-
DBMS
Fill in the Blanks
-
1Fill 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.
-
True or False
-
1True 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.
-
Short Answer Questions
-
1
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?
-
One Word Answer
-
1
Write short notes on the following:
-
1. DDL: ---------------------
-
2. DML: ---------------------
-
3. Application Programmer: ---------------
-
4. Data Independence: --------------------
-
5. Data Manager: -------------------
-
Match the Following
-
1
Match the following:
One Word Answer
-
1
Give the example of each of the following:
-
1. DDL -------------------------
---------------------------------------
---------------------------------------
-
2. DML --------------------------------
-------------------------------------------
------------------------------------------
-
E-Commerce
Fill in the Blanks
-
1Fill 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.
-
True or False
-
1True 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.
-
Short Answer Questions
-
1
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?
-
One Word Answer
-
1
Write short notes on the following:
-
1. E-business: ------------------------
-
2. E-shopping : ---------------------
-
3. E-ticketing : ----------------------
-
Computer Ethics
Fill in the Blanks
-
1Fill 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________.
-
True or False
-
1True 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.
-
Short Answer Questions
-
1
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?
-
One Word Answer
-
1
Write short notes on the following:
-
1. Copyright -------------------
-
2. Patent --------------------
-
3. Trademark ------------------
-
Match the Following
-
1
Match the following:
Cyber Crime
Fill in the Blanks
-
1Fill 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.
-
True or False
-
1True 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.
-
Short Answer Questions
-
1
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.
-
One Word Answer
-
1
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.
-
Match the Following
-
1
Match the following:
Java
Fill in the Blanks
-
1Fill 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.
-
True or False
-
1True 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.
-
Short Answer Questions
-
1
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?
-
Match the Following
-
1
Match the following:
Dot Net
True or False
-
1True 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".
-
Fill in the Blanks
-
1Fill 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.
-
Short Answer Questions
-
1
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.
-
Match the Following
-
1
Match the Following:
Cloud & Mobile Computing
Fill in the Blanks
-
1Fill 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.
-
True or False
-
1True 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.
-
Short Answer Questions
-
1
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?
-
Long Answer Questions
-
1
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?
-