Advanced Computer Basic 5

#1. We use ….. operator to multiply in MS excel.

=

x

/

*

#2. Types of chart are :

bar chart

column chart

Pie chart

all of the above

#3. The mouse, joystick and light pen are example of ……….

input devices

none of the above

storage devices

output devices

#4. The output quality of a printer id measured by ………

dots printed per unit time

all the above

dot per square. Inch

dot per inch

#5. MS excel is ….. program.

Spreadsheet

Database

Graphics

None of the above

#6. Which of the following is not a valid data type in excel ?

label

Date/ Time

character

Number

#7. Which generation of the computer was made of transistor ?

First

second

third

fourth

#8. We can run power point slide in another computer program:

Export

none of the above

pack and go

save and go

#9. An IP address contains four set of number ranging from………

none of the above

1 to 255

1 to 100

1 to 200

#10. The power point view that displays only text (title & text )……

slide sorter view

Slide show

note page view

outline view

#11. Select the correct formula for addition :

=sum(A2:A5)

Max(A2:A5)

none of the above

add(A2+A3+A4+A5)

#12. Which of the following items do not have unique on a network ?

workgroup name

IP address

all of the above

computer name

#13. In a supermarket which of the following will be used in its computerized system ?

Bar code reader

pen

pencil

none of the above

#14. In MS Excel a formula always start with ……. Sign.

=

>=

<

#15. Which of the following key uniquely identify table ?

foreign key

Primary key

unique key

Key record

#16. < is……..operation.

Logical

Comparison

Arithmetic

my operator

#17. Which American computer is called big blue ?

Compaq corp.

IBM

Tandy sevenson

Microsoft

#18. In Excel a numeric value can be treated as a label value if it precedes with:

ampersand (&)

Apostrophe(')

Hash(#)

Exclamation (!)

#19. What is the column is MS access table called ?

Rows

Records

Columns

Field

#20. Which of the following is not computer language ?

low level language

all of the above

medium level language

high level language

#21. What is the extension of Microsoft Excel File ?

.pmt

.xml

.xls

.html

#22. Which one is an example of absolute cell reference ?

C5

None of the above

$D$7

A5:h5

#23. Which of the following is a term related with scanners ?

Media

cartridge

laser

TWAIN

#24. Which of the following control is known as drop down list ?

text box

combo box

List

none of the above

#25. The first computer introduced in Nepal was………..

ICT 1402

IBM 1400

IBM 1401

ICT 1401

Advanced Computer Basic 5

Advanced Computer Basic 5

Results

#1. We use ….. operator to multiply in MS excel.

#2. Types of chart are :

#3. The mouse, joystick and light pen are example of ……….

#4. The output quality of a printer id measured by ………

#5. MS excel is ….. program.

#6. Which of the following is not a valid data type in excel ?

#7. Which generation of the computer was made of transistor ?

#8. We can run power point slide in another computer program:

#9. An IP address contains four set of number ranging from………

#10. The power point view that displays only text (title & text )……

#11. Select the correct formula for addition :

#12. Which of the following items do not have unique on a network ?

#13. In a supermarket which of the following will be used in its computerized system ?

#14. In MS Excel a formula always start with ……. Sign.

#15. Which of the following key uniquely identify table ?

#16. < is……..operation.

#17. Which American computer is called big blue ?

#18. In Excel a numeric value can be treated as a label value if it precedes with:

#19. What is the column is MS access table called ?

#20. Which of the following is not computer language ?

#21. What is the extension of Microsoft Excel File ?

#22. Which one is an example of absolute cell reference ?

#23. Which of the following is a term related with scanners ?

#24. Which of the following control is known as drop down list ?

#25. The first computer introduced in Nepal was………..

Leave a Reply