Advanced Computer Basic 5

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

=

*

/

x

#2. Types of chart are :

all of the above

column chart

bar chart

Pie chart

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

Columns

Rows

Field

Records

#4. MS excel is ….. program.

Spreadsheet

Database

Graphics

None of the above

#5. Select the correct formula for addition :

=sum(A2:A5)

Max(A2:A5)

add(A2+A3+A4+A5)

none of the above

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

Key record

Primary key

unique key

foreign key

#7. Which American computer is called big blue ?

Microsoft

IBM

Compaq corp.

Tandy sevenson

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

cartridge

laser

TWAIN

Media

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

outline view

note page view

slide sorter view

Slide show

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

all of the above

high level language

medium level language

low level language

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

A5:h5

None of the above

C5

$D$7

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

ICT 1401

IBM 1400

ICT 1402

IBM 1401

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

computer name

IP address

all of the above

workgroup name

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

=

<

>=

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

.html

.xls

.xml

.pmt

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

1 to 200

none of the above

1 to 255

1 to 100

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

Date/ Time

character

label

Number

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

input devices

none of the above

storage devices

output devices

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

combo box

List

text box

none of the above

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

dot per square. Inch

dots printed per unit time

all the above

dot per inch

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

save and go

pack and go

Export

none of the above

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

second

third

fourth

First

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

Bar code reader

pencil

none of the above

pen

#24. < is……..operation.

my operator

Arithmetic

Comparison

Logical

#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. We use ….. operator to multiply in MS excel.

#2. Types of chart are :

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

#4. MS excel is ….. program.

#5. Select the correct formula for addition :

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

#7. Which American computer is called big blue ?

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

#24. < is……..operation.

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

Leave a Reply