Assignment for today
Summary
You are to work on your own for this assignment.
We've covered everything you need to know to complete this
assignment. If we haven't covered
it yet, then I've indicated how to do that in these instructions.
You MAY NOT ask your classmates for help. You may raise your hand to ask for help
from me. You may also access
the Microsoft Excel Help in the Help
menu to try and figure it out on your own.
If you talk, you will receive
a SINGLE warning.
If you talk a second time,
the following punishments will be enforced:
1.
You will receive a 0 for the assignment,
2. You will be asked to leave my room,
and
3. You
will have to come in at lunchtime or after
school to complete the assignment.
Since we saved our file on the desktop last time, you need
to move it to your network folder.
Log on to the network
Move your file from the desktop to your network folder
If you copy instead
of move, then you need to delete your file off of the desktop.
Task
In cell, D3, type the words "Years from today".
In cell, E3, type the words "Years old"
Type a formula that finds out how many years from today is
the year of your birth. This
formula will be in the first cell under the column header that says "years
from today".
Using functions within functions, we find the year
of today's date and subtract the year of your birthday. For the year of your birthday, you will
use the cell address where your birth date can be found and substitute the
cell address for the question mark below.
=year(today())-year(?)
Copy this formula from this
cell to all the cells below it until you reach the last student in your class.
Save the file
Format
In order to format, click
on the cell(s) you want to format and then click on the Format menu, then
click on Cells. DO NOT WASTE TIME FORMATTING. ONLY FORMAT WHAT I TELL YOU
TO BELOW.
Format the font, borders,
and shading is some way so it looks nice and not confusing
- "Not confusing" means in a clear and simple
way so it is easy to read and easy to follow the information in the cells.
- It is typical to have the column headings (the titles
of the columns that show what information appears below them)
- It is also typical to have the column headings aligned
in the same way as the data below it. So if a date formats to the right and the column heading to
the left, then you want to make their alignment all left, all right or all
center.
- If you format the information under the column headings, then it is typical
to format it all the same or format it so rows are the same so it is easy
to follow the information across the page.
Format the title in A1 of
your spreadsheet so its alignment is centered across the cells across the
entire width of your data (columns A through E) so you will select cells A1
through E1.
Save the file
Challenging task
Once, you've done that, try
to create a formula, which calculates your age in years and put it in the
column under the words "years old". You will need to utilize the
IF function and the other two functions we've used so far.
Copy this formula to the
cells below this
Save the file
Additional Formatting
If you wish to add or change
formatting you may do so.
Save the file