CST 151 - Spreadsheet Fundamentals

1. Use the components of the Excel window.
   1. Use basic spreadsheet file operations.
   2. Apply features found in groups within the tabs on the ribbon.
   3. Use and modify the Quick Access toolbar.
   4. Use the Help feature.
   5. Use shortcut menus.
   6. Use the scroll bar.
   7. Use the formula bar.
   8. Use the status bar.
   9. Use viewing buttons.
2. Create and print worksheets.
   1. Plan, design, build, and review a worksheet.
   2. Enter labels, values, and formulas.
   3. Edit cell entries.
3. Demonstrate skill in enhancing a worksheet.
   1. Change font and font style and apply font effects.
   2. Add borders and shading.
   3. Create and print headers and footers.
   4. Copy formulas.
   5. Identify relative and absolute cell references.
   6. Format numbers.
4. Create and print charts, illustrations, or tables.
   1. Create charts, illustrations, and tables.
   2. Specify titles, legends, and axis labels.
   3. Preview and print charts, illustrations, and tables.
5. Use built-in functions.
   1. Use the SUM, AVG, COUNT, MAX, and MIN functions.
   2. Use various financial functions.
   3. Use various date and time functions.
   4. Use various logical functions.
   5. Use various lookup and reference functions.
6. Create and use macros.
   1. Record, place, and play a macro.
   2. Name a macro and create a macro button.
   3. Edit and debug a macro.
7. Create and use a worksheet database.
   1. Create a database.
   2. Sort data and queries in a database.
   3. Find records in a database.
8. Integrate worksheet applications.
   1. Combine and link multiple worksheets.
   2. Paste, link, and embed objects between various software applications.
9. Demonstrate professionalism appropriate for the workplace.
   1. Participate in class.
   2. Follow written and oral directions.
   3. Complete and submit assignments on time.
   4. Participate constructively in activities.