 |
| 1 | |
Which Text function joins labels from multiple cells so that they appear as a single label in an Excel worksheet? |
| | A) | JOIN |
| | B) | SUBSTITUTE |
| | C) | CONCATENATE |
| | D) | AMPERSAND |
|
|
|
| 2 | |
Which of the following choices is a method of displaying a postal ZIP code with a leading zero such "08013" in an Excel worksheet? |
| | A) | Use the custom action choices |
| | B) | Format it as a literal |
| | C) | Create a custom format |
| | D) | Mark the insignificant zeros |
|
|
|
| 3 | |
Which of the following terms describes an Excel feature that provides task options for its data? |
| | A) | Delimiter |
| | B) | Literal |
| | C) | Query |
| | D) | Custom action |
|
|
|
| 4 | |
Which of the following argument lists are from the SUBSTITUTE function in an Excel worksheet? |
| | A) | Old_text, Instance_num, New_text |
| | B) | Text, Instance_num |
| | C) | Old_text, New_text, Instance_num |
| | D) | Text, Old_text, New_text, Instance_num |
|
|
|
| 5 | |
Which of the following file name extensions identifies a file with raw, unformatted data? |
| | A) | docx |
| | B) | html |
| | C) | txt |
| | D) | accdb |
|
|
|
| 6 | |
Which of the following custom format codes displays *24 in the cell in an Excel worksheet? |
| | A) | *00 |
| | B) | "*"00 |
| | C) | "*00" |
| | D) | "*"00" |
|
|
|
| 7 | |
Which of the following statements illustrates why importing data into an Excel workbook is a common task? |
| | A) | Consistent formatting and file names are available. |
| | B) | Associated tasks in Outlook are completed. |
| | C) | Data can be shared among workers. |
| | D) | Use of AutoCorrect options is enhanced. |
|
|
|
| 8 | |
Which of the following statements best describes how data is imported an Excel worksheet? |
| | A) | It is copied into the Excel workbook. |
| | B) | It is copied from Excel to another software program. |
| | C) | It is saved as an HTML file for the Web. |
| | D) | It is saved as an XPS file for viewing. |
|
|
|
| 9 | |
If the name John Thomas Doe has a space between each word, what is the maximum number of columns to which it can be converted while being imported into an Excel worksheet? |
| | A) | 1 |
| | B) | 2 |
| | C) | 3 |
| | D) | 5 |
|
|
|
| 10 | |
Which of the following commands pertains to the management of external data in an Excel workbook? |
| | A) | Naming and refreshing |
| | B) | Texturizing and trendlining |
| | C) | Scenario reporting and pivoting |
| | D) | Hiding and collapsing |
|
|
.