Click on the correct response for each question below.
|
1 | | When changing the name of a sheet tab, avoid using which of the following sets of characters? |
| | A) | Asterisk (*), question mark (?), forward slash (/), back slash (\), or colon (:). |
| | B) | Dash (-), underscore (_), or Space ( ) |
| | C) | Number (#), carrot (^), or at (@) |
| | D) | All of the above |
|
|
2 | | Using hyperlinks, you can connect a worksheet to: |
| | A) | a database stored on your company’s intranet |
| | B) | other Excel workbooks |
| | C) | other Office documents |
| | D) | all of the above |
|
|
3 | | To outline a worksheet, select a cell within the worksheet and then: |
| | A) | Choose: Data, Group and Outline, Auto Outline |
| | B) | Choose: Insert, Group, Auto Outline |
| | C) | Choose: View, Group and Outline, Auto Outline |
| | D) | Choose: Table, Insert Outline |
|
|
4 | | Which of the following is not true about the Spell Checker? |
| | A) | it is shared by all Office applications |
| | B) | you can not add items to the spell checker |
| | C) | it scans either a selected range or the entire sheet |
| | D) | you may select the proper spelling from a suggested list |
|
|
5 | | Sheet tabs can: |
| | A) | be renamed |
| | B) | have a color code |
| | C) | be moved to change the order |
| | D) | all of the above |
|