Computer Concepts Final
A bit can represent how many different values? - none - 1 - 2 - 3 - 4
2
ON WORKSHEET If the worksheet is correct, the value of the function =SUM(D5:D8) is - 67 - 1284 - 384 - 336
336
A byte is ____ bit(s). - 1 - 2 - 4 - 8 - 16
8
Describe the properties of a strong password?
A strong password is one that is at least 12-14 characters with capital letters, numbers, and special characters.
ON WORKSHEET The value in cell F9 can be calculated as =SUM(B9:E9) +F5+F6+F7+F8 =SUM(B5:E8) All of the above
All of the above
Which of the following is considered a benefit of using simulation programs? - They allow users to experience potentially dangerous situations without risk - They help to prevent costly errors - They allow users to train on software that is not installed on their systems - All of the above
All of the above
All of the statements below are true about the Digital Divide, except: - There is still a great gap between the levels of Internet access and the availability of technical tools in different regions of the world - Mississippi is negatively affected by the digital divide - Allows the use of all minds on the planet to solve problems - Many projects address the problem of digital divide
Allows the use of all minds on the planet to solve problems
The OS with the largest market share on tablet devices is - Linux - Windows - iOS - Android
Android
All of the following are browsers EXCEPT: Firefox Bing Chrome Safari
Bing
ON WORKSHEET The current active cell is - F9 - 13D - D13 - None of the above
D13
The general name for software used to manage databases is - modeling - structuring - integrating - DBMS
DBMS
T OR F: "What if" analysis is handy for a person planning home finances such as a budget but is of little use to serious businesses
F
T OR F: A query is used to facilitate the entry of data into a database
F
T OR F: A word or phrase in a word prossessing document may be boldfaced, but not an entire paragraph
F
T OR F: Although databases have several advantages, a disadvantage is a tendency to acquire redundant data
F
T OR F: Electronic word processing, spreadsheets and DBMS have eliminated the need for careful planning
F
T OR F: The minimum field width of a social security number expressed as XXX-XX-XXXX must be 15 characters
F
T OR F: What if" analysis is the process of changing only the formulas in a spreadsheet in order to observe the changed calculated results
F
T or F: A gigabyte is approximately 1,000 kilobytes
F
T or F: A potential risk of today's technology is the increased efficiency of business operations
F
T or F: A search engine that searches other search engines is called a SuperSearch engine
F
T or F: First-generation computers were characterized by the transistor
F
T or F: The physical parts of the computer system are referred to as software
F
What should you do if you spot unethical behavior at your work place? - Nothing, as long as the behavior is legal - Report it to the police immediately - Follow company procedures for reporting unethical behavior - Start looking for a new job
Follow company procedures for reporting unethical behavior
Which one of the following statements is NOT true about e-mail? - It is a popular form of communication - It is private - You may attach more than one documents - It is the primary world-wide electronic communication
It is private
Which of the following is ranked from smallest to largest? KB, MB, TB, GB MB, TB, GB, KB GB, KB, MB, TB KB, MB, GB, TB TB, GB, MB, KB
KB, MB, GB, TB
RAM stands for: - Readily Accessible Memory - Randomly Accessible Memory - Read Access and Memorize - Random Access Memory
Random Access Memory
T OR F: A key advantage of databases is integrity, which means the database is accurate and up-to-date
T
T OR F: A key advantage of word processing is that when changes are made to a document, only the changes need to be retyped, as opposed to the entire document
T
T OR F: A label provides descriptive information about entries in the spreadsheet
T
T OR F: A spreadsheet formula may contain one or more functions
T
T OR F: A user may specify a range of cells by highlighting a group that comprises a rectangular shape
T
T OR F: If the items in a word processing list indicate a sequence or a procedure, or if they are going to be referred to individually elsewhere in the text, it is better to number them instead of using bullets
T
T OR F: In an electronic spreadsheet, the value of any cell containing a formula will change if any value in a cell used in the formula changes
T
T OR F: Presentation graphics can appear professionally produced
T
T OR F: The copy/paste command sequence helps reduce keyboard errors
T
T OR F: The main reason businesses use data mining is to understand their customers better
T
T OR F: The manuals that come with packaged software are called documentation
T
T OR F: Word processing is software that lets you create, edit, format and print a text document
T
T or F: A person can truly be addicted to the Internet
T
T or F: A primary benefit of a jump or flash drive is portability
T
T or F: Fourth-generation computers were characterized by the microprocessor
T
T or F: In the URL www.hindscc.edu the top level domain is edu
T
T or F: Input, in computer terminology, is known as data
T
T or F: Many household appliances contain embedded computers
T
T or F: Mauchly and Eckert developed the ENIAC
T
T or F: Multimedia is a common application of computers
T
T or F: There is no universally agreed-on best system of ethics
T
T or F: You can share your favorite sites with others through social bookmarking
T
When shopping online, which of the following does NOT indicate that you have a secure connection displays? - A closed padlock icon in the status bar - The URL begins with https - The word "secure" in the title bar - The VeriSign or BBB seal on the Web page
The word "secure" in the title bar.
ON WORKSHEET From the title (ID) bar, we can tell that - The data is in Sheet 1 - The time is 7:07 P.M - This is a Microsoft Excel workbook named Acme Sales.xlsx - All of the above
This is a Microsoft Excel workbook named Acme Sales.xlsx
Which of the following statements is false? - Individuals who have no sense of right or wrong exhibit amoral behavior. - Ethical decisions are usually influenced by personal ethics. - Unethical behavior is always illegal - Life experience affects an individual's personal ethics
Unethical behavior is always illegal
How can becoming computer literate now help you understand and take advantage of future technologies when you are employed?
When we have some basic knowledge of computers we hold advantage over those that don't. For instance, if someone is applying for a job and he or she is computer literate, the individual has a higher risk of getting the job because most employers want employees that have basic knowledge about computers. Being computer literate also allows us make wise decisions when we are shopping online or trying to protect our computer in a secure manner.
Which of the following companies developed the very first GUI? - Apple - Microsoft - Intel - Xerox
Xerox
You have recently expanded your veterinarian's office and hired two new employees. Your newest employees will appear as knowledgeable as your ten year employees when customers call if you have - your employees take turns answering the phone - trained your employees to use spreadsheet and word processing software - a database for each family with pet name, breed, age, immunization record, etc. available to all employees - all of the above
a database for each family with pet name, breed, age, immunization record, etc. available to all employees
ON WORKSHEET Cell A7 likely contains - a value - a formula - a label - a function
a label
The central processing unit ________. - interprets and executes instructions - does arithmetic and logic operations - communicates with other parts of the computer system - both interprets and executes instructions and does arithmetic and logic operations - all of the above
all of the above
A presentation graphics slide can contain - charts - photographs - tables - all of the above are correct
all of the above are correct
Digital video cameras are used for ________. - sending video signals directly into a computer multimedia applications - desktop video conferencing - both multimedia applications and desktop video conferencing are correct - all of the above are correct
all of the above are correct
The smallest unit of storage in the computer is a ________. - character - word - bit - byte - none of the above is correct
bit
A benefit of using a hard disk as secondary storage is that it has ________. - more portability than a DVD - faster transfer than a DVD - more capacity than a DVD - both faster transfer than a DVD and more capacity than a DVD are correct - all of the above are correct
both faster transfer than a DVD and more capacity than a DVD are correct
In a relational database, the type of field that is used for descriptive data such as names and addresses is - numeric - date - character - logical
character
Images already produced by professional artists for public use are called - clip art - templates - page makeup - block art
clip art
In a relational database, another name for a field is - relation - row - column - operator
column
Information about a coin collection is best kept by using which of the following? - word processing software - spreadsheet software - database software - presentation software
database software
The word processing program predetermines the settings of features automatically unless overridden by a user. The predetermined settings are called - default settings - justification - pagination - headers and footers
default settings
To be processed by a computer, data must be converted to ________. - analog form - digital form - ASCII form - Unicode form - modem form
digital form
Gordon Moore, the Chairman of Intel, predicted in 1965 that the speed of a silicon chip of the same price would - remain the same year after year - triple every two decades - double about every 18 months for at least two decades - triple every year
double about every 18 months for at least two decades
A set of choices that appears, in the manner of a window shade, from the top of a screen is called a - drop-down or pull-down menu - default setting - scroll - template
drop-down or pull-down menu
Making changes to a word processing document to fix errors or improve its content is called - formatting - creating - editing - retrieving
editing
The science of creating work environments that are safe and efficient for workers is known as: - environmentally-sound physical planning - ectonomics - ergonomics - ergocentric
ergonomics
In a relational database, the maximum number of characters or digits in a field is determined by the - operator - field width - model - row
field width
The action of finding and changing each instance of a repeated item is called - find and replace - retrieving - automatic replace - automatic reformatting
find and replace
Augusta Ada King, Countess of Lovelace is often called the ________. - creator of the first computer - inventor of the automatic loom - first computer programmer - human calculator - poet laureate
first computer programmer
The appearance of a document is called its - style - format - font - kerning
format
An instruction to the spreadsheet program to calculate a number is a - label - formula - value - range
formula
Connectivity for a new computer means: - connecting a mouse, a keyboard, and a printer-all essential hardware pieces for the average user - connecting the software to the hardware of the system - allowing a printer to be connected to it - having a modem and/or network connection to communicate with other computers
having a modem and/or network connection to communicate with other computers
When purchasing a new printer the most important factor to consider is - how it is going to be used - color or black and white - memory - initial price and cost of consumables - speed
how it is going to be used
Hard disks for personal computers typically have this amount of storage - tens of megabytes - hundreds of megabytes - tens of gigabytes - hundreds of gigabytes
hundreds of gigabytes
In a relational database, only true or false conditions may be found in the type field known as - numeric - date - character - logical
logical
The circuit board on which the processor and other chips are placed is called the ________. - big board - motherboard - master circuit - connector circuit - system circuit
motherboard
Since products such as Microsoft's PowerPoint can be used to create and display on-screen presentations with animated visual effects and video clips, they are sometimes called - video presentation tools - multimedia presentation tools - animnation graphics - All of the above are correct
multimedia presentation tools
In a relational database, if calculations are to be made with data then the type of field must be - numeric - date - character - logical
numeric
Windows is a(n): - computer system. - piece of application software. - operating system. - type of CPU device
operating system
The sockets on the outside of a computer's system unit where cables are connected to it are called ________. - buses - ports - links - cards - processors
ports
In the URL http://www.hindscc.edu, the portion labeled http is the: - protocol - domain name - top-level domain - host
protocol
In a relational database, another name for a record is a - relation - row - column - operator
row
A user can move the document up and down and thus view any part of the document by - word wrap - reformatting - scrolling - formatting
scrolling
A font, such as Times New Roman, that includes small marks is called - italic - serif - ragged - sans serif
serif
When using the Internet for research, you - can assume that everything you find is accurate and appropriate - should evaluate sites for bias and relevance - can assume the author is an authority on the subject matter - can assume that the links provided on the site are the only additional sources of information
should evaluate sites for bias and relevance
Facebook, MySpace, and Twitter are considered: - podcast Web sites - social networking Web sites - business-to-business Web sites - e-commerce Web sites
social networking Web sites
A program that checks for the correct word spelling is the - page makeup program - spelling checker - thesaurus - template
spelling checker
Another name for a worksheet is a - graph - cell - spreadsheet - function
spreadsheet
A record of personal finances is best maintained by using which of the following? - word processing software - spreadsheet software - data base software - presentation software
spreadsheet software
Software that offers synonyms and antonyms is called a - spelling checker - thesaurus - template - page makeup program
thesaurus
Viruses that activate on certain dates or with the passage of time are known as - boot-sector viruses - script viruses - time bombs - encryption viruses
time bombs
A tall, upright system unit with relatively more expansion slots and bays is known as a(n) : - skyscraper - desktop - tower - iMac
tower
A 2.0 GHz personal computer has a processor capable of handling how many clock (machine) cycles per second? - two thousand - two million - two billion - two hundred million
two billion
If there is not enough room for a word on the current line, the word will automatically be moved to the beginning of the next line using the feature called - scrolling - formatting - automatic reformatting - word wrap
word wrap
The vertical graph line that normally shows amounts such as dollar values is the - label - y-axis - x-axis - title
y-axis
