T
E
C
H
P
100
Janet is writing a paper on the history of Broadway musicals, and uses information she got from this Web page.
Which of the following should Janet include as part of the full citation in her report?
A.http://www.musicals.net/
B.Web sites do not need to be cited
C.The Resource For Musicals
D.Musicals.Net – Windows Internet Explorer
A.http://www.musicals.net/
100
Joe is trying to catalog all the songs that he has acquired on his computer. He wants to create his own searchable database of all his music. Which of the following is a defined field that he would likely want to include?
A.Fieldname = SongTitle, Field Type = numeric
B.Fieldname = SongTitle, Data Type = text
C.Fieldname = Type, Field Type = date
D.Fieldname = Artist, Field Type = Boolean
B.Fieldname = SongTitle, Data Type = text
100
Using compression techniques with multimedia files can have which of the following consequences?
A.less available storage space
B.need for more network bandwidth
C.reduction in image quality
D.increased options for security
C.reduction in image quality
100
Zach sits down at his computer and turns it on, but nothing happens. No blinking lights appear, and nothing appears on the screen. Which of the following troubleshooting sequences should he try?
A.check that all the cables and power cords are plugged in
B.press the on/off button repeatedly until something happens
C.check that Windows completely up to date
D.open the system, remove the memory and processor, and try again
A.check that all the cables and power cords are plugged in
100
Which of the following terms relates to United States laws governing whether or not an original work, such as a magazine article or piece of art, can be reproduced without consulting its creator?
A.Copyright
B.Online Safety
C.Acceptable Use
D.Uniform Resource Locator
C.Acceptable Use
200
A keyboard and mouse are examples of which of the following?
A.graphics devices
B.storage devices
C.output devices
D.input devices
D.input devices
200
Kasey is writing a history paper on the French Revolution. Which of the following features of her word processing software would help her find another way of saying “rebellion?”
A.Spell Check
B.Headers and Footers
C.Grammar Check
D.Thesaurus
D.Thesaurus
200
en is searching a database for information on nutrition using keyword search terms. Which of the following Boolean operators would he use if he wanted the search to return all records containing all the search terms?
A.And
B.Not
C.And Not
D.Or
A.And
200
Marta enters the names and phone numbers of all the people in her cooking club into a table. What is one thing she can now do with that information?
A.sort the rows into ascending or descending order
B.generate accounts and passwords for each of the people
C.automatically confirm the spelling of all the names
D.include a button bar with each of the members' names
A.sort the rows into ascending or descending order
200
In this database table, FirstName is an example of which of the following?
A.active cell
B.record
C.field
D.row
C.field
300
What is one of the advantages of using a Web site to display a multimedia presentation?
A.It will be viewable from any location with an Internet connection.
B.Text on a Web site is easier to read than on CDs or hard disks.
C.Only Web sites will allow you to use audio and video clips.
D.Data transfer from a Web site is faster than from other storage devices.
A.It will be viewable from any location with an Internet connection.
300
Cable and DSL are examples of which of the following?
A.software applications
B.types of local area networks
C.hardware components of a computer
D.high-speed Internet services
D.high-speed Internet services
300
Which of the following are spreadsheets commonly used for?
A.writing and editing technical manuals and documentation
B.conducting searches of extensive collections of records
C.formatting and displaying documents combining text, graphics, and video
D.making data more readable and understandable using charts/graphs
D.making data more readable and understandable using charts/graphs
300
Which of the following is another term for "highlighting" when using word processing or desktop publishing software?
A.deleting
B.bolding
C.selecting
D.formatting
C.selecting
300
Which of the following best describes a combination of letters, numbers and/or symbols used to provide a means of security when accessing a computer or network account?
A.firewall
B.hacker
C.username
D.password
D.password
400
Nick works for the university as a public relations specialist. In his work, he produces advertising and promotional media such as flyers, magazine and newspaper ads, and posters to hang up around campus. This type of work would best be considered which of the following?
A.database design
B.word processing
C.desktop publishing
D.help desk support
C.desktop publishing
400
Which of the following is most likely the source of data for this pie chart?
A.files stored on a network file server.
B.links from a Web site
C.clip art from a desktop publishing program
D.rows and columns from a spreadsheet
D.rows and columns from a spreadsheet
400
In spreadsheets, a cell reference is also referred to as which of the following?
A.axis
B.cell address
C.active cell
D.entry bar
B.cell address
400
Which of the following activities would spreadsheet software typically be used for?
A.create brochures and flyers
B.develop storyboards for presentations
C.manage large numbers of records
D.organize and analyze financial data
D.organize and analyze financial data
400
Which of the following are the keywords in the above database search?
A.In this category
B.Foods
C.peanuts, crackers
D.Time ending soonest
C.peanuts, crackers
500
Charlene wants to be an accountant. She knows that accountants frequently use spreadsheets. Which of the following would it be most helpful for Charlene to learn about?
A.Web and file servers
B.hyperlinks and hypertext
C.fields and records
D.formulas and functions
D.formulas and functions
500
A multimedia presentation might include which of the following?
A.cell references, home rows
B.rows, columns, tables
C.text, graphics, audio clips
D.records, fields, search boxes
C.text, graphics, audio clips
500
The school secretary at Mountview Junior High is creating a phone directory database of students, staff, and teachers. Which of the following would be the most appropriate fields to define in the new phone list database?
A.Rows, Columns, Column Headings, Cell References
B.Last Name, First Name, Age, Gender
C.Last Name, First Name, Area Code, Phone Number
D.Phone Number, Membership Status, Year, Date
C.Last Name, First Name, Area Code, Phone Number
500
Having too many programs open at the same time can result in which of the following?
Having too many programs open at the same time can result in which of the following?
A.out of memory error message
B.incompatible software error message
C.low disk space error message
D.incompatible hardware error message
A.out of memory error message
500
Which of the following would be the broadest search criteria in a search of an audio CD database?
A.Date = 01/30/2000
B.Artist ¹ "Davis"
C.Keyword = "Jazz"
D.Title = "Nighthawks at the Diner"
C.Keyword = "Jazz"