Intergrating

Lakukan tugas rumah & ujian kamu dengan baik sekarang menggunakan Quizwiz!

non-theme font

A font that is not associated with a particular theme; non-theme fonts retain their appearance no matter what theme is used with the workbook.

IF function

A logical function that tests a condition and then returns one value if the condition is true and another value if the condition is false.

approximate match look up

A lookup where the lookup value falls within a range of numbers in the compare values in the lookup table.

exact match lookup

A lookup where the lookup value must match one of the compare values in the lookup table.

first-level item

A main item in a list.

gallery

A menu or grid that shows a visual representation of the options available or the selected button.

error value

A message in a cell that indicates some part of a formula is preventing Excel from returning a calculated value.

query by example (QBE)

A method of constructing a query by giving Access an example of the information you are requesting.

Touch Mode

A mode you can switch to if you are using PowerPoint on a device with a touch screen in which the ribbon increases in height so that there is more space around each, making it easier to use your finger to tap the specific button you need. Also, in the main part of the PowerPoint window, the instructions telling you to "Click" are replaced with instructions to "Tap."

record selector

. In a datasheet, the small square at the beginning of a row (also called the row selector) that you click to select the entire row.

theme font

A font associated with a particular theme and used for headings and body text in the workbook; theme fonts change automatically when you change the theme applied to the workbook.

sans serif font

A font that does not include extra strokes, such as Arial.

serif font

A font that has extra strokes at the end of each character, such as Times New Roman.

mixed reference

A cell reference that contains both relative and absolute references; for example, the mixed reference for cell D2 can have an absolute row (such as $D6) or an absolute column (such as D$6).

relative reference

A cell reference that is interpreted in relation to the location of the cell containing the formula.

absolute reference

A cell reference that remains fixed when the cell formula is copied to a new location

pie chart

A chart in the shape of a circle divided into slices like a pie that show data values as a percentage of the whole.

combination chart

A chart that combines two or more Excel chart types into a single graph.

column chart

A chart that displays data values as columns with the height of each column proportional to its value.

line chart

A chart that displays data values using a connected line rather than columns or bars.

sparkline

A chart that is displayed entirely within a worksheet cell.

XY scatter chart

A chart that shows the pattern or relationship between two or more sets of values.

file

A collection of data that has a name and is stored on a computer

web (World Wide Web)

A collection of electronic documents or files—called webpages—that are available through the Internet.

table

A collection of fields that describes a person, place, object, event, or idea.

theme

A collection of formatting for text, colors, images, and graphical effects that are applied throughout a workbook to create a specific look and feel.

style

A collection of formatting options that include a specified font, font size, font styles, font color, fill color, and borders.

group

A collection of related buttons for related commands organized on a ribbon tab.

database

A collection of related tables stored in the same file.

relational database

A collection of related tables stored in the same file.

website

A collection of related webpages connected by hyperlinks, or links, which you click to move from one webpage to another.

clustered column chart

A column chart that displays the data values in separate columns side-by-side.

stacked column chart

A column chart that places the data series values within combined columns showing how much is contributed by each series.

100% stacked column

A column chart that places the data series values within combined columns showing what percentage is contributed by each series.

bar chart

A column chart turned on its side so that the length of each bar is proportional to its value.

Slides tab

A column of numbered slide thumbnails providing a visual representation of several slides at once on the left side of the PowerPoint window.

style

A combination of several formats that you can add to an object.

Internet service provider (ISP)

A company that provides Internet access by connecting your computer to one of its servers via a telephone or cable modem.

record

A complete set of field values for a specific person, place, object, event, or idea.

low quality

A compression setting that compresses the videos as small as possible.

Presentation Quality

A compression setting that compresses the videos slightly and maintains the quality of the video.

Internet Quality

A compression setting that compresses the videos to a quality suitable for streaming over the Internet.

disk

A computer device for storing data.

drive

A computer device that can retrieve and sometimes record data on a disk

value

A condition usually consists of an operator, often a comparison operator, and a(n) _.

data bar

A conditional format that adds a horizontal bar to the background of a cell proportional in length to the cell's value.

cell highlighting

A conditional format that changes a cell's font color or fill color based on the cell's value.

folder

A container for files and subfolders.

theme

A coordinated set of colors, fonts, backgrounds, and effects.

condition

A criterion, or rule, that determines which records are selected in a query.

data callout

A data label that appears as a callout bubble pointing to a data marker.

query, table

A data source can be an Access table or _______, or an Excel or Word _______.

form

A database object you can create and customize to maintain, view, and print records in a database in different and useful ways.

Access

A database program you use to enter, organize, display, and retrieve related information.

subdata

A datasheet that displays the records related to the current record.

TODAY function

A date function that displays the current date.

chart title

A descriptive label or name for the chart area.

Hard Drive

A device mounted inside the computer's system unit that holds a large capacity and a fast access storage device.

Biometric Device

A device that authenticates a person's identity using personal characteristics.

Zoom box

A dialog box you can use to enter text, expressions, or other values.

stored

A disadvantage to linking is that source and destination files must be ________ together.

diagram

A drawing that visually depicts information or ideas and shows how they are connected.

backup

A duplicate copy of a file.

Favorites Center

A feature in Internet Explorer that provides tools for saving favorite webpages and viewing a history list of previously visited webpages.

History list

A feature in Internet Explorer that tracks the webpages you visit over a certain time period, not just during one browsing session.

Favorites list

A feature in Internet Explorer that you can use to store and organize a list of webpages you want to revisit.

SmartArt

A feature that allows you to easily create a diagram on a slide.

Goal Seek

A feature that automates the trial-and-error method by allowing you to specify a value for the calculated item, which Excel uses to determine the input value needed to reach that goal.

AutoFit

A feature that automatically adjusts the size of the font and line spacing in a text box to fit the content.

Format Painter

A feature that copies and pastes formatting from one cell or range to another without duplicating any data.

AutoFill

A feature that copies content (text, values, or formulas) and formats from a cell or range into an adjacent cell or range.c

Live Preview

A feature which previews the change on the slide so you can instantly see what the text will look like if you apply that format.

common field

A field that appears in more than one table, allowing you to connect the records in the separate tables.

calculated field

A field that you create with an expression that displays the results of the expression in a datasheet, form, or report, but does not exist as a field in the database.

primary key

A field, or a collection of fields, whose values uniquely identify each record in a database table.

Filter by Form

A filtering technique that lets you select all or part of a field value in a datasheet or form, and then display only those records that contain the selected value in the field.

subfolder

A folder contained within another folder.

nonunique(sort field)

The default category in the Navigation Pane; it arranges objects by type (tables, queries, forms, reports, and so on).

All Access Objects

The default category in the Navigation Pane; it lists all the objects in the database grouped by type (tables, queries, forms, reports, and so on).

ID field

The default field Access creates to serve as the primary key field for all new tables.

All Access Objects (Access)

The default group in the Navigation Pane; it displays all objects in the database.

Query1

The default query name is __________

embedding disadvantage

The destination file size increases to reflect the addition of the object from the source file.

linking advantage

The destination file size remains fairly small.

datasheet

The display of a table's contents in rows and columns, similar to a table or spreadsheet; each row is a separate record in the table, and each column contains the field values for one field in the table.

data type

The field property that determines what field values you can enter for the field and what other properties the field will have.

sort field

The field used to determine the order of records in a datasheet.

destination file

The file in which you want to insert an object created with another program and in another file.

data source(word)

The file that contains the variable information in main document.

source file

The file that initially contains the object being integrated into the destination file.

PMT function

The financial function that calculates the payment schedule required to repay a loan.

Recently Used Shapes

The first category in the Shapes gallery is ________ ___________ _________.

title slide

The first slide in a presentation and generally contains the title of the presentation plus any other identifying information you want to include, such as a company's slogan, the presenter's name, or a company name.

primary sort field

The first sort field specified that determines the order of records in an object.

fill

The formatting of the area inside of a shap

poster frane

The frame that appears on the slide when the video is not playing.

F2 key

The function key you press to switch between navigation mode and editing mode in a datasheet.

category values

The groups or categories that a series values belong to.

Gridlines

The horizontal and vertical lines on the spreadsheet.

navigation pane

The left pane of the File Explorer window that provides access to resources and locations on your computer.

root directory

The location at the top of the file system hierarchy where Windows stores folders and important files that it needs when you turn on the computer.

Address bar

The location in Internet Explorer in which you enter the address of the webpage you want to view.

Or logical operator

The logical operator you use in a query when you want a record selected if at least one of the specified conditions is met.

And logical operator

The logical operator you use in a query when you want a record selected only if two or more conditions are met.

ribbon

The main set of commands, located at the top of the PowerPoint window, organized into tabs and groups that you click to execute commands you need to work with PowerPoint.

tranisition

The manner in which a new slide appears on the screen in place of the previous slide during a slide show.

median

The middle value in data.

maintain(a database)

The mode in which Access selects an entire field value, and your typed entry replaces the highlighted field value.

editing mode

The mode in which you can insert or delete characters in a field value based on the location of the insertion point.

filename

The name of a file; provides important information about the file, including its contents and purpose.

Percentage Style %

The number format for percentages that adds the % symbol after the number and no decimal places.

comma style

The number format that adds a thousands separator to numbers, adds two decimal places, and lines up values within a column by their decimal points.

Accounting Formatting

The number format that places a currency symbol at the left edge of the column, adds a thousands separator to the value, and shows two decimal places; lines up numbers within a column by their currency symbols and decimal points; negative numbers are enclosed in parentheses.

currency formating

The number format that places a currency symbol directly to the left of the first digit of the currency value, adds a thousands separator to the value, and shows two decimal places; lines up numbers within a column by their decimal points; negative numbers are displayed with a negative sign.

high speed serial port allowing multiple connections at the same port

USB (Universal Serial Bus) port

Spam

Unsolicited messages sent to many recipients.

relative

Use ________references when you want to repeat the same formula with different cells.

effects

Use the Shape _________ button to add a shadow, glow, or soft edges to a shape.

#

Use the ______ wildcard symbol to match any single numeric character.

harmful programs that instruct your computer to perform destructive activities such as erasing a disk dive

Viruses

presentation media

Visual and audio aids that can be used to support key points and engage the audience's attention.

more than one LAN connected together The Internet is the largest example of a WAN

WAD (wide area network)

Computers and peripherals that use high frequency radio waves instead of wires to communicate and connect in a network

WLAN (Wireless Local Area Network)

directories

Web ________ list websites organized by categories.

web server

Webpages are stored on _______ which computer connected to the Internet that manage the display of the webpages.

Excel Chart Tools

When you click an Excel chart that is embedded in Word, the __________ contextual tabs appear on the Word Ribbon

ribbon

When you click an embedded object, the__________ in the destination program changes to include tabs and commands from the embedded object's source program.

nine

When you click the New slide button arrow, the New Slide gallery displays _________ available layouts

Common fields

When you create a form containing data from two tables that have a one-to-many relationship, Access uses the defined relationship between the two tables to automatically join the tables through the _ ________ _________ that exists in both tables.

criteria

When you create a query, you tell Access what _ should be used to select the data.

mail merge

When you merge a main document with a list of addresses from a data source, it is called a ________ _________

mail merege

When you merge a main document with a list of addresses from a data source.

thumbnail

When you point to the Internet Explorer button on the task bar, _________ images (miniature pictures) of all open tabs are displayed.

Slide

When you preview an animation, it plays automatically on the slide in the ________ pane.

Design

When you specify a sort using two or more nonadjacent sort fields, you must specify the sort fields in _ view.

!

Wildcard character that matches any character not within brackets

?

Wildcard character that matches any single alphabetic character

keywords

Words or phrases that you can enter in as search box that describe an image that you want to search for.

personal computer connected to a network

Workstation

Virtual memory

You are running two programs at once that require 10 megabytes each on a computer that only has 16 megabytes of RAM. What makes this possible?

Layout

You can change a form's theme in_____ view.

Heading

You can create PowerPoint slides by importing a Word document that has been created using only the _______ 1, 2, and 3 styles

CHART TOOLS

You can modify an embedded chart's appearance using commands on the ______ _______ contextual tabs that appear on the ribbon.

Normal

You can modify transitions in _______ or Slide Sorter view.

pure black and white

You can print slides in color, grayscale, or ______ ______ ______ ______.

keywords

You can search clip art using _________

template

You can search for a(n) _, or predefined database and download it from Office.com.

show

You can tell if a field will appear in the query datasheet if there is a check mark in the field's _ check box in the design grid.

Quick Access Toolbar

You can undo an error by clicking the Undo button on the ________

tables

You can use lists of Excel data to build _____ in Access.

axis title

Descriptive text that appears next to an axis.

handle the transmission protocol between a computer and its peripherals when you add a device to an existing computer, part of its installation includes adding its device driver to the computers configuration

Device driver

connects to: computers, LAN, modem, internet allows data to be transmitted at high speed

Ethernet port

F4

Excel allows you to cycle through the different reference types using the_____ key.

themes

Excel uses _______to maintain a consistent look within a workbook.

merge fields

Fields that contain instructions for replacing field placeholders with the variable information from a data source.

named collection of stored data

File

high speed serial port developed by Apple Computers, slightly faster than USB

FireWire (IEEE 1394) port

query

In Access, you use a _____ to extract(sort) information from a database

Click to Add column

In Datasheet view for a table, the datasheet column you can use to create a new field in the table.

Unhide Fields

In Datasheet view, the command that allows you to redisplay any hidden fields.

Group By operator

In Datasheet view, the command that allows you to remove the display of one or more fields.

protocol

In a URL, the text that reads "http://" is known as the ___________.

Simple

In a ____ interest, the interest is equal to a percentage of principal for each period that the money has been lent.

plus sign (+)

In a datasheet, a symbol indicating that a record has related records in another table

Or logical operator (Access)

In a datasheet, a symbol indicating that a record has related records in another table.

field selector

In a datasheet, the column heading (also called the column selector)that you click to select the entire column.

column selector

In a datasheet, the column heading (also called the field selector) that you click to select the entire column.

expand indicator

In a datasheet, the plus sign that lets you display the related records in the subdatasheet.

row selector

In a datasheet, the small square at the beginning of a row (also called the record selector) that you click to select the entire row.

main form

In a form based on two related tables, the form that contains data from the primary table.

navigation

In a form with a main form and a subform, there will be two sets of ________ buttons for use in selecting records from each of the tables.

primary key

In a given table, a field is defined as a(n) _ _ when its values uniquely identify each record in the table.

Large companies use this to provide centralized storage, processing, and management for large amounts of data.

Mainframes

Making Your Password More Secure

Make it long, using letters, numbers, symbols, and capital letters.

backing up

Making a copy of a database file to protect your database against loss or damage.

program intended to cause harm or convey information to others without the owners permission

Malware

Paste Special Dialog box

Offers additional choices for moving data on the Clipboard to the destination file.

hits

Pages returned in search results that contain content that matches your search words. Generally organized in order of relevancy.

logging in / logging on signing in with a username and password

Passwords

Network without a server All computers are equal

Peer to peer network

hardware components that are not part of the motherboard or CPU

Peripheral devices

Home/office computers- general computing tasks

Personal Computers (PC)

practice of sending e-mails to customers or potential customers of a legitimate web site asking them to click a link in the e-mail the link leads to a spoofed site

Phishing

allows you to manipulate digital photos

Photo editing software

cell style

Predefined formatting options that you can apply to cells in a worksheet.

allows you to project a presentation before a group, print it out for a quick reference, or transmit it to remote computers

Presentation software

Modifying data and executing commands

Processing

any device connected to the network

Node

Optional

Not all functions have arguments, and some functions have _ arguments, which are not required for the function to return a value, but can be included to provide more control over the returned value.

laptop computers small lightweight portable

Notebook computers

significant digits

The number of digits that should be displayed for a calculation; they indicate the accuracy of the measured and calculated values.

portrait

The orientation where the page is taller than it is wide.

landscape

The orientation where the page is wider than it is tall.

details pane

The pane in Windows Explorer that displays the characteristics of the folder or selected object.

plot area

The part of a chart that contains the graphical representation of the data series.

tab

The part of the ribbon that includes commands related to specific activities or tasks.

hardware

The physical components of a computer are referred to as ___.

Cell

The point where a column and a row meet.

design grid

The portion of the Query window in Design view in which you specify the fields and record selection criteria for the query you are creating

Phishing

The practice of sending e-mails to customers or potential customers of a legitimate Website asking them to click a link in the e-mail is called __.

phishing

The practice of sending e-mails to customers or potential customers of a legitimate website asking them to click a link in the e-mail is called __.

title

The presentation usually starts with __________ slide.

filter(excel)

The process of limiting data to a subset of the original values.

source program

The program used to create an object.

destination program

The program used to create the file in which you want to insert an object that was created using another program.

scale

The range of values displayed on a chart axis.

print area

The range or ranges in a worksheet that you specify to be printed.

data source

The range that contains the data displayed in a chart.

data series

The range that contains the values plotted on a chart.

aspect ratio

The ratio of an object's height to its width.

Run

The results of a query can be seen at any time by pressing the _ button.

Integration

The seamless nature of OLE among some applications is referred to as __.

#72

The search value _______finds 072, 172, 272, 372, and so on. Selected:

detail

The set of field values for the fields in a report that belong to a related table are called ______ records.

recordset

The set of records that results from running a query.

Fill Handle

The small black plus sign on the bottom right in an active cell.

Sizing handles

The small squares that appear in the corners and in the middle of the sides of a border of a selected object.

linking disadvantage

The source and destination files must be stored together.

embedding advantages

The source file and destination file can be stored separately.

field value

The specific value, or content, of a field in a record.

greater

The statement "A1 >= B1" tests whether the value in cell A1 is _______than or equal to the value in cell B1

Sum

The sum icon.

pencil symbol

The symbol that appears in a row selector to indicate that the record is being edited.

star symbol

The symbol that appears in a row selector to indicate that the row is the next one available for a new record.

fair use

The term ______ ____ refers to the legal use of copyrighted material for educational or nonprofit purposes.

intellectual

The term __________ property refers to all creations of the human mind.

refining

The text uses the phrase, ________ a search query, to mean either adding additional keywords to locate more specific information, or removing extraneous keywords that have led to incorrect/misleading results.

search query

The translation of your original question into a form that a search engine can understand. It is built from the keywords you identified as most related to your topic.

wildcard

The values specified for a search operation can be exact values or they can include a(n) _______character.

Print preview

The view of a report, form, or datasheet that shows you what the object will look like when printed.

Backstage View

The view that appears when you click the File tab on the ribbon, and contains the commands that allow you to manage your presentation files and PowerPoint options.

home page

The webpage that appears when the browser starts. The main page of a website is also this

background image

The________does not affect any cell's format or content.

helps the computer carry out its basic operating tasks -Operating system -Utilities -Device drivers -Programming languages

System software

sizing handles

There are ___________ ____________ around the selected image to resize the image.

Terabyte One trillion bytes

TB

date

TODAY is an example of a(n) _____ function.

right-click

To get correct spelling you can ____ ____ the flagged word in the Outline tab.

three (Subtle, Exciting, & Dynamic)

Transitions are organized into _____________ categories.

IF

The _ function is a logical function that returns one value if the statement is true and returns a different value if the statement is false.

Insert Function Dialog Box

The ___ ____ ____ ___organizes all of the functions by category and allows you to search for functions that perform particular calculations.

placeholder

A region of a slide reserved for inserting text or graphics.

databases

A relational DBMS provides protection of _ through security, control, and recovery facilities.

USB drive

A removable disk you can plug into your computer and use to store files.

View tab

A tab on the File Explorer window's ribbon that contains options for specifying the view of the window.

lookup table

A table that stores the data you want to retrieve with a lookup function in categories.

design

A table's _ includes the field names and characteristics of the fields themselves, plus any layout changes to the datasheet.

presentation

A talk (lecture) or prepared file in which the person speaking or the person who prepared the file—the presenter—wants to communicate with an audience to explain new concepts or ideas, sell a product or service, entertain, train the audience in a new skill or technique, or any of a wide variety of other topics.

Clipboard

A temporary storage area available to all Windows programs on which text or objects are stored when you cut or copy them.

clipboard

A temporary storage area for files and information that you have copied or moved from one place and plan to use somewhere else.

theme family

A theme and its variants with different coordinating colors and sometimes slightly different backgrounds.

Mini Toolbar

A toolbar that appears when you first select text, and contains commonly used buttons for formatting text.

Mini Toolbar

A toolbar that contains buttons to perform common formatting options for a selection.

Entrance

A type of animation effect where text and objects are not shown on the slide until the animation occurs.

Motion Paths

A type of animation effect where text and objects follow a path on a slide.

exit

A type of animation effect where text and objects leave the screen before the slide show advances to the next slide.

emphasis

A type of animation effect where text and objects on the slide change in appearance or move.

exact match

A type of query in which the value in the specified field must match the condition exactly in order for the record to be included in the query results.

Teleconference

A type of remote conferencing allows people at different locations to talk to one another by telephone.

Web Conference

A type of remote conferencing that takes place over an internet connection.

IP address

A unique number consisting of four sets of numbers from 0 to 255, separated by periods (such as 216.35.148.4), that identifies the server or computer connected to the Internet.

domain name

A unique string of letters and/or numbers that are easy to remember, such as Microsoft.com

points

A unit of measurement for indicating the size of text.

constant

A value in a formula that doesn't change.

Presenter view

A view in PowerPoint that allows you to view your slides with speaker notes on one monitor, while the audience sees only the slides in ordinary Slide Show view on another monitor or screen.

text

Although dates and times in Excel appear as_____ they are actually numbers.

second-level item

An item beneath and indented from a first-level item; sometimes called a subitem.

control

An item on a form, report, or other database object that you can manipulate to modify the object's appearance.

insertion point

An object on the screen that indicates where text will appear when you start typing, usually appears as a blinking line.

Slide Master

Can have a picture added to all your slides

duration

Change the_______ setting to change the speed of a transition.

promoting

Changing a second-level bullet into a first-level bullet is called ______ the item.

road message gets put on to reach the receiver, such as a telephone or coaxial cabl

Channel

Links dialog box

You manage your linked objects using the ________ ______ ________

form

You use a(n) _ to enter, edit, and view records in a database.

absolute

You use an ______reference when you don't want a cell reference to change

Mail Merge Recipients

You use the _______ dialog box to select the people who will receive a merged letter.

Syntax

_ is a set of rules which specifies how a function should be written.

operating systems

__ allocated system resources, manage storage space, maintain security, detect equipment failure, and control basic input and output.

library

in File Explorer, a container for folders and files that organize files by category—documents, music, pictures, and videos, no matter where these files are stored, such as your hard disk, removable drives, and network.

subform

in a form based on two related tables, the form that contains data from the related table.

keeps track of schedules, appointments, contacts and to-do lists

information management software

deep web

information stored on databases rather than on webpages

created by user within a software

data file

logical function

function that works with statements that are either true or false.

Speaker notes

information you add about slide content to help you remember to bring up specific points during the presentation; also called notes.

run (a query)

it answers a query and display the results.

Which of the following is NOT a personal computer? Laptop desktop mainframe all of the above

mainframe

general formatting

the number format that, for the most part, displays values exactly as they are typed.

argument

the numbers, text, or cell references used by the function to return a value.

Links dialog box

used to break a link

Navigation pane

used to see the outline of a document

hard disk

A storage device permanently housed inside the computer case.

can

A style ________ be combined with custom formatting.

occurs when you copy and paste source data in the new file

Embedding

return values

The data values you want to retrieve from a lookup table.

secondary sort field

. A second field that determines the order of records in an object that are already sorted by the primary sort field.

sizing handle

. A square or dot on the edge of a selection box that is used to change the object's width and height.

comparison operator

. A symbol that indicates the relationship between two values.

Simple Query Wizard

. An Access wizard that lets you quickly select the records and fields to display in a query datasheet.

query

. A question you ask about the data stored in a database. In response, Access displays the specific records and fields that answer your question.

embedded chart

. A chart object placed in a worksheet.

date function

. A function that inserts or calculates dates and times.

compacting

. A process that rearranges the data and objects in a database to decrease its file size, thereby making more space available and enhancing the performance of the database.

gigabyte GB

1 billion bytes of data.

SkyDrive

A Microsoft service that provides online storage space for your files.

Windows Explorer

A Windows 7 tool that displays the contents of your computer and uses icons to represent drives, folders, and files.

File Explorer

A Windows 8 tool that displays the contents of your computer and uses icons to represent drives, folders, and files.

Heading 2

A Word paragraph formatted with ________ style will become the first level of text on a PowerPoint slide.

sans serif font

A _______________, such as Arial, does not include decorative strokes on each character.

conditional format

A _______applies formatting only when a cell's value meets a specified condition.

fill color

A background color that can be added to cells to help differentiate parts of a worksheet or highlight data.

datasheet selector

A box in the upper-left corner of a datasheet that lets you select the entire datasheet.

selection box

A box surrounding an object such as a chart that is used to move or resize the object.

More Button

A button that appears on all galleries that contain additional items or commands that don't fit in the group on the ribbon.

Quick Analysis Tool

A button that appears whenever you select a range of cells, providing access to the most common tools for data analysis and formatting for the selected range.

Phishing

A form of criminal activity using social engineering techniques to fraudulently acquire sensitive information, such as passwords and credit card details, by masquerading as a trustworthy person or business in an electronic communication.

Long Date Format

A format for dates that displays the day of the week and the full month in addition to the day of the month and the year.

RGB color model

A format used to create custom colors by specifying varying intensities of red, green, and blue.

report

A formatted printout (or screen display) of the contents of one or more tables or queries in a database.

Median function

A function that determines the middle value in a range.

WORKDAY funtion

A function that displays the date of a weekday that is specified number of weekdays past a starting date.

MIN Function

A function that displays the minimum value in the range.

lookup function

A function that finds a value in a table of data and inserts it in another location in the worksheet, such as a cell or in a formula.

aggregate function

A function that performs an arithmetic operation on selected records in a database.

VLOOKUP function

A function that returns values from a vertical lookup table.

COUNTA function

A function that tallies how many cells in specified range are not blank (contain numbers, dates, or text).

data marker

A graphical representation of a value in a chart, such as a column or pie slice.

relational

A group of related tables is called a(n) _ database.

Add & Delete Group

A group on the Fields tab in Table Datasheet view that contains options for adding different types of fields to a table.

adjustment handles

A handle that appears on a selected object that you can drag to change the object's proportions without changing the size of the shape.

rotate handle

A handle that appears on a selected object that you can drag to rotate the object.

legend

A key that identifies the colors or the shapes used in a worksheet or a chart.

leader line

A line that connects a data label to its corresponding data marker.

gridline

A line that extends the value of a major or minor tick mark across the plot area of a chart.

tick mark

A line that identifies the units at regular intervals on a chart axis.This answer is correct. The correct answer is: A line that identifies the units at regular intervals on a chart axis. 43. ungrouped sparklines Selected:

field list

A list containing the fields for a table, with the table name at the top and the fields listed in the order in which they appear in the table.

bulleted list

A list of items with some type of bullet symbol in front of each item or paragraph.

numbered list

A list similar to a bulleted list except that numbers appear in front of each item instead of bullet symbols.

unnumbered list

A list that does not have bullets or numbers preceding each item. Unnumbered lists are useful in slides when you want to present information on multiple lines without actually itemizing the information.

search box

A location on a webpage in which you can enter keywords,which are specific words and phrases that describe a topic of interest. You then click the search button and the browser displays a list of pages pertaining to your topic.

file path

A notation that indicates a file's location.

animation sequence

A number that appears next to an object on a slide in the slide pane that indicates the order in which the item will animate during the slide show. The animation sequence numbers only appear on the slide when the ANIMATIONS tab is selected on the ribbon

automatic page break

A page break Excel sets automatically when the page of the printout is full.

manual page break

A page break you insert to indicate where a new page of the printout should start.

task pane

A pane that opens to the right or left of the Slide pane and contains commands and options related to the task you are doing.

Notes Pane

A pane you can display below the Slide pane in Normal view in which in image of the slide appears in the top half of the presentation window and the notes for that slide appear in the bottom half.

exploded pie chart

A pie chart that moves one slice away from the others as if someone were taking the piece away from the pie.

text placeholder

A placeholder designed to contain text, and usually display text that describes the purpose of the placeholder and instructs you to click so that you can start typing in the placeholder

Content placeholder

A placeholder designed to hold several types of slide content including text, a table, a chart, SmartArt, a picture, or a video.

wildcard character (*, ?, [ ], -, #)

A placeholder you use when you know only part of a search value or when you want the search value to start or end with a specific character or match a certain pattern.

theme

A predefined set of formats including colors, fonts, and other effects that enhance a database object's appearance and usability.

Microsoft PowerPoint 2013

A presentation graphics program that you can use to create and display visual and audio aids on slides to help clarify the points you want to make in your presentation or to create a presentation that people view on their own without you being present.

Live Preview

A preview of how a workbook would be affected by an option in a gallery.

foreign key

A primary key field from one table that you include as a field in a second table to form a relationship between the two tables.

Worm

A program that copies itself repeatedly, using up resources and possibly shutting down the computer or network.

web browser

A program that locates, retrieves, and displays webpages.

copyright

A protection granted by law to the author or creator of an original work who creates a tangible expression of that work or creation that says the work cannot be used by another without permission from the author or creator.

select query

A query in which you specify the fields and records you want Access to select, and the results are returned in the form of a datasheet

comparison operator

A query operator that asks Access to match the values of a database field to the selection criteria is known as a(n) _ _.

grouped report

A report in which the data from a record in the primary table appears as a group, followed on subsequent lines of the report by the joined records from the related table.

contextual tab

A ribbon tab that appears only in context—that is, when a particular type of object is selected or active—and contains commands for working with that object.

Quick Access Toolbar

A row of buttons on a program's title bar that give you one-click access to frequently used commands.

Firewall

A security system consisting of hardware and/or software that prevents unauthorized intrusion.

toolbar

A set of buttons for completing current tasks.

Navigation Pane

A set of buttons found at the bottom of a table datasheet or form that you use to move through the records in the table.

navigation buttons

A set of buttons found at the bottom of a table datasheet or form that you use to move through the records in the table.

font

A set of characters that employ the same typeface, such as Arial, Times New Roman, and Courier.

font

A set of characters with the same design

control layout

A set of controls grouped together in a form or report so that you can manipulate the set as a single control.

record

A set of data such as first name, last name, address, etc. for a specific person is a(n) _.

filter

A set of restrictions you place on the records in an open datasheet or form to temporarily isolate a subset of the records.

protocol

A set of rules that computers use to exchange files. Hypertext Transfer Protocol (HTTP) and File Transfer Protocol (FTP) are two of the most common protocols used on the Internet.

ungrouped sparklines

A set of sparklines that can be formatted individually.

grounded sparklines

A set of sparklines that share a common format.

field

A single characteristic or attribute of a person, place, object, event, or idea.

chart animation

A slowed down effect of changing data source values, making it easier to see how changing one value affects the chart.

fill handle

A small black square in the lower-right corner of a selected cell or range that you drag over an adjacent cell or range to copy the original content and formatting into the selected range.

relational database management system

A software program in which data is organized as a collection of tables, and relationships between tables are formed through a common field.

database management system (DBMS)

A software program that lets you create databases and then manipulate data in them.

navigation mode

A sort field for which more than one record can have the same value.

unique (sort field)

A sort field whose value is different for each record.

Office Clipboard

A special a Clipboard available only to Microsoft Office applications. Once you activate the Office Clipboard, you can store up to 24 items on it and then select the item or items you want to paste.

archive

A special type of folder containing compressed files.

template

A special type of presentation file that has a theme applied and contains text, graphics, and placeholders to help direct you in creating content for a presentation.

expression

A statement containing a combination of database fields, constants, and operators that you define in a query to perform a calculation.

Normal view

A view in PowerPoint that displays slides one at a time in the Slide pane, allowing you to see how the text and graphics look on each slide, and displays thumbnails of all the slides in the presentation in the Slides tab on the left.

Slide Sorter View

A view in which all the slides in the presentation are displayed as thumbnails in the window; the Slides tab does not appear.

Notes Page View

A view in which the image of the slide appears at the top of the page, and the notes for that slide appear underneath the slide image.

graph

A visual representation of a set of data values; also called a chart.

what-if-analysis

A way to explore the impact that changing input values has on the calculated values in a workbook.

trial-and-error method

A way to perform what-if analysis by changing one or more of the input values to a value you estimate to see how it impacts the calculated results.

Slide Show View

A way to view the presentation such that each slide fills the screen, one after another.

search engine

A website used to locate webpages related to the keywords you enter. Use a program called a spider or bot to compile databases of webpages that are indexed by keywords. It searches its database to find webpages that include those keywords, and shows the results as a list of links to those webpages.

Internet

A worldwide collection of computer networks that allows people to communicate and exchange information.

calculated

A(n) _ field displays the results of an expression.

Logical

A(n) _ function is a function that works with values that are either true or false.

Comparison

A(n) _ operator is a symbol that indicates the relationship between two values.

mixed

A(n) _ reference contains both relative and absolute references.

bulleted item

A(n) ____ _____ is one paragraph in a bulleted list.

domain name

A(n) ______ _____ identifies the realm in which a server or computer resides.

subtitle text placeholder

A(n) ______ ______ ______is designed to hold the presentation's subtitle.

font

A(n) ______ is a design of a set of characters.

web server

A(n) ________ ______ is a computer that manages the display of Web pages on a Web site.

task

A(n) ________ pane is a pane that opens to the right or left of the Slide pane and contains commands and options related to the task you are doing.

copyright

A(n) _________ is a protection granted by law to the author or creator of an original work who creates a tangible expression of that work or creation.

print area

A________can cover an adjacent or nonadjacent range.

query

Access has a built-in _ language that allows you to ask questions and obtain answers about your data.

themes

Access uses _ to format the objects in a database.

active

After clicking on the text box placeholder the border becomes a dashed line which indicates that the text box is ______ or selected.

intellectual property

All creations of the human mind, such as original ideas and creative works presented in a form that can be shared or that others can recreate, emulate, or manufacture. On a webpage, intellectual property includes the text, images, and videos on the page, as well as the design of the page itself.

Date, Addressee, Subject, Body, Writer, and Reference Initials

All the parts of a simplified memo(in order) are:

contacts

Among the pages common to many websites is the ___________ (s) page, which contains information about how to get in touch with the owner/manager of the website.

Short Text

An Access data type that allows field values containing letters, digits, and other characters.

AutoNumber

An Access data type that automatically assigns a unique number to a record.

AutoFilter

An Access feature, available by clicking the arrow to the right of a field name in Datasheet view for a table or query, that enables you to quickly sort and display the field's values in various ways.

Form Wizard

An Access tool that asks you a series of questions, and then creates a form based on your answers.

Query Wizard

An Access tool that asks you a series of questions, and then creates a query based on your answers.

Report Wizard

An Access tool that asks you a series of questions, and then creates a report based on your answers.

Form tool

An Access tool that creates a form containing all the fields in the table or query on which the form is based.

Expression Builder

An Access tool that makes it easy to create an expression by providing boxes for entering the expression, options for displaying and selecting common operators, and one or more lists of expression elements, such as table and field names.

Report Tool

An Access tool that places all the fields from a table or query on a report.

Query Wizard

An Access tool that prompts you for information by asking a series of questions and then creates the appropriate query based on your answers.

AVERAGE function

An Excel function that calculates the average value from a collection or numbers.

0 to 255

An IP address contains four sets of numbers from _ to _.

short date format

An abbreviated format for dates in the format mm/dd/yyyy.

linking

An advantage of _______ is that the destination file remains fairly small.

secondary axis

An alternate axis in a chart against which other data series with a different scale is plotted; usually appears on the right side of a chart.

status bar

An area at the bottom of the PowerPoint window that provides information about the file and contains commands for viewing the presentation in different ways and for zooming in on the view.

Format Pane

An area that provides a collection of commands to format the selected chart element.

required arguement

An argument that is needed for the function to return a value.

optional argument

An argument that is not required for the function to return a value.

animation

An effect applied to an object that makes the object appear, disappear, or move.

file icon

An icon that indicates a file's type.

chart element

An individual part of a chart, such as the title or the legend.

subitem

An item beneath and indented from a first-level item; also called a second-level item.

textbox

An object that contains text.

file system

An operating system's hierarchy of folders and files, which ensures system stability and enables Windows to find files quickly.

mode

Another approach is to calculate the most common value in the data, otherwise known as the _

detects spyware and deletes them

Anti-spyware software

searches executable files for the sequences of characters that may cause harm and disinfects the files by erasing or disabling those commands

Antivirus software (virus protection software)

object

Anything that can be manipulated as a whole, such as a chart, table, picture, video, sound clip, block of text, or almost anything else you can create on a computer.

ScreenTip

Appears when you rest the mouse pointer on a button, and identifies the name of the button; sometimes it also displays a key combination you can press instead of clicking the button and information about how to use the button.

enables you to perform specific computer tasks

Application Software

Ergonomics

Applied science devoted to comfort, efficiency, and safety in the workplace.

adjacent

AutoFill, which copies content and formats from a cell or range into an _______ cell or range.

quarter

Avoid putting information on the bottom ________ of the slide because people in the back of a large room will not be able to see it.

search engine

Because they are the most effective way to locate information on the web, the Address bar in Internet Explorer provides access to a(n) _________ _______.

heading 2 style in word

Become first-level bulleted items in PowerPoint

Heading 1 style in Word

Become slide titles in PowerPoint

preview

Before you print a Web page, it's a good idea to _______ it to see how it will look.

"On" (1) "off" (0) computer language

Binary digits or bits

Optical storage device 25 GB, stores high definition video

Blu-ray

uses short range radio waves to connect a device wirelessly to another device or to the Internet

Bluetooth

objects

Both shapes and pictures, such as photos and clip art, are treated as _________ in PowerPoint.

date, alphabetical

By default, the entries in the History list are organized into _____ folders, the _________ order.

Optical storage device stores 700 MB of data

CD

Complementary metal oxide semiconductor memory Semi-permanent information about where essential software is stored.

CMOS memory

high speed memory chip on motherboard or CPU Stores frequently and recently accessed data and commands

Cache memory

Apply to All

Click the ________ __________ ________ button to apply a selected transition to all the slides in the presentation.

Cancel

Click the _________button in the Find and Replace dialog box to stop the search operation.

network with servers that act as the central storage location

Client / Server network

simple drawings that are included as collections with many software packages

Clip art

grouping

Columnar, Tabular, Datasheet, and Justified are ________ choices.

HTTP (Hypertext Transfer Protocol) FTP (File Transfer Protocol)

Common protocols on the Internet

Electronic device that accepts information and instructions from a user, manipulates the information for retrieval later

Computer

Hardware - Physical components Software - programs or lists of instructions Operating system - software controlling the basic input and output commands

Computer system made of

Animation Painter

Copies animation to other objects.

Print Your Handouts From Microsoft Office Word 2003

Creates more elaborate handouts than what you can make in Microsoft Office PowerPoint 2007.

Optical storage device 4.7-15.9 GB

DVD

transmits video digitally

DVI (Digital Video Interface)

smart guides

Dashed red lines that appear as you drag a selected object, indicating the center and the top and bottom borders of the objects. Smart guides can help you position objects so they are aligned and spaced evenly.

Words, numbers, figures, sounds, and graphics that describe people, events, things, and ideas.

Data

data path between the microprocessor RAM and the peripherals along which communication travels

Data bus

collection of information stored on one or more computers organized in a uniform format of records and fields

Database

lets you collect and manage data

Database management software

handles transmission protocol between computer and peripheral devices computer program that can establish communication because it contains information about the characteristics of your computer and of the device

Device drivers

tabbed browsing

Displays multiple webpages in the same browser window.

Slides Pane

Displays the current slide as it will appear during your slide show.

includes word processing software, desktop publishing software, email editions, and web authoring software

Document production software

icon

Each object in the Navigation Pane has a unique _, or image to indicate the type of object.

1 byte = one character

Eight bits = 1 byte

plagiarism

Failure to cite the source of material that you use in producing your own work.

prevents other computers on the internet from accessing a computer and prevents programs on a computer from accessing the internet without the computer user's permission can be either hardware or software software firewalls track all incoming and outgoing traffic

Firewall

Can be written to more than once Small, portable card encased in hard plastic data can be written and rewritten Used in digital cameras, handheld computers, video game controllers USB Flash Storage Device

Flash memory

points

Font sizes are measured in _________, where one is approximately 1/72 of an inch.

complex

For more _______ patterns, you can use the Fill Series dialog box

Series

For more complex patterns, you can use the _______dialog box instead of the AutoFill feature.

font style

Formats that can applied to a font such as italic, bold, bold italic, underline, strikethrough, and color.

conditional formating

Formatting applied to a cell when its value meets a specified condition.

Main

Forms for tables that have a one-to-many relationship will have a(n) ______ form and a subform.

Gigabyte One billion bytes

GB

names

Give fields descriptive _ so that you can easily identify them when you view or edit records.

allows you to create illustrations, diagrams, graphs, and charts

Graphics software

high-speed serial port that transmits video and audio digitally

HDMI (High Definition Multimedia Interface) port

Run on batteries & fit in palm of hand

Hand-held Computers

Common magnetic storage: magnetic oxides covering metal plates sealed in a case inside computer

Hard disk

ISP (Internet server provider)

Home connections to the Internet require an account with a(n) ___ ___ ___ (use acronym).

Landscape

If contents do not fit across the Excel page, change the orientation to __________orientation.

embed

If you _______ an Excel chart into Word, and then modify the chart in Word, the source file remains unmodified.

Live Preview

If you click the Paste button arrow, a menu appears; you can point to the buttons on that menu to see a(n) ____ _____ of the pasted object.

Change, Source

If you have changed the location of the source file for a linked object, you need to identify the new location by navigating to the Links dialog box, clicking the ______ _______ button, and then navigating to the new location of the source file.

Dot Leader Tabs

If you need to set up a table of contents for your research project.

Document

If you save a custom theme to the ____________ Themes folder, that theme will be listed in its own row above the installed themes in the Themes gallery.

Link & Keep Source Formatting

If you're in Word and want to link a chart, and you're happy with the way the chart is currently formatted, then you would choose the ______ _ ____ _____ ___________ button in the Paste Options menu.

merging

In a mail merge, combining the main document with the data source so that Word replaces the merge fields in the main document with the appropriate information from the data source.

Hide fields

In a query, an operator that allows you to combine two or more conditions.

comparison operator

In a query, an operator that asks Access to compare the value in a database field to the condition value and to select all the records for which the relationship is true.

Filter by Section

In a query, an operator that divides the selected records into groups based on the values in the specified field.

detail record

In a report based on two tables, the set of field values displayed for each field in the related table.

parentheses

In complex expressions, you can enclose calculations in _ to indicate which ones should be performed first.

alphabetical

In the History list, within each site folder, the webpages you visited appear in ____________ order.

Design grid

In the _ _, you include the fields and record selection criteria for the information you want to see.

plagiarism

Including two sentences from someone else's work in your research paper, without using quotation marks or attribution, is an example of _____

Paragraph

Increase List Level and Decrease List Level buttons can be found in the ________ group on the Home tab.

table

Information arranged in horizontal rows and vertical columns.

footer

Information that appears at the bottom of slides, notes pages, or handouts of a presentation.

header

Information that appears at the top of notes pages or handouts of a presentation.

print tittle

Information that appears on every printed page; specified as rows or columns to repeat on the top or left of each page.

notes

Information you add about slide content to help you remember to bring up specific points during the presentation; also called speaker notes.

uses infrared light waves to beam data from one device to another

Infrared technology

data typed into computer

Input

the seamless nature of OLE among some applications

Integration

Favorites Center

Internet Explorer brings together the Web pages you have recently visited and the pages you go to on a regular basis in one central location -- the _______ ______.

Has a Heading TO: FROM: DATE: SUBJECT:

Is true about a standard style memo.

Query wizard

It is a good idea to build specialized and complicated queries by using the _ _.

Kilobyte One thousand bytes

KB

computers and peripherals located close to each other

LAN (Local Area Network)

major tick marks

Lines that identify the main units on a chart axis.

minor tick marks

Lines that identify the smaller intervals between major tick marks on a chart axis.

Sign in link

Link that appears in the upper-right corner of the PowerPoint window that lets you sign into your Office account.

allows you to create a connection between the source data and the copy in the new file the link updates the copy every time a change is made to the source data

Linking

Megabyte One million bytes

MB

Modern Language

MLA stands for ______ _____ Association.

Copyright Software

Mary made a copy of her favorite music CD and gave it to her friend as a gift and broke this law.

the speed of the microprocessor

Megahertz is a measurement of __.

storage locations on the motherboard RAM Random access Memory Cache Memory Virtual memory ROM Read-only memory CMOS Complementary metal oxide semiconductor memory

Memory

thumbnail

Miniature image of a picture.

thumbnails

Miniature images of all the slides in the presentation that appear in the Slides tab on the left side of the PowerPoint window when in Normal view.

which contains the processing hardware -- the computer's major electronic components- and is located inside the computer

Motherboard

allows you to record digital sound files, video files, and animations

Multimedia authoring software

connects one computer to other computers and peripheral devices

Network

establishes the communications protocols that will be observed on the network controls the traffic flow of data traveling through the network

Network Software

text

Once you enter text into a text placeholder, it is no longer a placeholder and becomes an object called a(n) _______ box.

formatting

One of the benefits of conditional _ is that it helps you analyze data by highlighting significant trends in data.

Source

One option when linking an Excel chart to a Word document is Link & Keep ________ Formatting.

source

One option when linking an Excel chart to a Word document is Link & Keep ________ Formatting.

Theme

One paste option when pasting an Excel chart into Word is Use Destination _______ & Embed Workbook.

provides a graphical user interface (GUI) that acts as a liaison between the user and the computer

Operating environment

-controls the input and output (I/O) -allocates system resources -manages files on storage devices -guards against equipment failure

Operating system

CD, DVD, Blu-ray on which data is recorded as a trail of tiny pits

Optical Storage devices

result of computer processing your input

Output

network that allows two or more devices located close to each other to communicate or to connect a device to the internet

PAN (Personal Area Network)

used by a programmer to write computer instructions Instructions translated into electrical signals that the computer manipulates and processes

Programming languages

Freeware

Programs offered on the internet at no cost and are usually unreliable.

rules that transfer data between sender and receiver

Protocol

Distribution Lists

Provides an easy way to send electronic messages to a group of people.

Design Template

Provides consistency in design and color throughout the entire presentation.

Temporary memory changes while computer is on Can be upgraded to make computer faster.

RAM Random Access Memory

Volatile

RAM is often referred to as __ memory

Permanent Storage for instructions used by the computer

ROM Read Only Memory

the computer or device at the message's destination file

Receiver

device that controls traffic between network components usually has a built in firewall

Router

Web Archive, single file

Save option that saves a picture of the current webpage

Webpage, Text File

Save option that saves text from the webpage without saving graphics or styles

relevance

Search engine hits are generally organized in order of _________.

spider

Search engines use a program called a(n) _______ or bot to compile databases of webpages that are indexed by keywords.

steps a computer owner takes to prevent unauthorized use of or damage to the computer

Security

computer originating message

Sender

acts as the central storage location for programs provides mass storage for most of the data used on the network

Server

two placeholders.

Slides can include only ________ _________

Expansion cards plug into electrical connectors on the motherboard called __.

Slots

Phone Calls Connect to: Internet, check email etc.

Smartphones

relative

Some cell references are called _ references because they are always interpreted in relation to the location of the cell containing the formula.

1922

Songs published earlier than ____ are in the public domain in the United States.

conditional formatting

Special formatting applied to field values that meet specified conditions.

keywords

Specific words and phrases that describe a topic of interest and can be used to search for information on that topic.

technical details about components

Specifications

website set up to look like another web site, but which does not belong to the organization portrayed in the site has a URL (address on the Web) that looks similar to a URL from the legitimate site usually set up to try to convince customers of the real site to enter personal information

Spoofed site

a numerical analysis tool used to create a worksheet composed of a grid of columns and rows you type data into the cells, and enter mathematical formulas into other cells that reference the data

Spreadsheet software

programs contained with other programs that track a computer users internet usage and send this data back to the company or person that created it usually installed without the computer users permission or knowledge

Spyware

personal computer that is not connected to a network

Standalone computer

Magnetic storage media Optical storage devices Flash memory

Storage media

at least eight characters consists of upper - and lowercase letters and numbers does not include common personal information

Strong Password

Largest/Fastest computers. Processes enormous volumes of data.

Supercomputers

data label

Text associated with an individual data marker.

hyperlink

Text or a graphic that, when clicked, connects to and displays another part of the webpage or a different webpage. Also called link.

watermark

Text or an image that appears in the background of each page behind other content.

current Web page.

The "Web Archive, single file (*.mht)" option for saving a Web page saves a picture of the ____ ____ ____

Archive

The "Web _________, single file" save option saves a "picture" of the current Web page, without any of the page elements.

standard colors

The 10 colors—dark red, red, orange, yellow, light green, green, light blue, blue, dark blue, and purple—that are always available regardless of the workbook's theme.

theme colors

The 12 colors that belong to the workbook's theme.

seven, seven

The 7x7 rule means no more than _______ items per slide, with no more than _____ words per item.

Form Wizard

The Access utility that allows you to choose some or all of the fields in a table or query to use as the basis for a form, choose fields from other tables and queries, and display the selected fields in any order on the form.

Report Wizard

The Access utility that asks you a series of questions and then creates a report based on your answers.

Layout View

The Access view that allows you to modify many aspects of a form's layout and design.

Datasheet view (for a table)

The Access view that shows a table's contents as a datasheet in rows and columns.

Form View

The Access view you use to view, enter, and maintain data in the table on which a form is based.

COUNT function

The Excel function that tallies how many cells in specified range contain numbers or dates.

eight

The Form Wizard allows you to select one of _______layout types.

Function

The Logical button is part of the ___________Library group.

FORMAT

The PICTURE TOOLS _______ tab appears when a picture is selected.

pictures.

The Remove Background tool is available only to __________

Empahsis

The Underline animation is an example of a(n) ___________ animation that is available only to text.

Date type

The _ _ determines what field values you can enter for the field.

Insert Function

The ______ dialog box organizes all of the functions by category and allows you to search for functions that perform particular calculations.

Find

The __________ button lets you search for specific data in a form and display only the qualifying records.

*

The __________ wildcard character allows you to match any number of characters.

-

The __________ wildcard character allows you to match any one of a range of characters.

mode

The ____is most often used with data that has only a few possible values

URL (uniform resource locator)

The address of the webpage you want to view.

interst

The amount added to the principal by the lender.

principal

The amount of money being loaned

cell

The area where a row and column intersect in a table.

layout

The arrangement of placeholders on the slide; in SmartArt, the arrangement of the shapes in the diagram.

primary axis

The axis against which data series in a chart is plotted; usually appears along the left side of a chart.

horizontal axis(category axis)

The axis that displays the category values from each data series.

vertical axis (value axis)

The axis that displays the series values from the data series.

navigation bar

The bar on the left side of Backstage view that contains commands for working with the file and program options.

compare value

The categories used for matching to a specified lookup value in a lookup table.

lookup value

The category you want to find in a lookup table.

chart area

The chart and all of the other chart elements.

field values

The columns in Datasheet view contain the _ _ for each field in the table.

peripheral devices

The computer needs additional components called __ to accomplish its input, output, and storage functions

exact match

The condition that requires a value in a specified field to be identical to the specified condition is called a(n) _ _.

Field Value

The content of a field is the _ _.

Slide Master View

This view allows you to see and change placeholders and layouts as well as make across-the-board changes, such as adding a logo to all of your slides.

serif

Times New Roman, a _____ font, has extra decorative strokes at the end of each character.

delay

To add a pause before an animation, increase the time in the ________ box in the Timing group.

logical operator

To add, change, and delete records in database tables to keep them current and accurate.

update (a database)

To add, change, and delete records in database tables to keep them current and accurate.

Outline

To change the color, weight, or style of a shape's border, use the Shape ________ button.

Sorter

To change the slides' order in your presentation you should use Slide _______

Close

To close an open database without exiting the Access program, click the File tab to display Backstage view, and then click _.

merge

To combine, such as several cells into one cell.

AutoFill

To copy only the formats or only the formulas, click the ______ Options button and select the appropriate option.

relationship

To create a form based on two tables, you must first define a(n) _____ between the two tables.

extract

To create an uncompressed copy of a compressed file in a folder you specify.

Criteria

To define a condition for a field, you place the condition in the field's ________box in the design grid.

history list

To delete a(n) ________ _______, click the Safety button on the Command bar, then click Delete Browsing History.

blank

To deselect the clip art inserted in your slide you should click a(n) ___________ area of the slide.

URL (Uniform Resource Locator)

To display a specific Web page, you enter its _____ (use acronym) in the Address bar.

Slide Sorter view

To duplicate, rearrange, or delete slides, you select the slides in the Slides tab in Normal view or switch to ____ _________ ________

Active

To enter text in a cell, the cell must first be:

Slides from Outline

To import a Word outline into a PowerPoint presentation, use the ____ _____ _____ command on the New Slide button menu.

drag

To include a field in a query, you can click and _ the field from the field list to the design grid.

Slides from Outline

To insert a Word outline into PowerPoint, you click the New Slide button arrow, then click _____ _____ _____.

embed

To insert a copy of an object along with a link to its source program in a destination file, allowing you to edit the object using the source program's commands.

Formulas

To insert a function, click the _ tab on the Ribbon.

paste

To insert copied or cut text or objects stored on the Clipboard anywhere in the presentation or in any file in any Windows program.

INSERT

To insert special Norwegian letters using a keyboard with only English letters, you can use the Symbol button in the Symbols group on the ________ tab.

link

To integrate an object into a file by creating a direct connection between the source and destination files. The object exists only in one place—the source file—but the link displays the object in the destination file as well.

copy

To leave the original selected text or object on the slide and place a copy of it on the Clipboard.

sort

To list files and folders in a particular order, such as alphabetically by name or type or chronologically by their modification date

duration

To make a slide transition faster, decrease the ________.

shift

To move multiple controls on a report, hold down the _____ key to select them all so you can move them as a unit.

Ctrl

To open a new tab in Internet Explorer, you press the ___ key and click a Web address link in a Web page.

Backstage

To open a presentation previously saved you should first click the File tab to display ___________view.

HOME

To open the Find and Replace dialog box, click the Find button on the ______ tab.

MAILINGS

To perform a mail merge, you work with commands in the ________ ribbon tab.

nest

To place one thing inside another, such as a function inside another function.

Print

To print a single page of a report, first click the______ button in the Print group on the Print Preview tab.

sort

To rearrange records in a specified order or sequence.

move

To remove a file from its current location and place it in a new location.

crop

To remove the parts of a photo you don't want to include.

cut

To remove the selected text or objects from one location so that you can place it somewhere else.

90

To rotate an object, you can use the Rotate commands on the Rotate button menu to rotate objects in ____-degree increments

Arragne

To rotate objects you first should click the Rotate button in the __________ group on the Home tab.

Linked Worksheet Object

To update a linked table in Excel, right-click the table in the document, point to ______ ______ ________ on the shortcut menu, then click Links.

scroll bars

To view fields or records that are not visible on your display, you can use the vertical or horizontal _ _.

Quick Access Toolbar

Toolbar that contains buttons for frequently used commands.

extra memory simulating RAM if more is needed.

Virtual memory

Slide Show View

Use this view to deliver your presentation to your audience.

built-in Headings styles

Used to format paragraphs in Word to import an outline in Word to a PowerPoint presentation.

tabs

Used to open multiple webpages simultaneously in one browser window.

Use the "Thesaurus" Feature

Using Microsoft Word 2003 or 2007, if you wanted to find another word to replace the word "responsible" in the report you just typed.

Plagiarizing Your Work

Using wording of someone else's work.

category of system software that augment the operating system by taking over some of its responsibilities for allocating hardware resources

Utilities

allows analog video transmission

VGA (Video Graphics Array)

Left and Right Margins Would Have Straight Lines

What is full justification?

public domain

When anyone is free to copy a given piece of work without requesting permission from the last copyright holder.

related

When creating a form based on two tables, you create a subform for data from the _______table.

currency

When evaluating search results, verifying _______ means to find out when the information was last updated, and whether timeliness affects the reliability of the information.

RTF files

When exporting the results of an Access query to Word, you will make use of the Export -- ___ ____ dialog box.

Zoom, pointer

When in Print Preview, you can use _____or the ____ to toggle between a full page display and a close-up display.

Hacking

When someone invades someone else's computer without permission.

median

When the data includes a few extremely large or extremely small values, it might be best to use the _______value from the sample

nonunique

When the sort field is _, records with the same sort field value are grouped together, but they are not in a specific order within the group.

Repeat

When there are no actions that can be redone, the Redo button changes to the_______ button.

On Click

When you advance through the slide show.

desktop

Which of the following is a personal computePharming mainframe desktop all of the above

Describes WLANs connected using a standard radio frequency established by the institute of Electrical and Electronic Engineers (IEEE)

Wi-Fi (Wireless fidelity) WLAN

allows computers to connect over many miles to a LAN a WiMAX tower sends signals to a WiMAX receiver built or plugged into a computer

WiMAX (Worldwide Interoperability for Microwave Access)

Tabbed browsing

____ _____ lets you display multiple Web pages in the same browser window.

AutoFill

____ can also be used to create a series of numbers, dates, or text based on a pattern.

Filter By Selection

_____ _____ ______lets you select all or part of a field value in a datasheet or form, and then display only those records that contain the selected value in the field.

Information

_______ is an Excel function category that returns information about the format, location, or contents of worksheet cells.

Search criteria

________ _______ are keywords that relate to the topic for which you want to find information on the Web.

Pinning

_________ a webpage to the taskbar allows you to open the webpage directly from the desktop without first opening Internet Explorer.

Merge fields

__________ ___________ contain instructions for replacing field placeholders with the variable information from a data source.

Dynamic Content

__________ _________________ transitions are a combination of the Fade transition for the slide background and a different transition for the slide content.

Formatting

__________ is the process of changing a workbook's appearance by defining the fonts, styles, colors, and decorative features.

Unnumbered

__________ lists are useful in slides when you want to present information on multiple lines without actually itemizing the information.

Animations

________________ are effects applied to an object, such as a graphic or a bulleted list, that make the object appear, disappear, change in appearance, or move.

Calculated

______values too large to fit into the cell are displayed in scientific notation.

slide

a page in a presentation.

●ᴥ●

boo

Special high speed memory reserved for the microprocessor's use is called

cache memory

has instructions that tell a computer how to perform a task

executable file

(=^W^=) (=^W^=) (=^W^=)

nyan cat

__ allocate system resources, manage storage space, maintain security, detect equipment failure, and control basic input and output.

operating systems

(=^W^=)

purrr

rilakkuma :D

same

main document

the text and other information (including punctuation, spaces, and graphics) that you want to keep the same in each merged document.

extension

three or more characters following a dot in a filename to identify the file's type.

allows you to create and manage Web sites

web site creation and management software

tangible form

words, numbers, notes, sounds, pictures, etc. of an original work

pooh

●ᴥ●


Set pelajaran terkait

Strategic Marketing Exam 1 Review

View Set

19 - Health Insurance Policy Provisions

View Set

Chapter 34: The United States in Today's World

View Set

Information Security and Assurance - C725 - final Study

View Set

development part 1 practice questions

View Set