Top 80+ Solved Computer Applications in Economics MCQ Questions Answer
Q. Mathematical operations in MS Excel should begin with
a. = sign
b. + sign
c. either a or b
d. none of these
Q. Total number of columns which MS Excel 2007 version supports is
a. 6 thousands
b. 10 thousands
c. 16 thousands
d. 20 thousands
Q. 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
Q. 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
Q. Which of the following formulae is not correct in MS Excel
a. =c1*2
b. =c1/c2
c. c1^2
d. none of these
Q. Duplication of data in various location is called
a. data redundancy
b. integrity
c. atomicity
d. none of these
Q. Happening of an event in its entirety or not at all is called
a. data redundancy
b. integrity
c. atomicity
d. none of these
Q. Under Relational database data presented in the form of a
a. table
b. graph
c. diagram
d. all of the above
Q. Major functions of a database
a. update and retrieve data
b. data integrity
c. data replication
d. all of the above
Q. The key which consists of one or more fields that uniquely identify each record thatwe store in the table is
a. primary key
b. secondary key
c. master key
d. none of the above
Q. Major application of database management system includes;
a. airline reservation system
b. corporate records
c. banking system
d. all of the above