| 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 wont 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 informatino 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 promary sort range of data, such as a last name |
| Secondary Sort | indicates teh next 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 and payment terms, and financial projections |
| IF Statements | are condiontion operators used in spreadsheet formulas |
| Date Function | are used to calculate a period of time |
| NOW date | returns the current date |
| LookUp Funtion | is used to compare a cell vaule to an array of cells and return a caule that matches the location of the vaule in the array |
| VLiookUp | is used when there are more than two columns in the array |
| List | is a feature used to create a more user-friendly spreadsheet atmosphere |
| Validated list | limits data entry to specific choices programmed into the function |
| Non-Validated List | allows additional entires other than those provided in the drop-down menu |
| Count | is used to return the number of cells in a range |
| CountA Function | will return the number 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 ofthe graph |
| X-Axis | is thebottom horizontal side of the graph |
| Data Markers | are used in a graph to 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 teh 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 teh purpose and content |
| X-axis Title | describes the horizontal data |
| Y-axis Title | describes the vertical data |
| Embedded Chart | one that appears on teh same sheet as the spreadsheet it represents |
| Linked Chart | one 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 | used to show trends or changes in data over time |
| XY Scatter Chart | used to show the correlation of two or more data sets |
| Pie Chart | used to represent teh contribution of each component of one series of data to the whole |
| Exploded Pie Chart | pie chart in which the individual components are enhanced |
| 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 | a data type in toggle format that allows a user to select a yes or no 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 | a data type used to define preset values for database entries |
| Memo | a 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 | data type used to arrange and sort data chronologically |
| 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 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 Query is a database object created by placing filters and selecting multiple criteria to exact information from one or more tables |
| And | Reduces the number of records because both confitions must be met |
| Or | increases the number of records becuase one or the other condition must be met |
| Graphic Elements | lines, images, and shapes that are stored in the form's design |
| Controls | allow the data to be manipulated |
| 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, summerize, 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 and usually contains field names |
| Detail dection | contains the report details or content information |
| Report footer | appears once at the end of a report |
| Page footer | appears on every page 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 |
| PowerPoint font size | generally 24 pt is the minimum |
| 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 complemnt to a speaker-delivered presentation |
| Group Delivery without speaker | does not require explanation or interpretation by a speaker |
| continuous loop | presentation is played repeatedly intil manually stopped |
| Rolling script | Presentation is 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 |
| PowerPoint Hardcopy | to complement presentations and enable retention of information |
| Presentation Software | is a 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 |
