Question 1

The task of changing the appearance of a document is called
A)formatting
B)editing
C)proofing
D)inserting

Accepted Answer

Formatting refers to the process of adjusting the appearance of a document, which includes changing the font size, style, margins, and other visual elements to make the document more presentable or to adhere to specific guidelines.

Question 2

MS Excel is a
A)word processor
B)spreadsheet
C)dbms
D)none of these

Accepted Answer

MS Excel is primarily known as a spreadsheet program used for data organization, analysis, and storage.

Question 3

Intersection of rows and columns in a spreadsheet is called
A)record
B)cell
C)file
D)workbook

Accepted Answer

Cells are the individual boxes in a spreadsheet where rows and columns intersect.

Question 4

Originally, workbook of a MS Excel contains
A)1 spreadsheet
B)2 spreadsheets
C)3 spreadsheets
D)4 spreadsheets

Accepted Answer

A new workbook in Microsoft Excel originally contains 3 spreadsheets by default, although this setting can be changed by the user.

Question 5

Total number of rows which MS Excel 2007 version supports is
A)65536
B)65546
C)1048576
D)1058576

Accepted Answer

MS Excel 2007 supports 1,048,576 rows per worksheet, a significant increase from the 65,536 rows supported in Excel 2003 and earlier versions.

Question 6

A file in MS Excel is called
A)worksheet
B)workbook
C)directory
D)none of these

Accepted Answer

In MS Excel, a file is referred to as a workbook, which can contain one or more worksheets.

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

Accepted Answer

MS Excel 2007 supports 16,384 columns per worksheet, which corresponds to the column header "XFD".

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

Accepted Answer

The correct formula to calculate the sum of values from cell C1 to C10 in Excel is =SUM(C1:C10). The colon (:) is used to specify a range of cells.

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

Accepted Answer

The correct formula to calculate the average of values from cell C1 to C10 in Excel is =average(c1:c10), which uses a colon to specify the range of cells.

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

Accepted Answer

The correct syntax for exponentiation in MS Excel is POWER(number,power), not c1^2.

Question 11

MS Access is a
A)word processor
B)spreadsheet
C)dbms
D)none of these

Accepted Answer

MS Access is a database management system (DBMS) designed to help users create and manage databases.

Question 12

Data pertaining to one particular item is called
A)table
B)record
C)field
D)none of these

Accepted Answer

Data pertaining to one particular item is typically organized into a record, which is a collection of related fields.

Question 13

Duplication of data in various location is called
A)data redundancy
B)integrity
C)atomicity
D)none of these

Accepted Answer

Data redundancy refers to the unnecessary repetition or duplication of data within a database or across multiple data storage locations.

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

Accepted Answer

Atomicity refers to transactions being fully completed or not executed at all, ensuring that if any part of the transaction fails, the entire transaction fails and the database state is left unchanged.

Question 15

Under Relational database data presented in the form of a
A)table
B)graph
C)diagram
D)all of the above

Accepted Answer

In a relational database, data is organized and presented in the form of tables, which consist of rows and columns.

Question 16

Major functions of a database
A)update and retrieve data
B)data integrity
C)data replication
D)all of the above

Accepted Answer

Databases are designed to update and retrieve data efficiently, ensure data integrity by maintaining consistency and accuracy of the data, and support data replication to distribute data across different locations or systems for redundancy and performance. Therefore, all of the options listed are major functions of a database.

Question 17

MS Access provides the facility to create
A)forms
B)queries
C)reports
D)all of the above

Accepted Answer

MS Access is a database management system that allows users to create forms for data entry, queries to search and manipulate data, and reports to format and summarize data, hence all of the options are correct.

Question 18

Major application of database management system includes;
A)airline reservation system
B)corporate records
C)banking system
D)all of the above

Accepted Answer

Database Management Systems (DBMS) are crucial for managing data in various applications. They are used in airline reservation systems to handle bookings and flight schedules, in corporate environments to manage employee records, financial data, etc., and in banking systems to manage accounts, transactions, and customer information. Therefore, all the options listed are major applications of DBMS.

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

Accepted Answer

Microsoft PowerPoint supports adding sound effects to presentations, and the formats it can handle include (.wav) files, which are waveform audio files, and (.mid) files, which are MIDI (Musical Instrument Digital Interface) files. These formats are specifically designed for audio, unlike the other options listed which include image file formats (jpg, gif) that do not contain sound.

Question 20

Special effects used to introduce slides in a presentation are called
A)effects
B)custom animations
C)transitions
D)present animations

Accepted Answer

The answer of Special effects used to introduce slides in...

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

The task of changing the appearance of a document is called

MS Excel is a

Intersection of rows and columns in a spreadsheet is called

Originally, workbook of a MS Excel contains

Total number of rows which MS Excel 2007 version supports is

A file in MS Excel is called

Total number of columns which MS Excel 2007 version supports is

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

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

Which of the following formulae is not correct in MS Excel

MS Access is a

Data pertaining to one particular item is called

Duplication of data in various location is called

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

Under Relational database data presented in the form of a

Major functions of a database

MS Access provides the facility to create

Major application of database management system includes;

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

Special effects used to introduce slides in a presentation are called