Review QuestionsChapter Extension 5: Introduction to Microsoft Excel
1) A ______is a table of data which has rows and columns.
A) spreadsheet
B) cell
C) broadsheet
D) library
2) In Excel, the term "______" refers to a single spreadsheet.
A) workbook
B) library
C) worksheet
D) gridline
3) In Excel, a ______is a combination of one or more worksheets.
A) dashboard
B) workbook
C) batch
D) datasheet
4) In Microsoft Excel, the columns are identified by ______.
A) capital letters
B) numbers
C) Roman numerals
D) lowercase letters
5) In Microsoft Excel, the intersection of a row and column is called a(n) ______.
A) junction
B) content point
C) cell
D) data point
6) In Microsoft Excel, the wide bar of tools and selections that appears just under the tabs is termed the ______.
A) menu tab
B) task pane
C) office button
D) ribbon
7) When adding graphs, hyperlinks, or images to a Microsoft Excel worksheet, you use the ______tab.
A) Data
B) Format
C) View
D) Insert
8) In Microsoft Excel, which of the following tabs can be used for filtering and sorting the information in your spreadsheet?
A) Data
B) Add-ins
C) Formula
D) Home
9) In Microsoft Excel, most frequently used tools and selections appear under the ______tab.
A) Data
B) Home
C) View
D) Add-ins
10) In Excel, the Review tab can be used for ______.
A) creating more complex formulas
B) filtering and sorting data in the spreadsheet
C) tracking changes and making comments
D) formatting the page, often for printing
11) Which of the following can be used to move the focus to a different cell in the Excel worksheet?
A) arrow keys
B) office button
C) shift key
D) data tab
12) You have entered a formula in the cell G9. Which of the following would occur if you press F2 function key after selecting the cell G9?
A) The formula in G9 can be edited without retyping.
B) The formula will be copied to the clipboard.
C) A graph that explains the formula would appear.
D) The formula in the cell will be locked.
13) In Excel, every formula must begin with a(n) ______sign.
A) plus
B) minus
C) dollar
D) equality
14) What is the meaning of the formula SUM (C3:C8)?
A) Add all the values starting from the third cell to eighth cell in the third column.
B) Add the all the values starting from the third cell to eighth cell in the third row.
C) Add the values of third cell in the third column and eighth cell in the third column.
D) Add the values of third cell in the third row and eighth cell in the third row.
15) Which of the following is the correct method for accessing Microsoft Help?
A) It can be accessed by clicking the question mark in the office button that appears at the upper left-corner of the Excel window.
B) It can be accessed by clicking the question mark in the upper right-hand corner of the ribbon on the Excel window.
C) It can be accessed by clicking the question mark in the status bar that appears at the very bottom of the Excel window.
D) It can be accessed by clicking the question mark present on the title bar of the Excel window.
16) In Excel, the option to change the page orientation is located on the ______tab.
A) Page Layout
B) View
C) Review
D) Add-ins
Review QuestionsChapter Extension 6: Preparing a Computer Budget Using Excel
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
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
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
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.
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
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
7) Cache memory is the performance factor for ______.
A) the CPU
B) the main memory
C) printers
D) computer displays
8) ______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
9) 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
10) 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.
11) In optical disks denoted as CD-R, R stands for ______.
A) recoverable
B) recordable
C) rewritable
D) read-only memory
12) The dot pitch of a CRT monitor refers to the ______.
A) number of pixels in one mm2
B) number of pixels in a unit area
C) distance between the pixels
D) size of its pixels
13) 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
14) 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.
15) 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
16) Which of the following is an example of a vertical market software?
A) Microsoft Office
B) Adobe Acrobat
C) AutoCad
D) Open Office
17) ______is an example of a horizontal market software
A) AutoCad
B) Open Office
C) Goldmine
D) Act!
1