Getting Started
- Overview: Excel 2A and 2B + HTML Assignment 2
- Pages: page 589 to 642;
- File Download: E02A and E02B (Please right click and select
save link as...);
After you have followed the instructions in the manual and finished all the steps, check the following questions before you raise your hand and declare you are done.
Project 2A & 2B
Here is what you should learn from Project 2A & 2B:
- Learn to use AutoFill for series of data and for duplicating cells. Learn to use Smart Tag associated with AutoFill to customize the AutoFill actions. Note that you may select 2 cells to do AutoFill, so that you do not need to specify "copy cells" or "data series", and Excel will guess. It is also possible to input series like "1, 4, 7, ...";
- Learn how to adjust cell heights and width, how to change sizes for multiple cells at the same time, how to insert columns and rows, and what would happen when you delete a column or a cell.;
- Learn to set alignment method for a cell or multiple cells. Learn to merge multiple cells.;
- Know how to use copy, cut and paste to copy or move cell contents. Learn how to use clipboard management to copy and paste multiple cell contents to the same destination area (using "paste all"). Know how you would duplicate a whole worksheet, and how to copy data from one workbook to another;
- Recall how to set the header and footer. What is AutoFit? How to enable the currency style and the percentage style? How to increase or decreasethe decimal places? How to enable comma style for long numbers?;
- Learn how to change the range of AutoSum function, either by dragging or by editing the formula in the formula bar or in the cell under edit mode;
- Learn how to copy formulas between cells. What is relative cell reference? How would you use it to input something like "1, 2, 4, 8, 16, 32, 64"? How would you disable relative cell reference and use absolute cell reference?
- Know how to use grave accent to enable display of formulas in cells. Know how to change the page orientation for printing purpose.
HTML Assignment 2: Line Break and Horizontal Line
This will be covered at 6:30PM.