Intergrating
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.
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
●ᴥ●
