Kroenke Emis3 Tif Ce06

Experiencing MIS, 3e (Kroenke)
Chapter Extension 6: Preparing a Computer Budget Using Excel

Multiple Choice

1) 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: A
Page Ref: 367
Difficulty: Easy
AACSB: Use of IT
Study Question: Study Question 2

2) 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
Answer: A
Page Ref: 367
Difficulty: Easy
AACSB: Use of IT
Study Question: Study Question 2

3) 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
Answer: D
Page Ref: 371
Difficulty: Moderate
AACSB: Use of IT
Study Question: Study Question 2

4) 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: A
Page Ref: 371
Difficulty: Moderate
AACSB: Use of IT
Study Question: Study Question 2
5) 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
Answer: C
Page Ref: 372
Difficulty: Easy
AACSB: Use of IT
Study Question: Study Question 3

6) 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
Answer: D
Page Ref: 372
Difficulty: