NOTES/ SOLVED QUESTION/ANSWERS :OXFORD KEYBOARD COMUTER SCIENCE WITH APPLICATION SOFTWARE FOR CLASS / BOOK 5TH SECOND ED

NOTES/ SOLVED QUESTION/ANSWERS :OXFORD KEYBOARD COMUTER SCIENCE WITH APPLICATION SOFTWARE FOR CLASS / BOOK 5TH  SECOND EDITION

LIST

CONTENT

  1. CHARACTERISTICS AND EVOLUTION OF COMPUTERS

Early calculating devices

Evolution of computers

Characteristics of computers

Limitations of computers

  1. DATA STORAGE DEVICES

Input devices

Output devices

Memory

  1. FORMATTING IN MS WORD

Page formatting

Column formatting

Paragraph formatting

Printing a document

WORKSHEET 1 38

  1. FEATURES OF MS WORD

Spelling 8c grammar

Thesaurus

Change case

Find and replace

Bullets and numbering

Insert symbol

  1. CREATING TABLES IN MS WORD 54

Creating a table

Modifying a table

Formatting a table

  1. WORKING WITH OBJECTS IN MS WORD 68

Wordart

Drawing objects in ms word 2007

Inserting clip art and pictures

  1. WORKSHEET 2
  2. MORE ON MS POWERPOINT 2007

Creating a new presentation

Themes

Running a slide show

Viewing and organizing slides

  1. MICROSOFT EXCEL 2007

Starting ms excel 2007

Components of the

Ms excel window

Data types

Saving a workbook

Creating a new workbook

Entering data

Selecting cells

  1. FIRST STEP TO THE INTERNET

The internet

Requirements for connecting To the internet

The world wide web (www)

Email

Netiquette

Safety on the internet

  1. MAKING FLOW CHARTS

Algorithms and flow charts

Flow charts

Rules for making flow» charts

Concept of a loop l

WORKSHEET 3

APPENDICES

 

Ch:1 CHARACTERISTICS & EVOLUTION OF COMPUTERS P: 1-11

 

 

  1. FILL IN THE BLANKS WITH THE CORRECT WORDS.

Charles Babbage decisions John von Neumann Pascaline vacuum tubes

  1. Blaise Pascal invented the first mechanical calculator called the ……………… ..
  2. …………….. .. is called the father of modern computers.
  3. The first-generation computers used ……………… .. .
  4. …………….. .. developed the concept of stored programs.
  5. Computers lack the ability to make ……………… .. .

ANSWERS: 1. a. Pascaline b. Charles Babbage c. vacuum tubes d. John von Neumann e. decisions

 

  1. WRITE T FOR THE TRUE STATEMENTS AND F FOR THE FALSE ONES.
  2. The abacus was probably the first calculating device.
  3. Charles Babbage invented the difference engine.
  4. The MARK I was faster than the ENIAC.
  5. Examples of first generation computers are the ENIAC and UNIVAC I.
  6. The computers that we use at home possess artificial intelligence.

ANSWERS: 2. a. T b. T c. F d. T e. F

 

  1. NAME THE FOLLOWING.
  2. The first fully automatic calculator …… ..
  3. The first fully electronic digital computer …… ..
  4. The first electronic computer that used stored programs ……
  5. The first commercially available electronic computer …… ..
  6. Has all the components of the CPU on a single chip …… ..

ANSWERS : . a. MARK I b. ENIAC c. EDSAC d. UNIVAC I e. VLSIC

 

  1. ANSWER THE FOLLOWING.
  2. Name the computer built to help the army launch bombs and missiles more accurately.
  3. ENIAC

 

  1. What were the limitations of first-generation computers?
  2. The limitations of the first-generation computers are as follows:
  3. Their operating speeds were quite slow.
  4. Their power consumption was very high. iii. They required a large space for installation. iv. Their potential to be programmed for tasks was quite limited.

 

  1. What is a supercomputer?
  2. Fifth-generation computers are referred to as supercomputers. They have very large storage capacities, high speeds, and the ability to carry out highly sophisticated operations.

 

  1. List any two characteristics of computers.
  2. The two characteristics of a computer are as follows:
  • Speed: A computer can perform complex mathematical and statistical calculations at very high speeds.
  • Accuracy: A computer is very accurate. If the data entered into the computer and the set of instructions are correct, then the result produced will be accurate.

 

  1. What is artificial intelligence?
  2. Artificial intelligence is a branch of computer science that aims to create computers that can think, behave, and react in the same way as humans.

 

  1. CIRCLE THE CORRECT OPTION.
  2. The ……………….. … ….. .. -generation computers were very large.
  3. second ii. first iii. third iv. fourth
  4. The main component of second-generation computers was the ………….
  5. vacuum tube ii. transistor iii. integrated circuit iv. microprocessor
  6. The first electronic computer was the …………. .. .
  7. ENIAC ii. UNIVAC iii. EDVAC iv. EDSAC
  8. Microprocessors are used in …………….. .. -generation computers.
  9. first ii. second iii. third iv. fourth
  10. Artificial intelligence is associated with …………………….generation computers
  11. third ii. first iii. fifth iv. second

ANSWERS: 5. a. ii b. ii c. iv d. iv e. iii

 

Ch:2 DATA STORAGE DEVICES P: 12-22

  1. FILL IN THE BLANKS WITH THE CORRECT WORDS.

RAM 8 binary flash ROM volatile

  1. The computer works with only two digits, O and 1, called …………… .. digits.
  2. 1 byte = …………… .. bits
  3. Memory where content is lost when the power is switched off is known a…………… .. memory.
  4. …………… .. and …………… .. are memories that can be directly accessed by the CPU
  5. A …………… .. drive is a portable device used to store, access, and transfer data.

ANSWERS:

  1. a. binary b. 8 c. volatile d. RAM, ROM e. flash
  2. WRITE T FOR THE TRUE STATEMENTS AND F FOR THE FALSE ONES.
  3. ROM is a volatile memory. ….. ..
  4. PROM, EPROM, and EEPROM are types of ROIII. ….. ..
  5. CD5 are no longer used for data storage. 3 ….. ..
  6. CD5, DVDs, and Blu-ray discs look similar.
  7. Once the data is stored in a pen drive, it cannot be erased. ….. ..

ANSWERS:

  1. a. F b. T c. T d. T e. F

 

  1. NAME THE FOLLOWING.
  2. It is a special pen attached to a graphics tablet. ………………… .
  3. lt is also known as a VDU. ………………… ..
  4. This type of printer is used for bulk printing. ………………… ..
  5. This memory retains its content even when the power is switched off. ………………… ..
  6. These discs are present one below the other in a hard disk. ………………… ..

ANSWERS:

  1. a. Stylus b. Monitor c. Laser printer d. Non-volatile memory e. Platters
  2. ANSWER THE FOLLOWING.
  3. What are the three types of memory used to store data?
  4. a. The three types of computer memory are primary memory, read-only memory, and secondary memory.
  5. What is non-volatile memory?
  6. Memory where the contents are retained even when the power is turned off is known as nonvolatile memory.
  7. What does ROM stand for? Name the three types of ROM.
  8. ROM stands for read-only memory. Types of ROM: i. Programmable read-only memory (PROM) ii. Erasable programmable read-only memory (EPROM) iii. Electrically erasable programmable read-only memory (EEPROM)
  9. Why is secondary memory needed?
  10. In secondary memory, the programs and data are stored for future reference. It also has a much larger storage capacity which can be used for bulk data processing.
  11. Arrange in ascending order (lowest to highest) of capacity.

hard disk CD-ROM DVD Blu-ray disc pen drive

  1. CD-ROM, DVD, Blu-ray disc, pen drive, hard disk.

 

  1. CIRCLE THE CORRECT OPTION.
  2. It is the smallest unit of information that a computer can work with.
  3. bit ii. O iii. 1 iv. byte
  4. It is non-volatile memory, i.e. it loses data when the power is switched off.
  5. RAM ii. ROM iii. CD . iv. DVD
  6. The storage capacity of a computer is called its ……….. .. .
  7. CPU ii. binary digit iii. memory iv. p
  8. Which of these is not secondary memory?
  9. CD ii. DVD iii. ROM iv. p
  10. 1 MB is equal to ………….. .. .
  11. 1024 bytes ii. 1024 KB iii. 1024 GB iv. 1

ANSWERS: 5. a. i b. ii c. iii d. iii e. ii

 

 

Ch: 3 FORMATTING IN MS WORD P:23-37

  1. FILL IN THE BLANKS WITH THE CORRECT WORDS.

orientation Default L 1 horizontal View

  1. …………….. .. settings are the settings that are pre-defined in software.
  2. The default top margin is …………….. .. inch.
  3. To display both the horizontal and vertical ruler bars, click on the …………….. .. ta
  4. …………….. .. refers to the direction in which the page is being printed.
  5. …………….. .. alignment refers to the position of the text in relation to the left and right margins.

ANSWERS: 1. a. Default b. 1 c. View d. orientation e. horizontal

 

  1. WRITE T FOR THE TRUE STATEMENTS AND F FOR THE FALSE ONES.
  2. The default page orientation in MS Word is Landscape.
  3. By default, an MS Word document has one column.
  4. Paragraph spacing is measured in lines or points.
  5. You can only change the vertical alignment.
  6. The keyboard shortcut to cehlfie-align text is Ctrl+E.

ANSWERS: 2. a. F b. T c. T d. F e. T

 

  1. NAME THE FOLLOWING.
  2. The default page orientation …………. ..
  3. To insert a page break, click on this tab. …………. ..
  4. To set column style, click on this button on the Page Layout tab. …………. ..
  5. To change the alignment, click on this tab. …………. ..
  6. Click on this option of the Microsoft Office Button to print a document.
  7. a. Portrait b. Insert c. Columns d. Page Layout tab for vertical alignment; Home tab for horizontal alignment e. Print

 

  1. ANSWER THE FOLLOWING.
  2. What is page formatting?
  3. a. Making changes to the settings of a page is called page formatting.
  4. What is paragraph formatting?
  5. Paragraph formatting is a feature of MS Word. It is used to set the appearance of text in a paragraph.
  6. Define alignment.
  7. Alignment is the manner in which text is placed between the margins of a page.
  8. Write the keyboard shortcuts to
  9. justify text ii. left-align text
  10. i. Ctrl + J ii. Ctrl + L
  11. Write down the steps to print a document.
  12. i. Click on the Microsoft Office Button. ii. Select Print. The Print dialog box appears. iii. Choose the required option and then click on OK.

 

  1. CIRCLE THE CORRECT OPTION.
  2. The amount of white space between the text and the edges of the page
  3. margins ii. formatting iii. alignment iv. none of these
  4. To change the page margins, click on the ………………… .. tab.
  5. Home ii. Page Layout iii. View iv. none of these

Type(s) of page orientation are …………. .. .

  1. Portrait ii. Landscape iii. none of these iv. both (i) and (ii)

d In ………….. .. orientation, text is printed along the length of the page.

  1. Landscape ii. Portrait iii. both (i) and (ii) iv. none of these

Which of the following cannot be set using the Page Setup dialog box?

  1. orientation ii. top margin iii. number of columns iv. paper size

ANSWERS: 5. a. i b. ii c. iv d. i e. iii

 

 

Ch4 FEATURES OF MS WORD P:40-53

  1. FILL IN THE BLANKS WITH THE CORRECT WORDS.

bullet Symbols five green Thesaurus

  1. A ……………………. .. wavy line indicates a grammatical mistake.
  2. The ……………………. .. provides a list of synonyms for a given word.
  3. Change Case has ……………………. .. options.
  4. You can mark a line of important information with a …………………….. .. .
  5. ……………….. .. are special characters that can be inserted in an MS Word document.

ANSWERS: 1. a. green b. Thesaurus c. five d. bullet e. Symbols

 

  1. WRITE T FOR THE TRUE STATEMENTS AND F FOR THE FALSE ONES.
  2. Click on Add to Dictionary in the Spelling and Grammar dialog box to add the word to the MS Word dictionary. ….. ..
  3. The Thesaurus option is available under the Home tab. ….. ..
  4. The Bullets button is available in the Paragraph group of the Review tab. …… ..
  5. By default, a black dot is used as a bullet in MS Word. …… ..
  6. Each font has a separate set of symbols.

ANSWERS: 2. a. T b. F c. F d. T e. T

 

  1. NAME THE FOLLOWING.
  2. Click on this tab to get the Change Case option. …………………
  3. This option is used to search for a given word. ……………………
  4. The Symbol option is available under this tab. ……………………
  5. The Bullets button is available in this group of the Home tab…………………… ..
  6. Click on this tab to find the Spelling & Grammar tool…………………… ..
  7. a. Home tab b. find c. Insert d. Paragraph e. Review

 

  1. ANSWER THE FOLLOWING.
  2. What do the red wavy lines in an MS Word document indicate?
  3. a. A red wavy line indicates a misspelled word.
  4. What is the Thesaurus tool used for?
  5. The Thesaurus tool is used to find synonyms for words typed in the document and to replace a word with one of its synonyms.
  6. Which Change Case option would you use to get
  7. all characters in capital letters ii. the first letter of each word in capital.
  8. i. UPPERCASE ii. Capitalize Each Word
  9. Write down the steps to remove bullets from an MS Word document.
  10. i. Select the list. ii. Click on the Home tab. iii. In the Paragraph group click on the down arrow next to the Bullets button. iv. Click on None.
  11. Write down the method to apply the default numbering style in an MS Word document
  12. To apply the default numbering style, click on the Numbering button in the Paragraph group on the Home tab.

 

  1. CIRCLE THE CORRECT OPTION.
  2. A ………………… .. wavy line marks incorrect spelling.
  3. red ii. green iii. blue iv. black
  4. The Spelling & Grammar tool is available in this group.
  5. Home ii. Review iii. View iv. none of these
  6. Which button should you click on in the Spelling and Grammar dialog box if no correction is required?
  7. Ignore ii Add to Dictionary iii. Ignore Once iv. Change All
  8. The keyboard shortcut to check spelling and grammar
  9. F7 ii. F6 iii. F5 iv. F4
  10. The Find option is available in the ………………… .. group on the Home tab.
  11. Font ii. Paragraph iii. Style iv. Editing

ANSWERS: 5. a. i. b. iv c. iii d. i e. iv

 

Ch5 CREATING TABLES IN MS WORD P:54-67

  1. FILL IN THE BLANKS WITH THE CORRECT WORDS.

Tab four row Layout selection bar

  1. A horizontal series of cells in a table is called a …………………………. .. .
  2. There are ………………………….. different ways to create a table in MS Word 2007
  3. To select an entire row of a table, click on the …………………………. .. of the row.
  4. To move to the next cell, use the …………………………. .. key.
  5. To change the column width, click on the …………….. .. tab.

ANSWERS:

  1. a. row b. four c. selection bar d. Tab e. Layout
  2. WRITE T FOR THE TRUE STATEMENTS AND F FOR THE FALSE ONES.
  3. A table is a set of data arranged in rows and columns.
  4. To select adjacent cells in a table, click and drag through the cells.
  5. You can use the arrow keys to move through the cells in a table.
  6. Once created, you cannot change the row height.
  7. You cannot insert a picture in a table cell.

ANSWERS: 2. a. T b. T c. T d. F e. F

 

 

  1. NAME THE FOLLOWING.
  2. A vertical series of cells in a table
  3. The tab to change the row height
  4. The key for moving through the cells in a table
  5. The tab used to change the border of the table
  6. The group displaying the Picture option . . . . . . . . . . . . . . .
  7. a. Column b. Layout c. Tab d. Design e. Illustrations

 

  1. ANSWER THE FOLLOWING. …
  2. Differentiate between a row and a column.
  3. a. Row: A horizontal series of cells in a table Column: A vertical series of cells in a table
  4. List three ways to create a table in MS Word 2007.
  5. Three ways to create a table in MS Word 2007 are as follows: i. Using a grid ii. Using the Insert Table option iii. Using Quick Tables
  6. How would you select an entire row in a table?
  7. To select an entire row, click on the selection bar of that row.
  8. Write down the steps to change the column width.
  9. The steps to change the column width are as follows: i. Select the column. ii. Click on the Cell size group on the Layout tab. iii. Click on the Table Column Width scroll box.
  10. Write down the steps to insert a picture in a table cell.
  11. To insert a picture in a table cell, follow the given steps: i. Select the cell. ii. Click on the Insert tab. iii. Under the Illustrations group, click on the Picture option. The Insert Picture dialog box appears. iv. Browse and select the picture to be inserted. v. Click on the Insert button.

 

  1. CIRCLE THE CORRECT OPTION.
  2. To create a table in an MS Word document, click on this tab.
  3. Home ii. View iii. Insert iv. none of these
  4. The rectangular box formed at the intersection of a column and a row in a table is a
  5. cell ii. rectangle iii. box iv. none of these
  6. If you want to move back one cell, press and hold the ………………… .. key and then press the Tab key.
  7. Shift ii. Ctrl iii. Alt V iv. none of these
  8. You can change the table style from the …………….. .. group on the Design tab.
  9. Font ii. Table Styles iii. Illustrations iv. none of these
  10. To change the alignment of text in a cell, click on the ………………. .. tab.
  11. Page Layout ii. Layout iii. Insert iv. Home

ANSWERS:

  1. a. iii b. i c. i d. ii e. ii

 

Ch: 6 WORKING WITH OBJECTS IN MS WORD P:68- 82

EXERCISES

  1. FILL IN THE BLANKS WITH THE CORRECT WORDS.

Insert Clip Art Format WordArt Styles WordArt

  1. ………………… .. is a text-styling feature of MS Word.
  2. The ………………… .. tab appears when you select a WordArt object.
  3. The Shape Outline button is in the ………………… .. group.
  4. The Illustrations group of the ……….. .. tab provides tools for creating different shapes
  5. When you choose Clip Art in the Illustrations group of the Insert tab, the…………….. .. pane appears.

ANSWERS: 1. a. WordArt b. Format c. WordArt Styles d. Insert e. ClipArt

  1. WRITE T FOR THE TRUE STATEMENTS AND F FOR THE FALSE ONES.
  2. To add WordArt text, click on the Insert tab. J …… ..
  3. You cannot change the outline for WordArt text. ll …… ..
  4. You can change the line style of a WordArt to dots or dashes. …… ..
  5. You cannot apply a shadow to a WordArt object. …… ..
  6. You can change the colour of a drawing and rotate it. …… ..

ANSWERS: 2. a. T b. F c. T d. F e. F

 

 

  1. NAME THE FOLLOWING.
  2. Things other than text and tables that can be inserted in an

MS Word document ……………….. ..

  1. To add WordArt, click on this tab. ……………….. ..
  2. This group of the Insert tab provides tools for creating shapes. ……………….. ..
  3. On selecting a drawing, this tab appears under Drawing Tools. …………….. ..
  4. This effect is applied to a WordArt object to make it look as if it is casting a shadow. …………….. ..
  5. a. Objects b. Insert c. Illustrations d. Format e. Shadow

 

  1. ANSWER THE FOLLOWING.
  2. How would you edit a WordArt object?
  3. a. We can edit an object using the tab under WordArt Tools.
  4. What are the different fill effects that can be applied to a WordArt object?
  5. The different fill effects that can be applied to a WordArt object are 3D effect, shadow effect, and artistic effect.
  6. Write down the steps to draw a rectangle.
  7. i. Click on the Insert tab. ii. In the Illustrations group, click on the Shapes button and choose the rectangle shape. iii. Click and drag to draw the shape.
  8. Which tab appears when you select a drawing object?
  9. The Format tab.
  10. Write down the steps to insert a picture from a file.
  11. i. Click on the Insert tab. ii. Click on Picture in the Illustrations group. iii. The Insert Picture dialog box appears. Locate the picture and then click on the Insert button.

 

  1. CIRCLE THE CORRECT OPTION.
  2. Which of the following can be inserted in an MS Word document?
  3. Picture ii. WordArt iii. Chart iv. all of these
  4. The ……………… .. gallery includes different styles that can be applied to any text.
  5. Drawing ii. WordArt iii. both (i) and (ii) iv. none of these
  6. Which tab of the Colors dialog box would you use to mix your own colours?
  7. Custom ii. Standard iii. both (i) and (ii) iv. none of these
  8. Which of the following options is not available in the Format tab under WordArt Tools?
  9. Shape Outline ii. Shape Fill iii. Change Shape iv. Copy
  10. Which group of the Insert tab is used to insert clip art on a document?
  11. Clip Art ii. Picture iii. Illustrations iv. none of these

ANSWERS: 5. a. iv b. ii c. i d. iv e. iii

 

 

Ch7 MORE ON MS POWER POINT 2007 P:85- 99

  1. FILL IN THE BLANKS WITH THE CORRECT WORDS.

Ctrl Design Esc Home Theme

  1. A …………… .. is a set of colours, fonts, and special effects.
  2. To insert a new slide, click on the New Slide down arrow under the …………… .. tab, and select the layout.
  3. The ………….. .. tab has various themes that can be applied to the entire presentation.
  4. Press the …………… .. key to end the slide show and return to PowerPoint.
  5. To select multiple slides in Slide Sorter view, press the …………… .. key.

ANSWERS: 1. a. Theme b. Home c. Design d. Esc e. Ctrl

 

  1. WRITE T FOR THE TRUE STATEMENTS AND F FOR THE FALSE ONES.
  2. You can add content, rearrange slides, and make notes using the Normal view.
  3. The Normal view has three parts -Outline pane, Slide pane, and Notes pane.
  4. When you change the text on the Outline tab, the text also changes in the corresponding slide.
  5. The Notes pane is used to type notes that refer to the current slide.
  6. Slide Sorter view enables you to see all slides in a presentation at once. …. ..

ANSWERS:

  1. a. T b. F c. T d. F e. T

 

  1. NAME THE FOLLOWING.
  2. The dotted rectangular box on a slide that can hold text, tables, and graphics
  3. The key used to run a slide show …………….. ..
  4. This tab displays the text in a slide in Normal view. ……………..
  5. To make a copy of selected slide, press this key combination. …………….. ..
  6. The view that displays a series of slides one by one in full screen mode …………….. ..
  7. a. Placeholder b. F5 c. Slides d. Ctrl + C e. Slide show

 

  1. ANSWER THE FOLLOWING.
  2. What are the different ways to start a new presentation?
  3. a. You can start a new presentation from a blank slide, a template, existing presentation, or word outline.
  4. Write down any two ways to add a new slide in a presentation.
  5. Two ways to add a new slide in a presentation are: i. Office Themes ii. Duplicate Selected Slides
  6. In how many ways can you view slides in a presentation?
  7. There are three ways to view the slides in a presentation: i. Normal view ii. Slide Sorter view iii. Slide Show view
  8. Name two places where you are likely to come across PowerPoint presentations.
  9. We generally come across PowerPoint presentations in schools and offices.

 

  1. CIRCLE THE CORRECT OPTION.
  2. Under which tab would you find the button to change the slide layout?
  3. Home ii. Insert iii. Design iv. Slide Show
  4. Under which tab would you find the background and colour scheme of a slide?
  5. Animation ii. Review iii. View iv. Design
  6. Which of the following is not a method to move forward through a slide show?
  7. Enter key ii. right arrow key iii. space bar iv. F5
  8. Which of these is not a view button on the Status bar?
  9. Slide Editor ii. Normal iii. Slide Sorter iv. Slide Show
  10. The Outline pane appears in ………… .. .
  11. Slide Sorter view ii Normal view iii. Slide Show view iv. Notes pane

ANSWERS: 5. a. i b. iv c. iii d. i e. ii

 

 

Ch: 8 MICROSOFT EXCEL 2007 P:100-113

  1. FILL IN THE BLANKS WITH THE CORRECT WORDS.

cell Formula Rows XFD 16,384 1,048,576,

  1. A worksheet has ………. ……. .. rows and ………………. .. columns.
  2. ………………. .. are numbered as 1, 2, 3, and so on.
  3. The last column is labelled as ……………….. .. .
  4. A ………………. .. pointer is a highlighted cell boundary that specifies which cell is active at that moment.
  5. The ………… .. bar is used for editing the cell contents.

ANSWERS:

  1. 1048576, 16384 b. Rows c. XFD d. cell e. Formula
  2. WRITE T FOR THE TRUE STATEMENTS AND F FOR THE FALSE ONES.
  3. There are two scroll bars–vertical and horizontal.
  4. There are two worksheets in every new workbook.
  5. The name box shows the content of the active cell.
  6. In a new workbook, you must start typing in cell Al.
  7. To move to the next cell, press Tab or the right arrow key.
  8. a. T b. F c. F d. T e. T

 

  1. NAME THE FOLLOWING.
  2. The smallest unit of a worksheet …………… ..
  3. The name of the cell formed by the intersection of row 5 and column B …………… ..
  4. It gives the address of a selected cell. …………… ..
  5. It displays the data or formula in the active cell. …………… ..
  6. A rectangular block of contiguous cells …………… ..

ANSWERS:

  1. a. Cell b. B5 c. Name box d. Formula bar e. Range

 

 

  1. ANSWER THE FOLLOWING.
  2. What is a workbook?
  3. a. A workbook is a collection of worksheets.
  4. How many worksheets are there by default in a workbook?
  5. There are three worksheets by default in a workbook.
  6. What is meant by range of cells?
  7. A rectangular block of contiguous (touching especially along a line) cells is called a range.
  8. Write down one method to select the cells B2:E5.
  9. Place the mouse pointer at cell B2. Hold the left mouse button and drag it diagonally to cell E5.
  10. How would you select a complete row say ?
  11. To select a complete row, say 5, click on the corresponding row heading (here 5).

 

  1. CIRCLE THE CORRECT OPTION.
  2. How many blank worksheets are shown when a new workbook is created?
  3. one ii. two iii. three iv. four
  4. Where is the address of the active cell displayed?
  5. Status bar ii. Name box iii. Formula bar iv. active cell
  6. lf you press …………. .., the cell accepts your typed text as its contents.
  7. Enter ii. Tab iii. Insert iv. Ctrl
  8. Which of these refers to a range of cells in column B, rows 3 to 6?
  9. B3, B6 ii. B3;B6 iii. B3:B6 iv. B3 to B6
  10. To select several cells or ranges that are not touching each other, you would hold the …………….. .. key throughout the selection.

Ctrl ii. Alt iii. Shift iv. space bar

ANSWERS:

  1. a. iii b. ii c. i d. iii e. i

 

Ch9 FIRST STEP INTO THE INTERNET P:114-126

 

  1. FILL IN THE BLANKS WITH THE CORRECT WORDS.

commerce home page modem net surfing web pages

Online shopping is known as

A ……………… .. is a device that allows a computer to connect and communicate with other computers.

The individual pages that collectively form the World Wide Web are known as

Moving from one website to another is called ……………… ..

The opening page of a website is called ……………… ..

ANSWERS:

  1. e-commerce b. modem c. web pages d. net surfing e. home page
  2. Write T for the true statements and F for the false ones.
  3. Internet stands for international network.
  4. A modem can be internal or external.
  5. A web page can contain text, images, audio, and video.
  6. The address of a website includes spacing.
  7. Mozilla Firefox is a search engine.

ANSWERS:

  1. a. F b. T c. T d. F e. T

 

  1. NAME THE FOLLOWING.
  2. t provides an Internet connection for a fee.
  3. t is a program used to locate and display web pages.
  4. t is the collection of one or more related web pages, linked together through a system of hyperlinks.
  5. t is a program that searches through a collection of web pages for particular information.
  6. Special set of manners to be followed when using the Internet
  7. a. ISP b. Web browser c. Website d. Search engine e. Netiquette

 

  1. ANSWER THE FOLLOWING.
  2. What is ARPANET?
  3. a. In 1969, the Department of Defence of the U.S.A. set up a network of computers called Advanced Research Projects Agency Network (ARPANET). The aim of designing such a computer network was to share information on research and development in the field of science and technology.
  4. Write down any two examples of web browsers.
  5. Mozilla Firefox and Google
  6. What is net surfing?
  7. Moving from one website to another on the Internet is called net surfing.
  8. What is a search engine? Give any two examples.
  9. A search engine is a program that searches through a collection of web pages for information on a specific topic. Google and Yahoo! Search are two examples of search engines.

 

  1. CIRCLE THE CORRECT OPTION.
  2. Web browsers are used to ……. ..
  3. view web pages ii. sort web pages iii. create web pages iv. none of these
  4. Mozilla Firefox and Google Chrome are …………. ..
  5. types of search engines ii. types of web browsers iii. types of word processors iv. types of Internet service provider

e  Which of these is not true about a web address?

  1. It is the address of any website on WWW. ii. It is a search engine. iii. It cannot contain spacing. iv. It is typed in lowercase letters.

Search engines are used to …………. ..

  1. search and list web documents ii. find web pages iii. display links to web pages that match the search iv. all of these

Which of these is not netiquette?

  1. Do not give personal information. ii. Answer all the messages sent to you. iii. Respect the privacy of other people. iv. Ask your parents for permission.

ANSWERS:

  1. a. i b. ii c. iii d. iv e. ii

Ch10 MAKING FLOW CHARTS P:127-134

  1. FILL IN THE BLANKS WITH THE CORRECT WORDS.

bottom flow chart flow lines off-page oval

  1. A …………… .. is a diagrammatic representation of a problem solving process.
  2. The …………… .. symbol is used to indicate the start and end of a program.
  3. Flow chart symbols are connected together by means of ……………. ..
  4. A flow chart is generally drawn from top to ……………. ..
  5. …………… .. connectors are used when a flow chart ends on one page and begins again on another page.

ANSWERS:

  1. a. flow chart b. oval c. flow lines d. bottom e. off-page

 

  1. WRITE T FOR THE TRUE STATEMENTS AND F FOR THE FALSE ONES.

A flow chart cannot be drawn on paper.

A flow chart uses symbols and flow lines for the representation of a problem-solving process.

The oval symbol indicates the start/end of the process.

A rectangle indicates a single process.

A decision box must have two flow lines coming out of it.

ANSWERS:

  1. a. F b. T c. T d. T e. T

 

  1. NAME THE FOLLOWING.

A formal set of instructions that should be followed to perform a specific task like solving a logic or a mathematical problem

A diagrammatic representation of a problem-solving process in which steps are laid out in logical order

It is used to connect various parts of a flow chart on the same page.

This symbol is used to indicate the input and output of the program

It is a sequence of instructions that repeats itself a specified number of times until a particular condition is met.

  1. a. Algorithm b. Flow chart c. Connectors d. Parallelogram e. Loop

 

  1. ANSWER THE FOLLOWING.

What is an algorithm?

  1. a. An algorithm is a formal set of instructions that should be followed to perform a specific task such as solving a logical or a mathematical problem.

What is the significance of a flow chart?

  1. A flow chart is a diagrammatic representation of a problem-solving process in which steps are laid out in logical order.

 

How many output lines do you get from a decision box?

  1. Two lines

 

Which boxes occur only once in a flow chart?

  1. Start and stop boxes

 

When do you use the concept of loop in a program?

  1. A loop is used when a process has to be repeated a certain number of times until a certain condition is met.

 

 

  1. CIRCLE THE CORRECT OPTION.
  2. It is the diagrammatic representation of the problem-solving process
  3. algorithm ii. flow chart iii . instructions iv. coding
  4. These are used to show the flow of logic in a flow chart.
  5. flow lines ii. connectors iii. off-page connectors iv. all of these
  6. This symbol is used to indicate processes or actions.
  7. oval ii. diamond iii. rectangle iv. parallelogram
  8. This box is used when one needs to choose between options.
  9. parallelogram ii. rectangle iii. oval iv. diamond
  10. Every flow chart should have only one of this symbol.
  11. decision box ii. Process box iii . flow line iv. start box

ANSWERS:

  1. a. ii b. i c. iii d. iv e. iii

 

CYBER OLYMPIAD QUESTIONS P:139-141

 

  1. This device had numbers carved on bones or strips of wood.
  2. abacus b. Pascaline c. Napier’s bones d. difference engine
  3. The machine(s) designed by Charles Babbage.
  4. difference engine b. analytical engine
  5. both (a) and (b)
  6. none of the above
  7. Present-day computers use ……. ..
  8. vacuum tubes b. transistors c. integrated circuits d. microprocessors
  9. Which of these is not a characteristic of computers?
  10. accuracy c. diligence b. speed d. none of these
  11. A computer used in a ATM has a/an
  12. graphics tablet c. mouse b. touch screen d. pointing device

6.Text or graphical information on a VDU is called …………. .. .

  1. hard copy c. pixel b. soft copy d. resolution
  2. Which of these is not a non-impact printer?
  3. dot matrix c. line b. daisy wheel d. laser
  4. Which of these is not a secondary storage device?
  5. CD c. Blu-ray disc b. pen drive d. RAM
  6. Which of these is not a type of ROM?
  7. PROM c. PEROM b. EPROM d. EEPROM

10 TB is equal to ………………. .. .

a 210 GB b 210 KB c. 210 MB d. 210 bytes

  1. Which of these stores the most data/ information?
  2. CD c. hard disk b. DVD d. Blu-ray disc
  3. Which of the following can you do with the Page Setup option on the Page Layout tab?
  4. set margins c. set paper size b. set orientation d. all of the above
  5. The amount of line space between the lines of text in a paragraph is called
  6. paragraph spacing b. line spacing c. text spacing d. page spacing
  7. It refers to the position of text in relation to twe left and right page margins.
  8. vertical alignment b. horizontal alignment c. top alignment d. bottom alignment
  9. Type(s) of page orientation(s)
  10. landscape c. widthwise b. portrait d. both (a) & (b)
  11. A red wavy line under a word means
  12. grammatical error b. spelling is incorrect c. unrecognized word d. both (b) and (c)

l7. This option is used to find a particular word in the document and replace it with another text or word.

  1. Cut and Paste b. Copy and Paste c. Find and Replace d. none of the above

18.This option converts lowercase letters  to uppercase and vice versa.

  1. sentence case c. lowercase b. uppercase d. toggle case

19.Which of the following statements about a table is not true?

  1. You cannot insert a table in MS Word. b. It consists of rows and columns. c. A cell is formed by the intersection a of row and a column. d. You can type text inside a cell.

20.The number of cells formed in a table with 5 rows and 4 columns

  1. 10 c. 30 b. 20 d. 40

21.Use this to move to the next cell in a table

  1. Tab key c. Enter “b. Right arrow key d. Both (a) and (b)

22.To add a slide to a presentation, use

  1. Office Theme b. Duplicate Selected Slides c. Reuse Slides c. all of the above

23.To run a slide show, …………. .. .

  1. press F5 b. click on the Slide Show tab and then click on the From Beginning button in the Start Slide Show group. c. click on the Slide Show icon near the bottom-right corner of your screen. d. all of the above
  2. Which of these is not a PowerPoint view?
  3. Slide Show c. Normal b. Slide Sorter d. Web Layout

25.Which view is best suited for making a PowerPoint presentation?

  1. Normal c. Slide Show b. Slide Sorter d. all of these
  2. Which view is best suited for editing a PowerPoint presentation?
  3. Normal c. Slide Show b. Slide Sorter d. none of these
  4. Which view is best suited for viewing a PowerPoint presentation?
  5. Normal c. Slide Sorter b. Slide Show d. none of these
  6. The name of the column after the Z column in MS Excel.
  7. Z1 c. AZ b. ZA d. AA

29.The approximate number of rows in MS Excel 2007

  1. 1 billion c. 100 thousand b. 1 million d. 10 thousand
  2. The name of the cell formed by the intersection of the 4th row and 5th column is …….. .. .
  3. D5 b. E4 C. 4E d. 5D

.31. The key used for Extend Selection

  1. F2 c./W F5 b. F4 d. F8
  2. To select the entire worksheet, press
  3. Ctrl + A c. Shift + A b. Alt + A d. Shift + Alt + A

33.The Internet is used for …….. .. .

  1. chatting b. sending messages c. buying/selling d. all of the above

34.A wireless mobile broadband uses a

device called a/an …….. .. .

  1. dongle b. USB modem c. internet stick d. all of the above

35.Which is true about the WWW?

  1. It contains web pages. b. The web pages contain text, graphics, audio, and video. c. The web pages are linked. d. all of the above
  2. ln email, you type the address of receiver in the ………. .. box.
  3. T0 c. Message box b. Subject d. any of these

37.The flow chart symbol used to mark the beginning or end is a/an …….. .. .

  1. rectangle c. oval b. parallelogram d. circle

38.A sequence of instructions that repeats

itself a specified number of times until a particular condition is met is called a

  1. sequential c. loop b. conditional d. nested

39.Which of the following symbols is used in a flow charts for general processing?

  1. circle c. pentagon b. rectangle d. diamond

40.The lines used to show the flow of logic in a flow chart are called ……. ..

  1. straight lines b. single arrow-headed lines double arrow-headed lines none of the above

Cyber Olympiad Questions 1. c 21. d 2. a 22. d 3. d 23. d 4. c 24. d 5. b 25. a 6. b 26. a 7. a 27. c 8. d 28. d 9. c 29. b 10. a 30. c 11. c 31. d 12. c 32. a 13. b 33. d 14. b 34. a 15. d 35. d 16. b 36. a 17. c 37. c 18. d 38. c 19. a 39. b 20. b 40. d

REVISION QUESTIONS P:141-142

  1. Name the first calculating device.

1 35 Revision Questions 1. Abacus.

 

  1. Give an two characteristics of second generation computers.
  2. i. Smaller and faster than first-generation computers ii. Used transistors

 

  1. Give the full form of EDSAC. Name the person who designed this computer.
  2. Electronic Delay Storage Automatic Calculator. It was designed by M. Wilkes.

 

  1. Name two programming languages that were developed at the time of the second generation computers.
  2. COBOL and FORTRAN.

 

  1. What are microprocessors?
  2. Microprocessors are very-large-scale integrated circuits which contain all the components of a CPU.

 

  1. What are input devices? Name one pointing device.
  2. The devices through which data and instructions are entered into a computer are called input devices. The mouse is a pointing device.

 

  1. Name a machine that uses a touchscreen.
  2. ATM.

 

  1. How is the size of a computer monitor measured?
  2. The size of a monitor is measured by the diagonal length of the screen.

 

  1. What is hard copy?
  2. Printed output is called hard copy.

 

  1. Give two examples of non-impact printers.
  2. Inkjet and laser printers.

 

  1. How much data can be stored in a Blu-ray disc?
  2. 25 GB.

 

  1. What is the common name of a flash drive?
  2. Pen drive.

 

  1. What is meant by default settings?
  2. Settings that are standard or pre-defined in software are called default settings.

 

  1. How can you set margins using ruler bars?
  2. To set the margins using ruler bars, place the mouse pointer on the margin boundary. The pointer changes to a double arrow called the margin marker. Drag the margin marker to the desired location.

 

  1. How can you change page orientation?
  2. Page orientation can be changed by using the Page Setup dialog box. Click on the Margins tab of the Page Setup dialog box and select the required orientation.

 

  1. Write down the steps to change the paper size.
  2. Click on the Page Layout tab, and then click on the drop-down arrow of the Size option of the Page Setup group and choose the required size.

 

  1. How do you correct misspelled words in an MS Word document using the

Spelling & Grammar feature?

  1. You can correct misspelled words by right-clicking on the word and selecting the desired spelling from the options displayed in the pop-up menu.

 

  1. Write down the steps to use the Thesaurus feature in an MS Word document.
  2. The steps to use the Thesaurus feature are as follows: a. Click on the Review tab. b. In the Proofing group, click on Thesaurus. The Research task pane appears to the right of the document window. c. Press Alt and click on the word that you want to look up, i.e. ‘talent’. Results appear in the Research task pane. d. To use one of the words in the list of results or to search for more words, choose from the following: • To use one of the words, point to it, click on the drop-down arrow, and then click on Insert or Copy.

 

  1. Differentiate between a cell and a column in a table.
  2. The rectangular box formed at the intersection of a column and a row is called a cell. A vertical series of cells in a table is called a column.

 

  1. Write down the steps to delete a row in a table.
  2. Select the row you wish to delete. Right-click and select an appropriate Delete option from the submenu.

 

  1. How would you merge two or more cells in a table?
  2. The steps to merge cells are as follows: a. Select the cells to be merged. b. Click on the Layout tab. c. In the Merge group, click on the Merge Cells option.

 

  1. How would you change the row height in a table?
  2. The steps to change row height are as follows: a. Select or click anywhere in the row whose height you want to change. Click on the Layout tab. b. In the Cell Size group, click on the Table Row Height scroll box to change the height of the row.

 

  1. Write down the steps to change the border and shading colour of a table?
  2. The steps to change the border colour are as follows: a. Click on the table. Under Table Tools, click on the Design tab. b. In the Table Styles group, click on the drop-down arrow of Borders option and then click on Borders and Shading. c. The Borders and Shading dialog box appears. Click on the Borders tab and then choose the options you want. i. Select a border setting from the Setting options. ii. Choose a line style from the Style drop-down list. You can select from the various border styles. iii. Select the desired line colour from the Color drop-down menu. You can choose from the various colours available in the custom palette. iv. Select the line width from the Width drop-down list. d. Click on the Shading tab. Select the desired shading colour and click OK.

 

  1. Write down the steps to change the fill colour of a WordArt object.
  2. 1. Click on the WordArt object. The Format tab appears under WordArt Tools. 2. In the WordArt Styles group, click on the Shape Fill option. 3. You can choose from the following: • Click on the colour you want under Theme Colors. • If you do not want any colour, click on No Fill. • If you want a colour that is not in Theme Colors, click on More Fill Colors. The Colors dialog box appears. You can click on the colour that you want from the Standard tab or use the Custom tab to mix your own colours.

 

  1. What is WordArt?
  2. WordArt is a text styling feature of MS Word.

 

  1. How many rows are there in an Excel worksheet?
  2. A worksheet has 1048576 rows and 16384 columns.

 

  1. What is the address of the cell at the junction of the 8th row and 9th column?
  2. 8I.

 

  1. How would you represent the range of cells from A3 to D7?
  2. A3:D7.

 

  1. Give the default names of the worksheets. How would you change the name of a worksheet?
  2. Sheet1, Sheet2, Sheet3; we can change the name of a sheet by right-clicking and selecting Rename from the shortcut menu.

 

  1. Give the full form of modem.
  2. Modem stands for modulator demodulator.

 

  1. Differentiate between a website and a web page.
  2. Website A collection of one or more related Web pages, linked together through a system of hyperlinks. Web page An individual page connected to the World Wide Web that contains text, graphics, audio, video, and links to other pages.

 

  1. List any two examples of search engines.
  2. Examples of search engines: • Google (http://www.google.com) • Yahoo! Search (http://search.yahoo.com)

 

  1. Draw the Start/Stop box in a flow chart.
  2. Oval.

 

  1. Ramiz has just got the marks of his first-term exams. He wants to calculate his total marks in five subjects and the

percentage. Draw a flow chart for this purpose.

  1. Draw a flow chart to print the multiplication tables of the numbers 7 to 10.
  2. Write an algorithm and then draw a flow chart to find the area and perimeter of a rectangles.
  3. 1. Start 2. Read Length, Breadth 3. Calculate Area = Length * Breadth 4. Calculate Perimeter = 2 (Length + Breadth) 5. Print ‘Area of the rectangle is:’ Area 6. Print ‘Perimeter of the rectangle is:’ Perimeter 34. Start Read M1, M2, M3, M4, M5 Stop Print Total, Percentage Total = M1+M2+M3+M4+M5 Percentage = (Total/500) * 100 35. Start I = 1, N = 7 Stop Print N, “*”, I, “=”, Product Product = N * 1 I = I + 1 Is I > 10? 38 1 7. Stop Start Read Length, Breadth Stop Print ‘Area of the Rectangle is:’ Area Print ‘Perimeter of the rectangle is:’ Perimeter Area = Length * Breadth Perimeter = 2 (Length + Breadth)

 

  1. Name the four parts of the Normal view in PowerPoint.
  2. The Normal view has four parts: Outline tab, Slides tab, Slide pane, and Notes pane.

 

  1. How is the Slide Sorter view in PowerPoint useful?
  2. The Slide Sorter view is used to see all slides of the presentation in miniature (small) form on the screen. This makes it easy to add, delete, and move slides, and add timings for moving from one slide to another.

 

 

                                              THE END

Leave a Reply

Your email address will not be published. Required fields are marked *