ST.
JOHN’S PUBLIC SCHOOL
JALLADIANPET || MEDAVAKKAM || SIRUSERI
CHENNAI – 600 100
CHAPTER -1
COMPUTER LANGUAGES
I) Fill In The Blanks:
1. A program is a set of instructions which tells computer
what to do.
2. The development of computer languages can be
classified into four categories.
3. Machine Language consists of sets of binary [Link]
0 and
1.
4. Spacewar was the first interactive computer game.
5. Assembly Language uses mnemonic codes or symbols.
II) Multiple Choice Questions:
1. A program written in assembly language is _________
a) Assembler b)Source Program c)Object Code
2. A __________ converts a high level language program to
machine language line by line.
a)Assembler b)Compiler c)Interpreter
3. The program converted into machine language by the
translator is called ______________
a)Source Program b)Object Program c)Assembler
[Link] term software was first used by _________________
a)John MAccarthy b)[Link] c)John Von Neumann
III) Answer the following:
1. What do you mean by machine language?
Ans: Machine Language is the one that a computer
understands. It is expressed in Binary form – 0’s and 1’s where
0 means “off” state , 1 means “on” state.
2. How is assembly language different from machine
language? Ans: Assembly language uses mnemonic codes or
symbols instead of 0’s and 1’s used in machine language.
Example of mnemonic code is ADD,SUB.
3. What are the key features of high level language? Ans:
The key features of high level language are:
i) Simple and user friendly language.
ii) Language which is machine – independent.
4. What is the difference between interpreter and
compiler?
Ans:
Interpreter Compiler
Scans the entire program and
Translates program one statement at translates it as a whole into machine
a time. code.
Compilers usually take a large
Interpreters usually take less amount amount of time to analyze the source
of time to analyze the source code. code.
No intermediate object code is
generated Generates intermediate object code
5. What are features of 4GL?
4GL is machine independent.
Minimal user skills required to obtain results.
It is an application development tool.
CHAPTER -2
Microsoft Excel 2007
I) Answer the following:
[Link] do you understand by MS Excel?
Microsoft Excel is the most popular spreadsheet
software.
It is a powerful tool that helps to organize, calculate and
analyze data in rows and columns.
Differentiate between a workbook and a worksheet.
The excel screen that appears on the screen is called
workbook. A worksheet is a grid like area made up of
rows and columns.
What is a cell? How many characters can a cell contain?
A cell is an intersection of a column and a row in a
worksheet.
What is a formula bar? How is it different from the name box?
Formula bar shows the characters and formulas that you
enter in an active cell whereas name box displays the location of cell
pointer.
How can you rename a worksheet?
To rename a worksheet double click on the worksheet
tab which we want to rename. It will be highlighted. Type
a new name and press enter key.
Book back Exercise Answers:
Answers:
1. Three
2. Merge and center
3. Formula
4. sheet
5. Column
6. tab
7. F12
Choose:
Answers:
1. Autosum
2. left
3.1048576
4. name
5. = equal to
6. three
CHAPTER -3
Editing a Worksheet
I) Answer the following:
1. How will you make modification in cell contents using Edit mode?
Ans To start working in Edit mode, do the following:
Double-click the cell that contains the data that you want to edit.
2. Explain the method to insert multiple columns in a worksheet.
Ans: To insert multiple columns select the same number of
columns that you want to insert
3. What is the function of Undo and Redo
commands? Ans:
• The Undo feature in Excel can quickly correct mistakes that
you make in a worksheet.
• The Redo button lets you “undo the Undo.”
• The Undo button appears next to the Save button on the Quick
Access toolbar,
4. How will you move data in a worksheet using dragging
method? Ans:
• Select the cells that contain the data or object you want to move
or copy.
• Position the pointer on the border of the selection.
• Move the selection by holding down the mouse button and
dragging and-dropping the selection to the new location.
5. What is Auto Fill? How can it be applied?
Ans: Instead of entering all your data manually, you can use the
AutoFill feature to fill cells with data that follows a pattern or that
is based on data in other cell.
Book back Exercise Answers:
Answers:
format
Delete sheet columns
Insert sheet rows
Cancel and enter
end
space
Choose:
Answers:
1. f4
2. paste
[Link]
4. shift
5. ctrl+z
6. apostrophe
CHAPTER-4
USING MAIL MERGE
1. What do you understand by the term mail merge?
ANS: Mail merge is a feature required to send letters with similar information
to a number of people who reside at different location.
2. How many documents are combined using mail merge feature? Name
them.
Ans: Mail merge combines two documents- Main document and Data source
associated with main document.
3. What is data source?
Ans: Data source consists of mailing list, for example, name, address , city , pin
, telephone number etc.
4. What is a main document?
Ans: A main document contains the text that we wish to send to all the
selected addresses.
5. How will you create a recipient list for the main document?
Ans: To create a new mailing list , select type a new list radio button under
select recipients section and click on create option.
Answers:
1. Main document
2. Tab
3. Ms word
4. Tick
Answers:
1. Record
2. Merge field
3. Type a new list
CHAPTER 5
MICROSOFT POWERPOINT 2007
ANSWER THE FOLLOWING:
1. How will you insert table in a presentation?
Ans:
1. Insert a Table into PowerPoint Find the Insert tab at the top of the application. On the left side, click
on Table to...
2. Type in Cells to Adjust Your Table As I hover over the possible grid, PowerPoint will show the size of
the table to...
3. Use Layout to Add More Rows or Columns
2. How will you add rows in a table?
Ans: To add a row at the end of a table, click the last cell of the last row, and then press the TAB key.
Delete a row Click a row or cell in the table, and then click the Table Layout tab.
3. How can you apply border to a table?
Ans: You can apply a Table Style to the table by clicking the style you want to apply. If the style doesn’t
appear in the Table Styles group under Table Tools on the Ribbon, click the More button to reveal the
Table Styles gallery.
4. What is a chart?
Ans: A chart is a general term for many types of data, organized in a structured format.
5. Name the component of chart.
Ans:
• Chart area
• Category axis
• Value Axis
• Data Series
• Category Name
• Plot area
• Legend
Points at a glance
ANSWERS:
[Link] Table
2. layout
3. Shading
4. Plot area
[Link] series
[Link] borders
Answers:
1. cell
2. legend
3. alignment
4. table tools
[Link]
[Link]
*******************************************************