We are learning the number keypad. Click on http://www.typeonline.co.uk/number_pad_lesson1.html
Choose exercise 2 and then click on the word “start.”
Time will not start until you put your cursor in the white rectangle and start typing.
Record your typing speed and accuracy on a piece of paper.
What are we learning today? 4.2 Creation and formatting of Spreadsheets
Guided Practice: Learn the following flashcard skills:
02 Color Scales- Home tab, click Conditional Formatting, click color scales
04 Sparklines-
Insert tab, click Column Sparklines, highlight where you want sparklines, click Marker color, Negative points red
Insert tab, click Line Sparklines, highlight where you want sparklines, click Show Marker
06 Alignment of data - Home tab- top of the alignment group
14 Merge Cells- Home tab, Merge and center button
16 Hide and Show Rows- right click on row 12 and choose hide, highlight column labels E and G and right click and choose unhide.
19 Hide worksheet- right click on tab and choose hide
Independent Exercise:
Open your Hurricanes file:
1. Finish finding the sum, max, min and averages of columns D, E and F.
2. Use any color scale on column E.
3. Merge cells H4 and I4.
4. Hide column B.
5. Insert column sparklines at the bottom of Column D in cell D14.
6. Align the hurricane names in Column A counter clockwise.
No comments:
Post a Comment