Web Analytics
daij2
Answered

  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

  1. The =COUNT function calculates what value?
Aadds up the values in the range of cells provided
Bidentifies how many cells were in the range
Cidentifies how many cells with data were in the range
Didentifies the maximum value in the range

  1. The following numbers are sorted in which way: 10, 20, 30, 40?
Aascending
Bdescending
Cshuffled

  1. A cell reference =SUM(sheet1.A1,sheet2.A2) will place the results in which of the following?
Athe current worksheet
Bworksheet sheet1
Cworksheet sheet2

Verified Answer :

  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 
janessa0804

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


Related Questions