Excel Days
Complete the following exercises using Excel.
Submit the 3 assignments to the Portal
1. Excel Practice - directions and example to follow
- column of 100 1's
- column of counting from 1-100
- column of counting by 2's to 100
- column of counting by 5's to 100
- column of counting by 10's to 100
- Heading - Excel Practice (merged and centered)
- Bold, larger than cell text, colored font and colored fill
- Date in one column
- Convert one full column of numbers to currency formatting
- Use the function button to sum all the rows
- include a title on the column of the sums
- At the bottom of each column compute using functions
- sum
- average
- max
2. M&M's
3. Grades
Snip of Demonstration of Excel Practice in class