Excel Unit B Quiz
Select the best answer for the question. Remember you can look in your book or, if all else fails, open Microsoft Word and look and see.
What type of cell reference changes when it is copied? (pg. 12 & 14)
- Absolute
- Circular
- Looping
- Relative
What character is used to make a reference absolute? (pg. 16)
- &
- ^
- $
- @
Which button can be used to enter data in a cell? (pg. 4)
- Undo
- X
- Copy
- Check Mark
In the order of precedence what is the second operation calculated? (pg. 7)
- Parentheses
- Exponents
- Multiplication and division
- Addition and subtraction
Which formula below is an example of a relative cell reference? (pg. 14 & 16)
- =A1+A2
- =$A$3+B2
- =#A3+B2
- =(relative)A1+A2
Which formula below is an example of an absolute cell reference? (pg. 14 & 16)
- =A1+A2
- =$A$3+B2
- =#A3+B2
- =(absolute)A1+A2
You have a list of months from January to May and you need to finish out the year, what can you use to help you do this quickly? (pg. 14)
- Type each new month by yourself
- Use the fill handle
- Copy the months you have already have
- You can’t add months