Computer Operator 14

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

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

CHECK

VALIDATE

VARIFY

SAME

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

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

Title

Main Heading

TOC

Header

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

5

16

8

2

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

Press space bar

Click mouse

Page down

Any of above

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

DIR

MKDR

COPY

XCOPY

#8. Microsoft word cannot be used for ...

Writing stories

Drawing charts

Statistical Analysis

mail merge

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

Kaspersky

AVG

CHKDSK

NOD

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

#11. Power point is usually used for :

Data processing

Typing letters

Accounting

Lecturing and presentation

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

sysdate

time

date/time

date

#13. Thesaurus is MS-word is used for

Checking spelling

Checking grammar

Finding words with similar meanings

Correcting English

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

Graphs

Database

Scheduler

Statistical functions

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

Unlimited

2 MB

1048576

65536

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

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

Hard disk

Monitor

Printer

Keyboard

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

Circul reference

Wrong format

Invalid cell

Wrong operator

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

Output area

Button area

Status area

Text area

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

CTR-X

CTR-F

CTR-S

all of above

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

Programming

Processing

Storing

Organizing

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

Ctrl +I

Ctrl +M

Ctrl +W

Ctrl +N

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

Wallpaper

Desktop

Screen saver

Window

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

memory

Processor