Informatika | Alapismeretek, ECDL » Practice Activity Competency

Source: http://www.doksinet Lakewood Technology Competencies Level 1 Basic Technology Skills Practice Activity: Competency 1.3 Demonstrates Basic Operations & Concepts of Excel Since many teachers are less familiar with, and have less call to use, Microsoft Excel than other parts of the Microsoft Office suite, the assessment for this competency is designed more as a guided exploration than the assessments for other competencies. The following steps mirror that exploration, for those teachers who wish to practice before taking the actual assessment. Directions:  Open Excel to create a new workbook. Also open a new Word document As you work through this assessment, you will be completing tasks in Excel and answering questions in Word.   Click and drag through cells A1 through G1 to highlight these cells. Click on the Merge and Center button on the toolbar. Notice the effect that this button has on the selected cells. What might you use this for?  Type “Major

Cities of the Pacific Northwest” in this merged cell.  Enter the following data in the Excel workbook:  Click on the row number for Row 3, and then go to Window  Freeze Panes. Try scrolling down through the workbook and observe what happens. Which rows remain unchanged as you scroll? If you wanted to freeze the top 5 rows, which row would you need to click in before going to Window  Freeze Panes? Source: http://www.doksinet Lakewood Technology Competencies Level 1 Basic Technology Skills       Place the cursor on the line between Column A and Column B, so that it looks like this: Double click with the cursor like that. Repeat this step between Column B and Column C, and between Column C and Column D. Notice the effect that double clicking on the column boundary has on the workbook. Also try clicking and dragging on the column boundary. What effect does that have? Click on cell A3 and drag diagonally down to cell C14, so that you highlight

all of the data, but not the column header row. Go to Data  Sort In the Sort dialog box that opens up, select “Population” from the drop-down menu and check the Descending button. Notice the effect that Data  Sort has on the workbook. Click on cell A2 and drag diagonally down to cell C14, so that you highlight all of the data, including the column header row. Go to Data  Filter  AutoFilter. Click on the drop-down arrow that has appeared next to the State column header. Choose “WA” from the list Go back to that drop-down and choose “OR”. Go back to that drop-down and choose “(All)” Again, notice the effect that these filters have on the workbook. How might you use filters to manage large amounts of data? Click on cell A14 and drag over to cell C14, to highlight these three cells. Go to the borders button on the toolbar, and select the Thick Bottom Border from the drop-down: Source: http://www.doksinet Lakewood Technology Competencies Level 1 Basic

Technology Skills  Click on cell C15, and then click on the AutoSum button on the toolbar. Excel will automatically insert the function to find the sum of the populations in this column. The format of this function is as follows: =SUM(C3:C14) The equals sign tells Excel that what follows is a function. The word “SUM” tells Excel to add the values in the selected cells. The contents of the parentheses tell Excel what cells to use for the function. In this case, the selected cells start with cell C3 and continue through cell C14. The colon tells Excel to include all of the cells in between   Explore some of the other functions on the AutoSum drop-down. There are other functions available using the More functions link at the end of the list, or by going to Insert  Function. How might you use these functions to manipulate data. Select cells A3 through C14 again, and then click on the Chart Wizard button on the toolbar. o Select “Clustered column with a 3-D visual

effect” and click Next. o On the next screen, do not change anything. Click Next again o On the third screen of the Chart Wizard, give the chart a title (“Populations of NW Cities”) and a label for the Value axis (“Population”). o Still on the third screen of the Chart Wizard, click on the Legend tab, and uncheck the box for “Show legend”. Click Next o On the final screen of the Chart Wizard, select the button for “As a new sheet” and click Finish.  Your chart will now be displayed on its own sheet. To get back to the data, you can click on the Sheet 1 tab in the lower left part of the screen: Source: http://www.doksinet Lakewood Technology Competencies Level 1 Basic Technology Skills  Format your chart for printing: o Double click on the grey background of the chart and set the Area color to None. o We want to omit the state name.  To do this, right click on one of the column on the chart and choose “Source data”.  Click on Series tab and then

click on the Category (X) axis labels box. icon at the end of the  This takes you back to the data. Notice that both the city names and the state names are outlined with a blinking dotted line. Click and drag from cell A3 to A14 so that just the cities are outlined.  Click on the icon on the floating toolbar, and then click OK. o Double click on the name Seattle. On the Alignment tab, set the degrees to 45 and then click OK.  Explore other types of charts and other chart options. Try double clicking on other areas of the chart, such as right on the horizontal axis or right on a gridline. What options come up?