| A | B |
|---|
| Workbook | File which contains one or more spreadsheets |
| Spreadsheet | arrangement of cells in columns and rows used to organize, analyze, calculate, and report information |
| Cells | Individual locations on a spreadsheet |
| Label Classification | Used for cells with text or numbers that won't be used in a calculation |
| Value Classification | indicates that the data has the potential to be used in calculations |
| Formatting | applied to spreadsheet components for the purpose of organizing and clarifying information |
| Header/Footer | feature used to add identifying information to a spreadsheet |
| Font Size and Style | Options used to clarify information by adding emphasis to titles, column headings, and grand totals |
| Justification | used to format cell data for the purpose of clarifying and organizing information |
| Left | by default, cells formatted as labels are ______ justified |
| Right | by default, cells formated as values are _______ justified |
| Indent | format applied to cell data to emphasize subcategories |
| Center | formatting usually applied to titles and column headings |
| Wrap | applied to cells that require more space when the row or column size is adjusted |
| Merge | used to combine adjacent cell ranges or cells |
| Column Width | adjusted to fit the longest entry |
| Borders and Shading | used to emphasize and organize information and can be applied to columns, rows, cell ranges, or individual cells |
| Renaming | makes a spreadsheet more user-friendly by adding a descriptive identifier to the spreadsheet tab |
| Order of Spreadsheets | helpful in organizing and clarifying information |
| Sort | used to arrange data in alphabetical or chronological order |
| Primary Sort | indicates the primary sort range of data, such as a last name |
| Secondary Sort | indicates a subordinate sort range, such as a first name |
| Freeze Panes | allows the user to work in multiple areas of a large spreadsheet and focus the view on specific cell ranges |
| Fill Series | used to fill a column or row with consecutive data |
| Print Preview | used to validate how data is represented on paper before printing |
| Print a Selection | used when printing only a portion of a spreadsheet |
| Linking and Embedding | used to integrate spreadsheet data with other software applications |
| Cell Reference | indicates a cell's location and provides instructions for how cell data is copied or used in calculations |
| Spreadsheet Functions | predefined formulas that perform calculations by using specific values in a specific order |
| Relative | cell vaule changes as the formula is copied |
| Absolute | cell vaule remains static when copied to other locations |
| Mixed Reference | indicates the combination of an absolute cell and a relative cell |
| Parentheses | control the order of operations |
| Conditions of Criteria | tell the funtion how to calculate the results and what data to use |
| Sum | adds the range of cells |
| Average | Determines the average of the range of cells |
| Maximum | finds the highest number in the range of cells |
| Minimum | finds the lowest number in the range of cells |
| Advanced Funtions | are used in higher-level operations, such as in conditional and comparison equations, to compute interest rates, due dates, payment terms, and financial projections |
| IF Statements | condiontional operators used in spreadsheet formulas |
| Date Function | used to calculate a period of time |
| NOW Function | returns the current date |
| LookUp Funtion | compares a cell value to an array of cells and returns a calculation that matches the location of the value in the array |
| V-LookUp | look-up function used when there are more than two columns in the array |
| List | allows users to select from pre-determined choices in a drop-down menu |
| Validated list | limits data entry to specific choices programmed into the function |
| Non-Validated List | allows additional entries other than those provided in the drop-down menu |
| Count | returns the number of cells in a range |
| CountA Function | returns the number of cells in a range that contain any value |
| CountIF function | will count cells that meet a condition set fourth in a formula |
| Y-Axis | is the left vertical side of a graph |
| X-Axis | is the bottom horizontal side of the graph |
| Data Markers | indicate data values |
| Data Series | collection of related values, such as one row or column from a spreadsheet |
| Gridline | horizontal or vertical line that extends across the plot area of the graph for the purpose of adding clarification to the data |
| Plot Area | background portion of a graph |
| Tick Mark | used in a graph to clarify data categories or values |
| Legend | object that explains the symbols, colors, or patterns used to differentiate the data |
| Data Label | single value or text explanation used to explain the data in a series |
| Chart Title | main heading, which describes the purpose and content |
| X-axis Title | describes a graph's horizontal data |
| Y-axis Title | describes a graph's vertical data |
| Embedded Chart | chart that appears on the same worksheet as the spreadsheet it represents |
| Linked Chart | chart that will change to reflect changes made to the spreadsheet it represents |
| Column Chart | used to make comparisons and generalizations about groups of data, such as to compare the number of students from each class to their attendance at assemblies |
| Stacked Bar Chart | used to represent the sum of more than one value and compare the contribution of individuals to the whole |
| Line Chart | shows trends or changes in data over time |
| XY Scatter Chart | shows the correlation of two or more data sets |
| Pie Chart | represents the contribution of each component of one series of data to the whole |
| Exploded Pie Chart | pie chart which separates to enhance the individual components |
| Database | tool used to organize, store, retrieve, and communicate groups of related information |
| Tables | building blocks of all databases, used to group and organize the information within a database |
| Entry | single piece of data in a database table |
| Field | grouping or category of similar information contained in a table |
| Record | complete description of all of the fields related to one item in a table |
| Yes/No data type | in toggle format, this allows a user to select a positive or negative value in a database cell |
| Caption | field property used for column naming that allows a more user-friendly and properly formatted field name than that stored in the database design |
| Lookup Wizard data type | used to define preset values for database entries |
| Memo data type | used for lengthy entries that allows combinations of text and numbers |
| Input Mask | a template-like field property that regulates how data is entered in a cell |
| Decimal Places field property | used to format numbers for one or more decimal points |
| Currency data type | used to format numbers as decimal values with a dollar sign |
| Date/Time data type | used to arrange and sort data chronologically |
| Auto Number | used to automatically assign a number to each record and assist in preventing duplication of data |
| Primary Key | field in a database that is of the same data type and size as a related field in a linked table; used to format each record in a database as a unique entity |
| Filters | allow for the one-time retrieval of information that meets specific criteria |
| Sorts | allow for information to be arranged in a specific order such as alphabetical, chronological, ascending, or descending |
| Database Relationships | a link between two or more tables in a database |
| One-to-One | when only one record is linked to a record in another table |
| One-to-Many | when a record in one table is linked to more than one record in another table |
| Many-to-Many | when multiple records from both tables are linked |
| Foreign Key | when tables are linked by the primary key, the related field in the second table is this_____________ |
| Join Line | a graphical representation of the link between two or more tables |
| Referential Integrity | protects related data that is stored in multiple tables |
| Junction Table | a table used to join primary key fields from multiple tables |
| Raw Data Import | a useful and practical method for obtaining information from other sources and creating database tables |
| Query | a database object created by placing filters and selecting multiple criteria to exact information from one or more tables; can be saved and reused |
| And | conditional operator that reduces the number of records returned because both conditions must be met |
| Or | conditional operator that increases the number of records returned because either one or the other condition must be met |
| Graphic Elements | lines, images, and shapes that are stored in a form's design |
| Controls | allow the data to be manipulated, often by hiding or scrolling |
| Descriptive Text | can be added to a form for the purpose of identifying fields and forms or adding captions or prompts |
| Subforms | are forms within and related to a main form through a common field |
| Report | object used to organize, summarize, and print some or all of the data from one or more database tables or queries |
| Lines and Borders | used for decoration |
| Report header | appears once at the beginning of a report and usually contains items such as the company name, adress, and logo |
| Page header | appears at the top of every page of a report and usually contains field names |
| Detail section | contains the internal report content information |
| Report footer | appears once at the end of a report |
| Page footer | appears on every page of a report and usually contains page numbers |
| Rules of sevens | no more than 7 lines of text per slide and not more than 7 words per line |
| Minimum font size | 24 points |
| Animation | used to control how the presentation is viewed and to add visual interest |
| 3 characteristicis of apporpriate content for presentation software | educate, persuade, narrate |
| Group Delivery with speaker | as a supplement and complement to a speaker-delivered presentation |
| Group Delivery without speaker | does not require explanation or interpretation by a speaker |
| Continuous loop | played repeatedly until manually stopped |
| Rolling script | usually stand-alone content, such as a prop for posting the lyrics of a song or the lines of a poem |
| Self-Serve | may be delivered via a website, such as the Microsoft training presentations that are user-selected and interactive |
| Hardcopy | Printed materials that complement presentations and enable retention of information |
| Presentation Software | program used to create slide shows or multimedia presentations |
| Multimedia | presenting data in more than one medium, such as combining text, graphics, animation, video, and sound |
| PowerPoint Notes Page | contains one slide per page and any notes that accompany the slide |
| PowerPoint Outline View | presents information in compact form without graphics |
| Animation Schemes | A polished sequence of effects that can be applied to several slides or the whole show |
