CS140 Introduction to Computers Review

c

A ________ relies on the server for its processing ability. a. medium client b. terminal c. thin client d. fat client

a

A ________ uses an aggregate function for data that can be grouped by two types of information and displays data in a compact, spreadsheet-like format. a. crosstab query b. select query c. simple select query d. subquery

a

A ________ uses cables, radio waves, or infrared signals to link computers or peripherals, such as printers, within a small geographic area. a. LAN b. WAN c. MAN d. CAN

b

A ________ uses long-distance transmission media, like satellites and leased lines, to link computers separated by a few miles or even thousands of miles. a. LAN b. WAN c. MAN d. CAN

c

A ____________ function is one that automatically updates each time the workbook is opened. a. dynamic b. static c. volatile d. variable

a

A _____________ is a set of unified design elements, such as colors, fonts, and effects that provides a consistent look for your presentation. a. theme b. design c. layout d. format

b

A benefit to modifying a form in Layout view is that you can make changes to the form design and display the _______________ from the underlying table at the same time. a. validation rules b. data c. field descriptions d. field properties

a

A bibliography is called Works Cited in MLA style. a. True b. False

Extended ASCII

A character coding format that uses eight bits and can represent 256 different characters

b

A chart that you create in PowerPoint is stored in a Word table that is incorporated into the PowerPoint file. a. True b. False

Data point

A chart value that originates in a worksheet cell

Transitions gallery

A collection of available transition effects for PowerPoint presentation slides

Documentation

A collection of printed or online material that provides instructions and brief tutorials

Picture Styles gallery

A collection of style formatting options that can be applied to a picture, text, or an object.

field

A column heading

Data marker

A column, bar, area, dot, pie slice, or other symbol in a chart that represents a single data point

a

A command followed by an ellipsis (...) indicates that a dialog box will display if you click the command a. True b. False

Modem

A communication device used to send and receive data from one transmission system to another

wizard

A feature that walks you step by step through a process

b

A fill color refers to either the inside or the outside color of an object on a PowerPoint slide. a. True b. False

a

A formula is an equation that performs mathematical calculations on values in other cells, and places the answer in the cell containing the formula. a. True b. False

c

A gallery of text styles that offer decorative effects, such as shadowed or mirrored text is called ________________. a. TextArt b. ClipArt c. WordArt d. SmartArt

a

A gallery of text styles with decorative effects is called ____________. a. WordArt b. ClipArt c. TextArt d. SmartArt

WordArt

A gallery of text styles with which you can create decorative effects, such as shadowed or mirrored text

Chart

A graphic representation of numeric data.

Backbone

A high capacity transmission line that carries Internet traffic

Laser printer

A high resolution non impact printer that uses an electrostatic reproductive technology similar to that used by copiers

T1 line

A high-bandwidth fiber-optic or specially conditioned copper cable trunk line that can handle 24 digitized voice channels or carry computer data at a rate of up to 1,544 Mbps is a

citation

A note inserted into the text of a report or research paper that refers to a source in the bibliography.

a

A page break indicator displays for manual page breaks. a. True b. False

Intranet

A password-protected network controlled by an organization and accessed only by employees is

b

A picture inserted into a Word document, cannot be resized in Word. a. True b. False

a

A pie chart should be used when you need to show the relationship of each part to a whole. a. True b. False

Bluetooth

A popular short-range wireless radio transmission technology that does not require direct line of sight and enables devices like computers, mobile phones, and printers, within 30 feet of each other to communicate automatically and wirelessly is

a

A prewritten formula that looks at values, performs an operation, and then returns a final value is called a(n) ________________. a. function b. operation c. calculation d. equation

b

A report created using the Report button cannot be modified. a. True b. False

GPS (Global positioning system)

A satellite-based system consisting of a cluster of 27 Earth-orbiting satellites that enable portable receivers to determine their location with an accuracy of 109 yards or less is a

b

A screenshot can easily be inserted into a document by displaying a window or Web site you would like to insert, and then clicking the Screenshot button found on the __________ tab. a. Page Layout b. Insert c. Add-Ins d. View

b

A series of steps that describe what a computer must do to solve a problem or perform a task is a(n) ________. a. system procedure b. algorithm c. function d. scenario

Data series

A set of related data points

referential integrity

A set of rules that Access uses to ensure that the data shared between related tables is valid.

b

A(n) ________ is a wired or wireless WAN network connection point that enables users to access the WAN. a. IP address b. POP c. TCP/IP d. IP

d

A(n) ________ is an Office feature that displays a list of potential results. a. ScreenTip b. Preset color arrow c. option button d. gallery

c

A(n) ________ is an arrangement of information organized into rows and columns. a. cell b. intersection c. table d. presentation

b

A(n) ________ is an image that represents facial expressions and should only be used in informal conversation. a. emotioncon b. emoticon c. snippet d. face icon

b

A(n) ________ is the fundamental unit of storage that enables Windows 7 to distinguish one set of information from another. a. document b. file c. entry d. glossary

d

A(n) ________ is the size of a notebook with a screen that swivels and lies flat over the keyboard. a. desktop b. laptop c. all-in-one d. tablet PC

Insert Above

Adds a row above the current one

a

After a chart is created in Excel, it can be copied and pasted into other applications. a. True b. False

b

After typing an = (equal sign) and the beginning letters of a function name, a list of Excel functions beginning with the letters appears. The feature that allows this is called ______________. a. Formula AutoFill b. Formula AutoComplete c. Formula Find d. Formula Search

c

After your invitation is accepted in LinkedIn, you can click the Contacts menu and then click ________ to see information about your contacts. a. New People b. My Contacts c. My Connections d. My Profile

Pit

An indentation on an optical disk that corresponds to the binary digit 0

Inkjetprinter

An inexpensive non impact printer that produces excellent color output by spraying ionized ink from a series of small jets onto a sheet of paper

a

Animations that bring a slide element onto the screen are known as ____________ effects. a. Entrance b. Graphic c. Slide d. Presentation

d

3-D, which is short for three-dimensional, refers to an image that appears to have all three spatial dimensions including ________. a. length, width, and height b. width, height, and depth c. length, height, and depth d. length, width, and depth

Unicode

A 16-bit character-representation code that can represent more than 65,000 characters.

a

A ________ can either be a desktop PC, a notebook, a netbook, a workstation, or a terminal. a. client b. mainframe c. supercomputer d. minicomputer

a

Any active window on your computer can be pasted into a document as a screenshot. a. True b. False

c

As you type in a cell, when you reach the right border of the cell, wordwrap moves the text _____________. a. to the next cell b. to the clipboard c. to the next line within the cell d. row

Avg

Averages the values in a field

a

Because Office Web Apps use the standard file formats of the desktop version of Office 2010, you will have ________ viewing of documents. a. high-fidelity b. low-resolution c. restricted d. pixelated

b

Because the slide layouts in PowerPoint are not designed to accommodate digital picture files, you must first add a picture placeholder. a. True b. False

b

Between your computer or business network and the Internet backbone are devices called ________. a. network access points b. routers c. network points d. Internet service provider

a

Common fields for related tables may not have the same name, but they must have the same data type and field size. a. True b. False

Tracks

Concentric circular bands on a hard disk or platter where data is recorded

a

Data and objects from one Microsoft Office program can be copied and pasted into a file in another Microsoft Office program. a. True b. False

b

Data can be exported from Access to Excel, but you will not have the option to include the original formatting and layout with the data. a. True b. False

table

Data organized into rows and columns

common fields

Fields that contain the same data in more than one table.

a

Google's operating system that supports many types of mobile devices is called ________. a. Android b. CDMA c. Astrid d. Google Mobile

d

Header text will print at the top of: a. only slide handouts. b. only notes pages. c. only non-title slides. d. slide handouts or notes pages.

sentence

Hold down Ctrl and click anywhere in the sentence

entire document

Hold down Ctrl and then press A.

Tab

If in the last cell of the last row, a new row is added

a

In the address bar, the ________ which is the sequence of folders that lead to the current file or folder location is indicated. a. path b. address c. file d. description

a

In which view would you be able to view the Field Properties area of an Access Table? a. Design view b. Object view c. Navigation pane d. Datasheet view

form header

Information that is printed at the top of the first page.

a

Making Internet data appear to come from one place when it is really coming from another is known as ________. a. Forgery b. Data diddling c. Salami shaving d. Shilling

Internet telephony

Making use of the Internet for real-time voice communication is referred to as

b

Many programs contain millions of lines of computer programming language code. With so many lines of code, _____ are inevitable. a. viruses b. bugs c. frustrated programmers d. frustrated users

b

Margin information is stored in the paragraph mark at the end of a paragraph. a. True b. False

c

Cell content can be one of two things: a. a formula or a calculation. b. a text value or a number value. c. a value or a formula. d. a number value or a date value.

b

Changes cannot be made in the Layout view of a report. a. True b. False

a

Changing a value in a cell to see how the change affects the outcome of a formula is called a what-if analysis. a. True b. False

b

Changing the theme colors changes the overall design of the presentation. a. True b. False

portion of text

Click to position the insertion point at the beginning of the text you want to select, hold down Shift, and then click at the end of the text you want to select.

a

Clicking on the ________ displays sheet tabs that are not in view. a. sheet tab scrolling button b. Name Box c. expand horizontal scroll bar button d. Formula Bar

Artistic effects

Formats applied to images that make pictures resemble sketches or paintings.

a

Formatting with a bullet list or numbered list will add automatic indents. a. True b. False

b

Holding down Shift and pressing Enter adds a new tab stop. a. True b. False

d

How can fields be rearranged in the query design grid? a. Click the Field Order button b. Fields can only be rearranged in Datasheet view. c. Click the Move Tool d. Click and drag method

b

How can you add rows to a table using only the keyboard? a. Press Ctrl + M b. Press Tab from the last cell in the last row c. Press Shift + Enter d. Press Enter

b

How does a decimal tab stop align the text or numbers? a. Text or numbers are left aligned at the tab stop and extend to the right. b. The decimal point aligns at the tab stop. c. Text or numbers are centered around the tab stop. d. Text or numbers are right aligned at the tab stop and extend to the left.

a

The command that joins selected cells into one larger cell and then centers the contents is called _________________. a. Merge & Center b. Group & Center c. Center & Align d. Create & Center

a

Question 2. Excel functions will propose a range if data is _______________ of a selected cell. a. above or to the left b. below or to the left c. below or to the right d. above or to the right

a

RE: is commonly used to mean ________. a. regarding b. receiver c. responding d. replying

Backgroun Removal

Removes unwanted portions of a picture so that the picture does not appear as a self-contained rectangle

record

Represented by a row of information

a

The default alignment for text in a new document is Align Text Left. a. True b. False

a

The default alignment for text values is: a. left alignment. b. justified alignment. c. right alignment. d. center alignment.

a

The default format for a new table includes a black border around each cell. a. True b. False

c

The document needs 2" top, bottom, right, and left margins. Which Margins gallery setting should be selected? a. Normal b. Wide c. Custom Margins d. Office 2003 Default

a

The dotted vertical and horizontal lines that appear in the rulers to indicate a pointer's position are called ruler guides a. True b. False

Zoom

The feature to choose how much of a document, presentation, or worksheet you view on the screen

a

The field in a table that uniquely identifies a record is known as a _____________. a. primary key b. design key c. field index d. table index

foreign key

The field in the related table used to connect to the primary key in another table.

b

The field on the one side of the one-to-many relationship is typically the primary key and the connecting field on the other side of the relationship is typically referred to as a(n) ____________. a. home key b. foreign key c. identifier key d. foreign field

a

The first principle for planning a database is to consider how to organize the data in tables to avoid redundant data. a. True b. False

b

The highlighted date in the ________ and at the top of the appointment area is the date that you are viewing, which is, by default, the current date. a. Time Bar b. Date Navigator c. Work Week view d. Week view

d

The idea of connecting computers of different designs and over distant locations started in the ________. a. 1970s b. 1990s c. 1980s d. 1960s

b

The intersection of a column and a row is referred to as a data box. a. True b. False

b

The intersection of a row and a column in a table creates a box, called a block, into which you can type. a. True b. False

Past link

The key pressed in Excel to cancel an action, such as a copy.

Esc

The key pressed in Word to update linked data from Excel.

Works Cited

The list of sources title when using MLA style

a

The Form Wizard is a good method to use when you want to control how the form looks by selecting the layout and which fields to include. a. True b. False

a

The Help feature displays step-by-step instructions for performing many tasks. a. True b. False

b

The Margins button is located on the View tab. a. True b. False

a

The Message Bar may display an alert when an Access database is opened. a. True b. False

a

The NOW function does not require an argument. a. True b. False

b

The New slide button is an example of a ___________ button. a. group b. split c. selection d. down-arrow

b

The Options dialog box lets the user select nonprogram related settings, such as applying a header and footer style. a. True b. False

a

The Picture Tools Format tab is the Ribbon location for many different ___________ that can be applied to pictures. a. styles b. animations c. transitions d. layouts

Notes pane

The PowerPoint screen element that displays below the Slide pane and provides space to type notes regarding the active slide.

a

The Preview pane button displays the contents of most files without opening the file in a program. a. True b. False

c

The ________ component of Outlook stores your schedule. a. Contacts b. E-mail c. Calendar d. Appointments

c

The ________ describes a unique sequential or random number assigned by Access as each record is entered. a. Yes/No b. Text c. AutoNumber d. Number

a

The ________ displays Microsoft Office Backstage view. a. File tab b. title bar c. navigation pane d. Ribbon

d

The ________ displays a group of task-oriented buttons that contain the commands, styles, and resources you need to work in Outlook. a. File tab b. title bar c. navigation pane d. Ribbon

b

The ________ displays a large image of the active slide. a. Notes pane b. Slide pane c. Slides/Outline pane d. Status bar

c

The ________ displays a list of shortcuts to Outlook's components and folders. a. File tab b. title bar c. navigation pane d. Ribbon

a

The ________ displays below the Slide pane and provides space for you to type information regarding the active slide. a. Notes pane b. Slide pane c. Slides/Outline pane d. Status bar

c

The ________ displays either the presentation in the form of thumbnails or the presentation outline. a. Notes pane b. Slide pane c. Slides/Outline pane d. Status bar

a

The ________ displays in a horizontal bar at the bottom of the presentation window, the current slide number, number of slides in a presentation, theme, View buttons, Zoom slider, and Fit slide to current window button. a. Status bar b. Notes pane c. Slides/Outline pane d. View buttons

b

The ________ displays the name of the program and the program window control buttons. a. File tab b. title bar c. navigation pane d. Ribbon

d

The ________ is an area of the Access window that displays and organizes the objects in a database. a. object window b. field properties c. Data Type d. Navigation Pane

a

The ________ value determines the spacing between tick marks and thus between the gridlines in the plot area. a. major unit b. axis c. interval unit d. minor unit

a

The ___________ of the data bar represents the value in the cell. a. length b. color c. pattern d. height

Layout

The arrangement of elements, such as title and subtitle, lists, pictures, tables, charts, shapes, and movies on a PowerPoint slide

Record Selector bar

The bar at the left of record when it is displayed in a form, and which is used to select an entire record.

c

The cell used to indicate the desired value when using Goal Seek is called the ________ cell. a. Goal b. Argument c. Set d. Parameter

c

The characteristic that defines the type of information that will be entered into a field (such as text, number, or date) is known as a ________. a. column name b. table names c. data type d. row type

a

The columns in a column chart emphasize the distinct values of each data point. a. True b. False

d

________ is an area of the Start menu that displays all the available programs on your computer system. a. Installed Programs b. Programs c. My Programs d. All Programs

c

________ is an inexpensive medium with bandwidth too low to simultaneously carry video, voice, and data. a. Coaxial cable b. Fiber-optic cable c. Twisted pair d. Cat-5

c

________ is one way to transfer files over the Internet, and it is especially useful for transferring files that are too large to send by e-mail. a. B2B b. C2C c. FTP d. VoIP

d

________ is the ability to hear or see content while it is being downloaded from a Web site instead of waiting until the download is complete. a. Bandwidth b. Throughput c. Broadband d. Streaming

b

________ is the actual amount of data that is transmitted. a. Bandwidth b. Throughput c. Broadband d. Streaming

a

________ is the conflict that occurs when two computers try to access the LAN at the same time. a. contention b. chipset c. hub d. terminator

d

________ is the field in the related table used to connect to the primary key in another table. a. Subdatasheet b. A join key c. Referential integrity key d. A foreign key

a

________ is the largest of the social networking sites and useful to keep in touch with friends and family, post photos, share links, and distribute information with people you identify as friends. a. Facebook b. LinkedIn c. MySpace d. Twitter

b

________ is the modification of data by altering accounts or database records so that it is difficult or impossible to tell that the accounts have stolen funds or equipment. a. Forgery b. Data diddling c. Salami shaving d. Shilling

c

________ is the process of arranging data in a specific order based on the value in a field. a. Referential integrity b. Joining c. Sorting d. Filtering

a

________ is the real-time communication between two or more participants over the Internet. a. Instant messaging b. tMessaging c. iMessaging d. Text messaging

c

________ style is the default print setting; it prints the text of the selected items one at a time. a. Print b. Table c. Memo d. Standard

d

________ technology uses a GPS-enabled chip to pinpoint the location of a cell phone. a. Cell site b. Convergence c. Digitization d. Location awareness

a

________ view displays the data as columns and rows similar to the format of an Excel worksheet. a. Datasheet b. Data Type c. Field Properties d. Design

d

________ view displays the structure of the table's fields. a. Datasheet b. Data type c. Field properties d. Design

b

___________ allows you to set how text flows around a graphic. a. Graphic wrapping b. Text wrapping c. Image wrapping d. Paragraph wrapping

Backstage view

a centralized space for tasks related to file management

relative cell reference

a changeable reference relative to a cell in a worksheet

Column chart

a chart type that can have two or more data series

data marker

a column, bar, area, dot, pie slice or other symbol in a chart that represents a single data point

chart layout

a combination of chart elements, including a title, legend, labels for the columns, and the table of charted cells

Codec

a compression/decompression algorithm

Absolute cell reference

a fixed reference to a cell in a worksheet

chart

a graphic representation of data in a worksheet

Text box

a moveable, resizable container for text or graphics

value axis

a numerical scale on which the charted data is based

Bus topology

a physical layout of a network where every device is attached to a common cable or pathway

Travel Mouse

a pointing device that is is half the size of a normal mouse, but with all the same capabilities is

Theme

a predesigned set of colors, fonts, lines, and fill effects that look good together and can be applied to an entire document or to specific items

Plotter

a printer that produces high quality output by physically moving ink pens over the surface of the paper

Plug-in

a program downloaded from a web site that extends the ability of your web browser to enable multimedia features

Standalone program

a program purchased and installed separately that functions independently and is fully self-contained

Video Editor

a program that enables you to modify digitized videos

Font

a set of characters with the same design and shape

data series

a set of related data points

Bevel

a shape effect that uses shading and shadows to make the edges of a shape appear to be curved or angled

Integrated program

a single program that manages an entire business or set of related tasks

USB flash drive

a solid-state portable storage device that is also refered to as jump drive or memory stick is

Office Clipboard

a temporary storage area for text or graphics that you select and then cut or copy

Clustered Column

a type of 2-D Column Chart

Racetrack

a type of memory that uses the spin of electrons to store information is

Space after paragraphs

common technique used to distinguish paragraphs

label control

control on a form or report that contains descriptive information, usually a field name.

Format Painter

copies the formatting of specific text or of a paragraph and applies it to other locations in your document

Single line spacing

default line spacing in Microsoft Word 2010

Metadata

details about a file that describe or identify it

Info tab

displays information about the current file

=

equal to

Registers

fast temporary storage areas located only within a microprocessor

>

greater than

<=

greater than or equal to

>=

greater than or equal to

Toggle Button

is turned on by clicking it once, and then turned off by clicking it again.

ROM

memory located on the motherboard in which essential start-up instructions are prerecorded and that does not erase when the system is switched off

Alignment

refers to placement of paragraph text relative to the right and left margins

Cycle

shows a continual process

Hierachy

shows a decision tree or displays an organizational chart

Matrix

shows how parts relate to a whole

List

shows non-sequential information

Pyramid

shows proportional relationships with the largest component on the top or bottom

Process

shows steps in a process or timeline

Packaged software

software purchased off the shelf for the needs of the general public including the basic home and business user

Modules

the functions offered by an integrated program that share the same interface, enable you to switch among them quickly and are not available as standalone programs

category lables

the labels that display along the bottom of the chart to identify the category of data

chart style

the overall visual look of a chart in terms of its graphic effects, colors, and backgrounds such as flat or beveled columns, colors, backgrounds

Virtual memory

the portion of a hard disk that the operating system treats like RAM when RAM is full is

Shareware

the term that refers to a "try before buying" program

Sparkline

tiny charts embedded in a cell to give a visual trend summary alongside your data

data source

Objects from which a query selects its data

d

Often ________ e-commerce involves the use of an intermediate site, such as the popular online auction destination eBay. a. B2C b. C2B c. B2B d. C2C

d

One method of reducing the space a file takes up on your disk is called file ________. a. extract b. shorten c. archive d. compression

safe

One method to help troubleshoot a start-up problem is to start Windows in ________ mode.

a

One of the most important utility software packages for any computer connected to the Internet is ________. a. antivirus software b. accessories software c. backup software d. an Internet browser

a

One step you should take to keep your operating system current is to enable ________. a. automatic system updates b. an off-site storage area c. troubleshooting d. an uninterruptable power supply

Soft copy

Output displayed on a monitor or played through speakers

c

Press [Alt]+[Ctrl]+[Delete] to access the Windows ________. a. processor b. print function c. Task Manager d. shut-down sequence

Find button

Produces a dialog box to search for data

d

Program instructions and data are divided into fixed sized units called ________. a. packets b. blocks c. batches d. pages

b

Saving a query saves the design of the query and the records retrieved; therefore, each time the query is opened, the same record results will always display. a. True b. False

Center tab

Text in all lines except the first line in the paragraph indents

Hanging Indent

Text in the first line of a paragraph indents.

First Line Indent

Text is centered around the tab stop.

Decimal tab

Text is right aligned at the tab stop and extends to the left

a

Text surrounded by brackets is called a ________. a. content control b. text control c. template control d. placeholder text

a

The Americans with Disabilities Act of ________ mandated that both public and private entities provide computer access to individuals with disabilities. a. 1990 b. 1980 c. 1987 d. 1997

b

The AutoFit Contents option means that the table row height will adjust in size but the column width will remain fixed. a. True b. False

b

The COUNTIF function has three arguments—the range of cells to check, the criteria, and the value to return if the criteria is not found. a. True b. False

b

The Clip Art task pane includes several options for research results not limited to Illustrations. Which other check box options are available? a. SmartArt, Videos, and WordArt b. Pictures, Objects, and WordArt c. Documents, Photographs, and Shapes d. Photographs, Videos, and Audios

a

The Excel feature that fills in the remaining characters for you when you begin typing in a cell is called: a. AutoComplete. b. AutoFill. c. AutoCheck. d. AutoType.

c

The Linux operating system called ________ was released to promote One Laptop per Child. a. Linux Devine b. All-in-one c. Sugar d. Free for all

c

The MLA style uses ________-inch indents at the beginning of the first line of every paragraph. a. 1.00 b. 0.75 c. 0.50 d. 0.25

b

The Report Header will display information at the top of every page. a. True b. False

a

The Show Table dialog box can be moved to view the tables more easily as they are added to the Relationships window. a. True b. False

a

The Simple Query Wizard allows you to create a title for your query before the query is displayed. a. True b. False

a

The Summary Options button displays in the Report Wizard if the data is grouped and contains numerical data. a. True b. False

c

The U.S. Department of Defense and a project called ________ had the initial idea of connecting computers of different designs and over distant locations. a. EDUNET b. MILNET c. ARPANET d. INET

b

The Windows Explorer program navigates the Internet. a. True b. False

1993

The World Wide Web was not viable to the general public until ________.

c

The ________ allows you to control the look of the presentation window with a set of commands. a. Notes pane b. Status bar c. View button d. Slides/Outline pane

a

The ________ component of Outlook is your e-mail address book for storing information about people, organizations, and businesses with whom you communicate. a. Contacts b. Appointments c. Calendar d. E-mail

a

The ________ displays on the right, in which you can preview an e-mail message without actually opening it. a. Reading Pane b. Calendar c. Navigation Pane d. Inbox

c

The ________ displays one-hour time increments. a. Date Navigator b. Work Week view c. Time Bar d. Week view

a

The ________ displays the current document in its own window with the viewing and editing menus from the Web App, but without the toolbars and tabs from the browser. a. Pop-Out b. Pop-Up c. Pull-Up d. Pull-Out

a

The ________ handles the addressing scheme embedded within each packet transmitted over the Internet, enabling each packet to reach the correct destination. a. IP address b. POP c. TCP/IP d. IP

b

The ________ icon in the record selector box indicates that a record is being entered or edited. a. arrow b. pencil c. crossbar d. check mark

b

The ________ is a Windows Vista and Windows 7 application with which you can capture all or part of a screen. a. Cropping Tool b. Snipping Tool c. Snapping Tool d. Clipping Tool

a

The ________ is a formatting mark that displays each time you press Enter. a. paragraph symbol b. space character c. line break symbol d. tab symbol

c

The ________ is a free file storage and file sharing service. a. Windows Live ThumbDrive b. Windows Live FlashDrive c. Windows Live SkyDrive d. Windows Live JumpDrive

c

The ________ is the area below the Ribbon that displays information such as security alerts when there is potentially unsafe, active content in an Office document that you open. a. Access Trust Center b. Navigation Pane c. Message Bar d. Security Warning

a

The ________ is the characteristic that defines the kind of data that you can type in a field, such as numbers, text, or dates. a. Data Type b. Navigation Pane c. field properties d. object window

a

The ________ is the extension following the host name and indicates the type of group or institution to which the site belongs. a. top-level domain b. host name c. domain name registration d. domain name

a

The ________ is the main high-speed routes through which data travels. a. Internet backbone b. routers c. network access point d. network service provider

b

The ________ is the way in which the parts of the e-mail address are put together. a. pattern b. syntax c. method d. structure

a

The ________ is usually the name of the group or institution hosting the site. a. host name b. domain name registration c. top-level domain d. domain nam

c

The ________ topology is ideal for office buildings, computer labs, and WANs. a. ring b. bus c. star d. network

Hot swapping

The ability to connect and disconnect devices without shutting down your computer is referred to as

Streaming

The ability to hear or see content while it is being downloaded from a Web site instead of waiting till the download is complete

Internet TV

The ability to view television shows, videos, and movies over the Internet, for no additional cost, via download or streaming video is

Throughput

The actual amount of data that is transmitted through a given communication channel

c

The chart type commonly used when there is only one data series to plot is a _________________. a. bar chart b. line chart c. pie chart d. column chart

Right tab

The decimal point aligns at the tab stop

b

The default style of a footnote is the same as the style required for MLA footnotes. a. True b. False

b

The default width of a column is ________ pixels. a. 32 b. 64 c. 128 d. 16

b

The first principle of good database design is to organize data in the tables so that ________ does not occur. a. normalization b. redundant data c. a flat database d. a common field

d

The function used to find a middle value in a group of data. a. MAX b. SUM c. AVERAGE d. MEDIAN

c

The group of options that control when animated items display are known as ____________ options. a. Order b. Sequence c. Timing d. Threading

join line

The line joining two tables

d

The lower edge of the PC desktop screen displays a ________. a. status bar b. menu bar c. command bar d. taskbar

Convergence

The merging of disparate objects or ideas and even people into new combinations and efficiencies

one-to-many

The most common type of relationship

a

The most popular Internet service is ________. a. e-mail b. watching videos c. using search engines d. downloading music

b

The only way to select all of a table is to drag through each row. a. True b. False

a

The option to change the color of a worksheet tab can be found by right-clicking on the tab and selecting a color from the Tab Color menu option. a. True b. False

Tab order

The order in which the insertion point moves from one field to the next when you press the Tab key.

d

The original Macintosh operating system called Mac OS was released in: a. 1974 b. 1980 c. 1985 d. 1984

Star topology

The physical layout of a network that uses a central wiring device to which all devices are connected

Ring topology

The physical layout of a network where devices are attached in a circular wiring arrangement

Sectors

The pie-shaped divisions of a track on a hard disk or platter

b

The pointer shape that indicates you can draw a shape is called the ____________ pointer. a. pencil b. crosshair c. arrow d. drawing

a

The two most commonly used personal computers are categorized by their operating system, either ________. a. Windows or Mac b. Windows or Linux c. Mac or IBM d. Dell or IBM

b

To determine the percentage of a value to a total, you must multiply the value by the total. a. True b. False

d

To display multiple lines of text within a cell, you can use the _____________ command. a. Center Align b. Merge & Center c. Align left d. Wrap Text

c

To enable a printer to keep up with the amount of data sent to it by the computer, a ________ program is used. a. print accelerator b. multitasking c. spooling d. switching

b

To ensure that programs run quickly, operating systems use the computer's RAM as a(n) ________. a. command enhancer b. buffer c. accelerator d. quick access system

d

To export data from Access into Excel, Access offers export options on the ______________ Tab. a. Copy Data b. Transfer Data c. Excel Data d. External Data

b

To export data from Access, you must first open the Access database and select the data from a table to copy it for exporting. a. True b. False

a

To go to a particular Web site on the Internet you must type the ________ in the Internet address bar. a. URL (Universal Resource Locator) b. connection locator c. site name d. routeB

b

To group objects together, hold down the _______ key and click each additional object that you want to select. a. Ctrl b. Shift c. Tab d. Alt

c

To insert a digital picture on a slide, click on the _____________ button in the picture placeholder on the slide. a. Insert Text b. Insert Media c. Insert Picture from File d. Insert Design Element

b

To insert slides from an existing presentation into the current presentation, use the _________ option from the Slide layout gallery after you click the New Slide button arrow. a. Copy a Slide b. Reuse Slides c. Search for a Slide d. Insert a Slide copy

c

To make a video match the presentation theme colors, you can choose to _____________ a video. a. reformat b. redesign c. recolor d. reset

d

To remove an irregular shaped area, you can surround the area with _____________ marks. a. removal b. alteration c. erasure d. deletion

b

To select a nonadjacent range, select the first range, hold down the Shift key, and then select the second range. a. True b. False

b

To select a portion of the text, click to position the insertion point at the beginning of the text you want to select, hold down ________, and then click at the end of the text you want to select. a. [Alt]+[Shift] b. [Shift] c. [Ctrl]+[Shift] d. [Ctrl]+[Alt]

Sum

Totals the values in a field

paragraph

Triple-click anywhere in the paragraph

b

Use an OR condition when you want to display the records that meet ALL of the specified criteria. a. True b. False

a

Using the comparison operator criteria statement "between 2/1/2010 and 2/28/2010" will find dates in February. a. True b. False

b

Values & Number Formatting is a gallery option found on the shortcut menu called ___________. a. Paste Function b. Paste Special c. Paste Key d. Paste Choices

a

Very popular in recent years. a. Bluetooth b. Microwaves c. Radio transmission d. WiFi

b

Visual or sound effects added to individual objects or text on a slide are referred to as _____________. a. visualizations b. animations c. transitions d. mechanizations

c

Web sites and their associated images and scripts are housed on ________. a. hard drives b. external hard drives c. Web servers d. Web routers

b

What does a blue wavy line mean if it appears in your document? a. A blue wavy line is the same as a red wavy line but in a different color theme. b. A wavy blue line means there may be a common usage error. c. A blue wavy line is the same as a green wavy line but in a different color theme. d. A blue wavy line means there is a spelling error.

c

What does a folder contain? a. Word pad b. Memory c. Help features d. Files

c

What does it mean to merge cells? a. The selected cell increases in height. b. The selected cells become a new subtable. c. The selected cells become one large cell. d. The selected cell is split into two new cells.

b

What does the Slide pane display? a. An icon of the active slide b. A large image of the active slide c. A tiled image of the active slide d. A miniature image of the active slide

a

What does the intersection of a column and row in an Excel worksheet create? a. Cell reference b. Cell size c. Cell borders d. Cell format

c

What does the zoom slider do? a. It changes the size of an inserted image. b. It changes the page orientation. c. It changes the size of the viewing area. d. It can be used in full-screen reading.

a

When a table is printed, the name of the table and the date it is printed display at the top of the page. a. True b. False

b

When a value is changed on a Detail sheet, the Summary sheet must be refreshed to update the Summary sheet formula. a. True b. False

c

When charting data, typically you should not include __________. a. column headings b. row headings c. totals d. nonadjacent columns

d

When working with SmartArt Graphic types, a ________ includes pictures in the layout to communicate messages and ideas. a. Relationship b. Matrix c. Pyramid d. Picture

c

Which of the following is not true when finding and replacing text? a. The Replace command can be found in the Editing group of the Home tab. b. The Replace command enables you to locate all occurrences of specified text and replace it with alternative text. c. The Replace command is the easiest way to change the appearance of the text, layout, and design of a slide. d. A message box will display indicating the number of replacements that were made.

d

Which of the following is not true when formatting data as you type? a. You can format numbers as you type them. b. When you type numbers in a format that Excel recognizes, Excel automatically applies that format to the cell. c. Once formats are applied, cell formats remain with the cell, even if the cell contents are deleted. d. Numeric formats are the only formats that can be applied as you type.

c

Which of the following is not true when formatting objects? a. Use the Shape Styles gallery to apply predefined combinations of these fill and line colors and also to apply other effects. b. You can apply styles and effects to clip art, shapes, and text boxes to complement slide backgrounds and colors. c. Changing the inside text color is a distinctive and best way to format a shape. d. The fill color is the inside color of text or of an object.

a

Which of the following is not true when identifying good database design? a. Understand that the purpose of a database is to store the information in a manner that makes it easy for you to get the data you need by asking questions. b. When organizing the fields of information in your database, break each piece of information into its smallest useful part. c. Taking the time to plan and create a database that is well designed will ensure that you can retrieve meaningful information from the database. d. Determine the information you want to keep track of.

a

Which of the following is not used for Boolean searches? a. BUT b. OR c. AND d. NOT

c

Windows and Macs are equipped with ________ capabilities to allow different devices to automatically be recognized by the system. a. library modules b. special nodes c. plug-and-play d. device recognition

c

Windows dominates the market for operating systems at about ________ percent. a. 65 b. 75 c. 85 d. 90

b

With the Photographs check box selected, PowerPoint will search for images that were created in black and white. a. True b. False

c

________ is the transformation of data such as voice, text, graphics, audio, and video into digital form. a. Cell site b. Convergence c. Digitization d. Location awareness

d

________ is the use of a secret operative, on Internet auction sites, who bids on another seller's item to drive up the price. a. Forgery b. Data diddling c. Salami shaving d. Shilling

c

________ of Office Web Apps is free, and requires only a Windows Live ID and a computer with an Internet connection and supported browser software. a. Business use b. Open license use c. Personal use d. Institutional use

a

________ of Office Web Apps requires a SharePoint site with appropriate software and a SharePoint user ID. a. Business use b. Nonprofit use c. Open license use d. Personal use

d

________ provides templates and tools to help you plan and create your site without hiring a Web designer. a. SharePoint b. Skype c. LinkedIn d. Squarespace

c

________ serve as a placeholder for one or more unknown characters in the criteria. a. Primary keys b. Foreign keys c. Wildcard characters d. Conditions

a

________ software controls all devices and operations completed by a computer. a. System b. Program c. Application d. Major

Gigabyte

a unit of measurement for computer memory and disk capacity approximately equal to one billion bytes

Megabyte

a unit of measurement for computer memory and disk capacity approximately equal to one million bytes

data point

a value originating in a worksheet cell

data point

a value that appears in a that originates in a worksheet cell

Rotate

change the view of a pie chart within 360 degrees of its circle

Quick Commands

close Backstage view and either open a dialog box or close a file

Double line spacing

college research papers and draft documents that need space for notes

Relationship

illustrates connections

data series

is a group of related data points

<

less than

<>

not equal to

Explode

pull out a slice of a pie chart for emphasis

Custom software

software designed for specialized fields or businesses and that is tailor-made to suit their exact needs

Freeware

software given away for no charge but with the restriction that you cannot resell it for profit.

Chart area

the entire chart and all its elements

Plug-and-Play

the set of standards that detects the brand, model, and characteristics of a device when you plug it in and configure the system accordingly is

$ (dollar sign)

the symbol that displays to indicate an absolute cell reference

Parallel processing

the technique that uses more than one processor to run two or more portions of a program at the same time is

c

Similar to outlines, PowerPoint presentation text is organized by ________________. a. content categories b. headings c. list levels d. theme styles

Peer 2 Peer network

Skype is an example of a

a

SmartArt __________ are combinations of formatting effects that you can apply to SmartArt graphics. a. Styles b. Effects c. Themes d. Designs

b

SmartArt graphics can be pasted into Word, but not into Excel. a. True b. False

b

SmartArt graphics cannot be modified. a. True b. False

database management system

Software that controls how related collections of data are stored, organized, retrieved, and secured

Image editors

Sophisticated versions of graphic programs used to edit and create images and save them in a variety of file formats

Hard copy

Output viewed in printed form

c

Over time, your disk drive tends to develop small areas scattered across its surfaces. The way to fix this problem is to use a ________. a. disk segment cleaner b. reorganizer c. disk defragmentation utility d. disk copier utility

b

Page numbers displayed in a header must be manually inserted for each page. a. True b. False

Decrease List Level Button

Promotes the bullet point on a PowerPoint slide

b

A defined set of formatting characteristics is called a ______________. a. cell format b. cell style c. cell design d. cell theme

b

Information stored in a computer's RAM is ________. a. permanent b. temporary c. non-volatile d. slower than secondary memory

a

Queries can create calculated values that are stored in a(n) ________. a. calculated field b. condition c. expression d. wildcard character

b

The Footer gallery is located on the ________ tab. a. Home b. Insert c. Page Layout d. View

b

To change the properties for an entire document, you would click Show Document Panel in the View tab. a. True b. False

d

To change the view of a chart, you can __________ it within the 360 degree circle. a. spin b. drag c. flip d. rotate

c

When Task Manager is visible, select the ________ tab to view a list of processes running. a. People b. Programs c. Processes d. Procedures

a

When a black slide displays, this indicates that the presentation is finished. a. True b. False

d

Which of the following signs do all formulas begin with? a. Single quotation ' b. Left parenthesis ( c. Forward slash / d. Equal sign =

c

A ____ can access the server for data but does its own processing. a. minicomputer b. thin client c. fat client d. medium client

a

A _____ meets your individual computing needs or, when connected to a network, enables you to communicate PC and collaborate with others. a. PC b. subnotebook c. tablet PC

d

A ________ analysis tool that is included with Excel is Goal Seek. a. where-to b. what-now c. how-to d. what-if

d

A ________ are related data points represented by data markers. a. data trends b. data lines c. data groups d. data series

b

A ________ can compromise the security of your data because it is easy to guess. a. strong password b. weak password c. CAPTCHA d. bot

d

A ________ can find bad sectors on your hard drive and block access to them. a. repair program b. search utility c. disk cleanup utility d. disk scanning program

c

A ________ can propagate over a computer network and does not require an unsuspecting individual to open a file or execute a program or macro. a. logic bomb b. virus c. worm d. time bomb

b

A ________ is a communication device that sends and receives data from one transmission system to another. a. network interface card b. modem c. chipset d. hub

Holographic

A 3-D approach to portable storage that will enable much higher-density storage capacities and promoted for its backup capabilities is called

a

A PDF file ___________. a. cannot be easily changed b. works only with Apple computers c. cannot be printed d. can be opened with Microsoft Word

F9

A Paste Special option button that allows you to paste Excel data as a linked object.

Slide pane

A PowerPoint screen element that displays a large image of the active slide.

b

A ScreenTip suggests actions you can take. a. True b. False

a

A Slides/Outline pane displays either the presentation in the form of miniature images (Slides Tab) or the presentation outline (Outline tab). a. True b. False

c

A ________ is a database object that displays the fields and records from a table or a query in an easy-to-read format suitable for printing. a. filter b. query c. report d. table

c

A ________ is a database object that retrieves specific data from one or more database objects. a. table b. report c. query d. form

c

A ________ is a group of two or more computer systems linked together to exchange data and share an Internet connection and resources. a. node b. chipset c. network d. communication device

d

A ________ is a hidden piece of computer code set to go off on some date and time in the future usually causing a malicious act to occur to your system. a. logic bomb b. virus c. worm d. time bomb

a

A ________ is a horizontal group of cells in a worksheet. a. row b. column c. column heading d. row heading

d

A ________ is a movable, resizable container for text or graphics. a. border b. SmartArt graphic c. shape d. text box

c

A ________ is a movable, resizable container for text or graphics. a. chart area b. data points c. text box d. legend

c

A ________ is a set of standards or rules implemented by hardware, software, or a combination of the two. a. switch b. packet c. protocol d. token

b

A ________ is a simple, inexpensive device that joins multiple computers together in a single network but does not manage the traffic between the connections, which usually results in frequent collisions. a. network interface card b. hub c. modem d. chipset

c

A ________ is an Access object with which you can enter data, edit data, or display data. a. query b. filter c. form d. report

c

A ________ is an inexpensive input/output device consisting of a keyboard and video display with little processing capability. a. client b. thin client c. terminal d. fat client

b

A ________ is attached to program files, like an Excel spreadsheet, and spread to other programs or files on your hard disk when the file is opened. a. logic bomb b. virus c. worm d. time bomb

a

A ________ is hidden computer code that does not replicate but sits dormant on your system until a certain event or set of circumstances triggers it into action. a. logic bomb b. virus c. worm d. time bomb

c

A ________ links a city or town. a. LAN b. WAN c. MAN d. CAN

d

A ________ links a college campus or business park. a. LAN b. WAN c. MAN d. CAN

c

A ________ program is a program that is edited to subtract a very small amount of money from thousands of accounts, such as two cents daily, and divert it to an embezzler's account. a. Forgery b. Data diddling c. Salami shaving d. Shilling

a

A ________ system utility helps you keep your hard drive organized and efficient. a. file manager b. disk organizer c. system manager d. disk indexer

b

A ________ topology is practical in a relatively small environment such as a home or small office. a. ring b. bus c. star d. network

a

A ________ topology is well-suited for use within a division of a company or on one floor of a multifloor office building. a. ring b. bus c. star d. network

a

A ________ uses a combination of uppercase letters, lowercase letters, numbers, and special characters. a. strong password b. weak password c. CAPTCHA d. bot

Text box control

A bound control

Placeholder

A box on a slide with dotted or hatch-marked borders that holds text or other content

Coaxial cable

A broadband data transmission medium that carries data at transfer rates of 10 Mbps and consists of a center copper wire surrounded by insulation which is then surrounded by a layer of braided wire is

a

A bullet can be customized by changing its style, color, and size. a. True b. False

New (blank) record button

A button in the navigation area of a form that creates a new blank form to enter data.

a

A calculated control contains an expression that uses one or more fields from an underlying table or query. a. True b. False

b

A column break is the same as a page break. a. True b. False

a

A column chart is useful for illustrating comparisons among a group of related numbers a. True b. False

Lossless

A compression technique that allows a file to be completely restored without any flaws

Lossy

A compression technique that permanently removes some data from the file.

Unbound control

A control that does not have a source of data.

Bound control

A control that retrieves its source data from an underlying table or query.

a

A crosstab query summarizes a large amount of data in a small space so that it is easy to read. a. True b. False

a

A data ________ is a value that originates in a worksheet cell. a. point b. group c. marker d. series

b

A data source list cannot be changed in the Mail Merge Wizard. a. True b. False

report

A database object that displays the fields and records from a table or a query in an easy-to-read format suitable for printing.

query

A database object that retrieves specific data from one or more database objects.

b

A database template contains only a pre-built table. a. True b. False

Switch

A device that assists in passing data packets along in a single network, condenses bandwidth, and contains software that inspects the source and target of a data package and attempts to deliver it to that destination.

Paste special

A dialog box in Word that allows you to link Excel data into a Word document.

b

A domain name is the ________ name of the recipient's mail server. a. last b. host c. group d. user

Animation painter

A feature that copies animation settings from one object to another

b

A label mail merge only allows the option of typing names and addresses into a Word table. a. True b. False

a

A legend is unnecessary for a pie chart when you display the category names within the corresponding pie slices. a. True b. False

a

A line chart is best used when you want to display _________. a. trends over time b. comparisons among categories c. comparisons to a whole d. distance from a starting point

property sheet

A list of characteristics for controls on a form or report

field list

A list of the field names in a table

c

A major disadvantage of ________ is susceptibility to noise and interference. a. Bluetooth b. microwaves c. radio transmission d. WiFi

Router

A more complex network device that intellectually manages a network and has the ability to determine the best path to route data

Drop Down Rectangle

A name of a specific formatting option style found in the Picture Styles gallery.

Doors

A name of a specific type of transition found in the Transition gallery.

PAN

A network created among an individual's own personal devices, usually within a range of 32 feet and that involves wireless technology is a

output device

A printer is classified as a(n) ________. a. system device b. processing device c. output device d. integral part of every computer

d

A query is useful because it creates a ________ of records according to your specifications and then displays only those records. a. design grid b. subquery c. subdatasheet d. subset

Insert Tab

A range of cells in Excel that have been selected and defined as an independent table

a

A reference to a specific cell in a worksheet consists of the letter of the cell's column followed by the number of the cell's row (Example: A1). a. True b. False

b

A right tab stop aligns text with the right margin. a. True b. False

Category lable

A row heading that displays along the bottom of the chart to identify the category of data

Hub

A simple, inexpensive device that joins multiple computers together in a single network but does not manage the traffic between the connections.

b

A single media file, including art, sound, animation, or movie is called a ____________. a. graphic b. clip c. animation d. art

a

A slide background fill variation that combines theme colors in different intensities or patterns is known as a _______________. a. background style b. background design c. background pattern d. background format

c

A table with three rows and four columns has been inserted into a document. Which of the following is the default alignment for the table? a. Left aligned with fixed one inch column widths b. Center aligned with fixed one inch column widths c. Fills the width of the page to fit between the margins d. Right aligned with fixed one inch column widths

Multiplexing

A technique used to send more than one call over a single line.

a

A template includes content control text you do not wish to use. What should you do with the content control placeholder? a. Right-click the control and click Remove Content Control. b. Drag the content control text to a margin area. c. Ignore the unused content control. d. Left click the content control and click Delete on the Insert tab.

a

A template may be used multiple times without any change to the template document itself. a. True b. False

b

A text box is used when you want a fixed box for text that cannot be moved. a. True b. False

b

A theme is a collection of formatting options that can be applied to a picture, text, or an object. a. True b. False

b

A threat to the use of instant messaging is a phenomenon known as ________. a. spamming b. spimming c. phishing d. e-mailing

Bullet button

A toggle button, enabling you to turn the bullet symbol on and off

d

A type of computer operating system user interface that is commonly used today is ________. a. command line b. voice command c. menu driven d. graphical (GUI)

d

A utility that is handy for people with poor eyesight is called a(n) ________ utility. a. enlarger b. enhancer c. binocular d. magnifier

Bar tab

A vertical bar displays at the tab stop.

Reading view

A view that displays a presentation in a manner similar to a slide show but the taskbar, title bar, and status bar remain available in the presentation window.

c

A(n) ____ combines the system unit and monitor into one. a. desktop b. laptop c. all-in-one d. tablet PC

b

A(n) ________ can be any type of computer file that is included with an e-mail message. a. domain b. e-mail attachment c. e-mail address d. Internet services

a

A(n) ________ consists of a system unit that is about the size of a printer with an independent monitor and keyboard. a. desktop b. laptop c. all-in-one d. tablet PC

d

A(n) ________ includes discontinuous pulses in which the presence or absence of electronic pulses is represented by 1s and 0s. a. ADC b. DAC c. analog signal d. digital signal

a

A(n) ________ is 32 bits long, written in decimal, and has four parts that are separated by periods such as 128.25 4.108.7. a. IP address b. POP c. TCP/IP d. IP

c

A(n) ________ is a calendar activity occurring at a specific time and day that does not require inviting people or reservations. a. e-mail b. contacts c. appointment d. calendar event

d

A(n) ________ is a collection of information that tells Windows 7 what files and folders the account holder can access, what changes the account holder can make to the computer system, and what the account holder's personal preferences are. a. e-mail account b. user profile c. Outlook account d. user account

b

A(n) ________ is a company that provides access to the Internet. a. Internet access provider b. Internet service provider c. network service provider d. online service provider

d

A(n) ________ is a for-profit firm that provides a proprietary network and offers special services that are available only to subscribers. a. Internet access provider b. Internet service provider c. network service provider d. online service provider

b

A(n) ________ is a microchip that contains the circuitry to convert a digital signal to analog. a. ADC b. DAC c. analog signal d. digital signal

a

A(n) ________ is a microchip that contains the circuitry to convert an analog signal into a digital signal. a. ADC b. DAC c. analog signal d. digital signal

b

A(n) ________ is a set of instructions that a computer uses to accomplish a task, such as word processing. a. file b. program c. icon d. command

c

A(n) ________ operating system works in conjunction with other networked computers. a. standalone b. specialized c. server d. embedded

b

AT&T is an example of a(n) ________. a. network access point b. network service provider c. Internet backbone d. routers

form

An Access object with which you can enter data, edit data, or display data from a table or a query

a

An Emphasis effect can only be applied to an entrance effect. An Emphasis effect is an animation that emphasizes an object or text that is already displayed. a. True b. False

c

An Excel ________ shows the relationship of each part to a whole. a. column chart b. bar chart c. pie chart d. line chart

b

An Exit effect applies only to the end of a presentation. a. True b. False

a

An ________ is a line that serves as a frame of reference for measurement. a. axis b. plot area c. category axis d. value axis

Entrance effect

An animation that brings a slide element onto the screen

a

An entrance effect can be modified by using the animation Effect Options command. a. True b. False

b

An operating system available at no cost is the ________ operating system. a. Unix b. Linux c. Windows d. Snow Leopard

On Click

An option that begins the animation sequence for the selected slide element when the mouse button is clicked or the Spacebar is pressed

c

Before printing a table or report, it's best to use ____________ to verify how the data will print, view if it will appear as expected, and check how many pages will print. a. Database Tools b. Design View c. Print Preview d. Navigation Pane

b

Before you can close a database, you must save each object in the database. a. True b. False

b

Bevel is a shape effect that makes the edges of a shape appear to be flat. a. True b. False

c

Both Excel and Access can have database tables. Only Access can _______ information in multiple tables. a. manage b. export c. relate d. import

a

Bullets can be created within a cell of a table. a. True b. False

a

Business letters follow a standard format and contain the name and address of the person receiving the letter, also known as a(n) ________. a. inside address b. salutation c. complimentary closing d. body

a

By default the first field in a table created using the Blank database command is designated as the primary key field. a. True b. False

b

By default, a template opens as a template file so it can be modified before using the template to create a new document. a. True b. False

b

Calculated fields are fields created and stored in the database table. a. True b. False

d

Calculations that are performed on a group of records are called ________. a. expressions b. conditions c. calculated fields d. aggregate functions

b

Clicking the Print button while a form is displayed causes _________ to print. a. only the current record b. separate pages for all of the records in the form layout c. continuous pages for all records in the form layout d. continuous pages for all records in the Datasheet View

CTRL + Tab

Combines two or more cells into one cell.

b

Complaints of Web crimes increased by 22.3 percent between 2008 and 2009 but decreased by ________ percent between 2009 and 2010. a. 8.6 b. 9.9 c. 12.4 d. 10.2

a

Compound criteria use logical operators to display records that _______. a. meet conditions in one or more fields b. meet conditions in only multiple fields c. meet conditions in only one field d. appear only in calculated fields

data source

Contains information including the names and addresses of the individuals for whom the labels are being created

main document

Contains the text or formatting that remains constant

a

Contention sometimes results in ________, the corruption of network data caused when two computers transmit simultaneously. a. collisions b. chipsets c. topologies d. terminators

Timing Options

Control when animated items display in the animation sequence

View buttons

Controls the look of the presentation window with a set of commands

Duration

Controls the speed of an animation

b

Copying or reusing a query is not good database design. a. True b. False

Count

Counts the number of records in a field

bibliography

Created at the end of a document to list the sources referred to in the document.

d

Credit sources referred to as ________ are placed at the bottom of the page. a. citations b. endnotes c. pages d. footnotes

b

Criteria are __________ that help to identify specific records. a. fields b. conditions c. foreign keys d. data types

b

Data sorted in descending order is the same as data sorted from A to Z or lowest to highest number. a. True b. False

information

Data that is organized in a useful manner.

a

Deleting a record in a form, deletes that same record in the underlying table. a. True b. False

a

Design view does not display the data with the structure of the form. a. True b. False

b

Digitization enables ________, a term that refers to the merging of disparate objects or ideas and even people into new combinations and efficiencies. a. cell site b. convergence c. digitization d. location awareness

Worksheet grid area

Displays the columns and rows that intersect to form the worksheet's cells.

Status Bar

Displays the current cell mode, page number, worksheet information, view and zoom buttons, and common calculations for numerical data.

Name Box

Displays the name of the selected object or cell.

Formula bar

Displays the value or formula contained in the active cell and permits entry or editing.

a

Document Properties are searchable items. a. True b. False

word

Double-click the word

c

Each field name used in a(n) ________ must be enclosed within its own pair of square brackets, and the new field name must be followed by a colon. a. calculated field b. condition c. expression d. wildcard character

b

Edits you make in the Outline pane are displayed in the Slide pane after you click the update button. a. True b. False

b

Endnotes are placed at the bottom of the page just like a footnote. a. True b. False

c

Exporting Access data into another program helps to save time and________. a. increases the difficulty level to the work flow b. deletes files from your hard drive c. reduces the number of errors d. formats data with attractive styles

data

Facts about people, events, things, or ideas related to a specific topic or purpose.

a

Filtered Access data will show only the records you specified as filter criteria. a. True b. False

a

For basic text-formatting changes, such as changing the size, font, style, or font color, you must use commands from all except the ________. a. Chart Tools Ribbon b. Basic formatting can be changed from any of these locations. c. Mini toolbar d. Home tab

c

For what reason would you want to use the Font dialog box? a. It is the best way to multiple changes in font. b. There's no good reason to use the font dialog box. c. It provides font options that are not available on the Ribbon. d. It is the best way to select font theme colors.

Sheet tabs

Identify the worksheets in a workbook.

b

If a SmartArt graphic does not have enough shapes to illustrate a concept, you need to copy and paste additional shapes. a. True b. False

b

If a column does not end where you want it to, you can end the column at a location of your choice by inserting a manual ________. a. section break b. column break c. paragraph d. page break

b

If a presentation contains a large number of slides, a _____________ will appear to the right of the slide thumbnails. a. select b. scroll box c. select box d. down-arrow

a

If a slide contains a single bullet point, it may be more preferable to format it as a single paragraph without a bullet symbol. a. True b. False

a

If the Match case box is checked, Find will not find Correct if correct has been placed in the search box. a. True b. False

c

If the background theme graphics interfere with the slide content for a particular slide, you can always ______ the background graphics. a. format out b. delete c. hide d. disguise

a

If the year is left off when entering a date in Excel, the current year is assumed, but does not display in the cell. a. True b. False

a

If there are two or more user ________ on the computer start-up screen, click on your own and sign in. a. Icons b. Workspaces c. Names d. Areas

c

If you are contacting someone who does not have a Skype account, then you are prompted to ________ to join Skype. a. send a letter b. send a text message c. send an e-mail invitation d. call the individual

d

If you are creating a personal Web site, you might consider using your ________ or an arrangement that includes part of it. a. e-mail address b. log in c. password d. name

a

If you assign different user names for each user of your computer, the operating system creates a special ________ for each user. a. profile b. network c. disk drive d. email account

a

If you change the value in a cell that is referenced in a formula, the formula will re-calculate automatically. a. True b. False

a

If you click Computer on the right of the Navigation Pane, a list of ________ devices contained within or attached to your computer will display. a. storage b. external c. software d. hardware

d

If you decide you don't like the changes you have made to a slide background, you can use the _______________ feature to restore the original theme and color theme formatting to a slide. a. Original Slide Background b. Reset Slide Theme c. Remove Slide Background d. Reset Slide Background

c

If you have messages in your inbox, the contents of the ________ message display in the Reading Pane when you open Outlook. a. bottom b. saved c. first d. last

b

If you need to calculate weather predictions, you would use a ___. a. netbook b. supercomputer c. minicomputer d. mainframe

a

If you use the Paste Special option to link an Excel chart into a Word document, changes made in the Excel workbook will also be updated and shown in the chart contained in the Word document. a. True b. False

a

If you want all the slices of a pie chart to explode for emphasis, you can select the exploded pie chart type. a. True b. False

a

If you wanted to process large amounts of scientific data and identify underlying patterns, you would use a _____. a. supercomputer b. netbook c. minicomputer d. mainframe

d

If you work in situations that need to handle 4 to 200 clients, you would use a ________. a. supercomputer b. mainframe c. netbook d. minicomputer

d

If your computer is ________ Outlook's default setting is to send messages immediately when you click the Send button in the Message form. a. offline b. wired c. disconnected d. online

a

If your computer is ________ messages are stored in the Outbox. a. offline b. wired c. online d. connected

a

In 1971, AT&T built a network of transmitters, called ________, that automatically repeat signals. a. cell site b. convergence c. digitization d. location awareness

b

In Excel, _______ displays when a column is not wide enough to display an entire number. a. ... b. ### c. ??? d. $$$

b

In Excel, each workbook contains only one worksheet. a. True b. False

d

In Excel, the what-if analysis tool to use for finding the input needed for one cell to arrive at the desired result in another cell is called ____________. a. Goal Find b. Goal Value c. Goal Analysis d. Goal Seek

b

In Excel, when you create a table from a range of data cells, a subsequent sort will include all the rows and columns in the worksheet, not just in the table. a. True b. False

a

In Excel, you can drag the fill handle of a cell to fill adjacent cells with values based on the content of the first cell. a. True b. False

c

In Excel, you can group worksheets to enter a footer into two worksheets at a time, by pressing the ________ key while selecting the worksheets before inserting the footer. a. Home b. Alt c. Ctrl d. Esc

b

In PowerPoint, the Convert to SmartArt button is found on the Page Layout tab in the Paragraph group. a. True b. False

b

In PowerPoint, to convert a list of bullets into a SmartArt Graphic, click on one of the bullets in the list, and then click on the Convert to SmartArt button found on the ______________ tab. a. Design tab b. Home tab c. Page Layout tab d. Insert tab

a

In a PowerPoint presentation, a set of coordinating colors applied to the backgrounds, objects, and text are known as theme colors. a. True b. False

c

In a cell in an existing table, which of the following happens when you press Enter? a. Pressing Enter takes you outside of the table b. Pressing Enter moves you one cell to the right c. Pressing Enter creates a new paragraph within the cell d. Pressing Enter creates a new row

b

In a chart, the area bounded by the axes, including all the data series, is known as the ________________. a. data area b. plot area c. series area d. category area

a

In a command line operating system , the command copy C:\myfile.txt F:\myfile.txt will copy ________. a. myfile from disk C to disk F b. myfile from disk F to disk C c. everything on disk C to disk F d. nothing

a

In a line chart, the lines emphasize the flow from one data point value to the next. a. True b. False

c

In a new Word document, the default font is Calibri and the default font size is ________. a. 9 b. 10 c. 11 d. 12

d

In a new Word document, the default view is ________ view, which displays the page borders and displays the document as it will appear when printed. a. Full Screen Reading b. Outline c. Web Layout d. Print Layout

Congestion

In a packet switching network, a performance interruption that occurs when a segment of the network experiences an overload

b

In a presentation, you can only apply one type of transition for all slides. a. True b. False

b

In one method used to insert a footer in a Word document, you first click on the _______________ Tab. a. Home b. Insert c. Format d. Page Layout

the U S government

In the 1980s, only large universities and ________ were able to access the Internet including e-mail.

a

In the General number format, numbers display exactly as you type them but trailing zeros do not display, even if typed. a. True b. False

c

In the Inbox pane, the ________ for an e-mail that has not yet been read or opened displays in bold, and the icon at the left shows a closed envelope. a. sender's name b. e-mail heading c. message header d. question mark

c

In the Inbox, a small ________ displays under the date of the message indicating that the message has an attachment. a. question mark b. exclamation point c. paper clip icon d. envelop icon

a

In the MLA style, if the reference occurs at the end of a sentence, the ________ reference always displays to the left of the punctuation mark that ends the sentence. a. parenthetical b. explanatory c. descriptive d. bracketed

b

In the Mail Merge process in Word, merge fields are used as ___________ in the Word document. a. salutations b. placeholders c. form fields d. greetings

b

In the Trim Video dialog box, a clock displays to control the duration of the video. a. True b. False

source

Includes the name of the author, the full title of the work, the year of publication, and other publication information.

a

Initially, records entered into an Access table will display in the order in which they are entered. a. True b. False

c

Internet data can travel over any type of WAN because of Internet protocols. Collectively the Internet protocols are called ________. a. IP address b. POP c. TCP/IP d. IP

a

It is common practice to add one space at the end of sentence punctuation. a. True b. False

a

It's always a good idea to examine your report in Print Preview to ensure the data will appear in the report as anticipated. a. True b. False

d

Large ________ computers process transactions such as airline reservations, bank transactions, or registrations for students at a college. a. minicomputer b. terminal c. supercomputer d. mainframe

d

Lines, arrows, stars, banners, ovals, and rectangles are examples of ______________ in PowerPoint. a. graphics b. drawings c. designs d. shapes

d

LinkedIn ________ enable you to follow influential people and join areas of interest. a. Answers b. Professionals c. User Guides d. Groups

a

List levels are represented by bullets. a. True b. False

b

Live Preview is a name for the gallery of choices for paste options. a. True b. False

d

Located above the Backstage tab, the ________ display(s) for quick access to their commands. a. Backstage Commands b. Metadata c. Stage Commands d. Quick Commands

Max

Locates the largest value in a field

Min

Locates the smallest value in a field

b

Options to add borders or shading to a paragraph can be found on the ___________tab in the _________ group. a. Home, Font b. Home, Paragraph c. Insert, Text d. Page Layout, Paragraph

b

Many search engines that support Boolean operators allow you to use parentheses to place one search string inside of another, a process called ________. a. searching b. nesting c. querying d. operating

Workbook-level buttons

Minimizes, closes, or restores the previous size of the displayed workbook.

a

Modifying the background color or inserting a picture on the slide background are ways to customize a slide. a. True b. False

relational database

Multiple collections of data in the database related to one another.

b

New objects cannot be created in a database designed from a template. a. True b. False

b

Newsletters on letter-size paper in portrait orientation are frequently formatted with four or more columns. a. True b. False

b

Outlook displays a ________ box indicating that you are permanently deleting all the items in the Deleted Items folder. a. FYI b. warning c. confirmation d. important message

c

Outlook displays a message box if you do not enter a ________ for an e-mail message before clicking Send. a. Outlook does not display a message box before clicking send. b. Bcc address c. Subject d. Cc address

RAM

Non permanent memory, located on the motherboard, whose contents are erased when the computer's power is switched off.

b

Normalization is _______. a. consistency in data entry b. the process of applying design rules and principles c. redundant data processing systems d. data joined by a common field

b

On startup, PowerPoint displays a new blank presentation with two slides: a title slide and a content slide. a. True b. False

b

On the first page of a MLA style research paper, the first line typed is the report _________. a. report title b. author c. professor d. page number

d

On the task bar at the bottom of the desktop screen, click the ________ button to display the Libraries window. a. Libraries b. Display c. Folder2 d. Windows Explorer

b

Once a document is formatted for printing, what type of lines display to indicate where the pages would break in Normal view? a. Solid b. Dashed c. Dotted d. Crossed

b

Once a file is named, you cannot use the file as a starting point with a changed file name. a. True b. False

b

Populating a table is the same as changing its structure. a. True b. False

one character at a time

Position the insertion point to the left of the first character, hold down Shift and press the Left Arrow or Right Arrow keys as many times as desired.

a

PowerPoint 2010 offers video editing features to enable a video to fade in and out during the presentation a. True b. False

a

Press the ________ to complete the process of entering a formula. a. Enter key b. down arrow c. tab d. spacebar

d

Squarespace converts writing styles into ________ so you do not have to learn code to build Web content on your site. a. XHTML b. XML c. WYSIWYG d. HTML

c

Starting more than one application at a time is known as ________. a. workload increase b. loading foreground c. multitasking d. convergence

b

Tab order in a form refers to the sort order of the records in the table. a. True b. False

record

Table row

a

Text can be added to a document without retyping by using the Text from File option. a. True b. False

a

Text can be placed into a table from another file. a. True b. False

b

Text cannot be added to a shape graphic. a. True b. False

a

The Field dialog box, found on the Quick Parts button, can be used to place fields in a footer. a. True b. False

d

The Find and Replace feature searches the cells in a worksheet for specified data, then replaces each match with ___________________. a. bolded text b. highlighted text c. a replacement value from the thesaurus d. a replacement value of your choice

a

The First Line Indent button located on the ruler can be used to adjust the size of the indent. a. True b. False

a

The primary difference with ________ e-commerce and shopping at a physical store is that it is not place or time specific. a. B2C b. C2B c. B2B d. C2C

b

The primary function of the ________ is to connect the microprocessor to all other components of the computer. a. network interface card b. chipset c. modem d. hub

Contention

The problem that occurs when two computers try to access the LAN at the same time

Formatting

The process of changing the appearance of the text, layout, or design of a slide

b

The purpose of a database is only to store data. a. True b. False

a

The purpose of the Toggle Filter button alternates between applying and removing a filter. a. True b. False

c

The representation of a value from a worksheet cell on a chart is called a(n) ________________. a. data point b. absolute cell reference c. data marker d. legend

d

The result of the NOW function is formatted as _______________. a. general b. text c. numeric d. date and time

a

The right side of the Taskbar is known as the ________ area and is sometimes referred to as the system tray. a. notification b. message c. active program d. trouble

c

The second part of a complete URL specifies the Web site's ________, which correlates to the Web server's IP address. a. host name b. top-level domain c. domain name d. domain name registration

d

The second part of the e-mail address is the ________. a. server b. user name c. e-mail server d. domain name

c

The second principle of good database design is to use techniques that ensure ________ occurs when it is entered into the table. a. a common field b. redundant data c. normalization d. a flat database

a

The size of a field can be set in Datasheet view. a. True b. False

a

The status bar of the Task Manager provides information about the ________ and memory usage. a. CPU b. disk drive c. printer d. input/output

c

The symbols used to specify the type of calculation you want to perform in a formula are called ___________. a. summations b. divisors c. operators d. calculators

Design tab

The tab in Access where data in Office programs can be selected for import or export by using the buttons in the Import & Link group or the Export group.

Excel Table

The tab in Excel used to create a Total Row via the Total Row check box in the Table Style Options group.

External Data Tab

The tab in Excel used to define a table via the Table button in the Tables group.

c

The tables of information in a relational database are linked or joined to one another by a ________ field. a. redundant b. relationship c. common d. data

Pipelining

The technique, used in CPU's built with superscalar architecture, that feeds a new instruction into the CPU at every step of the processing cycle so that four or more instructions are worked on simultaneously is

a

The techniques used to edit text are similar in all Microsoft Office applications. a. True b. False

b

The term percentage rate of increase refers to the percent by which one number decreases over another number. a. True b. False

b

The terms folders and files are really different names for the same thing. a. True b. False

Bandwidth

The theoretical maximum amount of data that can be transmitted through a given communications channel at one time.

a

The three options for beginning the animation on a selected slide element are On Click, With Previous, and After Previous. a. True b. False

a

The title is the first level on an individual slide. a. True b. False

b

The title of a table typically spans all of the columns. To create a cell that permits you to do this, select the desired cell and click the ________ button. a. Combine Cells b. Merge Cells c. Insert Title Cell d. Insert New Row

Form tool

The tool that creates a form with a single mouse click

Physical address

The unique numeric identifies built into the hardware of each device on a network is its

d

The use of information technologies to corrupt or destroy an enemy's information and industrial infrastructure is called ________. a. pod slurp b. digital divide c. electronic warfare d. information warfare

a

There are a variety of slide transitions from which you choose that allow you to control the _____________ and __________ with which the slides advance. a. speed, method b. speed, design c. design, flow d. direction, method

d

There are two parts to an e-mail address, with each part separated by ________. a. # b. * c. & d. @

d

There was a 63 percent increase in ________ users in the fourth quarter of 2009. a. CMOS b. CD-ROM c. DVD d. VOD

d

Three-dimensional refers to an image that appears to have length, width, and __________. a. altitude b. breadth c. angles d. depth

b

Through a process called ________, individuals and organizations register a unique domain name with a service organization such as InterNIC, and are assigned a unique IP address that will be associated with that domain name. a. host name b. domain name registration c. top-level domain d. domain name

d

To ________ refers to highlighting areas of text or data or graphics so that they can be edited, formatted, copied, or moved. a. file b. double-click c. group d. select

a

To append records from an Excel worksheet to an existing database table, the field names must be identical. a. True b. False

b

To change a bulleted list to a numbered list, you must first remove the bulleted list format, and then apply the numbered list format. a. True b. False

b

To convert a bulleted list into SmartArt, click anywhere in the bulleted list placeholder, then click the Convert to SmartArt button on the ________ tab. a. Format b. Home c. Design d. Insert

b

To copy a file from one folder to another, first locate the folder and file you want to copy, click ________, and then click the folder where you want the copy to be located. a. Start b. Send to c. Apply d. Go

c

To copy an Excel chart, be sure to click on the _____________ of the chart. a. title b. category labels c. border d. data range

a

To copy animation settings from one object to another, you can use the __________ Painter. a. Animation b. Format c. Design d. Copy

b

To create a chart in Excel, select the ___________ for the chart. a. category labels b. range c. location d. type

b

To create a page border, use the Page Borders button found on the __________ tab. a. Home b. Page Layout c. Insert d. View

a

To create another line in the same cell of a table, you would press the _______ key. a. Enter b. Alt + Tab c. Alt d. Tab

a

To delete a worksheet in a workbook, right-click on the sheet tab, then select Delete on the shortcut menu. a. True b. False

b

To modify information on your Squarespace site, ________ mode must be active. a. WYSIWYG b. Content c. Edit d. Revise

b

To select all the worksheets in a workbook, you must select the tabs one at a time, then click on the Group button in the Selection group on the Home tab. a. True b. False

a

To sort on more than one field in a query, the fields should be displayed in a ______________ order in Design view. a. left to right b. right to left c. columns then rows d. top to bottom

d

To use Windows Live programs and services, you must create a ________. a. Platform account b. Windows Web page c. Windows platform d. Windows Live ID

b

To use an Access file as a data source for a Word mail merge, you must first retype the Access data into the Word document so it can be used by the Mail Merge Wizard in Word. a. True b. False

c

To view additional bullet styles from the Bullets and Numbering dialog box, click on the _________ button. a. Gallery b. More c. Customize d. View

a

Use the New from Existing button to open a copy of a selected document. a. True b. False

Merge Cells

Uses tab stops to move within a table cell

b

Using Web servers on the Internet to store files and run applications is referred to as ________. a. SharePoint computing b. cloud computing c. Web computing d. standard computing

a

Using the ________ style allows you to format a letter as outlined in business communications texts. a. No Spacing b. Bullet c. Business d. Numbered Bullet

d

What effect will high resolution have on the display of your Ribbon? a. More items on the status bar b. Less screen glare c. More file handling options d. More items and button names visible

a

What is a dialog box? a. Includes options for adjusting settings b. Lists keyboard short cuts c. Formats backgrounds d. Provides a method to ask questions when problems arise

d

What is the primary task of an operating system? a. Rename files b. Reset operating passwords c. Operate the processing system d. Store and organize your files and folders

c

When a business uses the Internet to provide another business with the materials, services, or supplies it needs to conduct its operations, they are engaging in ________ e-commerce. a. B2C b. C2B c. B2B d. C2C

b

When a picture is applied to a slide background using the Format Background option, you can move or resize the picture. a. True b. False

a

When a placeholder border is a dotted line, this means: a. you can make editing changes to the placeholder text. b. you are going to move the placeholder. c. you are going to delete the placeholder. d. all of the text is selected for editing.

a

When a query retrieves specific data from one or more tables, it is displayed as a portion of the total records available. The portion is called a _________. a. subset b. partial set c. query set d. relational set

c

When a table has been created, what new tabs appear on the ribbon? a. Format and Arrange b. Row and Column c. Design and Layout d. No new tabs are created

a

When a worksheet is just a little too large to fit on a printed page, you can scale the worksheet to make it fit on the page. a. True b. False

c

When adding text to a SmartArt graphic, you can either type directly in the SmartArt graphic or type in a(n) _____________. a. Access table b. Word table c. Text Pane d. SmartArt dialog box

d

When communication occurs between devices, the ________ accepts the transmission and responds. a. analog signal b. communications channel c. sending device d. receiving device

a

When communication occurs between devices, the ________ initiates the transmission. a. sending device b. analog signal c. communications channel d. receiving device

c

When data is filtered in an Excel table, a small ________ icon appears to indicate that a filter is applied. a. pencil b. check c. funnel d. sort

d

When one task uses its ________ or is interrupted by a task of higher priority, the task is suspended and the other task starts. a. CPA b. RAM c. buffer d. time slice

b

When opening an attachment, Outlook may display a dialog box to remind you that attachments might contain ________. a. a document that you cannot view on your computer b. viruses c. photos d. a document that has been sent to other recipients

a

When should the Print Preview option be used? a. Use Print Preview during document creation and before printing. b. There is no reason to use Print Preview. c. All typing should be done in Print Preview. d. Only use Print Preview if you think there may be a problem.

a

When sorting a query in Design view, fields with a Sort designation are sorted ________. a. from left to right b. by the foreign key c. You cannot sort fields in Design view d. from right to left

b

When text is too long to fit into a cell, Excel will automatically wrap the text. a. True b. False

d

When typing a formula in Excel, you use ___________ to control the order in which the mathematical operations will calculate. a. semicolons b. periods c. commas d. parenthesis

c

When using Skype, a(n) ________ indicator next to your name shows that you are online. a. blue b. red c. green d. yellow

a

When using WordArt, you can insert a new WordArt object or you can customize existing text by using WordArt formatting. a. True b. False

b

When using the Form Wizard, you are limited to the fields from one table only. a. True b. False

d

When using the Mail Merge Wizard, you can create a data source, or if you already have the data in an existing __________, you do not need to type the data again. a. Chart b. WordArt c. Control Field d. database

c

When using the Ribbon Clip Art command rather than the content placeholder Clip Art button, the result will be an image inserted: a. on the left side of the slide. b. at the center of the placeholder. c. in the center of the slide. d. on the right side of the slide.

a

When using the Trim Video dialog box, moving the end marker to the left __________. a. trims the portion of the video that follows the marker b. trims the portion of the video that precedes the marker c. lengthens the duration of the video d. decreases the compression settings for the video

a

When working with SmartArt Graphic types, a ________ illustrates connections. a. Relationship b. Matrix c. Pyramid d. Picture

c

When working with SmartArt Graphic types, a ________ shows a continual process. a. List b. Process c. Cycle d. Hierarchy

d

When working with SmartArt Graphic types, a ________ shows a decision tree or displays an organization chart. a. List b. Process c. Cycle d. Hierarchy

b

When working with SmartArt Graphic types, a ________ shows how parts relate to a whole. a. Relationship b. Matrix c. Pyramid d. Picture

a

When working with SmartArt Graphic types, a ________ shows non-sequential information. a. List b. Process c. Cycle d. Hierarchy

c

When working with SmartArt Graphic types, a ________ shows proportional relationships with the largest component on the top or bottom. a. Relationship b. Matrix c. Pyramid d. Picture

b

When working with SmartArt Graphic types, a ________ shows steps in a process or timeline. a. List b. Process c. Cycle d. Hierarchy

b

When writing an e-mail, you can move the insertion point from one box to another in the header area either by clicking in the box or by pressing ________. a. [Ctrl]+[Alt]+[Tab] b. [Tab] c. [Ctrl] d. [Alt]

a

When you are finished sorting, filtering, and totaling a table, you can convert the table into a normal _______. a. range b. workbook c. theme d. style

d

When you browse a Web page for the first time, a copy of the page is stored on your hard drive in a storage space referred to as ________. a. history b. favorites c. bookmarks d. cache

a

When you click the Form tool, the results will be an instant form in a simple ______________ layout with all the fields displayed in a single column. a. top-to-bottom b. descending order c. alphabetical order d. right-to-left

a

When you display the colors gallery, the top row contains the colors associated with the presentation theme. a. True b. False

b

When you edit the value of a cell included in a chart data series, you must manually refresh the chart to show the change a. True b. False

a

When you export Access data to Excel, you are creating a __________________ of the data in the Excel worksheet. a. copy b. pasted special link c. dynamic link d. static link

c

When you have linked Excel data into a Word document, a(n) _______________ displays when you open the Word document again. a. Update Notice b. Refresh Notice c. Security Notice d. Link Notice

b

When you insert a USB flash drive into one of the USB ports, the ________ program automatically runs. a. USB reader b. AutoPlay c. Windows Explorer d. disk cleaner

a

When you modify linked data, it is automatically updated in the destination file. a. True b. False

b

When you move a formula, the cell references in the formula will change if they are relative references. a. True b. False

b

When you paste Excel data into a Word document, Word automatically defaults to create a link to the Excel data. a. True b. False

b

When you point to an image in the Clip Art pane, a ScreenTip displays the creator of the image. a. True b. False

c

When you see a _______ between two cell references, this indicates a range that includes all the cells between the two cell references. a. comma (,) b. period (.) c. colon (:) d. semi-colon (;)

b

When you select a range of cells that make up a table, you should exclude the header row. a. True b. False

a

When you select a slide in Slide Sorter view, a ______________ indicates that it is selected. a. thick outline b. blinking outline c. dotted line d. highlighted arrow

b

When you sort tables, you can select either _____________ or ___________ order. a. alphabetical, numeric b. ascending, descending c. random, ordered d. static, random

d

When you use Ctrl + D, the duplicate picture will: a. always appear in the center of the slide. b. appear at the desired paste location. c. appear behind the original picture. d. overlap the original picture.

c

When your computer is configured to recognize ________ commands even handicapped people may use it. a. written b. typed c. voice d. mouse

b

Where in a document will the Find function search for matching text? a. You must first select the text and/or pages to be searched. b. From the current curser location to the end of the document c. Only within the current paragraph d. Automatically from the top of the document

b

Where possible, avoid compressing files because compressed files slow down file transmission. a. True b. False

d

Where would you find the option to apply a Theme to a single object in a database? a. Design grid b. Property sheet options c. Navigation pane options d. Theme button

c

Which action is NOT possible in Design view? a. View structure. b. Align controls. c. View underlying data. d. Add labels.

b

Which category in the Navigation Pane is useful because it is easy to determine the data source table of queries, forms, and reports? a. Object Type b. Table and Related Views c. Created Date d. Custom

a

Which country contributed the least amount of spam for the week ending July 24, 2011? a. United Kingdom b. Poland c. Colombia d. Thailand

a

Which country contributed the most spam for the week ending July 24, 2011? a. India b. Russia c. South Korea d. Taiwan

c

Which country hosted the least amount of malware on the web in 2009? a. Thailand b. Poland c. United Kingdom d. Turkey

d

Which country hosted the most malware on the web in 2009? a. Peru b. Russia c. China d. United States

d

Which data type should be applied to numbers that will not be used in calculations? a. Criteria b. Currency c. Number d. Text

c

Which document information could you expect to find on the Statistics tab of the Properties dialog box accessed from the Advanced Properties? a. Number of fonts used in the document. b. Number of spelling errors in the document c. Number of lines, paragraphs, and words in the document d. Margin and line spacing settings for the document.

c

Which item below is not part of the computer IPOS cycle? a. Processing b. Output c. Information d. Storage

d

Which keyboard shortcut will place a manual page break into a document? a. Ctrl + Tab b. Ctrl + End c. Ctrl + Home d. Ctrl + Enter

a

Which of the below is NOT a(n) output device? a. Microphone b. Speaker c. Printer d. Monitor

d

Which of the following appear on the Ribbon in all Office applications? a. The office ball b. PDF maker c. The backstage folder d. Tabs, groups, and commands

a

Which of the following is true about the insertion point? a. It indicates where text or graphics will be inserted. b. You can locate it by right-clicking the mouse. c. It is no longer available in Microsoft Word. d. It is activated by pressing the Ctrl, Alt, Delete keys.

b

Which of the following are elements of the MLA style guide? a.1.15-inch margins, 1.15-line spacing, double space between paragraphs b. 1-inch margins, double spacing, 0.5" first line indent with no spacing before or after paragraphs c. 1.25-inch margins, single spacing, first line hanging indent, spacing after paragraph 10 pt. d. .5-inch margins, double line spacing, spacing after paragraph 10 pt.

a

Which of the following can be used to designate footnotes? a. symbols such as * (asterisk) b. numbers only c. shapes d. clip art

a

Which of the following describes a citation in a research paper? a. A note inserted that refers to a source. b. A Web page used to publish the paper. c. A style used for the paper. d. A footnote style for the paper

b

Which of the following describes the AutoCorrect function? a. It maintains consistency whether you double space or indent paragraphs. b. It corrects spelling of commonly used words as you type. c. It marks misspelled words with red lines. d. It removes extra words when they are typed twice in a row.

b

Which of the following describes using a No Spacing style in a new document? a. Line spacing uses the default spacing. b. There is no space before or after paragraphs and single spacing is applied. c. Double spaces after punctuation are automatically converted to a single space. d. There is no style called No Spacing.

d

Which of the following describes what it means to run a query? a. Select a new data source for the query b. Add additional tables to a query c. Use the wizard to create the query d. Display the results of the query criteria

a

Which of the following is NOT one of the Summary Options in the Report Wizard? a. Sub Total b. Avg c. Sum d. Max

d

Which of the following is a disadvantage of computer use? a. Memory b. Connectivity c. Hardware reliability d. Security

d

Which of the following is a document template? a. Two documents linked together b. Read only sample documents c. A completed document d. A pre-designed document

b

Which of the following is a function of the Format Painter button? a. It paints images with a color you select. b. It copies the format of selected text and applies it to another location. c. It formats text in a default style. d. It copies text from one location to another.

c

Which of the following is an advantage of computer use? a. Security b. Information overload c. Storage d. Cost

a

Which of the following is an example of program or application? a. Microsoft Excel b. Ribbon c. Title bar d. Icon

a

Which of the following is contained in the data source for mail merge labels? a. Names and addresses of recipients b. Printer settings for labels c. Label size information d. Font formatting information

b

Which of the following is displayed when you click the Form tool? a. All records display in Datasheet View. b. All fields are displayed in Layout View. c. A design grid displays in Design View. d. A blank form displays.

d

Which of the following is not a consideration when sharing your Windows Live Calendar? a. If you share only viewing rights, you can choose what others can view. b. Options restrict a little more of what you are sharing. c. If you allow friends to have any editing rights, they can add, change, or delete items in your calendar. d. You should monitor your calendar carefully to meet deadlines.

d

Which of the following is not a platform that can be used to access Windows Live programs and services? a. On your PC b. On your smartphone c. On the Web d. All of these devices allow access to Windows Live programs and services.

b

Which of the following is not a popular Web browser? a. Firefox b. Sonata c. Google Chrome d. Safari

c

Which of the following is not an available feature in the PowerPoint 2010 Web App program? a. You can run your slide presentation with high fidelity. b. PowerPoint Web App saves your work automatically. c. You can perform more advanced formatting either in the PowerPoint Web App or in PowerPoint Office 2010. d. You can make last-minute changes to your presentation by using PowerPoint Web App.

c

Which of the following is not one of the best defenses against spyware? a. Avoid visiting questionable Web sites and download software only from reputable sources. b. Use a firewall, a program or device that allows you to access the Internet but strictly limits the ability of outside users to access local, corporate, or personal data. c. Click on pop-up ads with caution. d. Install an antispyware program and update it frequently.

a

Which of the following is not one of the rights for social network users that the Electronic Frontier Foundation proposes? a. The right to properly dispose of e-waste. b. The right to informed decision making. c. The right to control. d. The right to leave.

b

Which of the following is not one of the roles and responsibilities of an Internet access provider? a. Protecting their site and network from external threats. b. Providing customer service and technical support only during normal business hours. c. Providing and maintaining a connection to the Internet. d. Supporting the hardware and software needed to service the connection

c

Which of the following is not part of Windows Live Essentials? a. Mail b. Messenger c. Chrome toolbar d. Family Safety

a

Which of the following is not true about applying formatting in Office programs? a. In portrait orientation, the paper is wider than it is tall. In landscape orientation, the paper is taller than it is wide. b. Formatting is the process of establishing the overall appearance of text, graphics, and pages in an Office file. c. A footer is a reserved area for text or graphics that displays at the bottom of each page in a document. d. A header is a reserved area for text or graphics that displays at the top of each page in a document.

d

Which of the following is true of the Windows taskbar? a. It allows rapid page navigation. b. It can be resized. c. It replaces the status bar in earlier versions of Word. d. It contains the Start button.

a

Which of the following is not true about companies monitoring employees? a. Companies are prohibited, by law, to monitor their employees computer use. b. When entering a secured area that requires authorized access, be aware of anyone who is attempting to tailgate. c. Employees who access pornographic Web sites or circulate offensive jokes via e-mail may be creating a hostile environment for other employees. d. Companies are concerned about employees who may offer trade secrets to competitors in hopes of landing an attractive job offer.

b

Which of the following is not true about computer crime? a. Spyware is software that can collect your personal information, monitor your Web surfing habits, and then distribute this information to a third party. b. Identity theft is one of the fastest growing crimes in the United States and the United Kingdom. c. Malware is a general term that describes software designed to damage or infiltrate a computer system without the owner's consent or knowledge. d. In a phishing attack, a "phisher" poses as a legitimate company, like a bank or credit agency, in an e-mail or on a Web site in an attempt to obtain personal information

a

Which of the following is not true about formatting cells with Merge & Center and cell styles? a. Use the Merge & Center command to maintain a consistent look in a worksheet and across worksheets in a workbook. b. The Merge & Center command joins selected cells into one larger cell and centers the contents in the new cell. c. Formatting cells makes your worksheet attractive and easy to read. d. A cell style is a defined set of formatting characteristics, such as font, font size, font color, cell borders, and cell shading.

c

Which of the following is not true about managing your Windows Live Calendar? a. The calendar displays the current month. b. In the Day and Week views, you can see the entire event name and the time scheduled for each activity on the calendar. c. Any content displayed is color-coded according to the Calendar list displayed to the right of the calendar. d. Email reminders are generated based on your reminder selection.

c

Which of the following is not true about printing and deleting an Excel worksheet? a. If you attempt to delete a worksheet with data, Excel will display a warning and permit you to cancel the deletion. b. In Normal view, the vertical dotted line between columns indicates that as currently arranged, only the columns to the left of the dotted line will print on the first page. c. It is necessary to delete unused sheets to save storage space and remove any doubt that additional information is in the workbook. d. Scaling shrinks the width (or height) of the printed worksheet to fit a maximum number of pages, and is convenient for printing formulas.

c

Which of the following is not true about sending and receiving email via your Windows Live account? a. Always include a subject for email messages; it identifies to the recipient the reason for the email. b. A polite signature demonstrates professionalism. c. All unread emails appear in bold. d. Saving the email messages that you send confirms a message was sent to the recipient on a particular date and time

d

Which of the following is not true about sharing your Windows Live Calendar? a. The calendar displays the current month. b. You can send a link to contacts so they can view your calendar without a Windows Live ID. c. You can make your calendar public for anyone to see on a Web site or through a search engine. d. The default option for sharing is to share your calendar to the public.

a

Which of the following is not true about statistical functions? a. The MEDIAN function finds the average value that has as many values above it in the group as are below it. b. The SUM function is a predefined formula that adds all the numbers in a selected range of cells. c. Statistical functions, which include the AVERAGE, MEDIAN, MIN, and MAX functions, are useful to analyze a group of measurements. d. The AVERAGE function adds a group of values, and then divides the result by the number of values in the group.

b

Which of the following is not true about the message to enable editing or enable content? a. You might encounter these security features if you open a file from an e-mail or download files from the Internet. b. In Office 2010, some files open in Private View if the file appears to be from a potentially risky location, such as the Internet. c. These options are new security features in Office 2010 that protect your computer from malicious files by opening them in a restricted environment until you enable them. d. Trusted Documents is another security feature that remembers which files you have already enabled.

b

Which of the following is not true regarding Excel tables? a. You can sor t and filter the data in an Excel table. b. Sorting and filtering arrows display after you convert the table into a normal range. c. The Freeze Panes command enables you to select one or more rows or columns and then freeze them into place. d. To analyze a group of related data, you can convert a range of cells to an Excel table.

b

Which of the following is not true regarding IP addresses? a. Every host, computer, server, device, and application that communicates over the Internet is assigned an IP address. b. Internet service providers are assigned static IP addresses that they, in turn, dispense to you, their customer. c. A static IP address never changes and is the type used by most major Web sites. d. A dynamic IP address is automatically assigned to a computer when you log on to a network.

b

Which of the following is not true regarding Office Web Apps? a. Office Web Apps enable you to create, access, share, and perform light editing on Microsoft Office documents from any device that connects to the Internet. b. You need to have Office 2010 installed on your computer to use Office Web Apps. c. Office Web Apps are available in two ways. d. Office Web Apps are the online companions to Microsoft Office Word, Excel, PowerPoint, and OneNote.

d

Which of the following is not true regarding anonymity? a. Anonymity can be good or bad. b. Anonymity refers to your ability to convey a message without disclosing your name or identity. c. Technologies that threaten online anonymity include cookies, global unique identifiers, ubiquitous computing, and radio frequency identification. d. Privacy Rights Clearinghouse was founded by financial organizations to develop methods to deter fraud.

b

Which of the following is not true regarding clearing formats? a. You can choose to clear the contents of a cell, the formatting of a cell, or both. b. Clearing the contents of a cell deletes the value or formula typed there, including the formatting applied to a cell. c. Deleting the contents does not delete the formatting of the cell. d. Clearing the date formatting from the cell displays the date's serial number.

b

Which of the following is not true regarding conditional formatting? a. If the condition is true, the cell is formatted based on that condition. b. Conditional formatting should only be used on numeric values. c. A conditional format changes the appearance of a cell based on a condition d. If the condition is false, the cell is not formatted.

b

Which of the following is not true regarding cookies? a. Each cookie contains a unique ID, which is assigned to you by the Web site on your first visit. b. Cookies are often perceived to be extremely helpful to consumers because they give companies all the information needed to track customers. c. Cookies can be used to gather data on your browsing and shopping habits. d. A cookie is a small text file stored on your computer's hard disk by Web sites that you visit.

b

Which of the following is not true regarding numbered and bulleted lists? a. If the bullets were removed, then you clicked the Bullets button instead of the Bullets button arrow. b. The color of the numbers is determined by the font color used within the text of the bulleted point. c. You can customize a bullet by changing its style, color, and size. d. The presentation theme includes default styles for the bullet points in content placeholders.

b

Which of the following is not true regarding relationships? a. A relationship is an association that you establish between two tables based on common fields. b. Even before tables are related, you can create a query, a form, or a report that displays information from more than one table. c. Access databases are relational databases because the tables in the database can relate. d. After you have a table for each subject in your database, you must provide a way to connect the data in the tables when you need meaningful information.

a

Which of the following is not true regarding slide transitions? a. In the Slide pane, a star displays below the slide number providing a visual cue that a transition has been applied to the slide. b. You can choose from a variety of transitions, and you can control the speed and method with which the slides advance. c. When the On Mouse Click option is selected, the presenter controls when the current slide advances to the next slide by clicking the mouse button or by pressing [s]. d. The Effect Options vary depending on the selected transition and include the direction from which the slide enters the screen or the shape in which the slide displays during the transition.

b

Which of the following is not true regarding the Internet? a. The term cyberspace captures the concept of the intangible, nonphysical territory that the Internet encompasses. b. The Internet is maintained and controlled by the countries who own the Web sites. c. The networks that make up the Internet are not maintained by one company or organization. d. The Internet is a network in which every connected computer can exchange data with any other computer on the network.

a

Which of the following is not true regarding the Reading view? a. In Reading view, the status bar contains the Task button which is used to print, copy, and edit slides. b. In Reading view, the status bar contains the Next and Previous buttons, which are used to navigate in the presentation. c. The Reading view displays a presentation in a manner similar to a slide show, but the taskbar, title bar, and status bar remain available in the presentation window. d. A presenter can easily facilitate an online conference by switching to another window without closing the slide show.

d

Which of the following is not true regarding the World Wide Web? a. The documents that comprise the World Wide Web and are transported over the Internet are called Web pages. b. HTML is a language that uses a tag system of code to create Web pages. c. Standards and guidelines related to all aspects of the Web are published by the World Wide Web Consortium (W3C), an international organization based in Cambridge, Massachusetts. d. The Internet and the World Wide Web are the same thing.

c

Which of the following is not true regarding the history of the Internet? a. The purpose of the initial project was to create a form of secure communication for military and scientific purposes and to create a method for transferring such communications between computers. b. Each of the four initial computers connected hundreds of other computers to the network. c. The Internet is a network of servers. d. The outcome of the project was a network that consisted of four computers located at the University of California at Los Angeles, the University of California at Santa Barbara, the University of Utah, and Stanford Research Institute

b

Which of the following is not true regarding the order of operands? a. Multiplication and division are performed before addition and subtraction. b. Consecutive operators with the same level of precedence are calculated from right to left. c. Expressions within parentheses are processed first. d. Exponentiation, if present, is performed before multiplication and division.

c

Which of the following is not true regarding the sections of the Choose a SmartArt Graphic dialog box? a. The left section lists the SmartArt graphic types. b. The third section displays the selected SmartArt graphic, its name, and a description of its purpose. c. The lower section displays the SmartArt graphics according to type. d. Three sections comprise the Choose a SmartArt Graphic dialog box.

d

Which of the following is not true regarding your Windows Live profile? a. The Private setting restricts everyone from searching for you or seeing anything online unless you have allowed them to do so. b. The Public setting provides unlimited access to everyone. c. Consider the level of detail you want to provide in a profile. d. The Limited setting allows everyone to search for you and view your online activity and content.

a

Which of the following is not true when adding and managing friends in Windows Live Messenger? a. Any friends you had previously added will appear at the top of the list, if they are offline. b. Contacts include the people you have added to your Hotmail account for email, instant messaging, sharing calendars, and sharing documents. c. Contacts and friends are accessed using their Windows Live ID. d. Friends are people that must be added before you can share information and chat using Windows Live Messenger.

b

Which of the following is not true when safeguarding your data on the Internet? a. Surf the Web anonymously by using software products to protect your data and encrypt your online communications. b. It is a good idea to complete all registration forms on all web pages. c. Use a throwaway e-mail address from a free Web-based service such as Google's Gmail for mailing lists and chat rooms. d. Instruct children not to divulge any personal information online without first asking a parent or teacher for permission

d

Which of the following is not true when adding speaker's notes to a presentation? a. Use the Notes pane to type speaker's notes that you can print below a picture of each slide. b. While making your presentation, you can refer to these printouts to remind you of the important points that you want to discuss during the presentation. c. When a presentation is displayed in Normal view, the Notes pane displays below the Slide pane. d. Speaker's notes add impact to a presentation and help the audience visualize the messages you are trying to convey.

a

Which of the following is not true when changing fonts, font sizes, font styles, and font colors? a. When you click the Font Color button instead of the Font Color button arrow, the color displayed in the lower part of the Font Color button is applied to selected text while displaying the color gallery. b. Font styles include bold, italic, and underline. c. You can apply any combination of these styles to presentation text to draw the reader's eye to important text. d. The lower part of the Font Color button displays the most recently applied font color.

c

Which of the following is not true when changing the shape of a picture? a. The Crop arrow displays cropping options, such as the option to crop a picture to a shape. b. The Crop button enables the crop feature, which reduces the size of a picture by removing vertical or horizontal edges. c. An inserted picture is square in shape. d. You can modify a picture by changing its shape.

a

Which of the following is not true when collaborating and sharing documents on Office Documents in Windows Live? a. Those with whom you share and collaborate need to have Office installed. b. You can maintain a single copy of a document and share it with others by sending a link to it. c. Those with whom you share and collaborate can use an earlier version of Office. d. Those with whom you share and collaborate can work on a PC or a Mac.

d

Which of the following is not true when communicating with Windows Live Messenger? a. Any friends that are online and available at the same time as you are will display with a green icon to the left of their display name. b. Minimizing the Messenger pane removes any other MSN content from your window while displaying your contacts and their status. c. Check boxes might display to enable you to make logging in faster in the future. d. Change your status to Gone before you step away from your computer

c

Which of the following is not true when creating a Microsoft Outlook account? a. You might choose to create separate profiles to keep your work data and personal information separate. b. The Microsoft Outlook 2010 Startup Wizard helps you configure Outlook 2010 in your new user name account. c. Outlook uses the computer's IP address to identify which e-mail account you use and where the related data is stored. d. When initially configured, Outlook creates a single profile.

a

Which of the following is not true when creating a folder for sharing multiple documents? a. Anyone to whom you give permission to access the folder will have access to all of the documents in the folder. b. To share a collection of documents with the same people, create a folder for the documents. c. Within the folder, you can specify permissions. d. Entire folders cannot be shared on Office Documents in Windows Live.

a

Which of the following is not true when creating and formatting a SmartArt graphic? a. Four sections comprise the Choose a SmartArt Graphic dialog box. b. You can convert an existing bulleted list into a SmartArt graphic. c. When you create a SmartArt graphic, consider the message that you are trying to convey, and then choose an appropriate layout. d. A SmartArt graphic is a visual representation of information that you create by choosing from among various layouts to communicate your message or ideas effectively

a

Which of the following is not true when editing a Web App Workbook in the Excel 2010 Program? a. You can perform more advanced formatting. b. You can perform basic editing. c. Office Web Apps render some but not all of the formatting you apply in the Excel 2010 program. d. You can insert and delete rows and columns.

d

Which of the following is not true when editing an existing presentation? a. Changes that you make in the outline are immediately displayed in the Slide pane. b. Each slide in the outline displays the slide number, slide icon, and the slide title in bold. c. You can edit presentation content in either the Slide pane or the Slides/Outline pane. d. When you type in the outline or change the list level, the changes display in the Slide pane once you save your changes.

d

Which of the following is not true when inserting text boxes and shapes? a. You can use objects, including text boxes and shapes, to draw attention to important information or to serve as containers for slide text. b. Ruler guides are dotted vertical and horizontal lines that display in the rulers indicating the pointer's position. c. You can use the ruler guides to help you position objects on a slide. d. A shape box is an object with which you can position text anywhere on a slide.

b

Which of the following is not true when inserting, sizing, and positioning shapes? a. Shapes include lines, arrows, stars, banners, ovals, rectangles, and other basic shapes you can use to illustrate an idea, a process, or a workflow. b. To use, click the Insert tab, and then in the Drawings group, click the Shapes button to display the Shapes gallery. c. Shapes can serve as a container for text. d. Shapes can be sized and moved using the same techniques that you use to size and move clip art images.

b

Which of the following is not true when moving and sizing images? a. When you point to the image, the move pointer displays, indicating that you can move the image. b. You can also resize an image using the Shape Height and Shape Width boxes on the Home tab. c. Pressing [Shift] while dragging an object constrains object movement in a straight line either vertically or horizontally. d. When an image is selected, it is surrounded by sizing handles that you can drag to resize the image

d

Which of the following is not true when printing a presentation? a. The Preview box, in the insert Headers and Footers dialog box, indicates the placeholders on the printed Notes and Handouts pages. b. A header is text that prints at the top of each sheet of slide handouts or notes pages. c. Slide handouts are printed images of slides on a sheet of paper. d. Notes pages are printouts that contain the slide image on the bottom half of the page and notes that you have created on the Notes pane in the top half of the page.

a

Which of the following methods walks you step by step through the process of creating a form? a. Form Wizard b. Form Tool c. Form Layout d. Form Design

a

Which of the following is not true when sharing documents via email? a. When the recipient clicks the link in the message, the document opens in his or her version of Office. b. When you attach a Word document, an Excel workbook, or a PowerPoint presentation to an email message in Hotmail, you have the opportunity to save the file to your SkyDrive. c. To set an expiration date for the file, or to give the recipient read-only permission, click Edit details and change the settings. d. If you decide you do not want to send the file, or you selected the wrong file, click the Remove icon.

d

Which of the following is not true when using Excel to track data? a. Excel is limited as a database management tool because it cannot relate the information in multiple spreadsheets in a way a that a question could be asked and the results would be meaningful. b. The sorting and filtering capabilities of Excel are useful for a simple database where all the information resides in one large Excel spreadsheet. c. Many Microsoft Office users track data in an Excel spreadsheet. d. It is difficult to import a spreadsheet into Access because Excel lacks relationships between spreadsheets.

c

Which of the following is not true when viewing a presentation? a. An audience can view your presentation if your computer is connected to a projection system. b. After the last slide in a presentation, a black slide displays, indicating that the presentation is over. c. To advance to the next slide, you can press [Ctrl]+[N]. d. When you view a presentation as an electronic slide show, the entire slide fills the computer screen.

c

Which of the following is not true when working in Microsoft Outlook? a. Microsoft Outlook 2010 is an e-mail program. b. A user account is a collection of information that tells Windows 7 what files and folders the account holder can access, what changes the account holder can make to the computer system, and what the account holder's personal preferences are. c. Microsoft Outlook 2010 is a personal information mail program. d. Each person accesses his or her user account with a user name and, if desired, a password, to access his or her own desktop, files, and folders.

b

Which of the following is not true when working with Excel documents? a. In Excel Web App, you can navigate through the worksheets in a workbook and sort, filter, and recalculate worksheet data. b. The three tabs displayed on the Ribbon include File, Insert, and View. c. If you share an Excel file stored on a Windows Live SkyDrive, two or more individuals can edit the file at the same time. d. The Excel Web App saves your workbook automatically as you work. 28.

a

Which of the following is not true when working with WordArt? a. You can use WordArt to flow a picture into the content of the presentation. b. WordArt is a gallery of text styles with which you can create decorative effects, such as shadowed or mirrored text. c. You can choose from the gallery of WordArt styles to insert a new WordArt object. d. You can customize existing text by applying WordArt formatting.

a

Which of the following is not true when working with clip art? a. With the Illustrations check box selected, PowerPoint will search for images that were created with a digital camera or a scanner. b. There are many sources from which you can insert images into a presentation. c. One type of image that you can insert is a clip; a single media file such as art, sound, animation, or a movie. d. When you use the Clip Art command on the Ribbon instead of the Clip Art button in a content placeholder, PowerPoint inserts the image in the center of the slide.

d

Which of the following is not true when working with picture backgrounds? a. Background Removal removes unwanted portions of a picture so that the picture does not appear as a self contained rectangle. b. To avoid the boxy look that results when you insert an image into a presentation, use Background Removal to flow a picture into the content of the presentation. c. You can surround irregular-shaped areas that you want to remove with deletion marks. d. The Background Removal options display in the Edit group on the Ribbon.

b

Which of the following is not true when working with pictures in a presentation? a. Photographic images add impact to a presentation and help the audience visualize the messages you are trying to convey. b. The rotation handle, a yellow circle above the picture, provides a way to rotate a selected image. c. Sizing handles surround the inserted picture and indicate that the picture is selected and can be modified or formatted. d. The Picture Tools add the Format tab to the Ribbon, which provides numerous styles that you can apply to a picture, text, or an object.

a

Which of the following is the advantage of using a form in a database? a. A form is a visually attractive format in which to enter, edit, or display data. b. A form is a good way to display fields and records from a table in a format for printing. c. With a form you can retrieve data from one or more reports. d. A form allows you to display duplicate records for comparison.

b

Which of the following is the advantage of using a template to create a new database? a. Primary keys are not used. b. Objects are pre-built. c. Object names include your name. d. All data is pre-entered.

d

Which of the following is the best type of filter to use to retrieve only the records that contain the value in the selected field? a. Filter by Control b. Filter by Type c. Filter by Form d. Filter by Selection

b

Which of the following is the default line spacing in a new document? a. .75 b. 1.15 c. 1.25 d. 1.0

a

Which of the following is the fastest way to create a report? a. Report tool b. Report Wizard c. Report Design d. Blank Report

b

Which of the following is the keyboard shortcut for Print Preview? a. F2 b. Ctrl + F2 c. Ctrl + F4 d. F4

c

Which of the following is the procedure for getting Excel data into an Access table? a. Export b. Copy Wizard c. Import d. Modify

c

Which of the following is true about bulleted lists? a. The items in the list are in descending order of importance. b. The items in the list are in sequential order. c. The items in the list can be introduced in any order. d. The items in the list are in chronological order.

b

Which of the following is true about common dialog boxes? a. They are no longer used in current software applications. b. They operate the same way in all Microsoft Office programs. c. They use backstage formatting. d. They apply only to PDF documents.

d

Which of the following will Excel display if a cell width is too narrow to display an entire number? a. #VALUE? b. #NUM! c. #N/A d. ######

d

Which of the following would NOT be classified as a graphic object? a. pictures and clip art b. charts c. shapes and lines d. text files

c

Which of the following would be the best reason to use the Blank Report tool? a. Quickest method to create a complicated design b. All fields need to be in the report c. Few data fields are needed. d. Controls how data is grouped and sorted.

d

Which of the following would be the result if you placed *thin your criteria? a. mathematics b. straight c. three d. math

c

Which symbol would be considered a comparison operator symbol? a. ^ b. * c. > d. +

a

Which type of alignment is often used in newspaper-style columns? a. Justify b. Align Text Right c. Align Text Left d. Center

d

Which view displays the page borders and displays the document as it will appear when printed? a. Draft b. Outline c. Full Screen Reading d. Print Layout

b

Which view is used to type data into an Access table? a. Navigation pane b. Datasheet view c. Design view d. Object view

b

While in Layout view, text box controls cannot be arranged as a group. a. True b. False

b

Why is an Access database called a relational database? a. Access tables can have multiple rows. b. Access tables can connect to other tables. c. Access databases can have multiple tables. d. Access databases can share data with other programs.

a

Words not recognized by Word's dictionary are displayed as a spelling error using a wavy red underline. a. True b. False

b

You can ___________ parts of a video to make it shorter. a. cut b. trim c. snip d. crop

a

You can create a new appointment directly in the calendar by typing it in a blank time slot in the ________ area. a. appointment b. scheduling c. task d. calendar

a

You can create a new query from scratch or create a query from a(n) __________________. a. existing query b. existing report c. imported Excel file d. Form Wizard

b

You can edit presentation content in either the Slide pane or the ____________ pane. a. print preview b. Slides/Outline c. slide sorter d. slide show preview

b

You can forward an e-mail message you receive to someone else, which is commonly referred to as a ________. a. receiver b. third party c. forwarding party d. host

b

You can reposition data within a cell at an angle by __________ the text. a. cutting and using a special paste option b. rotating c. inserting d. dragging and dropping

b

You can set the ________ or the frequency of an appointment, which can be daily, weekly, monthly, or yearly. a. occurring pattern b. recurrence pattern c. repeat setting d. refresh pattern

a

You can ungroup a group of selected worksheets by right-clicking any sheet tab, and then click Ungroup Sheets. a. True b. False

a

You can use Slide Sorter view to rearrange, delete, and apply formatting to multiple slides. a. True b. False

a

You can view all grouped worksheets in Print Preview. a. True b. False

a

You have used "Is Null" in the criteria. That means you are looking for blank records for that field. a. True b. False

a

You would use the crop feature to reduce the size of a picture by removing the vertical or horizontal edges of the picture. a. True b. False

a

Your database has four tables. Which of the following must be established before you can create a query based on two of those tables? a. Relationship b. Referential integrity c. Redundancy d. Identical fields

d

Your report places a page break in the middle of grouped data, leaving the labels on one page, and the data on another. Which option would allow you to keep the group data together? a. Click the One Page button b. Use the Shrink to Fit option c. Use the Print data only option d. Use the keep whole group together on one page command

b

__ is a factor you must weigh against your computer's performance. a. Color b. Cost c. Versatility d. Size

d

________ is a standard newsgroup category that relates to social issues, including adoption, college-related issues, human rights, and world cultures. a. Misc b. Sci c. Comp d. Soc

c

__ is a professional social networking site where you can find past and present colleagues and classmates, connect with appropriate people when seeking a new job or business opportunity, or get answers from industry experts. a. Skype b. Squarespace c. LinkedIn d. SharePoint

a

________ are companies or businesses that provide access to the Internet either for free, for a fixed monthly charge, or for an itemized per use fee. a. Internet access providers b. Internet service providers c. network service providers d. online service provider

c

________ are continuous waves that vary in strength and quality. a. ADCs b. DACs c. Analog signals d. Digital signals

c

________ are designed to copy files periodically in case your hard drive fails. a. Disk manager programs b. Selective copy programs c. Backup software utilities d. Disk copy programs

b

________ are the foundation of an Access database. a. Records b. Tables c. Fields d. Data

b

________ are the motion effects that occur in Slide Show view when you move from one slide to the next during a presentation. a. Speaker notes b. Slide transitions c. Slide animations d. The slide sorter

b

________ are the upper part of the radio frequency spectrum and are electromagnetic radio waves with short frequencies that travel at speeds of 1 to 10 Mbps a. Bluetooth b. Microwaves c. Radio transmissions d. WiFi

d

________ can be based on any of the IEEE 802.11 standards and communicates through radio frequency technology, with ranges reaching 300 to 500 feet. a. Bluetooth b. Microwaves c. Radio transmission d. WiFi

c

________ can generate and grade tests that only humans can pass. a. A strong password b. A weak password c. CAPTCHA d. Bots

a

________ combines the flexibility of HTML with the addition of Extensible Markup Language. a. XHTML b. HXML c. HTML d. XML

a

________ consists of a center copper wire surrounded by insulation, which is then surrounded by a layer of braided wire. a. Coaxial cable b. Fiber-optic cable c. Twisted pair d. Cat-5

b

________ consists of thin strands of glass or plastic about the diameter of a human hair. a. Coaxial cable b. Fiber-optic cable c. Twisted pair d. Cat-5

d

________ contains four pairs of twisted-copper wire and supports speeds up to 100 Mbps over a maximum distance of 100 m. a. Coaxial cable b. Fiber-optic cable c. Twisted pair d. Cat-5

c

________ control(s) how the field displays and how data can be entered in the field. a. Data types b. The object window c. Field properties d. The Navigation Pane

c

________ effects are formats applied to images that make pictures resemble sketches or paintings. a. Object b. Drop shadow c. Artistic d. Format

d

________ in a PowerPoint presentation is/are organized according to list levels. a. Themes b. WordArt c. Graphics d. Text

a

________ include computers, modems, routers, switches, hubs, wireless access points, and network interface cards. a. Communication devices b. Wireless PC card adapters c. Network interface cards d. USB wireless adapters

d

________ is a collection of programs and services for individuals that work together. a. Web browser b. instant messaging c. Office Web Apps d. Windows Live

c

________ is a communication transmission that uses a wide band of frequencies to transport high volumes of data at high speeds, typically greater than 1 Mbps. a. Bandwidth b. Throughput c. Broadband d. Streaming

d

________ is a feature that enables subtle animations and translucent glass windows that can be custom colored. a. Snap b. Peek c. Shake d. Aero

d

________ is a free plug-in that improves the appearance of some applications in your browser. a. Silverfish b. Bluelight c. Redfish d. Silverlight

d

________ is a free, real-time blogging system in which you send and read short messages of up to 140 characters. a. Facebook b. LinkedIn c. MySpace d. Twitter

b

________ is a language that enables Web page developers to create their own set of rules to define how data is to be represented on the Web. a. HXML b. XML c. HTML d. XHTML

b

________ is a professional social networking site on which you post your professional profile and resume, connect with colleagues, and seek advice from experts. a. Facebook b. LinkedIn c. MySpace d. Twitter

d

________ is a program that can run automated tasks over the Internet, typically at a higher rate than would be possible for a human alone. a. A strong password b. A weak password c. CAPTCHA d. A bot

a

________ is a related group of technologies from Microsoft for collaboration, file sharing, and Web publishing within organizations. a. Cloud computing b. SharePoint c. Standard computing d. Web computing

c

________ is a set of rules that Access uses to ensure that the data between related tables is valid. a. A subdatasheet b. A join line c. Referential integrity d. A foreign key

c

________ is a social network that promotes itself as a fan-powered social entertainment destination with a major focus on music. a. Facebook b. LinkedIn c. MySpace d. Twitter

c

________ is a standard newsgroup category that covers everything related to computers and computer networks. a. Misc b. Sci c. Comp d. Soc

a

________ is a standard newsgroup category that includes subjects that do not fit into other standard newsgroup hierarchies. a. Misc b. Sci c. Comp d. Soc

b

________ is a standard newsgroup category that relates to sciences and social sciences. a. Misc b. Sci c. Comp d. Soc

Post script

an automated page-description language (PDL) that describes image elements as geometric objects such as lines and arcs and consists of commands given by the program and carried out by the printer to precisely re-create the computer image on a printed page.

3-D

an image that appears to have the three spatial dimensions of length, width, and depth

Webcam

an inexpensive camera attached to or embedded within your computer that can be used to hold live chat sessions and make video phone calls is a

Scroll Bar

appears when a window or pane has information that is not in view

Scroll Box

used within a scroll bar to view content that is not originally in view

Multiple 1.15 line spacing

was once the most commonly used spacing in business documents