question

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

answer

equal sign

question

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

answer

+

question

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

answer

the row references change in the formula

question

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

answer

f8 key

question

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

answer

d. all of the above

question

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

answer

MIN

question

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

answer

floating dollar sign

question

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

answer

best fit

question

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

answer

spell checker

question

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

answer

debugging

question

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

answer

function

question

Values used with a function are called _____.

answer

arguments

question

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

answer

order of operations

question

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

answer

AVERAGE

question

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

answer

MAX

question

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

answer

conditional formatting

question

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

answer

best fit

question

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

answer

true

question

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

answer

false

question

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

answer

false

question

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

answer

primary

question

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

answer

type

question

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.

answer

AutoNumber

question

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

answer

size

question

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

answer

navigation pane

question

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

answer

work

question

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

answer

landscape

question

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

answer

properties

question

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

answer

backup

question

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

answer

database management system

question

The rows in the tables are called ____.

answer

records

question

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

answer

database

question

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

answer

design

question

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

answer

row selector

question

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

answer

queries

question

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

answer

true

question

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

answer

false

question

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.

answer

true

question

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

answer

true

question

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

answer

false

question

The ____ slide introduces the presentation to the audience.

answer

title

question

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

answer

scheme

question

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

answer

home

question

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

answer

painter

question

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

answer

shapes

question

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

answer

effects

question

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

answer

weight

question

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).

answer

effect

question

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.

answer

watermarks

question

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

answer

sizing handles

question

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

answer

contrast

question

The ____ slider indicates the amount of opaqueness.

answer

transparency

question

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

answer

effects

question

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

answer

shadow

question

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

answer

outline

question

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

answer

bevel

question

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

answer

true

question

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

answer

false

question

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

answer

true

question

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

answer

true

question

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.

answer

worm

question

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

answer

engine

question

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

answer

either a or b

question

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

answer

database

question

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

answer

system

question

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

answer

cloud

question

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.

answer

thumb

question

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

answer

photo

question

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

answer

mouse

question

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

answer

green

question

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

answer

information processing cycle

question

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

answer

data

question

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

answer

system unit

question

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

answer

crystal

question

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

answer

optical disc

question

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

answer

operating system

question

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

answer

hypertext transfer protocol

question

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

answer

false

question

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

answer

true

question

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

answer

false

question

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

answer

subhead

question

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

answer

WordArt

question

________ means the colors blend into one another.

answer

gradient

question

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

answer

insert

question

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

answer

four-headed arrow

question

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

answer

jump line

question

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

answer

justified

question

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

answer

frame

question

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

answer

SHIFT+F5

question

The ______ identifies the specific publication.

answer

issue information line

question

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

answer

pull-quote

question

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

answer

crop

question

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.

answer

snaking

question

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

answer

section breaks

question

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

answer

drop cap

question

The item being copied is called the ______.

answer

source

question

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.

answer

true

question

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

answer

true

question

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

answer

true

question

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

answer

true

IBA Final Exam – Flashcards

Unlock all answers in this set

Haven't found what you were looking for?

Search for samples, answers to your questions and flashcards