Advanced Computer Basic 5

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

=

<

>=

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

Export

save and go

none of the above

pack and go

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

input devices

storage devices

output devices

none of the above

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

Media

laser

TWAIN

cartridge

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

Rows

Columns

Records

Field

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

Date/ Time

character

label

Number

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

all of the above

low level language

high level language

medium level language

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

unique key

foreign key

Key record

Primary key

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

$D$7

C5

None of the above

A5:h5

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

First

second

third

fourth

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

.xml

.pmt

.html

.xls

#12. < is……..operation.

Arithmetic

Comparison

Logical

my operator

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

none of the above

combo box

List

text box

#14. Types of chart are :

all of the above

Pie chart

bar chart

column chart

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

=

x

*

/

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

1 to 100

none of the above

1 to 255

1 to 200

#17. Which American computer is called big blue ?

Microsoft

IBM

Tandy sevenson

Compaq corp.

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

Apostrophe(')

ampersand (&)

Exclamation (!)

Hash(#)

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

IP address

workgroup name

computer name

all of the above

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

dots printed per unit time

all the above

dot per inch

dot per square. Inch

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

Bar code reader

pen

pencil

none of the above

#22. Select the correct formula for addition :

Max(A2:A5)

add(A2+A3+A4+A5)

none of the above

=sum(A2:A5)

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

slide sorter view

note page view

outline view

Slide show

#24. MS excel is ….. program.

Graphics

Database

None of the above

Spreadsheet

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

IBM 1400

ICT 1401

IBM 1401

ICT 1402

Advanced Computer Basic 5

Advanced Computer Basic 5

Results

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

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

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

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

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

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

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

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

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

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

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

#12. < is……..operation.

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

#14. Types of chart are :

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

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

#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. Which of the following items do not have unique on a network ?

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

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

#22. Select the correct formula for addition :

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

#24. MS excel is ….. program.

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

Leave a Reply