 |
| 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 |
|
|
.