Deck 2: Computer Applications and Software: Ms Excel, Ms Access, and Ms Powerpoint

Question 1

The task of changing the appearance of a document is called

A)formatting
B)editing
C)proofing
D)inserting

Answer 1

formatting

Question 2

MS Excel is a

A)word processor
B)spreadsheet
C)dbms
D)none of these

Answer 2

spreadsheet

Question 3

Intersection of rows and columns in a spreadsheet is called

A)record
B)cell
C)file
D)workbook

Answer 3

cell

Question 4

Originally, workbook of a MS Excel contains

A)1 spreadsheet
B)2 spreadsheets
C)3 spreadsheets
D)4 spreadsheets

Question 5

Total number of rows which MS Excel 2007 version supports is

A)65536
B)65546
C)1048576
D)1058576

Question 6

A file in MS Excel is called

A)worksheet
B)workbook
C)directory
D)none of these

Question 7

Total number of columns which MS Excel 2007 version supports is

A)6 thousands
B)10 thousands
C)16 thousands
D)20 thousands

Question 8

The formulae used to calculate the sum of value from the cell C1 to C10 is

A)=sum(c1-c10)
B)=sum(c1:c10)
C)=sum(c1,c10)
D)any of the above

Question 9

The formulae to calculate average from the cell C1 to C10 is

A)=average(c1-c10)
B)=average(c1:c10)
C)=average(c1,c10)
D)any of the above

Question 10

Which of the following formulae is not correct in MS Excel

A)=c1*2
B)=c1/c2
C)c1^2
D)none of these

Question 11

MS Access is a

A)word processor
B)spreadsheet
C)dbms
D)none of these

Question 12

Data pertaining to one particular item is called

A)table
B)record
C)field
D)none of these

Question 13

Duplication of data in various location is called

A)data redundancy
B)integrity
C)atomicity
D)none of these

Question 14

Happening of an event in its entirety or not at all is called

A)data redundancy
B)integrity
C)atomicity
D)none of these

Question 15

Under Relational database data presented in the form of a

A)table
B)graph
C)diagram
D)all of the above

Question 16

Major functions of a database

A)update and retrieve data
B)data integrity
C)data replication
D)all of the above

Question 17

MS Access provides the facility to create

A)forms
B)queries
C)reports
D)all of the above

Question 18

Major application of database management system includes;

A)airline reservation system
B)corporate records
C)banking system
D)all of the above

Question 19

In Microsoft PowerPoint two kind of sound effects files that can be added to the presentation are

A) (.wav) files and (.mid) files
B) (wav) files and (gif) files
C) (.wav) files and (. Jpg) files
D) (jpg) files and (gif) files

Question 20

Special effects used to introduce slides in a presentation are called

A)effects
B)custom animations
C)transitions
D)present animations

Question 21

How can you create a uniform appearance by adding a background image to all slides?

A)create a template
B)edit the slide master
C)use the autocorrect wizard
D)all of the above

Question 22

File which contains readymade styles that can be used for a presentation is called:

A)auto style
B)template
C)wizard
D)pre formatting

Question 23

MS- PowerPoint is a type of :

A)application software
B)system software
C)utility software
D)operating system