Deck 18: Preparing a Computer Budget Using Excel

Question 1

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

Answer 1

False

Question 2

The first step in preparing a budget for department hardware expense is to ________.

A) determine the base requirements
B) determine the computer workloads
C) assess employees' performance
D) create job categories

Answer 2

A

Question 3

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?

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.

Answer 3

A

Question 4

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

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

Question 5

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

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 6

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

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 7

Which of the following enables the fast processing of data once the data resides in the main memory of a computer?

A) CD-ROM
B) DVD
C) CPU
D) LCD

Question 8

Cache memory is the performance factor for ________.

A) the CPU
B) the main memory
C) printers
D) computer displays

Question 9

A site license means that ________.

A) an organization has purchased a license to equip all of the computers in a workplace with certain software
B) an organization has purchased a license to equip one of the computers in a work place with certain software
C) a person has obtained a license to equip his/her personal computer with a certain software
D) an organization has purchased the exclusive right to use a particular software

Question 10

The dot pitch of a CRT monitor refers to the ________.

A) number of pixels in one mm²
B) number of pixels in a unit area
C) distance between the pixels
D) size of its pixels

Question 11

Which of the following statements is true about LCD monitors?

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 12

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

Question 13

A ________ holds up to 700 MB of data and can be used to back up files.

A) Blue-ray disk
B) magnetic disk
C) DVD
D) CD

Question 14

________ is an example of a horizontal market software

A) AutoCad
B) Open Office
C) Goldmine
D) Act!

Question 15

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?

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

Question 16

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

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

Question 17

Which of the following is an example of a formula with an absolute address?

A) =G13*G13
B) =G13+G14
C) =$G13+$G14
D) =$G$13+$G$14

Question 18

$G$17 is the absolute address of the cell G17.

Question 19

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

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

Question 20

In optical disks denoted as CD-R,R stands for ________.

A) recoverable
B) recordable
C) rewritable
D) read-only memory

Question 21

A network interface card is not needed for wireless networks.

Question 22

Explain the role of the IT department in an organization.

Question 23

Briefly describe the variations in optical disks.

Question 24

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

Question 25

Briefly describe the process for preparing a departmental IT budget.

Question 26

What is the significance of the main memory in the functioning of a computer?

Question 27

Describe the two types of video display monitors.

Question 28

Unlike magnetic disks,optical disks are volatile;they do not maintain their contents when not powered.

Question 29

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

Question 30

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

Question 31

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

Question 32

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

Question 33

The amount of memory used for each cell in the pixel grid depends on the number of colors that each pixel is to display.

Question 34

For an LCD monitor,the distance between pixels is referred to as dot pitch.

Question 35

In the disk standard ATA-100,the 100 refers to the maximum transfer rate of 100MB per second.

Question 36

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

Question 37

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

Question 38

A CD-ROM is not an optical disk.

Question 39

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.