| A | B |
|---|
| You can reposition a worksheet by dragging its ____ to a new location. | Sheet tab |
| ____ are predesigned workbook files that you can use as the basis or model for new workbooks. | Templates |
| A ____ is a reference in a worksheet that opens another file or page when you click it. | Hyperlink |
| ____ graphics enhance worksheets by providing a visual representation of information and ideas. | SmartArt |
| If you know the function you want to enter, you can click the appropriate category button in the ____ group on the Formulas tab of the Ribbon. | Function Library |
| You switch between a chart sheet and a worksheet by clicking the appropriate ____. | Sheet tabs |
| To select multiple worksheets in a workbook, hold down the ____ key as you click the sheet tab of each worksheet you want to include in the group. | Ctrl |
| In a PMT function, the argument indicated by nper refers to ____. | number of payments |
| A chart, whether embedded in a worksheet or on a chart sheet, is considered part of a ____. | Workbook |
| An example of a square root function written correctly is ____. | =SQRT(D2) |
| ____ helps you enter a formula with a valid function name and arguments. As you begin to type the function name, a list of function names appears below the active cell. | Formula AutoComplete |
| A common workbook organization is to place sales data for each sales territory or region in its own worksheet, and then _______ the total sales in another worksheet. | Summarize |
| You can apply more than one filter to data to further limit the ______ of data. | Subset |
| The primary financial functions are future value, present value, and ________________. | Payment |
| Moving a ______ affects 3-D references in the workbook. | Worksheet |
| You can make a perfect square or circle by pressing and holding the ______ key as you drag in the worksheet to draw the shape. | Shift |
| The ______ sheet has a white sheet tab. | Active |
| The ____ task pane provides access to information typically found in references such as dictionaries, thesauruses, and encyclopedias. | Research |
| A ______ reference is a reference to the same cell or range in multiple worksheets that you use in a formula. | 3-D |
| A formula with a function has three parts: an ____________________, a function name, and (for most functions) at least one argument. | Equal sign |
| The ____ function returns the current date and time based on the computer’s date and time settings. | NOW |
| A(n) ____________________ sort arranges data with letters from Z to A, data with numbers from highest to lowest, and data with dates from oldest to newest. | Descending |
| A _______________________ is a picture of all or part of something you see on your monitor. | Screen shot |
| ______________________ permanently removes a worksheet and all its contents from the workbook. | Deleting |
| When you select the data source for a chart, you should also include the text you want to use as _______ in the chart. | Labels |
| When you want to see all the data in a worksheet again, you can restore all the rows by ______ the filter. | Clearing |
| The template includes all the parts of a workbook that will not change, such as text _______________, formulas, and formatting. | Labels |
| The _________ function returns the number of cells in a range of cells that contain data. | COUNTA |
| The _________ format cells based on their rank, such as the top 10 items, the bottom 15%, or those that are above average. | Top/Bottom Rules |
| A ________ is a shorthand way to write an equation that performs a calculation. | Function |
| The Chart Tools appear on the Ribbon with three _______ tabs; design, layout and format. | Contextual |
| The ______ interest rate is determined by dividing the annual interest rate by 12 months. | Monthly |
| A workbook may be saved in HTML format to use on the _______. | Internet |
| _____ charts are useful when you want to print a chart next to the data the chart illustrates. | Embedded |
| If a function contains more than one argument, _________ separate the arguments. | Commas |
| In the IF function, the first argument sets a condition for comparison, called a ________ test. | Logical |
| Filter arrows appear in the ________ heading cells. | Column |
| Functions that are used to format and work with cell contents. | Text functions |
| Functions used to analyze loans and investments. | Financial functions |
| Functions that are used to insert dates and times in a worksheet. | Date and time functions |
| Functions used to describe large quantities of data. | Statistical functions |
| Functions, such as the square root functions, that manipulate quantitative data in a worksheet. | Mathematical functions |
| The location where the data will appear after it is transferred. | Destination |
| A group of adjacent worksheets. | Worksheet range |
| Identifies the worksheets within the workbook. | Sheet tab |
| The location the data is being transferred from. | Source |
| The worksheet that appears in the workbook window. | Active sheet |
| Illustrates trends over time | Line chart |
| Show the relationship of parts to a whole. | Pie chart |
| Shows relationships among categories of data | Column chart |
| Tracks gains or losses | Win/loss sparkline |
| Shows the relationship between two categories of data, creating data points that are unrelated to each other. | Scatter chart |
| Highlights worksheet data by changing the look of cells that meet a specified condition. | Conditional formatting |
| Displays a subset of the data that meets certain criteria and temporarily hides the rows that do not meet the specified criteria. | Filtering |
| Rearranging the data in a more meaningful order. | Sort |
| A note attached to a cell that is usually used to explain or identify information contained in the cell. | Comment |
| A Workbook contains ____ worksheets. | three |
| Anything that appears on the screen that you can select and work with as a whole. | Object |
| Know how to describe what formulas do. For example, =Sheet4!A4+Sheet5!A5 | Adds the values in A4 of Sheet4 worksheet and A5 of Sheet5 worksheet |
| Be prepared to find the average, sum, count, minimum and maximum of a simple range. For example the average of 7, 9, 5 | answer: 7 |
