|
1 | | Imported content in a worksheet that originated in another program or format is called: |
| | A) | External data. |
| | B) | Imported content. |
| | C) | Matching sheets. |
| | D) | Exported files. |
| | E) | Access database. |
|
|
|
2 | | A new command in Excel 2013 that recognizes a pattern and duplicates it is: |
| | A) | AutoSum. |
| | B) | AutoComplete. |
| | C) | Flash Fill. |
| | D) | Copy Down. |
| | E) | Replicate. |
|
|
|
3 | | The type of importable document that includes basic data, no formatting, and commas or other characters to separate the data into columns and rows is: |
| | A) | A field. |
| | B) | A text file. |
| | C) | A list. |
| | D) | A table. |
| | E) | A worksheet. |
|
|
|
4 | | When you import a document into Excel that uses special characters such as commas to separate columns, you are importing a |
| | A) | Delimited file. |
| | B) | Field file. |
| | C) | Table. |
| | D) | Grid defined file. |
| | E) | Source file. |
|
|
|
5 | | The Microsoft Office relational database application that works with Excel to import and export data is called: |
| | A) | WordPad. |
| | B) | Backstage. |
| | C) | Office Wizard. |
| | D) | DataDrop. |
| | E) | Access. |
|
|
|
6 | | Web site data can be imported into Excel if the data is: |
| | A) | Hyperlinked. |
| | B) | Table formatted. |
| | C) | Delimited. |
| | D) | Simplified. |
| | E) | CSS. |
|
|
|
7 | | In an Excel table, the first row of the table with unique descriptive titles or labels is called the: |
| | A) | Header row. |
| | B) | Title row. |
| | C) | Field bar. |
| | D) | Ribbon. |
| | E) | Descriptor. |
|
|
|
8 | | When you apply a predesigned set of built-in format options such as borders, fill colors, and effects for an Excel table, you use: |
| | A) | A custom group. |
| | B) | A filter. |
| | C) | A data design. |
| | D) | A table style. |
| | E) | A layout. |
|
|
|
9 | | The process of arranging rows of data in an identified order is called: |
| | A) | Sorting. |
| | B) | Arranging. |
| | C) | Editing. |
| | D) | Formatting. |
| | E) | Aligning. |
|
|
|
10 | | To use an Advanced Filter in Excel, you first need to create a: |
| | A) | Condition. |
| | B) | Criteria range. |
| | C) | Location. |
| | D) | Data definition. |
| | E) | Query. |
|
|
|
11 | | When you use Excel's subtotal command your list data is formatted as a(n): |
| | A) | Outline. |
| | B) | Table. |
| | C) | Worksheet. |
| | D) | Record. |
| | E) | Group. |
|
|
|
12 | | When you need to highlight information in a worksheet by setting different fill colors or font styles for selected cells, use this Excel feature: |
| | A) | AutoFormat |
| | B) | Shade and Fill |
| | C) | Filter |
| | D) | Conditional formatting |
| | E) | Range formatting |
|
|
|
13 | | The term for specified Excel data that is indicated with a fill color, a horizontal bar, or an icon within the cell is: |
| | A) | Data visualization. |
| | B) | Graphic interface. |
| | C) | Gradient display. |
| | D) | Special formatting. |
| | E) | Data table. |
|
|
|
14 | | The basic Excel command that uses relational or comparison operators to determine if the value or label in a cell should be formatted is: |
| | A) | Conditional Rules. |
| | B) | Conditional Selection. |
| | C) | Highlight Cell Rules. |
| | D) | DataFind. |
| | E) | Standard Deviation. |
|
|
|
15 | | When you share Excel data with colleagues, use this feature to safeguard your work from accidental changes by others: |
| | A) | Secure lock |
| | B) | Password enabled |
| | C) | Set cell properties |
| | D) | Worksheet protection |
| | E) | Read-only |
|
|