IBA Final Exam

equal sign
To alert Excel that you are entering a formula and not text, type a(n) _____ preceding the formula.
+
If the following arithmetic operations all are found in a formula with non parentheses, which one is completed last?
the row references change in the formula
When you copy a formula with relative cell references down a row, _____.
f8 key
You can select a range using the keyboard, just press the _____ then use the arrow keys to select the desired range.
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
MIN
The _____ function is used to determine the lowest number in a given range.
floating dollar sign
To assign a dollar sign to appear immediately to the left of the first digit with no spaces, use a ______.
best fit
When Excel automatically sets the width of a column based on the widest entry in the column, it is called _____.
spell checker
Excel has a(n) _____ you can use to check the worksheet for spelling errors.
debugging
______ is the process of finding and correcting errors in a worksheet.
function
A(n) ______ is a prewritten formula that is built into Excel.
arguments
Values used with a function are called _____.
order of operations
The order in which calculations are performed in a formula is called _____.
AVERAGE
The ____ function sums the numbers in the specified range and then divides the sum by the number cells with numeric values.
MAX
Use the ____ function to display the highest value in a range.
conditional formatting
Formatting that appears only when the value in a cell meets specific conditions is called ____.
best fit
___ means that the width of a column will be increased or decreased.
true
T/F- Pressing the F9 key instructs Excel to recalculate all formulas.
false
T/F- In the formula =4 8 * 6 – 8 the subtraction operation (-) is completed before the multiplication operation (*).
false
T/F- The order of operations is from right to left.
primary
A unique identifier also is called a(n) ____ key.
type
Each field has a data ___, which indicates what can be stored in the field.
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.
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.
navigation pane
The ___ contains a list of all the objects in the database. You use this to open an object.
work
You work on objects such as tables, forms, and reports in the Access ____ area.
landscape
___ orientation means the printout is across the height of the page.
properties
Database ___, also known as metadata, can include such information as the file’s author, title, or subject.
backup
The simplest approach to recovery involves periodically making a copy of the database (called a __ copy or a save copy).
database management system
A(n) ____, such as Access, is software that allows you to use a computer to create a database.
records
The rows in the tables are called ____.
database
In Access, all the tables, reports, forms, and queries that you create are stored in a single file called a(n) ____.
design
_____ view, is only used to create a table or to modify the structure of the table.
row selector
To see the field size and/or caption for a field, click the field’s _____, the small box that precedes the field.
queries
_____ are simply questions, the answers to which are in the database.
true
T/F- Redundancy means storing the same fact in more than one place.
false
T/F- Database users typically use standard guidelines for naming tables.
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- When importing data, you have two choices. You can create a new table or add the records to an existing table.
false
T/F- Report view allows you to make changes, but it does not show you the actual report.
title
The ____ slide introduces the presentation to the audience.
scheme
Each presentation template has 12 complementary colors, which collectively are called ____.
home
The Increase Font Size buttons on the Mini toolbar and in the Font group (__ tab) enlarge the selected characters in predetermined amounts.
painter
The mouse pointer changed shape by adding a paintbrush to indicate that the Format ___ function is active.
shapes
Circles, squares, and triangles are among the geometric shapes included in the ____ gallery.
effects
Some ___ are shadows, reflections, glows, bevels, and 3-D rotations.
weight
PowerPoint gives you the option to change the line ___, or thickness, starting with 1/4 point.
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).
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.
sizing handles
A selected graphic appears surrounded by a selection rectangle, which has small squares and circles, called _____ _____ at each corner and middle locations.
contrast
_____ is the difference between the darkest and lightest areas of the image.
transparency
The ____ slider indicates the amount of opaqueness.
effects
Fill ____ add pattern and texture to a background, which add depth to a slide.
shadow
A(n) ____ helps letters display prominently by adding a shadow behind the text.
outline
The WordArt ____ is the exterior border surrounding each letter or symbol.
bevel
A(n) ____ edge is angled or sloped and gives the effect of a three- dimensional object.
true
T/F- People remember at least one-third more information when the document they are seeing or reading contains visual elements.
false
T/F- Contrast determines the overall lightness or darkness of the entire image.
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.
true
T/F- Solid fill is one color used throughout the entire slide.
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.
engine
A search ____ is a program that finds Web sites, Web pages, images, videos, news, maps, and other information related to a specific topic.
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
database
A ____ is a collection of data organized in a manner that allows access, retrieval, and use of that data.
system
______ software consists of programs that control the operations of the computer and its devices.
cloud
____ storage is an Internet service that provides hard disk storage to computer users.
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.
photo
Some ink-jet printers, called ___ printers, produce photo-lab quality pictures and are ideal for home or small- business use.
mouse
A ____ is a pointing device that fits comfortably under the palm of your hand.
green
_____ computing involves reducing the electricity consumed and environmental waste generated when using a computer.
information processing cycle
Computers perform four basic operations — input, process, output, and storage. These operations comprise the _____.
data
____ is the collector of unprocessed items, which can include text, numbers, images, audio, and video.
system unit
The ___ is a case that contains electronic components of the computer used to process data.
crystal
The LCD monitor uses a liquid _____ display to produce images on the screen.
optical disc
A(n) __________ is flat, round, portable metal disc with a plastic coating.
operating system
A(n) ______ is a set of programs that coordinates all the activities among computer hardware devices.
hypertext transfer protocol
______ is the set of rules that defines how pages transfer on the Internet.
false
T/F- Like a virus or worm. a Trojan horse does not replicate itself to other computers.
true
T/F- A Web site is a collection of related Web pages.
false
T/F- The Internet is the world’s largest WLAN.
subhead
A _____ is a heading within the body of the newsletter.
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.
gradient
________ means the colors blend into one another.
insert
To insert clip art, display the ____ tab and click the Clip Art button to display Clip Art pane.
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
jump line
If an article spans multiple pages, use a continuation line, called a ______ to guide the reader to the remainer of the article.
justified
When the text in the body of a newsletter is _______ it means that the left and the right margins are aligned.
frame
A _____ is a container for text that allows you to position the text anywhere on the page.
SHIFT+F5
You press _____ to return the insertion point to your last editing position.
issue information line
The ______ identifies the specific publication.
pull-quote
A(n) _____ is text that is pulled, or copied, from the text of the documment and given graphical emphasis.
crop
Word allows you to _____, or remove edges from, a graphic.
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.
section breaks
To divide a portion of a document in multiple columns, you use ______.
drop cap
A(n) _____ is a capital letter whose font size is larger then the rest of the characters in the paragraph.
source
The item being copied is called the ______.
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.
true
T/F- Like drawing objects or pictures, text boxes can be formatted or have styles applied.
true
T/F- To move a text box, select it and use the arrow keys.
true
T/F- Leader characters, such as dots, often are used in a table of contents to precede page numbers.