Computer Operator 14

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

5

16

8

2

#2. Thesaurus is MS-word is used for

Checking spelling

Checking grammar

Finding words with similar meanings

Correcting English

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

sysdate

time

date/time

date

#4. 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

#5. Power point is usually used for :

Data processing

Typing letters

Accounting

Lecturing and presentation

#6. Microsoft word cannot be used for …

Writing stories

Drawing charts

Statistical Analysis

mail merge

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

Title

Main Heading

TOC

Header

#8. 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)

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

Programming

Processing

Storing

Organizing

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

Output area

Button area

Status area

Text area

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

Ctrl +I

Ctrl +M

Ctrl +W

Ctrl +N

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

DIR

MKDR

COPY

XCOPY

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

Kaspersky

AVG

CHKDSK

NOD

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

memory

Processor

Keyboard

Arithmetic logic unit

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

Wallpaper

Desktop

Screen saver

Window

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

CHECK

VALIDATE

VARIFY

SAME

#17. Find the odd one out

CPU

RAM

CD drive

ALU

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

Circul reference

Wrong format

Invalid cell

Wrong operator

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

Press space bar

Click mouse

Page down

Any of above

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

Unlimited

2 MB

1048576

65536

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

Hard disk

Monitor

Printer

Keyboard

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

CTR-X

CTR-F

CTR-S

all of above

#23. 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

#24. 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

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

Graphs

Database

Scheduler

Statistical functions