STUDENT TEST BOOKLET
This test section contains Twenty-four multiple-choice questions. Please mark your answers for the multiple-choice questions in the spaces provided on your Student Response Booklet. Mark only one answer for each question. If you do not know the answer, make your best guess. DO NOT WRITE ANY ANSWERS IN THIS TEST BOOKLET. WHEN YOU FINISH, DO NOT WORK ON ANY OTHER TEST SECTION.1. / At a recent sales meeting the general manager informed all sales representatives that they were expected to design a sales presentation over the best selling vehicle at the dealership. Which of the following programs should the sales representatives use to meet the demands of the general manager?
A. / Microsoft Word
B. / Internet Explorer
C. / Microsoft Excel
D. / Microsoft PowerPoint
2. / Jim is in the process of typing a five-page research paper. The keyboard Jim is using represents which step in the information processing cycle?
A. / Output
B. / Processing
C. / Storage
D. / Input
3. / A computer is a complex machine that has changed in various ways since its invention. Which of the following best defines the word “computer”?
A. / A mobile device that contains a processor and storage
B. / A group of circuits and wires that work independently
C. / A machine that changes information from one form into another form
D. / A device that is very complicated and requires a tremendous amount of knowledge to operate.
4. / Sara is examining her brand new computer that she recently purchased from best buy. She notices the hard drive, the RAM and the processor while taking a look inside her computers case. Which of the following best classifies the computer pieces Sara noticed?
A. / Software
B. / Hardware
C. / Peripheral
D. / Storage
PLEASE GO ON TO THE NEXT PAGE è
5. / Jenny wants a computer system that processes information in the fastest amount of time possible. What computer component should Jenny focus on when searching for a new computer that meets her overall computer demand?A. / RAM
B. / ROM
C. / CD/RW
D. / CPU
6. / Sam removed several components from his computer system. After cleaning and replacing several of the components Sam placed everything back into his machine. After trying to power on his machine Sam realized that the paper he was typing on before he unplugged his computer was gone. Sam realized that he forgot to save his paper and that the paper was only stored temporarily on his computer. Which device stored Sam’s paper while he was typing?
A. / RAM
B. / Hard Drive
C. / CD/RW
D. / CPU
7. / Seth wants to purchase a new computer at Wal-Mart. Seth locates a Dell Optiplex PC for $499 and it is currently being offered at a discount of 25% off. How much will the PC cost Seth when he checks out, assuming KY’s 6% sales tax is applied?
A. / $349.70
B. / $396.71
C. / $402.45
D. / $353.58
8. / Which of the following are the only two values that a computer understands?
A. / 0 & 1
B. / A & B
C. / X & O
D. / Slow & Fast
PLEASE GO ON TO THE NEXT PAGE è
9. / Bill has been asked to place all output devices in closet A at 123 computer shop. Which of the following should not be placed in closet A by Bill?A. / Printer
B. / Scanner
C. / Speakers
D. / Monitor
10. / What is the purpose of the computers Hard Drive?
A. / Store data such as pictures, music and documents
B. / Provide Instructions for all operations to occur
C. / Allow connectivity to the Internet and store temporary files.
D. / Connect all internal components within a computer system
11. / Skyler wants to install a hard drive in his custom PC that will not be impacted by magnetic fields and has no moving parts. What type of hard drive should Skyler purchase?
A. / Solid State Hard Drive
B. / Removable State Hard Drive
C. / Flash State Hard Drive
D. / Portable State Hard Drive
12. / Kerry has been asked to speak to a group of aspiring production agent within the music industry about the differences in CD-R’s and CD-RW’s. Which of the following would be a difference between these two types of media?
A. / CD-RW’s protect all data that is placed on the CD so that it cannot be overwritten
B. / CD-R’s provide an option that allows the person burning a CD to decide on if the data will be permanent or temporary on the CD.
C. / CD-R’s keep data on the CD once it has been burned so that it cannot be erased or changed.
D. / CD-RW’s are more reliable than CD-R’s due to the extra layer of material that they possess.
13. / Al has been asked by his mother to explain some of the basics of a computer system. Currently Al is describing the area where icons can be found, right clicks can be made to adjust settings and the Graphical User Interface is located. This area is commonly called which of the following?
A. / Desktop
B. / Control Panel
C. / Personalization
D. / Accessories Folder
PLEASE GO ON TO THE NEXT PAGE è
14. / When trying to add up several cells that contain currency values within a Microsoft Excel Spreadsheet one would begin the equation to add up the selected cells with what item?A. / +
B. / -
C. / *
D. / =
15. / The Gaming Superstore has been looking at several different spreadsheet programs to use within their business. Which of the following is not a characteristic of a spreadsheet program such as Microsoft Excel?
A. / Utilize cells to separate data
B. / Allow font colors to be modified with features such as color, font style and font type
C. / Allow users to format text documents such as resumes and other business documents
D. / Incorporate multiple math functions that can be inserted with a click of a button
16. / = A1 + B2 + C3 was found within an Excel formula bar. How can this information be best explained?
A. / Excel will add the values found in A1, B2 and C3 together
B. / Excel will copy the values in A1, B2 and C3 into the clipboard for later use
C. / Excel will place the contents of A1, B2 and C3 into the cell in which the user clicks
D. / Excel will ask the user for numerical values for all three cells listed
17. / Which of the following is not an operating system?
A. / Mac OS X
B. / Windows Explorer
C. / Microsoft WIndows
D. / Linux
PLEASE GO ON TO THE NEXT PAGE è
18. / During a recent job skills exam Les found a hard drive, flash drive, compact disk, DVD and an external hard drive. Les was asked to correctly classify these items into an appropriate area of storage devices. Which of the following would be the most accurate selection Les could make?A. / Required Storage
B. / Portable Storage
C. / Temporary Storage
D. / Secondary Storage
19. / Skyler wants to construct a story about his life so far. A story that is about the author is commonly called a(n)______.
A. / Autobiography
B. / Biography
C. / Personal Narrative
D. / Self Analysis
20. / Kermit has been asked to construct a story about his great grandfather that will include the history of his great grandfather from when he was a young boy until the end of his life. Kermit has been asked to construct a(n)______.
A. / Autobiography
B. / Biography
C. / Personal Narrative
D. / Self Analysis
21. / Which of the following is a program in which a Spreadsheet is used to capture data and allow the user to perform various mathematical functions?
A. / Microsoft Word
B. / Internet Explorer
C. / Microsoft Excel
D. / Microsoft PowerPoint
PLEASE GO ON TO THE NEXT PAGE è
Apple's iPad: A Gadget Killer -- or Just Another Gadget?
Published : February 03, 2010 in Knowledge@Wharton
Apple, which brought consumers such hits as the iPod and iPhone, is wading into a new product category with the launch of its iPad, a touch-screen tablet computer that CEO Steve Jobs has said puts "the Internet in your hands" -- and apparently much more.
At a press event on January 27, Jobs unveiled the 1.5 pound tablet computing device with a 9.7 inch screen and built-in Internet connectivity, which will be available for purchase sometime in late March. "We call it the iPad. What this device does is extraordinary," said Jobs. "You can browse the web with it. It's phenomenal. It's way better than a laptop [and] way better than a smartphone."
Jobs positioned the much-hyped iPad as a companion product in Apple's lineup: The device fits between the iPhone and its Macbook laptop, with prices ranging from $499 to $829 depending on options such as the amount of memory and type of wireless connectivity (wi-fi and/or an additional wireless data plan through AT&T). Competitively, the iPad is targeted at netbooks -- popular mini-laptops with screens that measure 10 inches or less -- and tablet-style e-book readers such as Amazon.com's Kindle, Barnes & Noble's nook and Sony's Reader, according to experts at Wharton. In other words, Jobs positioned the iPad as a universal computing device that can play music, movies and video games, show pictures and hold a library of books.
What's unclear is whether consumers will buy into the idea of a universal device that meets all their needs -- or whether the iPad will become just one more gadget to juggle.
Apple's latest device may find a market, but it won't be easy, according to Peter Fader, a Wharton marketing professor. He says that the iPad, like other tablet PCs, has to answer a core question in the consumer's mind: Why do I need one? "Tablets fell into the cracks [in the past] because they couldn't answer that question, and the iPad is the same."
Others doubt whether the iPad packs a big enough technical punch to replace several devices. Wharton legal studies and business ethics professor Andrea Matwyshyn says that the iPad's technical specifications -- notably a 10-hour battery life -- may not enable it to function as a universal device, at least in its first generation, although she expects Apple to improve the product. According to Eric Clemons, an operations and information management professor at Wharton, the device also lacks the storage to replace multiple devices: Whereas the iPad comes in 16, 32 and 64 gigabyte (GB) versions, Apple's high-end iPhone alone offers up to 32GB of storage, and netbooks generally start with 160GB of storage.
In addition, the iPad, which uses the same operating system that powers the iPhone, doesn't support Adobe Systems' Flash software, which is used on many web sites. As a result, web surfing on the iPad may not compare to traditional laptops. Jobs' presentation didn't directly address iPad's lack of support for Flash, but one of the web sites displayed in his demonstration had a blank square where video or animated Flash content would have appeared.
If consumers still need to carry a laptop for Flash-enabled web browsing, a phone for placing calls, and an iPod for storing movies, books and music, "then what exactly do I need the iPad for?" asks Clemons.
That's a question many consumers are likely to ask, say experts at Wharton. "I'm struggling to place the iPad myself. It's not clear how exactly to position this device," says Kartik Hosanagar, an operations and information management professor at Wharton. "Initially, the iPad is a direct competitor to Kindle. But the iPad faces a superset of competitors: The iPhone, Kindle, iPod and the netbook." Although it's not clear how quickly -- or even if -- Apple's device will replace these gadgets, the advent of the iPad "highlights that these devices are converging," he adds.
Use the above article to answer questions 22-24
22. / Which of the following words could replace phenomenal as used in the 2nd paragraph to best convey the impact of the IPAD?A. / Common
B. / Functional
C. / Quicker
D. / Exceptional
23. / Which word best describes the mood the above article creates?
A. / Uncertainty
B. / Positive
C. / Sarcastic
D. / Hostile
24 / Based on the article we can assume that a universal device can be best described as ______.
A. / can work around the world
B. / allows multiple items to be connected
C. / takes the place of multiple devices
D. / works with multiple types of operating systems
25. / Zu was recently given a task using an Excel spreadsheet that contained the following expression:
= B3 * .06
What type of output could Zu expect from the expression contained within the spreadsheet?
A. / The expression will multiply the value B3 by .06
B. / The expression will change the value in cell B3 into a decimal value with two decimal places
C. / The expression will take the values in the first three cells of column B and multiply them by .06
D. / The expression will take the value of cell B3 and multiply it by .06
26. / As the lead auditor at BACK Accounting Bruce has to verify that all functions used are congruent to BACK standards. Bruce is currently checking a spreadsheet where the user is searching for the smallest number in a spreadsheet that contains over 1000 cells of data. What function should Bruce see being used?
A. / SUM
B. / AVERAGE
C. / MAX
D. / MIN
27. / When typing out a business letter a person should utilize the enter key 4 times after typing Sincerely so that……
A. / More information can be inserted into the document if it is needed
B. / Allow the user to sign his/her name
C. / Format the document in modern world layout
D. / Create a sense of spacing at the end of the document.
28. / Which layout should be used when constructing a web page within MS Word?
A. / Print Preview
B. / Web Design
C. / Web layout
D. / Print Layout
29. / The part of the computer system that helps protect the motherboard and other internal hardware within a computer system is commonly called the…….
A. / Hard Drive
B. / CPU
C. / Case
D. / RAM
30. / What is the name of the button used in MS Excel that allows the designer to combine multiple individual cells into one large cell?
A. / Cut
B. / Copy
C. / Print Preview
D. / Merge & Center