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