TOTAL –50

40 (THEORY)
Ch-7
1.What is spreadsheet?
A computer software based on the concept of grids is called spreadsheet.
2.what is grid?
Grid is a pattern of crisscrossed bars , horizontal and verticals.
3. use of spreadsheet
 It is used both simple and complex task.
 It works like a calculator.
 It allows automatic recalculations in case there are change in data
entered or inputted by user.
4.what is open office calc?
Open office calc is free spreadsheet software . it is an application of Apache
Open Office Suit.
5.what is title bar? Page no-114
Title Bar shows the “Name Of The Application” and “ The name of The File
currently open”.
6. what is menu bar? Page no-114
Menu bar is the bar which has options like File, Edit, View etc.-
7.what is tool bar? Page no-114
Toolbar offers icons for direct access to the main functions and commands. The
two main toolbars are Standard and Formatting toolbars.
8.what is formula bar? Page no-114
Formula bar shows the contents of the selected cell. It allows data to be entered
in the cells.
9.what is status bar? Page no-114
Status bar provides information about the spreadsheet and required actions. It
displays the current worksheet, total number of worksheets, current page style,
current selection and mode and helps to enlarge or reduce the display.

10.What is worksheet?
Ans-a worksheet is a single spreadsheet that contains cells organised in row and
columns.
11.what is cell ?
Ans – A cell is the intersection of a column and row in the from of a grid.
12.what is active cell?
Ans-active cell is a cell with highlighted boundary it. Only one cell can be active
at a time.

Chapter -6
What is custom animation? Page-95
We can make our slides more exciting by applying some special effects to the
text objects used in the slides.This can be done by using “custom animation”.
Chapter-5
What is normal view? Page-81
This is the “Default” and The Main view in which we design and edit our
presentation.
What is slide shorter view ? Page-83
In this view, slides appear in smaller form or Thumbnail form. This view is very
helpful if we wish to see all the slides together on the single screen in order to
change the slide sequence, or to take printout of the slides.
What is notes view? Page-87
In this view presenter can add some notes on the slides for his/her reference.
These notes will not be visible to the audience during the slide show.
What is slide show view?88
Slide show view is used to deliver or to show the presentation to the audience.
CHAPTER-4
28.what is slide show? P-56
When the presentation is presented to the audience in full screen mode, where
slides appear one after another is called Slide Show.
29. What is navigation key? P-57
To navigate in a presentation (moving from one slide to another) we use arrow
keys or mouse click. This is known as navigation key.
30-what is slide transitions? P-65
31. What is narration? P-71
Narration is a commentary and voice over added to the presentation.
32. What is authorized user? P-75
Authorized user is a person who has the permission to use and perform various
functions of the presentation.
Cha-3
25. What is dialog box? P-39
Dialog box is a small window that communicates the information to the user
and prompts them for an answer.
26.what is gallery? P-39
Gallery is an area where we find various themes or groups like backgrounds,
bullets, homepage, computers, arrows etc.
27. What is selection? p-43
Selection is a process of selecting the desired image with the help of various
keys on the keyboards.

CHA-1
Sample question EXAM QUESTION

1. The physical components of computer system which we can touch and feel
are call________.
1. HARDWARE
2.PROGRAM
3. SOFTWARE
4.FIRM WARE
2._______ is a set of program which governs smooth operation of the computer
system
1. HARDWARE
2.PROGRAM
3. SOFTWARE
4.SOFTWARE

3.WHAT IS PROGRAM?
Program is a set of instruction that tells the computer what to do.
4. WHAT IS INSTRUCTION?
Instructions are the commands given to the computer in a language it can
understand.
5. What is HARDWARE?
The physical components of the computer system which we can touch and feel
are called hardware.
8.WHAT IS BOOTING?
Booting is the process that starts the operating system when we turn on our
computer.
9. FULL FORM
RAM - Random Access Memory
ROM - Read-Only Memory
ATM - Automated Teller Machine
GUI - Graphical User Interface (P-11)
10 what is primary memory?
The Operating system remains in the Primary memory (RAM) and runs various
applications till we turn off the computer.
11. What is interface? P-9
Interface is a device that allows the user to communicate with the computer.
12. What is version p-10
Version is the technology upgradation which is different from its previous type.
13. Example of single user operating system
ans- ms dos
14.example of multi user operating system
ans-unix
15.what is Kiosk?
Kiosk is an electronic machine (including a computer and a display screen) from
which newspaper, refreshments, tickets etc are sold.
16. What is application software? P-14
Application software are the set of programs designed to solve a specific
problem or do a specific task.
17-what is custom software?
Custom is a tailor made software. This software is developed to meet all the
requirements specified by the user.
18. What is specific purpose software?
Specific Purpose software is a software that has to be customized as per people
requirements/needs.
19.what is programming code?
Programming code is a computer instruction written in a programming
language.
20. Page no 19 and 20 (activity)

1What is computer ?
 Ans-A computer is an electronic device that manipulates information, or
data. It has the ability to store, retrieve, and process data.
1. What is hardware ?
ANS –Physical Parts of the computer is known as hardware.
Example- cpu, mouse, monitor
2. What is single user operating system ?
The single user operating system help to run the single computer at a
time.
Example MS DOS
3. What is software?
Software is a set of instructions, data or programs used to operate
computers.
EXAMPLE-ms word, excel
4. What is hard disk ?
Hard disk is physical drive or magnetic storage device which help to
store the data.
5. What is system software ?
Ans-System software is a type of computer program that is designed to
run a computer's hardware and application programs

Ch-1
What is computing system? P-3
a.Ms Word
b.Ms Excel
c.Ms Power Pint
d.Tux Pai
Ch-6&7
7. Which of the following is an extension of a worksheet created in Calc?
(a) .ods
(b) .odd
(c) .xls
(d) .obj
8. How can one calculate the total of values entered in a worksheet column of?
(a) By manual entry
(b) By auto-sum
 (c) By formula
(d) By function
11. A function should start with__________________.
(a) ‘=’ sign
(b) alphabets
(c) numbers
(d) All of the these
B. Fill in the blanks
1. The column immediately next to column “Z” is AA
2. The default extension of a workbook created using a LibreOffice Calc
spreadsheet is .ods_.
3. The spreadsheet feature used to continue the series is called as
fill handle.
4.Average is Sum of Value divided by number of values.
5.Open Office .org Calc helps to arrange the rows of the data list
alphabetically in ascending or descending order.
6. The cell address of the cell formed by the intersection of the ninth column
and the eighth row will be 18.
7.Cell is the basic element of a spreadsheet
8.Cell Addresss is column letter followed by row number
9.Average is sum of value divided by number of values.
10.Function are used to quickly manipulate the data.
11.Charts are the graphical representation of data available in the worksheet
12.Formatting means general arrangement of data.

. State whether the following statements are True or False

1. A cell is a intersection of row and column. TRUE
2. A spreadsheet is also called as worksheet. TRUE
A 1. Which of the following consists of rows and columns?
(a) Worksheet
(b) Title Bar
(c) None of these

2. A cell is identified by __________

(a) A row number
(b) A column letter
(c) A column letter followed by a row number
4. Which of the following allows us to create a new copy of an existing file to
update changes and keeps the previous one, while saving an existing file?
(a) Save (b) Copy existing (c) Save As

5. What do you do to save the changes in an existing file?

(a) Use ‘Save’ button (b) Press Ctrl+N from keyboard
(c) Use ‘Save As’ option
6. What is the keyboard shortcut to create a new workbook?
(a) Ctrl + T keys (b) Ctrl + N keys (c) Ctrl + M keys
7. In Excel, a formula begins with a/an
(a) equal to (=) sign (b) plus (+) sign (c)
8. What is used as a separator for numerical values in thousands, one hundred
thousands, etc.?
(a) Comma (b) Decimal (c) Hash
13. Which of the following is Autofill handle a part of?
(a) Ms Word (b) Ms Excel (c) Ms Powerpoint
21. Which of the following is a keyboard shortcut to open a new workbook?
(a) Ctrl + N (b) Ctrl + M (c) Ctrl + W

21. A cell with a dark boundary is known as a/an:

(a) Inactive cell (b) Active cell (c) Working cell
22. What character does every formula start with?
(a) Equal to (=) (b) Colon (:) (c) Semicolon (:)