Excel Days

Excel Days

Complete the following exercises using Excel.

Submit the 3 assignments to the Portal

1. Excel Practice - directions and example to follow

1. column of 100 1's
2. column of counting from 1-100
3. column of counting by 2's to 100
4. column of counting by 5's to 100
5. column of counting by 10's to 100
6. Heading - Excel Practice (merged and centered)
1. Bold, larger than cell text, colored font and colored fill
7. Date in one column
8. Convert one full column of numbers to currency formatting
9. Use the function button to sum all the rows
1. include a title on the column of the sums
10. At the bottom of each column compute using functions
1. sum
2. average
3. max

2. M&M's

3. Grades

Snip of Demonstration of Excel Practice in class