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

Respuesta :

1. Answer is B   (D9=A2+B3)
2. 
C. identifies how many cells with data were in the range 
3. 
A. ascending (smallest to largest)
4. A. the current worksheet 

Answer:

1. '=A2+B3

2. identifies how many cells with data were in the range

3.  ascending

4. the current worksheet

i took the test