Computer Operator 14

#1. Which facility is not available in MS EXCEL ?

Graphs

Database

Scheduler

Statistical functions

#2. It you format your headings using standard heading styles for word, automated features you can create a ……. For documents.

Title

Main Heading

TOC

Header

#3. Maximum rows of data that can be entered in excel 2007 excel sheet is

Unlimited

2 MB

1048576

65536

#4. To print only slides 4, 5, 6 and 10, use the file/print menu option, select the slides option under print range. The range you would enter would be

4-6, 10

4,6;10

4,4-6,10

d/6, 10

#5. Which is not a part of the CPU ?

memory

Processor

Keyboard

Arithmetic logic unit

#6. In power point you can add a new slide by pressing the ……. Key combination.

Ctrl +I

Ctrl +M

Ctrl +W

Ctrl +N

#7. Which of command is not included in COMMAND.COM in MS-DOS ?

DIR

MKDR

COPY

XCOPY

#8. Which of the following software cannot be used removing computer virus ?

Kaspersky

AVG

CHKDSK

NOD

#9. If formula “=SUM($A$1+B1)” in cell C1 is copied to cell C2 what will be the resulting formula in the cell C2.

=SUM($A$1+B2)

=SUM($A1+$B1)

=Sum($A$2+B1)

=SUM($A$2+B2)

#10. Power point is usually used for :

Data processing

Typing letters

Accounting

Lecturing and presentation

#11. What will be the output of the following MS EXCEL formula =(2^2+4/2*2

5

16

8

2

#12. Microsoft word cannot be used for …

Writing stories

Drawing charts

Statistical Analysis

mail merge

#13. Which of the following command can be used in all windows office application ?

CTR-X

CTR-F

CTR-S

all of above

#14. A ……. Constraint restricts values you can insert into a column.

CHECK

VALIDATE

VARIFY

SAME

#15. What is wrong with formula =E1……A1 in cell E1 in Excel ?

Circul reference

Wrong format

Invalid cell

Wrong operator

#16. To change the system data you can use ………. Commands.

sysdate

time

date/time

date

#17. Which one of the following in only input device ?

Hard disk

Monitor

Printer

Keyboard

#18. What do you need to do before generating table of content is Ms-word ?

Select text for table of content

Select text to be included in header and change style to header

Copy and paste text into table of content

drag and drop text into table of content

#19. Find the odd one out

CPU

RAM

CD drive

ALU

#20. In Power point slide show what do you do to go to next page ?

Press space bar

Click mouse

Page down

Any of above

#21. The name for the way that computer manipulate data into information is called:

Programming

Processing

Storing

Organizing

#22. Thesaurus is MS-word is used for

Checking spelling

Checking grammar

Finding words with similar meanings

Correcting English

#23. You can edit a cell in spreadsheet by

clicking the formula button

Double clicking the cell to edit it in-place

Selecting edit and edit cell from the menu

none of the above

#24. Everything you see on the screen in called the ………

Wallpaper

Desktop

Screen saver

Window

#25. The button of your window given additional information about your work in a place called the……..

Output area

Button area

Status area

Text area