CIS Final Exam with Accurate
Solutions
According to von Neumann's definition of a computer, what are the four basic functions
of a computer? - ANS-input data, process data, output data, and store data
What are the two golden rules when using Excel? - ANS-1. Do not enter data that can
be calculated by using existing data.
2. Write a formula that can be copied.
A field is: - ANS-The smallest unit of data about an entity
In Microsoft Word, to balance the columns of text, insert a - ANS-continuous section
break
A set of rules that maintain consistency of data between two tables is - ANS-Referential
Integrity
What two inventions caused an explosion in internet usage? - ANS-hypertext and
browsers
The default cell referencing method in Excel is: - ANS-relative references
The type of business application that is used to collect data is called a(n): - ANS-TPS
The term bit stands for - ANS-binary digit
In Microsoft Access, what type of object is used to extract and manipulate data from one
or more tables? - ANS-query
The computer that an individual uses while connected to the internet is called a: - ANS-
client
In Excel, LOOKUP is an example of a: - ANS-function
The measure of picture quality for a printer is: - ANS-DPI
Waveform Audio can best be described as a(n): - ANS-digital representation of a sound
wave
, When an object or text is cut or copied from a document it is placed in the - ANS-
clipboard
The type of business application that is used to explore what-if scenarios is call a(n): -
ANS-DSS
To establish a one-to-many relationship between two tables, a _______ is used in the
table on the "many" side of the relationship - ANS-foreign key
The acronym ISP stands for: - ANS-Internet service provider
Microsoft Access is what type of database system? - ANS-relational
In Microsoft Word, the best way to format text and paragraphs throughout the document
is to use: - ANS-styles
Files being stored as small non-contiguous chunks scattered over a disk is called: -
ANS-fragmentations
Business software that is designed to perform multiple business functions for a single
industry is called: - ANS-vertical market
In Excel, each tab at the bottom represents a: - ANS-worksheet
Microsoft Windows Explorer is an example of what type of software? - ANS-
Maintaining the quality of data in a database is achieved by implementing: - ANS-
integrity constraints
Excel is an example of a(n) ______________ software package. - ANS-application
What type of software is used to manage large amounts of data? - ANS-DBMS
What is the binary representation of the number 49? - ANS-110001
A link from a Word document to a page on the WWW is known as a: - ANS-hyperlink
Internal memory is commonly referred to as RAM which stands for: - ANS-random
access memory
SQL can be described as - ANS-A language for accessing information in a relational
database
In Microsoft Access, to create a screen for editing data in a table, which type of object
would be created? - ANS-form
Solutions
According to von Neumann's definition of a computer, what are the four basic functions
of a computer? - ANS-input data, process data, output data, and store data
What are the two golden rules when using Excel? - ANS-1. Do not enter data that can
be calculated by using existing data.
2. Write a formula that can be copied.
A field is: - ANS-The smallest unit of data about an entity
In Microsoft Word, to balance the columns of text, insert a - ANS-continuous section
break
A set of rules that maintain consistency of data between two tables is - ANS-Referential
Integrity
What two inventions caused an explosion in internet usage? - ANS-hypertext and
browsers
The default cell referencing method in Excel is: - ANS-relative references
The type of business application that is used to collect data is called a(n): - ANS-TPS
The term bit stands for - ANS-binary digit
In Microsoft Access, what type of object is used to extract and manipulate data from one
or more tables? - ANS-query
The computer that an individual uses while connected to the internet is called a: - ANS-
client
In Excel, LOOKUP is an example of a: - ANS-function
The measure of picture quality for a printer is: - ANS-DPI
Waveform Audio can best be described as a(n): - ANS-digital representation of a sound
wave
, When an object or text is cut or copied from a document it is placed in the - ANS-
clipboard
The type of business application that is used to explore what-if scenarios is call a(n): -
ANS-DSS
To establish a one-to-many relationship between two tables, a _______ is used in the
table on the "many" side of the relationship - ANS-foreign key
The acronym ISP stands for: - ANS-Internet service provider
Microsoft Access is what type of database system? - ANS-relational
In Microsoft Word, the best way to format text and paragraphs throughout the document
is to use: - ANS-styles
Files being stored as small non-contiguous chunks scattered over a disk is called: -
ANS-fragmentations
Business software that is designed to perform multiple business functions for a single
industry is called: - ANS-vertical market
In Excel, each tab at the bottom represents a: - ANS-worksheet
Microsoft Windows Explorer is an example of what type of software? - ANS-
Maintaining the quality of data in a database is achieved by implementing: - ANS-
integrity constraints
Excel is an example of a(n) ______________ software package. - ANS-application
What type of software is used to manage large amounts of data? - ANS-DBMS
What is the binary representation of the number 49? - ANS-110001
A link from a Word document to a page on the WWW is known as a: - ANS-hyperlink
Internal memory is commonly referred to as RAM which stands for: - ANS-random
access memory
SQL can be described as - ANS-A language for accessing information in a relational
database
In Microsoft Access, to create a screen for editing data in a table, which type of object
would be created? - ANS-form
