Term
| In using functions, what are arguments? What are arguments separated by? |
|
Definition
| Numbers, text, or cell references used by the function to return a value and are always separated by a comma |
|
|
Term
| By default, what does the AutoFill copies? |
|
Definition
| The content of the selected cells |
|
|
Term
| In using cell references, what key you can press to switch a cell reference from relative to absolute, or mixed? |
|
Definition
|
|
Term
| Name the (3) cell references and give an example for each. |
|
Definition
| Relative references are always interpreted in relation to the cell containing the formula. Absolute references are fixed. Mixed references contain both relative and absolute reference. |
|
|
Term
| What is a logical function? |
|
Definition
| A category of excel functions that test whether a condition is true or false. |
|
|
Term
| What the PMT function does? |
|
Definition
| It can be used to calculate the payments for a loan or the future value of an investment. |
|
|
Term
| Describe the fill handle. What does it do when used? |
|
Definition
| The fill handle is a small black dot or square in the bottom right corner of the active cell. The fill handle has a number of uses including copying a cell’s contents to adjacent cells or to create a series. |
|
|
Term
| What type of function is the If function? What does it returns? |
|
Definition
| It is a logical function. What it does, basically, is test to see whether a certain condition is true or false. |
|
|
Term
| What is a syntax? What does it specifies? |
|
Definition
| It is a set of rules every function must follow. It specifies how the function should be written. |
|
|
Term
| What date function displays the current date only? |
|
Definition
|
|
Term
|
Definition
| The groups or categories that the series values belong to. |
|
|
Term
|
Definition
| A visual representation of a set of data. |
|
|
Term
|
Definition
| The rectangular box containing the chart and all of the other chart elements |
|
|
Term
|
Definition
| They are helpful for detailed Charles that need more space to be seen clearly of when you want to show a chart without any worksheet text or data |
|
|
Term
|
Definition
| A descriptive label or name for the chart, and usually appears at the top of the chart area. |
|
|
Term
|
Definition
| Text associated with data value |
|
|
Term
|
Definition
| Represent data values, like pie chart slices |
|
|
Term
|
Definition
| A range of values that is plotted as a single unit on the chart |
|
|
Term
|
Definition
| The range that contains the data you want to display in the chart. |
|
|
Term
|
Definition
| A rectangular area that labels the markers or symbols used in the chart |
|
|
Term
|
Definition
| The part of the chart that contains the graphical the graphical representation of all the data series in the chart |
|
|
Term
|
Definition
| A range of values that spans the vertical axis. |
|
|
Term
|
Definition
| The name of a data series |
|
|
Term
| Name (8) categories of Excel functions. |
|
Definition
Cube, Database, Date and Time,
engineering, financial, information, logical, text |
|
|
Term
|
Definition
| Retrieve info involving OLAP |
|
|
Term
|
Definition
| Retrieve and analyze data stored in databases |
|
|
Term
|
Definition
| Analyze or create date and time values and time intervals |
|
|
Term
|
Definition
| Analyze engineering problems |
|
|
Term
|
Definition
| Have financial applications |
|
|
Term
|
Definition
| Return information about the format location or contents of worksheet cells |
|
|
Term
|
Definition
|
|
Term
|
Definition
| Return text values or evaluate text |
|
|
Term
|
Definition
| radar ,column, line, pie, area, xy, stock, surface, doughnut |
|
|
Term
|
Definition
| Compares a collection of values from several different data sets |
|
|
Term
|
Definition
| Values are indicated by the height of the columns |
|
|
Term
|
Definition
| Values are indicated by the height of the line |
|
|
Term
|
Definition
| Values are indicated by the area of the pie slices |
|
|
Term
|
Definition
| Similar to the line chart except that areas under the lines contain a fill color |
|
|
Term
|
Definition
| Shows the patterns or relationship between two or more sets of values |
|
|
Term
|
Definition
| Displays stock market data |
|
|
Term
|
Definition
| Compares three sets of values in a 3-D chart |
|
|
Term
|
Definition
| Compares relative values of different categories to the whole |
|
|
Term
|
Definition
| A field that's displayed in the category area of the PivotChart report. Items in a category field appear as the labels on the category axis. |
|
|
Term
|
Definition
| Conditions you specify for a filter |
|
|
Term
|
Definition
| A table which is documentation that lists the fields to be maintained for each record, and a description of the information each field will include |
|
|
Term
|
Definition
| In a PivotTable or PivotChart report, a category of data that's derived from a field in the source data. PivotTable reports have row, column, page, and data fields. PivotChart reports have series, category, page, and data fields. |
|
|
Term
|
Definition
| A unique label that describes the contents of the data in that column |
|
|
Term
|
Definition
| To display only the rows in a list that satisfy the conditions you specify. You use the AutoFilter command to display rows that match one or more specific values, calculated values, or conditions. |
|
|
Term
|
Definition
| Lets you keep headings visible as you work with the data in a large worksheet |
|
|
Term
|
Definition
| The row of fields name in a table. |
|
|
Term
|
Definition
| A chart that provides interactive analysis of data, like a PivotTable report. You can change views of data, see different levels of detail, or reorganize the chart layout by dragging fields and by showing or hiding items in fields. |
|
|
Term
|
Definition
| An interactive table that enables you to group and summarize either a range of data or an Excel table into a concise, tabular format for easier reporting and analysis. |
|
|
Term
|
Definition
| A collection of information about a particular person, place, event, or thing. When Query displays a result set in the Data pane, a record is represented as a row. |
|
|
Term
|
Definition
| Filter the PivotTable to display summarized data for one of more field items or all field items in the report filter area |
|
|
Term
|
Definition
| A field used to order data |
|
|
Term
|
Definition
| A special row in an Excel table that provides a selection of aggregate functions useful for working with numerical data. |
|
|
Term
|
Definition
| The fields that contain summary data |
|
|
Term
| When you start Excel and see the blank worksheet called _____, you are actually using a workbook based on a template known as the _____ template. |
|
Definition
|
|
Term
| Name (2) ways you can ungroup worksheets. |
|
Definition
1)Click a sheet tab outside of the group
2)Right click any sheet tab in the group and click ungroup |
|
|
Term
| List (3) advantages to creating and using templates. |
|
Definition
1)Can alter the templates content so that it contain the info you want for all invoices
2)They help you standardize the appearance and content of workbooks
3)Don’t have to worry about saving over a previous invoice |
|
|
Term
| What does HTML stands for? |
|
Definition
| Hypertext markup language |
|
|
Term
| What keys are press when selecting an adjacent and a nonadjacent group of worksheets? |
|
Definition
|
|
Term
| A ScreenTip is displayed when you place the pointer over a _____. |
|
Definition
|
|
Term
|
Definition
| A reference to a range that spans two or more worksheets in a workbook. |
|
|
Term
|
Definition
| A connection between the files that allows data to be transferred from one file to the other. |
|
|
Term
|
Definition
| Is an Excel file that saves information about all of the currently opened workbooks, such as their locations, window sizes, zoom magnifications, and other settings. |
|
|
Term
|
Definition
| A link from one electronic document to another that can be triggered by the user |
|
|
Term
|
Definition
| The language used to write Web pages. |
|
|
Term
|
Definition
| A collection of two or more selected worksheets |
|
|
