IDIS 110: Foundations of Information Technology

Excel Skills Checklist

By the end of the Excel exercises and videos each student will be able to ...

Skills introduced in Excel Basics (pg 2-7)

- Specify a cell address using its row and column
- Determine the active cell in a spreadsheet
- Use the tab key to move right in a spreadsheet
- Use the name box on a sheet
- Create a new workbook
- Create a valid formula
- Add or remove decimal precision from a number
- Use the sum formula to compute a total
- Use the fill handle to copy a formula
- Resize columns
- Center text in a cell
- Format cells as currency
- Add and remove columns and rows
- Add and remove a spreadsheet to a workbook
- Rename a sheet
- Freeze the top row of a spreadsheet so you can always see column titles

Skills introduced in Absolute and Relative References

- Contrast the terms "relative reference" and "absolute reference"
- Use relative and absolute references
- Recognize a mixed reference

Skills introduced in class/exercises

- Merge cells
- Sort data
- Use an IF function in a formula
- Specify a cell range using ":"