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 _____________________