 |
| 1 | |
Where can the Remove Duplicates button be used? |
| | A) | Formula cells |
| | B) | HTML stylesheets |
| | C) | Tabular data |
| | D) | Connections dialog box |
|
|
|
| 2 | |
Which phrase is shown in proper case? |
| | A) | Refresh data when opening file |
| | B) | Refresh Data when opening file |
| | C) | Refresh Data When Opening File |
| | D) | refresh data when opening file |
|
|
|
| 3 | |
Which group on the Data tab includes the From Text and From Access buttons? |
| | A) | Connections |
| | B) | Data Tools |
| | C) | Get External Data |
| | D) | Data and Text |
|
|
|
| 4 | |
How can you create your own document theme? |
| | A) | Open the theme and copy the fonts, colors, and effects. |
| | B) | Set the fonts, colors, and effects and name/save the theme. |
| | C) | Open the Font, Color, and Effects dialog boxes and name each set. |
| | D) | Set all the formats and save the workbook. |
|
|
|
| 5 | |
What could you use to get data from dBase files? |
| | A) | MS Query |
| | B) | MS Web Query |
| | C) | MS Solver |
| | D) | MS Digitizer |
|
|
|
| 6 | |
What are the arguments for the SUBSTITUTE function? |
| | A) | Old_text, Instance_num |
| | B) | Text, Instance_num |
| | C) | Old_text, New_text |
| | D) | Old_text, New_text, Instance_num |
|
|
|
| 7 | |
From which command group can you manage external data? |
| | A) | Connections |
| | B) | Get External Data |
| | C) | Data Tools |
| | D) | From Other Sources |
|
|
|
| 8 | |
What filename extension applies to files with raw, unformatted data? |
| | A) | docx |
| | B) | html |
| | C) | txt |
| | D) | accdb |
|
|
|
| 9 | |
What term describes a series of dialog boxes that help you complete a task? |
| | A) | Dialog box |
| | B) | Delimiter |
| | C) | Query box |
| | D) | Wizard |
|
|
|
| 10 | |
Which button on the Data tab opens the External Data Range Properties dialog box? |
| | A) | Connections |
| | B) | Data Properties |
| | C) | External Data |
| | D) | Properties |
|
|
.