Advanced Computer Basic 5

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

label

character

Date/ Time

Number

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

all the above

dots printed per unit time

dot per inch

dot per square. Inch

#3. MS excel is ….. program.

Database

Graphics

Spreadsheet

None of the above

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

medium level language

low level language

high level language

all of the above

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

third

second

First

fourth

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

cartridge

Media

TWAIN

laser

#7. Select the correct formula for addition :

none of the above

=sum(A2:A5)

add(A2+A3+A4+A5)

Max(A2:A5)

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

input devices

output devices

none of the above

storage devices

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

Records

Rows

Columns

Field

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

ICT 1402

ICT 1401

IBM 1400

IBM 1401

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

slide sorter view

outline view

note page view

Slide show

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

none of the above

1 to 255

1 to 100

1 to 200

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

computer name

workgroup name

all of the above

IP address

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

$D$7

C5

None of the above

A5:h5

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

.xls

.html

.xml

.pmt

#16. Which American computer is called big blue ?

IBM

Tandy sevenson

Microsoft

Compaq corp.

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

Bar code reader

pen

none of the above

pencil

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

unique key

foreign key

Primary key

Key record

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

text box

combo box

none of the above

List

#20. < is……..operation.

Comparison

Logical

my operator

Arithmetic

#21. Types of chart are :

all of the above

bar chart

column chart

Pie chart

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

>=

=

<

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

Export

none of the above

pack and go

save and go

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

/

x

*

=

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

Exclamation (!)

ampersand (&)

Apostrophe(')

Hash(#)

Advanced Computer Basic 5

Advanced Computer Basic 5

Results

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

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

#3. MS excel is ….. program.

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

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

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

#7. Select the correct formula for addition :

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

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

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

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

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

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

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

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

#16. Which American computer is called big blue ?

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

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

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

#20. < is……..operation.

#21. Types of chart are :

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

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

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

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

Leave a Reply