CPSC 1105 - Technological Solutions: Excel Exam Study Guide
  1. EXAM - Thursday, March 30, 2006 @ 1:30 p.m. (be on time)
  2. YOU MUST HAVE A SAM ACCOUNT
  3. Bring your photo id.
  4. There are training sessions for the exam available through SAM
Excel Tasks
  1. Insert/Delete cells
  2. Merge and center cells
  3. Insert/Delete a row/column
  4. Copy/Edit values
  5. Use the fill handle to copy formulae
  6. Change value in cell
  7. Format the content of cells
  8. change fonts
  9. Correct the spelling
  10. Look up the meaning of a word in the Research Pane.
  11. Sort the items
  12. Enter values in a cell
  13. Open/close a file
  14. Save the workbook
  15. Center the headings in cells
  16. modify the height of row/width of a column
  17. Modify the orientation of the worksheet
  18. Preview the worksheet
  19. Show the formulas in the cells
  20. Use the Fit to Print option
  21. Create/edit a formula
  22. Use an absolute reference
  23. Use a function
  24. Use the Chart Wizard
  25. Print the chart only
  26. Save the current worksheet as a Web page
  27. go to specific cells
  28. add borders