Question 1

Vendors usually require their customers to pay the price of new software when upgrading from a previous version.

Accepted Answer

A) True 
 B)False  False

Question 2

Describe the two types of video display monitors.

Accepted Answer

There are two types of video display monitors: CRTs and LCDs.CRT monitors use cathode ray tubes;LCD monitors use a technology called liquid crystal display (LCD).Both types of monitors display images by illuminating small spots on the screen called pixels.The number of pixels displayed depends not only on the size of the monitor,but also on the design of the mechanism that creates the image.For a CRT monitor,the dot pitch of the monitor is the distance between pixels.The smaller the dot pitch,the sharper and brighter the screen image will be.For an LCD monitor,the pixel pitch is the distance between pixels on the screen.As with CRT monitors,the smaller the pixel pitch,the sharper and brighter the image will be.

Question 3

A disk takes 15 milliseconds to rotate under the read/write head and 3 milliseconds to position its read/write arm to the head over the correct circle.What is the seek time of this disk?

Accepted Answer

A)  3 milliseconds 
B)  15 milliseconds 
C)  5 milliseconds 
D)  45 milliseconds 
A)  3 milliseconds 
B)  15 milliseconds 
C)  5 milliseconds 
D)  45 milliseconds A

Question 4

Once you buy a computer,there is nothing you can do to increase memory speed.

Accepted Answer

A) True 
 B)False

Question 5

Which of the following is an example of a vertical market software?

Accepted Answer

A)  Microsoft Office 
B)  Adobe Acrobat 
C)  AutoCad 
D)  Open Office 
A)  Microsoft Office 
B)  Adobe Acrobat 
C)  AutoCad 
D)  Open Office

Question 6

________ is the time it takes the data to rotate under the read/write head.

Accepted Answer

A)  Rotational delay 
B)  Spin-up time 
C)  Seek time 
D)  Seek circle 
A)  Rotational delay 
B)  Spin-up time 
C)  Seek time 
D)  Seek circle

Question 7

Enterprise resource planning systems can have hundreds or even thousands of users,so vendors charge a license for each user or for a certain number of users.

Accepted Answer

A) True 
 B)False

Question 8

For a CRT monitor,the smaller the dot pitch,the sharper and brighter the screen image will be.

Accepted Answer

A) True 
 B)False

Question 9

Forecasting the requirement changes during the budget period must be the first step in preparing a budget.

Accepted Answer

A) True 
 B)False

Question 10

The time taken by the read/write arm to position the head over the correct circle is referred to as rotational delay.

Accepted Answer

A) True 
 B)False

Question 11

For a black-and-white image,the cells require at least four bits for display.

Accepted Answer

A) True 
 B)False

Question 12

ATA-100 is the channel standard used to represent a disk.What does the number 100 indicate here?

Accepted Answer

A)  The maximum transfer rate of the disk is 100 MB per second. 
B)  The disk has 100 circles per mm of its diameter. 
C)  The disk's rotation speed is 100 cycles per second. 
D)  The total disk space of the disk is 100 GB. 
A)  The maximum transfer rate of the disk is 100 MB per second. 
B)  The disk has 100 circles per mm of its diameter. 
C)  The disk's rotation speed is 100 cycles per second. 
D)  The total disk space of the disk is 100 GB.

Question 13

The term site license means that an organization has purchased a license to equip all of the computers on a site with certain software.

Accepted Answer

A) True 
 B)False

Question 14

Which of the following statements is true about LCD monitors?

Accepted Answer

A)  The dot pitch of an LCD monitor is the distance between its pixels. 
B)  They use cathode-ray tubes, the same devices used in traditional TV screens. 
C)  They have a longer life than CRT monitors. 
D)  They are big and bulky, about as deep as they are wide. 
A)  The dot pitch of an LCD monitor is the distance between its pixels. 
B)  They use cathode-ray tubes, the same devices used in traditional TV screens. 
C)  They have a longer life than CRT monitors. 
D)  They are big and bulky, about as deep as they are wide.

Question 15

CD transfer rates are about 10 times faster than those for DVDs.

Accepted Answer

A) True 
 B)False

Question 16

Having a very fast CPU is the most important factor for business processing.

Accepted Answer

A) True 
 B)False

Question 17

For an LCD monitor,the distance between pixels on the screen is termed ________.

Accepted Answer

A)  dot pitch 
B)  optimal resolution 
C)  pixel density 
D)  pixel pitch 
A)  dot pitch 
B)  optimal resolution 
C)  pixel density 
D)  pixel pitch

Question 18

When preparing a budget for department hardware expense,after forecasting requirement changes during the budget period,you should ________.

Accepted Answer

A)  determine if your department will be charged for overhead expenses 
B)  determine the hardware and software requirements for the team 
C)  identify the types of workloads that employees perform 
D)  determine the base requirements for the team 
A)  determine if your department will be charged for overhead expenses 
B)  determine the hardware and software requirements for the team 
C)  identify the types of workloads that employees perform 
D)  determine the base requirements for the team

Question 19

Which of the following is the best way to ensure that the address in a formula is not changed when it is copied or moved?

Accepted Answer

A)  Use an absolute address to represent the formula. 
B)  Enable the lock formula option from the Data tab. 
C)  Select the "Protect Sheet" option from the Tools menu. 
D)  Use the function key F2 after copying or moving the formula. 
A)  Use an absolute address to represent the formula. 
B)  Enable the lock formula option from the Data tab. 
C)  Select the "Protect Sheet" option from the Tools menu. 
D)  Use the function key F2 after copying or moving the formula.

Question 20

Explain the role of the IT department in an organization.

Accepted Answer

The IT department normally provides a he

Exam 18: Preparing a Computer Budget Using Excel

Vendors usually require their customers to pay the price of new software when upgrading from a previous version.

Describe the two types of video display monitors.

A disk takes 15 milliseconds to rotate under the read/write head and 3 milliseconds to position its read/write arm to the head over the correct circle.What is the seek time of this disk?

Once you buy a computer,there is nothing you can do to increase memory speed.

Which of the following is an example of a vertical market software?

________ is the time it takes the data to rotate under the read/write head.

Enterprise resource planning systems can have hundreds or even thousands of users,so vendors charge a license for each user or for a certain number of users.

For a CRT monitor,the smaller the dot pitch,the sharper and brighter the screen image will be.

Forecasting the requirement changes during the budget period must be the first step in preparing a budget.

The time taken by the read/write arm to position the head over the correct circle is referred to as rotational delay.

For a black-and-white image,the cells require at least four bits for display.

ATA-100 is the channel standard used to represent a disk.What does the number 100 indicate here?

The term site license means that an organization has purchased a license to equip all of the computers on a site with certain software.

Which of the following statements is true about LCD monitors?

CD transfer rates are about 10 times faster than those for DVDs.

Having a very fast CPU is the most important factor for business processing.

For an LCD monitor,the distance between pixels on the screen is termed ________.

When preparing a budget for department hardware expense,after forecasting requirement changes during the budget period,you should ________.

Which of the following is the best way to ensure that the address in a formula is not changed when it is copied or moved?

Explain the role of the IT department in an organization.

The Importance of MIS

Business Processes, Information, and Information Systems

Organizational Strategy, Information Systems, and Competitive Advantage

Hardware and Software

Database Processing

Data Communications

Business Process Management

E-Commerce, Web 2.0, and Social Networking

Business Intelligence and Information Systems for Decision Making

Information Systems Development

Information Systems Management

Information Security Management

Improving Your Collaboration Skills

Using Collaboration Information Systems

Information Systems and Decision Making

Knowledge Management and Expert Systems

Introduction to Microsoft Excel

Database Design

Using Microsoft Access 2010

Using Excel and Access Together

Remote, Nomadic, and Mobile Systems

Functional Processes, Applications, and Systems

Enterprise Resource Planning (ERP)Systems

Supply Chain Management

Processing Social Capital: Facebook, Twitter, and User-Generated Content (UGC)

Database Marketing

Reporting Systems and OLAP

Geographic Information Systems

Business Process Management

Systems Development Project Management

Outsourcing

International MIS

Filters