Computer Operator 14

#1. Power point is usually used for :

Data processing

Typing letters

Accounting

Lecturing and presentation

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

CTR-X

CTR-F

CTR-S

all of above

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

Graphs

Database

Scheduler

Statistical functions

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

Circul reference

Wrong format

Invalid cell

Wrong operator

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

CHECK

VALIDATE

VARIFY

SAME

#6. Microsoft word cannot be used for …

Writing stories

Drawing charts

Statistical Analysis

mail merge

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

Press space bar

Click mouse

Page down

Any of above

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

DIR

MKDR

COPY

XCOPY

#9. Find the odd one out

CPU

RAM

CD drive

ALU

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

Programming

Processing

Storing

Organizing

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

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

Title

Main Heading

TOC

Header

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

Unlimited

2 MB

1048576

65536

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

sysdate

time

date/time

date

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

memory

Processor

Keyboard

Arithmetic logic unit

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

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

Wallpaper

Desktop

Screen saver

Window

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

Ctrl +I

Ctrl +M

Ctrl +W

Ctrl +N

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

Hard disk

Monitor

Printer

Keyboard

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

Kaspersky

AVG

CHKDSK

NOD

#21. Thesaurus is MS-word is used for

Checking spelling

Checking grammar

Finding words with similar meanings

Correcting English

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

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

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

5

16

8

2

#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