Lesson #3: In
this lesson you will learn how use Autofill and how to
use the Pointing function.
completing the DEMO
PROBLEM you will have enough visual basis and
knowledge to work alone with excel in similar situation.
1.The fill handle is the quickest way to copy a cell to where?
a) The cells in A1
b) The cells that are adjacent to the cell your working with
c) The cells on a different excel document
d) No cells are copied using the fill handle
2.What is the first mode you should be in when you are pointing?
a) Point mode
b) Edit mode
c) Enter mode
d) Ready mode
3.What button do you push in the tool bar to access the Paste Function?
a) Autosum (Sigma sign)
b) Paste (clip board with little paper)
c) Copy (two pieces of paper)
d) Insert Function (fx)
4.What is the best way to average values in cells B1-B4?
b) =Average(B1, B4)
c) Neither a or b
d) both a and b are great ways to find the average
5.5.Cells A1, A2 and A3 have the numbers 7, 10 and 1 respectively. If in A4 the function typed is =
Sum(A1: A3), then what will be the number that appears after you hit the
enter key after the function?
6.6.When using the fill handle, what corner do you use to pull down to the range you would like?
a) lower right
b) lower left
c) upper right
d) upper left
back to lesson #2