Shared Flashcard Set

Details

COSC 1701 EL
Office 2010
162
Computer Science
Undergraduate 1
04/06/2012

Additional Computer Science Flashcards

 


 

Cards

Term
100% Stacked column chart
Definition
A chart type that places (stacks) data in one column per category, with each column having the same height of 100%
Term
3-D Chart
Definition
A chart that contains a third dimension to each data series, creating a distorted perspecitve of the data
Term
Absolute Cell Reference
Definition
A designation that provides a permenant reference to a specific cell.  WHen you copy a formula containing an absolute cell reference, the cell reference in the copied formula does not change, regardless of where you copy the formula.  An absolute cell reference appears with a dollar sign before both the column letter and row number, such as $B$5
Term
Access
Definition
A database program that is included in Microsoft Office
Term
Access Speed
Definition
Measures the time it takes for the storage device to make the file content available for use
Term
Action Centre
Definition
A Windows 7 component that monitors maintenance and security settings, alerting a user when necessary.  It provides alerts in pop-ups from an icon in the notification area
Term
Active Cell
Definition
The current cell in a worksheet.  It is indicated by a dark border onscreen.
Term
Adjustment Handle
Definition
A yellow diamond that enables you to modify a shape
Term
Aero Flip 3D
Definition
A Windows feature that shows open windows in a rotating 3D stack from which you can click to bring a window to view on the desktop
Term
Aero Peek
Definition
A preview of an open window, shown when you place the mouse pointer over the taskbar icon without clicking.  Aero Peek also enables you to minimize all open windows, showing the desktop temporarily.
Term
Aggregate function
Definition
A function that performs calculations on an entire column of data and returns to a single value
Term
Align
Definition
To arrange objects by lining up the sides, middles, or top/bottom edges of the objects.
Term
AND logical operator
Definition
Returns only records that meet all criteria
Term
Animation
Definition
A movement that controls the entrance, emphasis, exit, and/or path of objects in a slide show.
Term
Annotation
Definition
A written note or drawing on a slide for additional commentary or explanation
Term
Area Chart
Definition
A chart type that emphasizes magnitude of changes over time by filling in the space between lines with a colour
Term
Argument
Definition
A variable or constant input, such as cell reference or value, needed to complete a function.  The entire group of arguments for a function is enclosed within parentheses.
Term
Ascending order
Definition
A feature that arranges data in alphabetical order or sequential order from lowest to highest
Term
Aspect ratio
Definition
The ratio of an object's width to its height
Term
Auto Fill
Definition
A feature that enables you to copy the contents of a cell or a range of cells or to continue a sequence by dragging the fill handle over an adjacent cell or range of cells
Term
AutoNumber
Definition
A data type that stores a unique number for each record as it is added to a table and increments automatically each time a record is entered
Term
AutoRecover
Definition
Enables Word to recover a previous version of a document
Term
AVERAGE function
Definition
A predefined formula that calculates the arithmetic mean, or average, of calues in a range.
Term
Axis title
Definition
A label that describes either the category axis or the value axis
Term
Background
Definition

(Word) A colour, desgin, image, or watermark that appears behind text in a document or on a graphical image.

(PowerPoint) The portion of a picture to be removed during the Background Removal process

Term
Background Styles gallery
Definition
Provides both solid colour and background styles for application to a theme
Term
Backstage view
Definition
Display that includes commands related to common file activities and that provides information on an open file
Term
Backup
Definition

(Office Fundamentals) A copy of a file, usually on another storage medium.

(Access) Creates a duplicate copy of the database

Term
Bar chart
Definition
A chart type that compares values across categories using horizontal bars.  In a bar chart, the horizontal axis displays values and the vertical axis displays categories
Term
Bar tab
Definition
Tab that inserts a vertical line at the location of a tab setting. Useful as a separator for text printed on the same line
Term
Bibliography
Definition
A list of works cited or consulted by an author in his or her work and should be included with the published work.
Term
Bitmap image
Definition
An image created by bits or pixels containing colour information and placed on a grid that forms a picture
Term
Border
Definition
A line that surrounds a paragraph, a page, a table, or an image in a document, or that surrounds a cell or range of cells in a worksheet
Term
Bound control
Definition
A text box that is connected to a field in a table or query
Term
Breakpoint
Definition
The lowest calue for a specific category or series in a lookup table
Term
Brightness
Definition
The ratio between lightness and darkness of an image
Term
Bubble chart
Definition
A chart type that shows relationshops among three values by using bubbles to show a third dimension
Term
Bulleted List
Definition
Itemizes and separates paragraph text to increase readability
Term
Calculated control
Definition
A textbox that contains an expression that generates a calculated result when displayed in Form view.
Term
Calculated Field
Definition
Produces a value from an expression or function that references one or more existing fields
Term
Calculator
Definition
A Windows 7 accessory program that acts as a handheld calculator with four different views -- standard, scientific, programming, and statistical.
Term
Callout
Definition
A shape that includes a text box you can use to add notes.
Term
CamelCase Notation
Definition
A style of writing that uses no spaces in multi-word field names but uses uppercase letters to distinguish the first letter of each new word.
Term
Caption
Definition
A descriptive title for an image, an equation, a figure, or a table
Term
Caption Property
Definition
Used to create a more readable label instead of a field name, and displas in the top row in Datasheet view and in forms and reports
Term
Cascade Delete Related Records
Definition
An option that directs Access to automatically remove all records that are delted from a primary table from those related tables that match the primary key
Term
Cascade Update Related Fields
Definition
An option that directs Access to automatically update all foreign key values in a related table when the primary key value is modified in a primary table.
Term
Category Axis
Definition
The chart element that displays descriptive group names or labels, such as college names or cities, to identify data.
Term
Category Label
Definition
Text that describes a collection of data points in a chart
Term
Cell
Definition
The intersection of a column or row in a worksheet or table
Term
Cell address
Definition
The unique identifier of a cell, starting with the column letter and then the row number, such as A9
Term
Cell margin
Definition
The amount of space between data and the cellborder in a table
Term
Centre Tab
Definition
Sets the middle point of the text you type; whatever you type will be centred on that tab setting
Term
Change Case
Definition
Feature that enables you to change capitalization of text to all capital letters, all lowercase letters, sentence case, or toggle case
Term
Changed line
Definition
A vertical bar in the margin to pinpoint the area where changes are made in a document when the Track Changes feature is active
Term
Character Spacing
Definition
The horizontal space between characters
Term
Character style
Definition
Stores character formatting (font, size, and style) and affects only selected text.
Term
Chart
Definition
A visual representation of numerical dara that compares data and helps reveal trends or patterns to help people make informed decisions
Term
Chart area
Definition
A boundary that contains the entire chart and all of its elements, including the plot area, titles, legends and labels.
Term
Chart Sheet
Definition
A sheet within a workbok that contains a single chart and no spreadsheet data
Term
Chart Title
Definition
The label that describes the entire chart
Term
Circular Reference
Definition
A situation that occurs when a formula contains a direct or indirect reference to the cell containing the formula
Term
Citation
Definition
A note recognizing a source of information or a quoted passage
Term
Clip Art
Definition
An electronic illustration that can be inserted into an Office project.
Term
Clipboard
Definition
An office feature that temporarily holds selections that have been cut or copied
Term
Clustered column chart
Definition
A tyoe of chart that groups or clusters similar data into columns to compare values across categories
Term
Codec (coder/decoder)
Definition
A digital video compression scheme used to compress a video and decompress for playback
Term
Collapsed outline
Definition
Displays only the slide number, icon, and title of each slide in Outline view
Term
Color Scheme
Definition
A conditional format that displays a particular colour based on the relative value of the cell contents to other selected cells.
Term
Color Gallery
Definition
Provides a set of colours with each colour assigned to a different element for every available theme
Term
Column
Definition
A format that sections a document into side-by-side vertical blocks in which the text flows down the first vertical block and then continues at the top of the next vertical block.
Term
Column Chart
Definition
A type of chart that displays data vertically in columns to compare values across different categories
Term
Column Index Number
Definition
The number of the column in the lookup table that contains return values.
Term
Column Width
Definition
The horizontal measurement of a column in a table or a worksheet.  In Excel, it is measured by the number of characters or pixels.
Term
Command
Definition
A button or area within a group that you click to perform tasks
Term
Comment
Definition
A private note, annotation, or additional information to the author or another reader about the content of the document.
Term
Compact and Repair
Definition
Reduces the size of the database and repairs any corruptions to the database.
Term
Comparison Operator
Definition
Used to evaluate the relationship between two quantities to determine whether they are equal; if they are not equal, a comparison operator determines which one is greater than the other
Term
Compatibility Checker
Definition
Looks for features that are not supported by previous versions of Word
Term
Compress
Definition
The process of reducing the file size of an object
Term
Compression
Definition
A method applied to data to reduce the amount of space required for file storage
Term
Conditional Formatting
Definition
A set of rules that apply special formatting to highlight or emphasize cells that meet specific conditions
Term
Connector
Definition
A Lines shape that is attached to and moves with other shapes
Term
Constant
Definition
An unchanging value, such as a birth date
Term
Contextual tab
Definition
A Ribbon tab that displays when an object, such as a picture or clip art, is selected.
Term
Contrast
Definition
The difference between the lightest and darkest areas of an image
Term
Copy
Definition
Duplicates a selection from the original location and places the copy in the Office Clipboard
Term
Copyright
Definition
The legal protection afforded to a written or artistic work
Term
COUNT function
Definition
A predefined formula that tallies the number of cells in a range that contain values you can use in calculations, such as numerical and date data, but excludes blank cells or text entries from the tally
Term
COUNTA function
Definition
A predefined formula that tallies the number of cells in a range that are not blank; that is, cells that contain data whether a value, text, or a formula
Term
COUNTBLANK function
Definition
A predefined formula that tallies the number of cells in a range that are blank
Term
Criteria row
Definition
A row in the Query Design view that determines which records will be selected
Term
Criterion (criteria, pl.)
Definition
An expression used to filter the records in a table
Term
Cropping (or to crop)
Definition
The process of reducing an image size by eliminating unwanted portions of an image or other graphical object
Term
Cross-reference
Definition
A note that refers the reader to another location for more information about a topic
Term
Current List
Definition
Includes all citation sources you use in the current document
Term
Cut
Definition
Removes a selection from the original location and places it in the Office Clipboard
Term
Data bar
Definition
A conditional format that displays horizontal gradient or solid fill indicating the cell's relative value compared to other selected cells
Term
Data label
Definition
A descriptive label that shows the exact value of the data points on the value axis
Term
Data point
Definition
A numeric value that describes a single value on a chart
Term
Data redundancy
Definition
The unnecessary storing of duplicate data in two or more tables
Term
Data series
Definition
A group of related data points that appear in row(s) or column(s) in the worksheet
Term
Data Source
Definition
A listing of information
Term
Data type
Definition
Determines the type of data that can be entered and the operations that can be performed on that data
Term
Database
Definition
Consists of one or more tables to store data, one or more forms to enter data into the tables, and one or more reports to output the table data as organized information
Term
Database Table
Definition
A collection of related records that contain fields to organize data
Term
Datasheet form
Definition
A replica of a table's or query's Datasheet view except that it still retains some of the form properties
Term
Datasheet view
Definition
A view of a database object, which displays data in row and column format, and in which you can add, edit, and delete the records of a table, form or query
Term
Date arithmetic
Definition
The process of manipulating dates, or adding or subtracting a constant from a date
Term
Date formatting
Definition
Formatting that affects a date's display without changing the actual underlying value in the table
Term
DatePart function
Definition
Enables you to isolate a specific part of a date, such as the year.
Term
Decimal Tab
Definition
Marks where numbers align on a decimal point as you type
Term
Default
Definition
A setting that is in place unless you specify otherwise
Term
Delimiter
Definition
A special character that surrounds the criterion's value
Term
Descending order
Definition
Arranges data in alphabetical or sequential order from highest to lowest
Term
Design view
Definition
A view in which new database objects are created. and the design of existing objects is modified. Where you create tables, add and delete fields, and modify field properties
Term
Desktop
Definition
The screen display that appears after you turn on a computer. It contains icons and a taskbar
Term
Detail section
Definition
Displays the records in the form's record source and prints one line for each record in the report's record source
Term
Dialog box
Definition
A window that opens when you are accomplishing a task that enables you to make selections or indicate settings beyond those provided on the Ribbon
Term
Dialog Box Launcher
Definition
An icon in Ribbon groups that you can click to open a related dialog box
Term
Distribute
Definition
To divide or evenly spread over a given area
Term
Document Inspector
Definition
Checks for and removes different kinds of hidden and personal information from a document
Term
Document Panel
Definition
Provides descriptive informations about a document, such as a title, subject, author, keywords, and comments
Term
Doughnut Chart
Definition
A chart type that displays values as percentages of the whole but may contain more than one data series
Term
Draft view
Definition
Shows a simplified work area, removing white space and other elements from view
Term
Effects gallery
Definition
Includes a range of special effects that can be used on objects in the presentation
Term
Embed
Definition
TO store an object from an external source within a presentation
Term
Endnote
Definition
A citation that appears at the end of a document
Term
Enforce referential integrity
Definition
Ensures that data cannot be entered into a related table unless it first exists in the primary table
Term
Enhanced ScreenTip
Definition
Provides a brief summary of a command when you place the mouse pointer on the command button
Term
Excel
Definition
Software included in Microsoft Office that specializes in organizing data in worksheet form
Term
Expanded outline
Definition
Displays the slide number, icon, title, and content of each slide in outline view
Term
Exploded pie chart
Definition
A chart type in which one or more pie slices are separated from the rest of the pie chart
Term
Expression
Definition
A formula used to calculate new fields from the values in existing fields
Term
Expression Builder
Definition
A tool in Access to help you create expressions
Term
Field
Definition
The smallest data element contained in a table, such as first name, last name, address, and phone number
Term
Field property
Definition
A characteristic of a field that determines how the field looks and behaves
Term
Field Row
Definition
A row in the Query Design view that displays the field name
Term
File
Definition
A document or item of information that you create with software and to which you give a name
Term
File property
Definition
A file identifier, such as author or date created
Term
Fill
Definition
The interior contents of a shape
Term
Fill color
Definition
The background colour that appears behind data in a cell
Term
Fill handle
Definition
A small black square at the bottom-right corner of a cell used to copy cell contents or text or number patterns to adjacent cells
Term
Filter
Definition
Specifies criteria for including records that meet certain conditions, and displays a subset of records based on specified criteria
Term
Filter by Form
Definition
A filtering technique that displays table records based on multiple criteria, and allows the user to apply AND conditions and OR conditions
Term
Filter by Selection
Definition
A filtering technique that displays only the records that match the selected criteria
Term
Filtering
Definition
The process of specifying conditions to display only those records that meet the conditions
Term
Final: Show Markup
Definition
A view that displays inserted text in the body of the document and shows deleted text in a markup balloon
Term
Find
Definition
Locates a word or phrase that you indicate in a document
Term
Firewall
Definition
Software or hardware that protects a computer from unauthorized access
Term
First line indent
Definition
Marks the location to indent only the first line in a paragraph
Term
Flip
Definition
To reverse the direction and object faces
Term
Flow Chart
Definition
An illustration showing the sequence of a project or plan containing steps
Term
Folder
Definition
A named storage location where you save files
Term
Font
Definition
A complete set of characters -- upper and lowercase letters, numbers, punctuation marks, and special symbols with the same design that includes size, spacing, and shape
Term
Fonts gallery
Definition
Contains font sets for title text and bulleted text
Term
Footer
Definition
Information that displays at the bottom of each document page, presentation slide, handout or notes page
Term
Footnote
Definition
A citation that appears at the bottom of a page
Term
Foreground
Definition
(Word) Appears in front of text or images in a document or on a graphical image.
(PowerPoint) The portion of the picture to be kept during the Background Removal process
Term
Foreign Key
Definition
A field in one table that is also the primary key of anothe table
Term
Form
Definition
A database object that enables you to enter, modify, or delete table data
Term
Form Footer section
Definition
A part of a form that displays at the bottom of the form in Display view.
Supporting users have an ad free experience!