 |
| 1 | |
A key Excel skill is knowing how to access and convert data for use in your Excel worksheets. Explain why this is important and briefly discuss the types of files that can be imported. |
| | |
|
|
|
| 2 | |
Discuss Data Connections and how this feature keeps your Excel information current. |
| | |
|
|
|
| 3 | |
Conditional formatting is a useful way to visually highlight certain data. Describe the two basic Conditional Formatting commands, Highlight Cells Rules and Top/Bottom Rules and give an example of how each might be used. |
| | |
|
|
|
| 4 | |
Explain how you would create a Custom AutoFilter to display specific data in your Excel worksheet. |
| | |
|
|
|
| 5 | |
Explain how worksheet protection works and why you might want to use it. |
| | |
|
|