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
|
Definition
| A chart that contains a third dimension to each data series, creating a distorted perspecitve of the data |
|
|
Term
|
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
|
Definition
| A database program that is included in Microsoft Office |
|
|
Term
|
Definition
| Measures the time it takes for the storage device to make the file content available for use |
|
|
Term
|
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
|
Definition
| The current cell in a worksheet. It is indicated by a dark border onscreen. |
|
|
Term
|
Definition
| A yellow diamond that enables you to modify a shape |
|
|
Term
|
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
|
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
|
Definition
| A function that performs calculations on an entire column of data and returns to a single value |
|
|
Term
|
Definition
| To arrange objects by lining up the sides, middles, or top/bottom edges of the objects. |
|
|
Term
|
Definition
| Returns only records that meet all criteria |
|
|
Term
|
Definition
| A movement that controls the entrance, emphasis, exit, and/or path of objects in a slide show. |
|
|
Term
|
Definition
| A written note or drawing on a slide for additional commentary or explanation |
|
|
Term
|
Definition
| A chart type that emphasizes magnitude of changes over time by filling in the space between lines with a colour |
|
|
Term
|
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
|
Definition
| A feature that arranges data in alphabetical order or sequential order from lowest to highest |
|
|
Term
|
Definition
| The ratio of an object's width to its height |
|
|
Term
|
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
|
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
|
Definition
| Enables Word to recover a previous version of a document |
|
|
Term
|
Definition
| A predefined formula that calculates the arithmetic mean, or average, of calues in a range. |
|
|
Term
|
Definition
| A label that describes either the category axis or the value axis |
|
|
Term
|
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
|
Definition
| Display that includes commands related to common file activities and that provides information on an open file |
|
|
Term
|
Definition
(Office Fundamentals) A copy of a file, usually on another storage medium.
(Access) Creates a duplicate copy of the database |
|
|
Term
|
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
|
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
|
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
|
Definition
| An image created by bits or pixels containing colour information and placed on a grid that forms a picture |
|
|
Term
|
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
|
Definition
| A text box that is connected to a field in a table or query |
|
|
Term
|
Definition
| The lowest calue for a specific category or series in a lookup table |
|
|
Term
|
Definition
| The ratio between lightness and darkness of an image |
|
|
Term
|
Definition
| A chart type that shows relationshops among three values by using bubbles to show a third dimension |
|
|
Term
|
Definition
| Itemizes and separates paragraph text to increase readability |
|
|
Term
|
Definition
| A textbox that contains an expression that generates a calculated result when displayed in Form view. |
|
|
Term
|
Definition
| Produces a value from an expression or function that references one or more existing fields |
|
|
Term
|
Definition
| A Windows 7 accessory program that acts as a handheld calculator with four different views -- standard, scientific, programming, and statistical. |
|
|
Term
|
Definition
| A shape that includes a text box you can use to add notes. |
|
|
Term
|
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
|
Definition
| A descriptive title for an image, an equation, a figure, or a table |
|
|
Term
|
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
|
Definition
| The chart element that displays descriptive group names or labels, such as college names or cities, to identify data. |
|
|
Term
|
Definition
| Text that describes a collection of data points in a chart |
|
|
Term
|
Definition
| The intersection of a column or row in a worksheet or table |
|
|
Term
|
Definition
| The unique identifier of a cell, starting with the column letter and then the row number, such as A9 |
|
|
Term
|
Definition
| The amount of space between data and the cellborder in a table |
|
|
Term
|
Definition
| Sets the middle point of the text you type; whatever you type will be centred on that tab setting |
|
|
Term
|
Definition
| Feature that enables you to change capitalization of text to all capital letters, all lowercase letters, sentence case, or toggle case |
|
|
Term
|
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
|
Definition
| The horizontal space between characters |
|
|
Term
|
Definition
| Stores character formatting (font, size, and style) and affects only selected text. |
|
|
Term
|
Definition
| A visual representation of numerical dara that compares data and helps reveal trends or patterns to help people make informed decisions |
|
|
Term
|
Definition
| A boundary that contains the entire chart and all of its elements, including the plot area, titles, legends and labels. |
|
|
Term
|
Definition
| A sheet within a workbok that contains a single chart and no spreadsheet data |
|
|
Term
|
Definition
| The label that describes the entire chart |
|
|
Term
|
Definition
| A situation that occurs when a formula contains a direct or indirect reference to the cell containing the formula |
|
|
Term
|
Definition
| A note recognizing a source of information or a quoted passage |
|
|
Term
|
Definition
| An electronic illustration that can be inserted into an Office project. |
|
|
Term
|
Definition
| An office feature that temporarily holds selections that have been cut or copied |
|
|
Term
|
Definition
| A tyoe of chart that groups or clusters similar data into columns to compare values across categories |
|
|
Term
|
Definition
| A digital video compression scheme used to compress a video and decompress for playback |
|
|
Term
|
Definition
| Displays only the slide number, icon, and title of each slide in Outline view |
|
|
Term
|
Definition
| A conditional format that displays a particular colour based on the relative value of the cell contents to other selected cells. |
|
|
Term
|
Definition
| Provides a set of colours with each colour assigned to a different element for every available theme |
|
|
Term
|
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
|
Definition
| A type of chart that displays data vertically in columns to compare values across different categories |
|
|
Term
|
Definition
| The number of the column in the lookup table that contains return values. |
|
|
Term
|
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
|
Definition
| A button or area within a group that you click to perform tasks |
|
|
Term
|
Definition
| A private note, annotation, or additional information to the author or another reader about the content of the document. |
|
|
Term
|
Definition
| Reduces the size of the database and repairs any corruptions to the database. |
|
|
Term
|
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
|
Definition
| Looks for features that are not supported by previous versions of Word |
|
|
Term
|
Definition
| The process of reducing the file size of an object |
|
|
Term
|
Definition
| A method applied to data to reduce the amount of space required for file storage |
|
|
Term
|
Definition
| A set of rules that apply special formatting to highlight or emphasize cells that meet specific conditions |
|
|
Term
|
Definition
| A Lines shape that is attached to and moves with other shapes |
|
|
Term
|
Definition
| An unchanging value, such as a birth date |
|
|
Term
|
Definition
| A Ribbon tab that displays when an object, such as a picture or clip art, is selected. |
|
|
Term
|
Definition
| The difference between the lightest and darkest areas of an image |
|
|
Term
|
Definition
| Duplicates a selection from the original location and places the copy in the Office Clipboard |
|
|
Term
|
Definition
| The legal protection afforded to a written or artistic work |
|
|
Term
|
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
|
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
|
Definition
| A predefined formula that tallies the number of cells in a range that are blank |
|
|
Term
|
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
|
Definition
| The process of reducing an image size by eliminating unwanted portions of an image or other graphical object |
|
|
Term
|
Definition
| A note that refers the reader to another location for more information about a topic |
|
|
Term
|
Definition
| Includes all citation sources you use in the current document |
|
|
Term
|
Definition
| Removes a selection from the original location and places it in the Office Clipboard |
|
|
Term
|
Definition
| A conditional format that displays horizontal gradient or solid fill indicating the cell's relative value compared to other selected cells |
|
|
Term
|
Definition
| A descriptive label that shows the exact value of the data points on the value axis |
|
|
Term
|
Definition
| A numeric value that describes a single value on a chart |
|
|
Term
|
Definition
| The unnecessary storing of duplicate data in two or more tables |
|
|
Term
|
Definition
| A group of related data points that appear in row(s) or column(s) in the worksheet |
|
|
Term
|
Definition
|
|
Term
|
Definition
| Determines the type of data that can be entered and the operations that can be performed on that data |
|
|
Term
|
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
|
Definition
| A collection of related records that contain fields to organize data |
|
|
Term
|
Definition
| A replica of a table's or query's Datasheet view except that it still retains some of the form properties |
|
|
Term
|
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
|
Definition
| The process of manipulating dates, or adding or subtracting a constant from a date |
|
|
Term
|
Definition
| Formatting that affects a date's display without changing the actual underlying value in the table |
|
|
Term
|
Definition
| Enables you to isolate a specific part of a date, such as the year. |
|
|
Term
|
Definition
| Marks where numbers align on a decimal point as you type |
|
|
Term
|
Definition
| A setting that is in place unless you specify otherwise |
|
|
Term
|
Definition
| A special character that surrounds the criterion's value |
|
|
Term
|
Definition
| Arranges data in alphabetical or sequential order from highest to lowest |
|
|
Term
|
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
|
Definition
| The screen display that appears after you turn on a computer. It contains icons and a taskbar |
|
|
Term
|
Definition
| Displays the records in the form's record source and prints one line for each record in the report's record source |
|
|
Term
|
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
|
Definition
| An icon in Ribbon groups that you can click to open a related dialog box |
|
|
Term
|
Definition
| To divide or evenly spread over a given area |
|
|
Term
|
Definition
| Checks for and removes different kinds of hidden and personal information from a document |
|
|
Term
|
Definition
| Provides descriptive informations about a document, such as a title, subject, author, keywords, and comments |
|
|
Term
|
Definition
| A chart type that displays values as percentages of the whole but may contain more than one data series |
|
|
Term
|
Definition
| Shows a simplified work area, removing white space and other elements from view |
|
|
Term
|
Definition
| Includes a range of special effects that can be used on objects in the presentation |
|
|
Term
|
Definition
| TO store an object from an external source within a presentation |
|
|
Term
|
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
|
Definition
| Provides a brief summary of a command when you place the mouse pointer on the command button |
|
|
Term
|
Definition
| Software included in Microsoft Office that specializes in organizing data in worksheet form |
|
|
Term
|
Definition
| Displays the slide number, icon, title, and content of each slide in outline view |
|
|
Term
|
Definition
| A chart type in which one or more pie slices are separated from the rest of the pie chart |
|
|
Term
|
Definition
| A formula used to calculate new fields from the values in existing fields |
|
|
Term
|
Definition
| A tool in Access to help you create expressions |
|
|
Term
|
Definition
| The smallest data element contained in a table, such as first name, last name, address, and phone number |
|
|
Term
|
Definition
| A characteristic of a field that determines how the field looks and behaves |
|
|
Term
|
Definition
| A row in the Query Design view that displays the field name |
|
|
Term
|
Definition
| A document or item of information that you create with software and to which you give a name |
|
|
Term
|
Definition
| A file identifier, such as author or date created |
|
|
Term
|
Definition
| The interior contents of a shape |
|
|
Term
|
Definition
| The background colour that appears behind data in a cell |
|
|
Term
|
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
|
Definition
| Specifies criteria for including records that meet certain conditions, and displays a subset of records based on specified criteria |
|
|
Term
|
Definition
| A filtering technique that displays table records based on multiple criteria, and allows the user to apply AND conditions and OR conditions |
|
|
Term
|
Definition
| A filtering technique that displays only the records that match the selected criteria |
|
|
Term
|
Definition
| The process of specifying conditions to display only those records that meet the conditions |
|
|
Term
|
Definition
| A view that displays inserted text in the body of the document and shows deleted text in a markup balloon |
|
|
Term
|
Definition
| Locates a word or phrase that you indicate in a document |
|
|
Term
|
Definition
| Software or hardware that protects a computer from unauthorized access |
|
|
Term
|
Definition
| Marks the location to indent only the first line in a paragraph |
|
|
Term
|
Definition
| To reverse the direction and object faces |
|
|
Term
|
Definition
| An illustration showing the sequence of a project or plan containing steps |
|
|
Term
|
Definition
| A named storage location where you save files |
|
|
Term
|
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
|
Definition
| Contains font sets for title text and bulleted text |
|
|
Term
|
Definition
| Information that displays at the bottom of each document page, presentation slide, handout or notes page |
|
|
Term
|
Definition
| A citation that appears at the bottom of a page |
|
|
Term
|
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
|
Definition
| A field in one table that is also the primary key of anothe table |
|
|
Term
|
Definition
| A database object that enables you to enter, modify, or delete table data |
|
|
Term
|
Definition
| A part of a form that displays at the bottom of the form in Display view. |
|
|
