Extramarks-background-image
Q:

Q1.State True or False: [10x1 = 10]

  1. Data once stored in a file cannot be changed.
  2. Ranges can be used in a formula.
  3. Field names can be duplicated in the database.
  4. There are two methods for creating animation in flash.
  5. Deep Blue is the first super computer.
  6. A loop must move either forward or backwards.
  7. Mail merge is an utility in MS Excel.
  8. The timeline option indicates the current frame
  9. All formatting commands are available on Home tab.
  10. We can do arithmetic operation on text values.

A:
  1. False
  2. True
  3. False
  4. True
  5. False
  6. False
  7. False
  8. False
  9. True
  10. False
Q:

Q2.Fill in the blanks: [10x1 = 10]

  1. The ___________________are the biggest and the most powerful and expensive computers available today
  2. __________________ is the file that contains the information to be merged into a document
  3. To exit Slide Show,press _______________ key
  4. _______________ feature allows you to make all the content visible in the same cell
  5. The shortcut key to select the entire worksheet is ________________
  6. The_____________ operator is used to join two strings
  7. A ______________ is an online web service in which two or more users can send messages to each other
  8. In a FOR…NEXT loop,you may not specify the __________ value
  9. ____________ is the feature you use to secure your documents with a password
  10. In Flash, animations are made by changing the successive____________.

A:
  1. Super Computer
  2. Data Source
  3. Esc
  4. Wrap Text
  5. Ctrl+A
  6. &
  7. Chatroom
  8. Step
  9. Encryption
  10. Layers
Q:

Q3.Multiple choice Questions: [15x1=15]

1) An electronic device that stores data in the form of 0 and 1:

  1. Analog computer
  2. Digital computer
  3. Mainframe computer
  4. Abacus

2). The value of binary number ‘1+1+1’ is:

  1. 11
  2. 10
  3. 2
  4. 3

3). The system folder which can be used to change the settings of Windows:

  1. All Programs
  2. Accessories
  3. Control Panel
  4. Libraries

4). Commands on the Ribbon are organised in the form of:

  1. Projects
  2. Tabs
  3. Ribbons
  4. Tools

5). Data stored in RAM is:

  1. Permanent
  2. Temporary
  3. Numeric
  4. Alphanumeric

6). The bar which contains the value of active cells:

  1. Title bar
  2. Formula bar
  3. Status bar
  4. Menu bar

7). The feature which is used to temporarily hide data:

  1. AutoFilter
  2. Subtotal
  3. Pivot Table
  4. Sorting

8). The tab on the ribbon which is used to set document properties:

  1. Command
  2. Modify
  3. Edit
  4. Insert

9). Interconnection of two or more computers is called:

  1. Internet
  2. Server
  3. Browser
  4. Network

10). The type of virus which infects files with .EXE extension:

  1. Program File
  2. Boot virus
  3. Macro virus
  4. Spyware

11). The non-executable statement of QBASIC is:

  1. CLS
  2. REM
  3. LET
  4. PRINT

12). The shortcut key which is used to insert a Keyframe:

  1. F2
  2. F4
  3. F5
  4. F6

13). The option which would allows you to produce a smooth edge:

  1. Tolerance
  2. Anti-alias
  3. Warping
  4. Marquee

14). Removing error from a program is called:

  1. Running
  2. Bugging
  3. Debugging
  4. Compiling

15). The statement that stops the loop:

  1. DO
  2. WHILE
  3. WEND
  4. FOR

A:

  1. b
  2. a
  3. c
  4. b
  5. b
  6. b
  7. a
  8. b
  9. d
  10. a
  11. b
  12. d
  13. b
  14. c
  15. c
Q:

Q4. Answer the following questions in one sentence:[15x1=15]

Q.1 Name the process of converting a source code into machine code

Q.2 Computer works with two signals 0 (off) and 1 (on). Name the language which contains these two digits.

Q.3 Name the option available in All Programs which contains Windows Explorer.

Q.4 What are the three parts in which the Ribbon commands are organized?


Q.5 Name the two types of Gradients in Flash.

Q.6 Name the two main components of Mail-merge.

Q.7 Name the shortcut key which is used to enter default date or time.

Q.8 Which function is used to return the remainder of a number:

Q.9 Name the feature of Excel that used for the arrangement of data in ascending or descending order:

Q.10 Name the two types of Viruses.

Q.11 Name the type of reference in which either row or column remains fixed.

Q.12 What is the purpose of NEXT statement in Loop?

Q.13 What is the Full form of HTTP?

Q.14 Name the tweened animation that works on symbols.

Q.15 What is the full form of VIRUS?

A:
  1. Compilation
  2. Binary
  3. Accessories
  4. Tabs, Groups, Command
  5. Linear gradient & Radial gradient
  6. The two main components of mail merge are: a. Data source b. Main document
  7. Press Ctrl + Shift + # key
  8. MOD()
  9. Layout menu
  10. Boot Viruses & Program file viruses
  11. Mixed Reference
  12. It is used to increment the loop
  13. Hyper Text Transfer Protocol
  14. Motion Tween
  15. Vital Information Resources Under Seize
Q:

Q5. Answer the following questions in brief: [5x4=20]

Q.1 Differentiate between Application Software and System Software.

Q.2 Write down the steps for converting a decimal number into a binary number.

Q.3 Rohit is 6 years old boy. Shyam is twice as old as Rohit. Make a program to calculate the age of Shyam.

Q.4 List any three Excel functions along with their purpose.

Q.5 How can you save an object as a symbol in Adobe Flash CS4?

A:

1. System software helps run the computer hardware and computer system. It includes:

  • Device drivers
  • Operating systems
  • Servers

Application software allows end users to accomplish one or more specific tasks. Typical applications include:

  • Business Software
  • Computer Games
  • Databases
  • Educational Software

2. The steps to convert a decimal number into a binary number are as follows:

Step 1: Divide the given decimal number with the base 2.

Step 2: Write down the remainder and divide the quotient

again by 2.

Step 3: Repeat step2 till the quotient is zero.

3. Program to calculate the age of Shyam is:

REM Calculate age of Shyam

LET age=7

S_AGE=2*age

PRINT “AGE OF SHYAM=”;S_AGE

OUTPUT:

AGE OF SHYAM=14

4.

S.No

Functions

Purpose

1.

SUM(range)

Gives sum of given range

2.

AVERAGE(range)

Finds average of a range of numbers

3.

SQRT(number)

Returns square root

5. Once you have finished with a drawing, you should convert it to a reusable graphic symbol.

To do so, follow these steps:

  • Choose Modify > Convert to Symbol from the menu. The Convert to Symbol dialog box appears.
  • Type a name in the Name field.
  • Choose Graphic as the Type.
  • Click OK. Flash places a copy of the drawing in the Library.
Q:

Q6.) Answer the following questions:[5x2=10]

Q.1 . Write down the steps to create Shape Tween.

Q.2 List any 5 problems that a virus can cause to your computer.

A:

1. The steps to create Shape Tween are as follows:

a. Select the Text tool and type the text, and set various properties from Properties Panel.

b. Select Window à Align. In the Align Panel, select the To Stage button. Click on the Align Horizontal Center button and Align Vertical Center button. Take the pointer to another frame (49) and insert the Key frame in it.

c. Insert a blank Keyframe at frame (24) and then type some new text. Now, select this text and then click Modify à Break Apart. This will break apart the text in frame 1 and frame 49.

d. Now, click anywhere between frame 1 and 24, go to Properties Panel and select Shape from the Tween drop down menu. Again, click anywhere between frame 24 and frame 49 and select Shape from the Tween drop down menu.

e. Select Control à Play option from the menu to play your

2. A virus can cause problems in computer in many

ways, such as:

  1. Decrease the speed of the computer by decreasing the memory.
  2. Displaying a change in data against the filename in the directory, when a virus modifies the file.
Download App

Download Extramarks – The Learning App

Take your CBSE board preparation to another level with AI based and rich media animation on Extramarks - The Learning App.

Features of Learning App

  • Learn with studybot “Alex”
  • Personalized Learning journey
  • Unlimited doubt Solving
  • Quiz, challenge friends
  • Leaderboard Ranking
  • Academic Guru

Download App Download App