IBA Final Exam – Flashcards

Unlock all answers in this set

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