IBA Final Exam

size

Fields whose data type is Number often require you to change the field ___, which is the storage space assigned to the field by Access.

effects

Fill ____ add pattern and texture to a background, which add depth to a slide.

conditional formatting

Formatting that appears only when the value in a cell meets specific conditions is called ____.

crop

Word allows you to _____, or remove edges from, a graphic.

worm

A ___ is a program that copies itself repeatedly, for example in memory or on a network, using up resources and possibly shutting down the computer or network.

database

A ____ is a collection of data organized in a manner that allows access, retrieval, and use of that data.

mouse

A ____ is a pointing device that fits comfortably under the palm of your hand.

frame

A _____ is a container for text that allows you to position the text anywhere on the page.

subhead

A _____ is a heading within the body of the newsletter.

AutoNumber

A field with the ___ data type can store a unique sequential number that Access assigns to a record. Access will increment the number by 1 as each new record is added.

engine

A search ____ is a program that finds Web sites, Web pages, images, videos, news, maps, and other information related to a specific topic.

thumb

A USB flash drive, sometimes called a ____ drive, is a flash memory storage device that plugs into a USB port on a computer or mobile device.

sizing handles

A selected graphic appears surrounded by a selection rectangle, which has small squares and circles, called _____ _____ at each corner and middle locations.

primary

A unique identifier also is called a(n) ____ key.

bevel

A(n) ____ edge is angled or sloped and gives the effect of a three- dimensional object.

shadow

A(n) ____ helps letters display prominently by adding a shadow behind the text.

database management system

A(n) ____, such as Access, is software that allows you to use a computer to create a database.

drop cap

A(n) _____ is a capital letter whose font size is larger then the rest of the characters in the paragraph.

pull-quote

A(n) _____ is text that is pulled, or copied, from the text of the documment and given graphical emphasis.

function

A(n) ______ is a prewritten formula that is built into Excel.

operating system

A(n) ______ is a set of programs that coordinates all the activities among computer hardware devices.

optical disc

A(n) __________ is flat, round, portable metal disc with a plastic coating.

either a or b

An access provider is a business that provides individuals and organizations access to the Internet ____. a. for free b. for a fee c. either a or b d. neither a nor b

watermarks

Checks, currency, and legal documents use ____ to verify their authenticity. These semi-transparent images are visible when you hold the paper up to a light.

shapes

Circles, squares, and triangles are among the geometric shapes included in the ____ gallery.

information processing cycle

Computers perform four basic operations -- input, process, output, and storage. These operations comprise the _____.

properties

Database ___, also known as metadata, can include such information as the file's author, title, or subject.

type

Each field has a data ___, which indicates what can be stored in the field.

scheme

Each presentation template has 12 complementary colors, which collectively are called ____.

spell checker

Excel has a(n) _____ you can use to check the worksheet for spelling errors.

jump line

If an article spans multiple pages, use a continuation line, called a ______ to guide the reader to the remainer of the article.

+

If the following arithmetic operations all are found in a formula with non parentheses, which one is completed last?

database

In Access, all the tables, reports, forms, and queries that you create are stored in a single file called a(n) ____.

effect

Many PowerPoint transitions have options that you can customize to give your presentation a unique look. To access this feature, click the ___ Options button (Transitions tab | Transition to This Slide group).

weight

PowerPoint gives you the option to change the line ___, or thickness, starting with 1/4 point.

effects

Some ___ are shadows, reflections, glows, bevels, and 3-D rotations.

photo

Some ink-jet printers, called ___ printers, produce photo-lab quality pictures and are ideal for home or small- business use.

true

T/F- A Web site is a collection of related Web pages.

false

T/F- Contrast determines the overall lightness or darkness of the entire image.

false

T/F- Database users typically use standard guidelines for naming tables.

true

T/F- Gradient fill is one color shade gradually progressing to another shade of the same color or one color progressing to another color.

false

T/F- In the formula =4 8 * 6 - 8 the subtraction operation (-) is completed before the multiplication operation (*).

true

T/F- Leader characters, such as dots, often are used in a table of contents to precede page numbers.

false

T/F- Like a virus or worm. a Trojan horse does not replicate itself to other computers.

true

T/F- Like drawing objects or pictures, text boxes can be formatted or have styles applied.

true

T/F- People remember at least one-third more information when the document they are seeing or reading contains visual elements.

true

T/F- Pressing the F9 key instructs Excel to recalculate all formulas.

true

T/F- Redundancy means storing the same fact in more than one place.

false

T/F- Report view allows you to make changes, but it does not show you the actual report.

true

T/F- Solid fill is one color used throughout the entire slide.

false

T/F- The Internet is the world's largest WLAN.

false

T/F- The order of operations is from right to left.

true

T/F- To change the default printer that appears inthe Print dialog box, click File on the Ribbon, click the Print tab in the Backstage view, click Print in the Print gallery, then click the Name box arrow and select the desired printer.

true

T/F- To move a text box, select it and use the arrow keys.

true

T/F- When importing data, you have two choices. You can create a new table or add the records to an existing table.

true

T/F- You can drag a gradient stop to any location along the color bar, and you can also adjust the position, brightness, and transparency of any selected stop.

home

The Increase Font Size buttons on the Mini toolbar and in the Font group (__ tab) enlarge the selected characters in predetermined amounts.

crystal

The LCD monitor uses a liquid _____ display to produce images on the screen.

four-headed arrow

To move a graphic, point to the graphic, and when the mouse pointer has a(n) _____ attached to it, drag the graphic

outline

The WordArt ____ is the exterior border surrounding each letter or symbol.

navigation pane

The ___ contains a list of all the objects in the database. You use this to open an object.

system unit

The ___ is a case that contains electronic components of the computer used to process data.

AVERAGE

The ____ function sums the numbers in the specified range and then divides the sum by the number cells with numeric values.

title

The ____ slide introduces the presentation to the audience.

transparency

The ____ slider indicates the amount of opaqueness.

MIN

The _____ function is used to determine the lowest number in a given range.

issue information line

The ______ identifies the specific publication.

snaking

The body copy in columns, often called ______ columns or newspaper- style columns, flows from the bottom of one column to the top of the next column.

source

The item being copied is called the ______.

painter

The mouse pointer changed shape by adding a paintbrush to indicate that the Format ___ function is active.

order of operations

The order in which calculations are performed in a formula is called _____.

records

The rows in the tables are called ____.

backup

The simplest approach to recovery involves periodically making a copy of the database (called a __ copy or a save copy).

equal sign

To alert Excel that you are entering a formula and not text, type a(n) _____ preceding the formula.

floating dollar sign

To assign a dollar sign to appear immediately to the left of the first digit with no spaces, use a ______.

section breaks

To divide a portion of a document in multiple columns, you use ______.

insert

To insert clip art, display the ____ tab and click the Clip Art button to display Clip Art pane.

row selector

To see the field size and/or caption for a field, click the field's _____, the small box that precedes the field.

MAX

Use the ____ function to display the highest value in a range.

arguments

Values used with a function are called _____.

best fit

When Excel automatically sets the width of a column based on the widest entry in the column, it is called _____.

justified

When the text in the body of a newsletter is _______ it means that the left and the right margins are aligned.

the row references change in the formula

When you copy a formula with relative cell references down a row, _____.

d. all of the above

You can enter functions______. a. with the keyboard b. the Sum menu c. the Insert Function in the formula d. all of the above

f8 key

You can select a range using the keyboard, just press the _____ then use the arrow keys to select the desired range.

SHIFT+F5

You press _____ to return the insertion point to your last editing position.

work

You work on objects such as tables, forms, and reports in the Access ____ area.

best fit

___ means that the width of a column will be increased or decreased.

landscape

___ orientation means the printout is across the height of the page.

data

____ is the collector of unprocessed items, which can include text, numbers, images, audio, and video.

cloud

____ storage is an Internet service that provides hard disk storage to computer users.

queries

_____ are simply questions, the answers to which are in the database.

green

_____ computing involves reducing the electricity consumed and environmental waste generated when using a computer.

WordArt

_____ is a type of drawing object that enables you to create text with special effects such as shadowed, rotated, stretched, skewed, and wavy effects.

contrast

_____ is the difference between the darkest and lightest areas of the image.

design

_____ view, is only used to create a table or to modify the structure of the table.

debugging

______ is the process of finding and correcting errors in a worksheet.

hypertext transfer protocol

______ is the set of rules that defines how pages transfer on the Internet.

system

______ software consists of programs that control the operations of the computer and its devices.

gradient

________ means the colors blend into one another.