1. a formula =a1+b2 is in cell d8. if you copy that formula to cell d9, what is the new formula in cell d9?
a. '=a1+b2
b. '=a2+b3
c. '=a2+b2
d. '=b1+c2

2. the =count function calculates what value?
a. adds up the values in the range of cells provided
b. identifies how many cells were in the range
c. identifies how many cells with data were in the range
d. identifies the maximum value in the range

3. the following numbers are sorted in which way: 10, 20, 30, 40?
a. ascending
b. descending
c. shuffled

4. a cell reference =sum(sheet1.a1,sheet2.a2) will place the results in which of the following?
a. the current worksheet
b. worksheet sheet1
c. worksheet sheet2