| A | B |
|---|
| Printing group worksheets | can be printed with each worksheet coming after the previous one. |
| Evaluate formula dialog box | does not only display the results of the formula. |
| Track change history can be kept for | more than 15 days |
| Worksheet data type needed to create an oultine | data list |
| Invalid data can be __ after the Data Validation criteria has been set. | circled |
| This dialog box gives you an option to edit the formula in the Formula bar | Error Checking |
| Passwords are enabled by clicking the globe, prepare and then ___ | data encryption |
| In order to review the steps of a formula, if # values are displayed, you would not select. | Data validation |
| What can be protected in Excel? | Cells, worksheets, and workbooks. |
| Allow several or many people to work on the same workbook at the same time. | Shared workbooks |
| What saves information about window sizes, print settings, screen magnification and other display settings. | Not a Workspace |
| When is a trendline added to a chart | After the chart is created. |
| Can you add formulas to an existing Web page? | Yes |
| The process to enter a password. | Globe, prepare, and data encryption. |
| The subtotal feature allows you to ___ | total a group of data. |
| An outline lets you hide rows of data, but not columns | No |
| A function that predicts future requirements. | FORECAST |
| What gives you control over which type of data is put toghether in a worksheet? | Grouping |
| What keys in combination with the mouse lets you copy information from one worksheet to another. | Ctrl and Alt Keys |
| Bringing data from several worksheets into one worksheet. | Consolidation |
| In order to create a template you enter data and save it as a ____ . | Template |
| What type or protection lets you open a file and make changes? | Password |
| Outlining a workbook can be accomplished with both ___ workbooks. | large and small amounts of data |
| Where can you remove a cell from being watched? | Watch Window |
| Named ranges __ be used in formulas | can |
| What type of data may not be saved as an XMI spreadsheet | structured |
| The merge workbooks feature allows you to ___ changes if there is a conflict | accept or reject |
| What locates data in a range that displays vertically | VLOOKUP |
| You can add formulas modify and edit a created, saved or existing template.. | Correct |
| Outlined data | can be printed. |
| Named can be used in formulas | ranges |
