Computer Basics: Hardware, Software, Databases, and Spreadsheets Quiz

This document is a quiz designed to test fundamental knowledge of computer hardware, software, databases, and spreadsheets. The quiz covers a range of topics, including input and output devices, different types of software (system, application, and utility), and telecommunication devices. It also explores concepts like the internet, the World Wide Web, web sites, and URLs. Additionally, the quiz addresses database fundamentals, including relational databases, entity classes, and the steps involved in database design. Finally, it includes questions on spreadsheet basics, such as lists, column headings, and list definition tables. The answers to all questions are provided, offering a comprehensive review of the subject matter. This assignment is available on Desklib, a platform providing students with AI-based study tools and resources, including past papers and solved assignments.

1. Which of the following are used to enter information and commands in a computer?
Answer) B. Input devices
2. 2. Which of the following types of computer hardware tools allow you to see, hear, or otherwise recognize
the results of your information-processing requests?
Answer) A. Output devices
3. 3. Which of the following hardware tools allows you to send information to and receive it from another
person or location?
Answer) D. Telecommunication device
4. Which of the following enables you to solve specific problems or perform specific tasks?
Answer) A. Application Software
5. Which of the following types of software handles tasks specific to technology management and coordinates
the interaction of all technology devices?
Answer) B. System software
6. Which of the following types of software controls your application software and manages how your hardware
devices work together?
Answer) C. Operating system software
7. Which of the following provides additional functionality to your operating system including anti-virus software?
Answer) D. Utility Software

8. A _____ is really a mobile phone integrated into a handheld computer.
Answer) A. tablet
9. Josh, an investment banker, has to travel frequently on his business. He wants to travel light, and is in search
of a small computing device with a touchscreen, and all the functional capabilities of notebook or desktop
computer. A _____ will be best suited for his purpose.
Answer) C. tablet PC
10. Which of the following distinguishes an e-book reader from a tablet PC?
Answer) D. An e-book reader is designed to be more readable (than a tablet PC) in bright light.
11. Which of the following provides you with a multimedia-based collection of information, services, and Web
sites?
Answer) C. Internet
12. Which of the following represents a vast network of computers that connects millions of people all over the
world?
Answer) A. World Wide Web
13. KeepFit is a manufacturer of sports merchandise. You can visit a specific location on the Web and order
merchandise from KeepFit. This specific location is KeepFit's ____.
Answer) C. Web site
14. Which of the following is the domain name in the URL, http:// www.usatoday.com?
Answer) D. com
15. Technically, a Web site address is called a ____.
Answer) C. URL

16. Which of the following identifies a domain name?
Answer) A. A specific location on the Web where you visit, gather information, and perhaps even order products
17. What is a Web page?
Answer) C. A specific portion of a Web site that deals with a certain topic
18. www.yahoo.com is an example of a ____.
Answer) D. search engine
19. A specific portion of a clothing Web site deals with winter wear. This particular portion of the Web Site is
known as a ____.
Answer) B. Web page
20. The Web site of a leading retailer consists of clickable texts and images that take consumers to other sites or
pages of related merchandise on the Web. These clickable texts and images are ____.
Answer) D. links
21. Relational databases are similar to spreadsheets in that:
Answer) A. you maintain information in two-dimensional files.
22. Which of the following defines a database?
Answer) D. A concept in which you wish to store information and that you can identify with a unique key
23. What is the most popular type of database?

Answer) A. Relational database
24. Which of the following characterizes a relational database?
Answer) D. A logically related two-dimensional table or file of information
25. There are _____ primary steps in designing and building a database.
Answer) A. two
26. _____ are statements concerning the information you need to work with and the relationships within the
information.
Answer) A. Entity classes
27. Why would you define business rules for a database?
Answer) B. To ensure smooth transfer of files containing information
28. An organization wishes to store information about its employees in a database. The employees, in this case,
constitute a(n) ____.
Answer) B. primary key
29. What is the first step in designing and building a database?
Answer) A. Defining entity classes and primary keys
30. Which of the following is true about an entity class?
Answer) C. It represents a group or class of information that sits separately from other information in the
database.

31. What is the intersection of a row and column in a spreadsheet called?
Answer) C. Cell
32. Which spreadsheet term defines a collection of information arranged in columns and rows?
Answer) B. Inventory
33. Which of the following is a characteristic that a list must possess?
Answer) B. The first column in the list must contain the labels or column headings.
34. Which of the following is true of lists?
Answer) C. A list does not require a blank line above it if it starts from the first row.
35. In a list made using spreadsheet software, which of the following would be a label?
Answer) D. An entry made in the last row of the first column.
36. The administration department of a university makes a list of the professors currently employed by the
university (first column), the departments to which they belong (second column), and their ages (last column).
Which of the following entries would most likely be contained in the fourth row of the third column?
Answer) C. 24 August, 1956
37. A company makes a list of its customers using spreadsheet software. It has four columns containing
information on customer id (4-Digit), customer name, date of most recent purchase, and address respectively.
Which of the following represents information stored in the third column of the list?

Answer) D. 7714, 8012, 0212, 1678.
38. Should a spreadsheet list contain any blank rows?
Answer) C. No, blank rows should only surround the list.
39. A _____ is a description of a list by column.
Answer) A. list definition table
40. A list definition table:
Answer) D. describes a list by column.