Part – A
- Logical operations are performed in
__________________
(A) ALU (B) Control Unit (C)
Memory Unit (D) Plotter
- In Hard Disk a track is subdivided into
___________________
(A) Minor tracks (B)
Mini tracks (C) Sectors (D) Micro tracks
- Which is an object oriented language
(A) C (B) C++ (C)
Pascal (D)
Fortran
- Which is an operating system
(A) Window XP (B)
Window server 2003 (C)
Unix (D) All of the above
- Decimal number system has a base of radix
(A) 8 (B) 10 (C)
12 (D)
16
- In Binary number represent in __________
(A) O s and
is (B)
Os (C)
1s (D)
None
- Binary multiplication of 0 X 1 = ? __________
(A) 0 (B) 1 (C)
either A or B (D) None
- Complement of 1 is ________
(A) 1 (B) 0 (C)
either of A & B (D) None
- 1’s complement of 101101 is __________
(A) 010110 (B) 010010 (C)
101101 (D)
110010
- Is complement of 11001 is ________
(A) 00110 (B)
00111 (C)
10111 (D)
11101
- VMS and mainframe operating system are examples
of ________________ .
(A) Multi user, single tasking (B) Multi user, multi tasking
(C) single user, single tasking (D)
single user, multi tasking
- By default start button lies on _______
(A) Left
hand corner (B)
Right hand corner
(C) Top (D)
Any where
- *. Doc search for the files _____________
(A) Start unit .doc (B) Having extension .doc
(C) Any of the above (D)
None
- By default deleted items remain in ______________
(A) Recycle
Bin (B)
Any folder (C) Desktop (D)
None
- To restore files right click and select _________
option on recycle Bin
(A)
Delete (B) Restore (C)
explore (D)
None
- Media player used to _______________
(A) Play music (B)
See text (C) Play text (D) None
- Rows and columns details are shown in ________
(A) Scroll bar (B)
Edit bar (C) Status bar (D) None
- Hyper link can be used to more to a specific
location in the _____
(A) Same document (B)
Other document (C) Either (D) None
- To insert a table we can use _________
(A) Tables and borders (B) Insert table (C)
Insert work sheet (D) Drawing
- Vertical scroll bar is used for ______________
(A) Moving
the page up & down (B) Moving the page left
(C) Moving the page right (D)
None
- Cancel option is chooser to ___________
(A) The ject
the performed operation (B) Save the document
(C) Exit the document (D)
None
- Who is the first lady programmer ___________
(a) lady Ada
- What is logic proposed by george bool
(a) Booban logic (b) Calcnlas (c) Arithmetic (d) None
- Vaccum tubes the used in ________ generation.
(a) First (b) Second (c) Third (d) Fourth
- Transistor were used in ________ generation.
(a)
First (b) Second (c)
Third (d) Fourth
- IC’s were used in ________ generation.
(a)
First (b) Second (c) Third (d) Fourth
- LSI and VLSI were introduced in _____ generation.
(a)
First (b) Second (c) Third (d) Fourth
- Intel 4004 chip was developed ________-
(a) 1971 (b) 1975 (c)
1980 (d) 2000
- Computer designed for use by one person at a time
called ________
(a)
Personal computer (b)
Mini computer (c) Main
computer (d) Super computer
- Which is not the input device
(a)
Mouse (b)
Key board (c)
Joystic (d) Dot matrix
- Which is not the output device.
(a)
Visual display unit (b)
Printer (c)
Laser printer (d) None
- Which are the part of CPU
(a)
Arithmetic-logic (b)
Control unit (c) Memory (d) All
- Which is the example of secondary method.
(a)
Floppy (b)
Hard disk (c) CD (d) All
- In machine level language the programs were
written in ______
(a)
O’ S (b) I’S (c) Both (d) None
- Which one is not a high level language _______
(a)
COBOL (b)
FORTRAN (c) PASCAL (d)
C++
- Which one is not the system software ________-
(a)
Operating (b)
Compiler (c)
Interpreter (d) Ms- office
- Which one is the example of operating system.
(a)
Windows 98 (b) Window XP (c)
Unix (d) All
- Loading the operating system is called ________
(a) Booting (b) Loading (c) Porting (d) None
- Decimal number system uses digits ___________
(a)
1 to 10 (b) 0 to 9 (c) 0 to 8 (d) 0 to 1
- Radix is also called ______
(a) Base (b) Size (c)
Symbol (d) None
- Decimal has the base _______
(a) 10 (b)
8 (c)
2 (d)
16
- Binary addition of 110 to 111 is
(a) 1101 (b) 1011 (c)
11000 (d)
1000
- Binary multiplication of 1001 and 1010 is ______
(a)
1100101 (b) 1011010 (c) 1101010 (d) None
- 1’s complement of 10110 is ___________
(a) 01001 (b)
01000 (c)
10010 (d)
None
- z= x + y represents the ____ gate.
(a)
AND (b) OR (c) NOT (d) XOR
- Operating system is a ____ software.
(a)
Application (b) System (c)
Either (d)
None
- Main memory consist of __________
(a)
RAM (b)
ROM (c) Both (d)
None
- Which is the example of single user multitasking
OS.
(a)
Ms- Dos (b)
Palm OS (c) Window (d) None
- Which one is multi user os_______
(a) Unix (b) Window (c) Ms Dos (d) Plam os
- System with more than one processor are _____
(a)
Multi user (b)
Multi tasking (c) Multi
processing (d) None
- Tital bar consist of _____
(a)
Close button (b) Minimize (c) Maximize (d) All
- To save a file we use ______
(a)
Ctrl + S (b)
Alt + S (c) Either (d) None
- To Keep track on the location of word headings we
use __________
(a) Document Map (b)
Tracking (c)
Documenting (d) None
- To insert a work sheet we use ________
(a)
Insert table (b) Insert worksheet (c) insert exces (d) None
- Vertical scroll bar used to move the page ______
(a)
Left (b) Right (c)
Up-down (d)
None
- Before performing any operation with the text the
first step is ________
(a)
Select the option (b)
Apply the option (c) Select the text (d) None
- To bold a word we can use _________--
(a)
Alt B (b) Alt + ctrl + B (c)
Ctrl + B (d)
None
- To insert any symbol we use _________-
(a)
Find (b) Find and replace (c)
Insert symbol (d) None
- Ms-excel has the row header ___________
(a) 65636 (b) 65600 (c) 65700 (d) 65612
- Ms-excel has the column header ________.
(a)
A-100A (b) A-Z (c) Z-A (d) None
- After z we
use column header _______
(a)
A1 (b) AA (c) A2 (d) Z1
- To arrange the element in non-decreasing order is
called _____
(a) Sort ascending (b)
Sort Descending (c) Either (d) None
- Which can be a cell address ________
(a)
AA (b)
AB (c) A1 (d) None
- Which one is valid ______
(a)
D1+ D2 (b) = D 1+D 2 (c) + D1 + D2 (d)
None
- C7 : C10 is called ______
(a)
Area (b) Range (c)
Block (d)
Field
- To find maximum number in a range we use
__________
(a)
Greater (b) Maximum (c) Max (d)
None
- To find minimum number we use ________
(a)
Greater(range) (b) Maximum(range) (c) Min (d) None
- To count the total number we use _____
(a)
count A (b) Count blank (c)
Count (d)
None
- Count A counts _________
(a)
Empty text (b) Empty cell (c) Total cell (d) None
- = If (C2 >10000*, C2 * 0.25%) (*,C2*1%,*1)
if
C2 contain 10000 then what will be the revised value.
(a) 10100 (b) 10010 (c)
11000 (d)
None
- For auto sum we use _____
(a) 
(b) / (c) + (d) None
(b) / (c) + (d) None- 20.00 is the ______ format.
(a)
General (b) Fixed to 2 decimal (c)
Scientific (d)
Currency
- Which one is not a valid format.
(a)
51% (b) 51.00 (c) 51$ (d) 51.10E + 01
- Which one is not a type of chart _____
(a)
Pie chart (b)
Area chart (c) Line
chart (d) None
- State the If condition
(a) If sales > = 100000 then 1%
(b)
If sales < 100000 then 0.25%
(A) = If(C2> = 100000, C2 * 0.25%, C2 * 1%) (B) =
If(C2>100000, C2 * 1%, C2 * 0.25%)
(C) If (C2 > 100000, C2 * 1%, C2 * 0.25%) (D) None
- On the background option preview option is used
_____
(A) See the color (B) See the effect on slide (C) To change the style sheet
(D) None
- In the slide transition the effect can be
(A) Made slow (B)
Made fast (C)
Made medium (D) Any of the
above
- To calculate average we use _____________
(A) Avg. (range) (B)
Avg. (C1 : C10) (C)
Average (range) (D) None
- To convert letters in lower case we use :-
(A) Low (all address) (B)
= Low (Cell address) (C)
= Low (Cell range) (D) None
- When we switch off the pc the RAM content will be
______________ .
(A) Lost (B) Persist (C)
Count say (D) None
Part – B
- (a) Sum(C7:C10) is used to sum range C7 to C10
(b)
= Sum(C12:C10) is used to sum range C10 to C12
(A)
a only (B) b only (C) Both (D) None
- (a) To calculate average we use = avg. range
(b)
To calculate maximum number we are = maximum (C7:C10)
(A)
a only (B)
b only (C)
Both (D) None
- (a) Min function return the lowest value in the
given range.
(b)
Count function is used to count the number of cell addresses containing the
data.
(A)
TF (B)
FF (C) TT (D) FT
- (a) Upper function is used to convert the text in
a cell address to lower case.
(b)
Lower function is used to convert the text in cell address to upper case.
(A)
TF (B) FF (C)
TT (D)
FT
- SUMIF (parameters) what parameters to pats in
SUMIF operation.
(a) Range to check (b)
Criteria (c)
Range to total
(A)
a, b (B) b, C (C) a, b, c (D) only a
- COUNTIF
(a)
This function gives the count of number of cells which satisfies the condition.
(b)
By default the text is aligned to the right hand side of the cell.
(A) TF (B)
TT (C)
FF (D)
FT
- (a) Auto fill used to save data entry time.
(b)
Custom list is a collection of some commonly used words.
(A)
TF (B) TT (C) FF (D) FT
- Alignment of a cell can be
(a) Left (b)
Right (c) Center
(A)
a, b (B)
b, c (C) a, c (D) All
- We can do the following operations.
(a) Bold (b)
Italic (c) Underline
(A)
a, b (B)
b, c (C) a, c (D) All
- (a) Sort ascending is used to order in increasing
order.
(b)
Sort descending is used to order in decreasing order.
(A)
TF (B) TT (C) FT (D) FF
- (a) MS word is
system software.
(b)
In Ms-word title bar can be placed any where.
(A)
a only (B)
b only (C) Both (D)
None
- (a) Standard and default option like saving a
file opening a file and printing are in editing bar.
(b)
Scroll bar used to scroll through different documents
(A) TF (B)
FT (C)
FF (D)
TT
- Shapes, arrow etc, included in drawing tool bar.
(b)
Text is type in text area
(A)
TF (B)
FT (C)
FF (D) TT
- (a) Preview is used to edit the page.
(b)
Open is used to open a new document
(A)
a only (B)
b only (C)
Either (D) None
- (a) Undo is used to retain any modification made
to file.
(b)
Redo can be used before the undo
(A) a only (B) b only (C) Both (D) None
- (a) Column is used to change the pages into
columns.
(b)
Drawing button is used as a toggle button
(A)
a only (B)
b only (C) Both (D) None
- (a) Document map is a list of headings in the
document.
(b)
It is displays it at the top of the window, and highlights the heading in the
document.
(A)
TF (B)
FT (C)
FF (D) TT
- (a) “Zoom in” is used to see more of the pages.
(b)
“Zoom out” is used to get a closer view.
(A)
TF (B)
FT (C) FF (D) TT
- (a) “Close” standard tool bar is use to close all
open document without exiting the program.
(b)
Zoom is the part of formatting bar
(A) a only (B) b only (C) Both (D) None
- (a) Save tool is not a part of formatting tool
bar
(b)
Align left is part of formatting tool bar.
(A)
a only (B) b only (C) Both (D) None
- There are two ways to close the word
(a)
With saving the document
(b)
Without saving the document
(A)
a only (B)
b only (C) Both (D) None
- (a) Clip art is the option of insert menu.
(b)
To insert a symbol we use file menu.
(A) a only (B)
b only (C)
Both (D)
None
- (a) Total number of column headers are 512
(b)
AA cant be a column header
(A)
TF (B)
TT (C)
FT (D) FF
- (a) Sort ascending arrange a set of number in ascending
order.
(b)
Drawing tool used for creating charts.
(A) TF (B)
TT (C)
FT (D)
FF
- (a) We have to make cell active before editing
(b)
Press F2 key after selecting the cell of which we want to edit.
(A)
TF (B) TT (C) FT (D) FF
- (a) To multiply two cells we put formula B2 * C2
(b)
To add two cells we put formula = B2 +C2
(A)
a only (B) b only (C) Both (D) None
- (a) We can edit a formula applied on a cell
(b)
We can’t edit a formula to do this we have to delete the cell.
(A) a only (B)
b only (C)
Both (D)
None
- (a) To save file we used file menu - save
(b)
Save button is placed in formatting bar.
(A) a only (B)
b only (C)
Both (D)
None
- (a) To open a new file we use Ctrl +N
(b)
To select all we use Alt+ A
(A) a only (B)
b only (C) Both (D) None
- (a) To insert a cell we select insert button on
the menu bar.
(b)
Select the insert cell.
(A)
a only (B)
b only (C) Both (D) None
- (a) We can move the elements from one location to
another.
(b)
We can move elements from one sheet to another
(A)
a only (B)
b only (C) Both (D) None
- (a) To perform a operation we have to select the
range.
(b)
A range may of any size
(A)
a only (B)
b only (C) Both (D) None
- True and False
(1) C is a High Level Language (2) C++ is a
High Level Language
(A) TT (B)
FF (C)
TF (D)
FT
- State True and False
(1) Operating System is a system Software (2) compiler
is a System Software
(A) TT (B)
FF (C)
TF (D)
FT
- State True and False
(1) Microsoft window XP is an operating system (2)
C is a operating system
(A) TT (B)
FF (C) TF (D)
FT
- (a) Count a ( ) counts the blank cells
(b)
Count Blank ( ) counts empty cells in a specified range.
(A)
TF (B)
TT (C) FT (D) FF
- (a) General format is 51
(b)
Fixed to 2 decimal places is 20.000
(A) TF (B)
TT (C)
FT (D)
FF
- State True and False
(1) C is a High Level Language (2) C++ is a
High Level Language
(A) TT (B)
FF (C)
TF (D)
FT
- (1) Division of Binary
(2) Division of Binary 
(A) TF (B)
FT (C) TT (D)
FF
- (1) 0 in Binary represents On
(2) 1 in Binary represents Off
(A) TT (B) FF (C)
FT (D)
TF
Part – C
- To make cell entry, what sequence we follow
(a) Make the cell active (b)
Type the context of cell
(c) Click or enter to complete the all entry
(A) a, c, d (B) a, b, c (C) c, b, a (D) c, a, b
- Which are right formula to multiply two cells
(a) B2 * C2 (b)
B2 . C2 (c)
= B2 * C2
(A)
a, b (B)
b, c (C) c, only (D) a only
- To copy the cell contents, sequence following
(a) Copy the cell (b)
Select the cell (c)
Select the other cell (d) Paste the
contents.
(A)
a, b, c, d (B) a,
c, d, b (C)
a, c, b, d (D) b, a, c, d
- Moving the cell content consist of following steps
(a) Select the cut option (b) Select the
area to be moved
(c) Right click and paste (d) select the area where you want to move the contents.
(A) b, a, d, c (B)
a, c, a, d (C)
a, b, c, d (D) d,
c, a, b
- to insert one column we follow
(a) Click on the insert button on the menu bar
(b) Select the cell to left of which you want to
insert the column
(c) Click on the column button on the menu bar.
(A) b, a, c (B) a, b, c (C)
c, a, b (D)
a, c, b
- (a) A1 : D1 called the range.
(b)
Sum(range) used for the sum
(c)
= Avg.(range) is used for the average.
(A) TTF (B) TFT (C) FTF (D) FFF
- (a) = upper (cell address) is used to convert
cell content to upper.
(b)
= Lower (cell address) is used to convert cell content of lower case.
(c)
Count blank(range) used to count empty cell.
(A) a, b (B)
b, c (C) a, c (D) All
- = If (C2 > = 100000, C2 * 1%, C2 x 8 0.25%)
(a)
C2 * 1% is used if condition is true
(b)
C2 * 0.25% is used if condition if false
(A) a only (B)
b only (C) both (D) None
- (a) Count If ( ) (1)
Total calculation
(b)
Auto sum (2)
Number of cell
(c)
Auto fill (3)
Saves data entry time
(A)
a-2, b-1, c-3 (B)
a-2, b-3, c-2 (C) a-3, b-2, c-1 (D) a-3, b-1, c-2
- (a) Chats are graphical representation of
information.
(b)
Database is a random collection of data
(c)
Database can be sorted in ascending or descending order.
(A) a, b (B)
b, c (C) a, b, c (D) a, c
- Match the Following
(a) Save standard tool bar is used to save the
document.
(b)
Open is used to open a new document
(c)
Page setup is used to set the layout of the page.
(A) a, b (B)
b, c (C) a, c (D) All
- To change the font style of exiting text.
(a) Select the text
(b)
Right click
(c)
After right click select edit
(A) a only (B)
a, b (C)
a, c (D)
All
- (a) User can give any desired font size.
(b)
User can give any desired font style
(c)
If red line under a word is shower means only the spelling is wrong
(A) a
only (B)
a, b (C)
a, c (D)
All
- (a) Justify is used to align from left edge to
the right edge of the page.
(b)
Left align is used for the left ride alignment.
(c) Center
is used for the center alignment of the text
(A) a only (B)
a, b (C)
a, c (D) All
- Match the Following
(a) (1)
Left
(b) (2)
Right
(c) (3)
Center
(d) (4)
Justify
(A)
a-3, b-1, c-2, d-4 (B)
a-2, b-1, c-3, d-4 (C) a-1,
b-3, c-2, d-4 (D) a-4, b-2,
c-1, d-3
- Match the following
(a) General format (1)
5.10 E +0 1
(b)
Percent (2)
$ 51
(c)
Scientific (3)
51
(d)
Currency (4)
51%
(A)
a-3, b-4, c-1, d-2 (B)
a-2, b-1, c-3, d-4 (C) a-1,
b-2, c-3, d-4 (D) a-4, b-1,
c-2, d-3
- (a) = MAX(C7:C10) finds the highest value
(b)
= MIN(C7:C10) finds the lowest value
(c)
= Average(C7:C10) finds the average value
(A) TTT (B) TFT (C)
TTF (D) FFT
- (a) Count () used to count the number of cell.
(b)
Count () is used to count non empty cells
(c)
Count back () is used to count empty cells
(A) TFT (B) TTF (C)
FFT (D) None
- (a) Upper () is used to covert cell content in
upper case
(b)
Lower () is used to cover cell content in lower case
(A)
a only (B) b only (C) Both (D) None
- (a) Currency format is $ is a valid format
(b)
Fixed to 2 decimal places is 20, 001
(A) a only (B) b only (C)
Either (D)
None
- (a) Blaise pascal (1) Analytical engine
(b)
Charles Babbage (2)
Boolean logic
(c)
Lady Ada (3)
Mechanical Calculator
(d)
George boole (4) Lady programmer
(A) a-1, b-4, c-2, d-3 (B)
a-3, b-1, c-4, d-2 (C) a-2,
b-1, c-3, d-4 (D) a-4, b-2,
c-1, d-3
- (a) First generation (1) Transistors
(b)
Second generation (2)
Vacuum tubes
(c)
Third generation (3)
VLSI
(d)
Fourth generation (4) IC
(A)
a-2, b-1, c-4, d-3 (B)
a-3, b-1, c-2, d-4 (C) a-4,
b-2, c-1, d-3 (D) a-1, b-2,
c-3, d-4
- (a) Mouse is an output device
(b)
Light pen is used with video display
(c)
Joy stick is an input device
(A) TTT (B) FTT (C) FTF (D) TFT
- (a) Daify wheel is a printer
(b)
Laser is an impact printer
(c)
Dot matrix is a non impact painter
(A) TTT (B)
FTF (C) FTF (D) None
- CPU consist of __________ ?
(a) Memory unit
(b)
Control unit
(c)
Arithmetic logic unit
(A) a, b (B) b, c (C) a, c (D) All
- Graphics is used in
(a) Animations (b)
Multimedia (c) CAD and
CAM software
(A) a only (B)
a, b only (C) a,
c only (D) All
- Which are the end user programs.
(a) Database programs
(b)
Word processor
(c)
Spread sheets.
(A) a, b (B) b, c (C) Both a & b (D)
None
- (a) Graphics accelerator card take over CPU work
(b)
Graphics accelerator have their own memory
(c)
Graphics accelerator is designed for particular type of videw bus.
(A) a only (B)
b, c (C) All (D) None
- (a) Internet is used in education, multimedia
etc.
(b)
Internet is used for quick information updates
(c)
The main disadvantage of internet is inadequate security
(A) a, b (B) b, c (C) both a & b (D)
None
- Match the column
|
(A)
|
Operating System
|
(1)
|
Application Software
|
|
(B)
|
Ms – Office
|
(2)
|
High Level Language
|
|
(C)
|
C Language
|
(3)
|
System Software
|
|
(D)
|
Unix
|
(4)
|
Operating System
|
(A) A-4, B-3,
C-2, D-1 (B) A-3, B-1, C-2, D-4 (C)
A-1, B-2, C-4, D-3 (D) A-2, B-3,
C-1, D-4
No comments:
Post a Comment