Use this log to reportcompletion of Introduction to Excel
located at: http://www.internet4classrooms.com/excel_task.htm
 Before starting the module, print this log.

Excel opens with three worksheets in a workbook. They are names sheet 1, sheet 2 and sheet 3. Change the names of the three sheets to attendance, average, and projects. Explain how to do that.



Name at least two things that can be accomplished by right-clicking on the name of the sheet in the tab. (Yes Macintosh users, you too can right click.)



You want to fill information from one cell into several other cells. Describe what the cursor will look like if Excel is ready to fill.



You want to display the number 3.141593 (pi) as a number with only two decimal places. Explain how you would do that.



The number 3.14 in a cell does not represent pi (in this example) it represents the price of a piece of pie. What is a quick way to ask Excel to display the number as $3.14?



I typed "pumpkin pi" in a cell, accidentally leaving off the final "e." I know I can click back on the cell and retype the entire two words, but I just want to add the final e. Explain how to do it.



I typed the number 1 into a cell, made sure I had the auto fill cursor, and attempted to fill to the right, but all of the cells contained the number 1. Explain why, and how to get Excel to fill the numbers 1 ,2, 3 and 4 into the cells.



You have a set of numbers in a column and want to very quickly find out the total of those numbers. How do you do it?



You want cells A1, B1, C1, D1 and E1 to be displayed as a single cell that stretches across all five columns. Explain how to do that.



In three adjacent cells I entered "6 students," "10 students" and "4 students." Excel Auto Sum was not able to tell me that I had 20 students. Why not?



You have a column of 10 numbers and you want to find the sum. However, there is a gap in the numbers and Excel has only picked up the first three numbers in the range. Explain how to correct this to include all 10 numbers in the equation.



Other than the "Today" function, list four other Date and Time functions (equations) available in Excel.



You are ready to write your own equation in an Excel worksheet. What is the first thing that you do?



You have written your own equation and it is correct. List the two ways that you let Excel know that you want to have the equation accepted (officially entered into the cell).



Scenario: Bill took three tests scoring 90, 80, and 70. The average of his tests counts as one-fourth of Bill's grade. What number value has Bill achieved toward his term grade? (show your work or explain your reasoning)



You want to write an equation that will always make reference to the same cell (cell D14), regardless where you paste the equation. How will you write D14 in the equation?



You want to right-click on a cell in Excel but you are using a Macintosh computer. OK, OK, even if you are using a Windows/PC computer, pretend you are using a Mac. How do you make it right click in Excel?



Use the data given on the Excel survey page to produce a worksheet of favorite ice cream flavors. Print the worksheet and include it with this log. Save your work, you will need it for #19.



Use the data in your ice cream worksheet to produce a pie chart. Instructions for this procedure are given on the Create a Chart page. Print the chart and include it with this log.



Download the M & M Spreadsheet to your desktop. Open the document from inside Excel, do not double-click the icon. Print only the extended activities page and include that with your log.



Teacher's Name _______________________________________________

Teacher's Signature ________________________________________________

School __________________________________________________

Principal's Signature ________________________________________________

Date of completion _____________________

 


Enter text in the search box
Search the Internet4Classrooms site


Visitors since November 2000
Click for Memphis, Tennessee Forecast
Memphis, TN

Internet4Classrooms is a collaborative effort by Susan Brooks and Bill Byles