Computer operator 3

#1. In MS Excel, what happens when dollar sign ($) are entered in a cell address ? (Ex:$B$2:$B$10)

an absolute cell address in created

cell address will change when it is copied to another cell

the sheet tab is changed

the status bar does not display the cell address

#2. Which of the following is a popular DOS based spreadsheet package ?

word

smart cell

excel

Lotus 1-2-3

#3. Which operator will combine text from two cells into one cell ?

& (ampersand)

=(equal)

space

none of the above

#4. Which page orientation you will select, if you wish to print to wide format ?

Landscape

portrait

horizontal

vertical

#5. Where from you can insert shapes in your slide ?

home menu

design menu

animation menu

all of the above

#6. …………. Present data in a way similar to an excel spreadsheet .

datasheet view

design view

print view

layout view

#7. Which key used for slide show from beginning ?

F2

F1

F5

F9

#8. A DBMS allow you to create and maintain a database, create reports, and develop application programs, select the best fit answer :

database management approach

DBMS user

database administrator

query language

#9. Mail merge is concerned with :

combining main document with data file

sending a typed letter to share holder of a company

to split main document

none of the above

#10. In MS –excel, B7:B9 indicates :

cell B7 and cell B9 only

cells B7 through B9

cell B8 only

none of the above

#11. A web page in located using a :

universal record linking

uniform resource locator

universal record locator

uniformaly reachable links

#12. In MS-word, you can convert the document’s file format by applying the command :

save

save as

permission

convert

#13. A world wide web contains web pages :

Residing in many computer

Created using HTML

With links to other web pages

Residing in many computers linked together using HTML

#14. How do you display current date and time in MS Excel ?

date()

today()

now()

time()

#15. What terms refers to a collection of related information ?

Database

List

Outline

Record

#16. An excel workbook is a collection of :

workbook

worksheet

Charts

worksheets and charts

#17. In MS Excel, what do you mean by a workspace ?

group of columns

group of worksheet

group of row

group of workbook

#18. The intersection of a row and column is called :

data

a field

a cell

an equation

#19. Database that contains tables linked by common field is called a

centralized database

flat file database

relational database

none of above

#20. DBMS is :

Collection of data

set of programs to access those data

set of programs to update those data

all of above

#21. Page setup for slides is available on :

Home menu

Design menu

Insert menu

View menu

Computer operator 3

Results

#1. In MS Excel, what happens when dollar sign ($) are entered in a cell address ? (Ex:$B$2:$B$10)

#2. Which of the following is a popular DOS based spreadsheet package ?

#3. Which operator will combine text from two cells into one cell ?

#4. Which page orientation you will select, if you wish to print to wide format ?

#5. Where from you can insert shapes in your slide ?

#6. …………. Present data in a way similar to an excel spreadsheet .

#7. Which key used for slide show from beginning ?

#8. A DBMS allow you to create and maintain a database, create reports, and develop application programs, select the best fit answer :

#9. Mail merge is concerned with :

#10. In MS –excel, B7:B9 indicates :

#11. A web page in located using a :

#12. In MS-word, you can convert the document’s file format by applying the command :

#13. A world wide web contains web pages :

#14. How do you display current date and time in MS Excel ?

#15. What terms refers to a collection of related information ?

#16. An excel workbook is a collection of :

#17. In MS Excel, what do you mean by a workspace ?

#18. The intersection of a row and column is called :

#19. Database that contains tables linked by common field is called a

#20. DBMS is :

#21. Page setup for slides is available on :

Leave a Reply