Data and Spreadsheets

What is the decimal equivalent of the binary number 1100?

• The decimal equivalent of the binary number 1100 is 12.

• The decimal equivalent of the binary number 1100 is 10.

• The decimal equivalent of the binary number 1100 is 20.

• The decimal equivalent of the binary number 1100 is 13.

In a computer, all data is stored in binary form. A binary digit has two possible states.

• 0 or 1

• 1 or 2

• 1 or 10

• 1 - 10

• False

Fill in the blank: To count the number of cells in the range C1:C20 that contain numbers, you would use the formula ______.

• =COUNT(C1:C20)

• =COUNTA(C1:C20)

• =COUNTIF(C1:C20, ">0")

• =COUNTNUM(C1:C20)

What formula would you use to find the minimum value in the range D1:D10?

• =MIN(D1:D10)

• =LOWEST(D1:D10)

• =SMALLEST(D1:D10)

• =MINIMUM(D1:D10)

Fill in the blank: To sum only the even numbers in the range E1:E10, you would use the formula ______.

• =SUMIF(E1:E10, "even")

• =SUMIF(E1:E10, MOD(E1:E10,2)=0)

• =SUMIF(E1:E10, ">0")

• =SUMIF(E1:E10, "even numbers")

Which formula would you use to calculate the product of the range F1:F5?

• =PRODUCT(F1:F5)

• =MULTIPLY(F1:F5)

• =PROD(F1:F5)

• =MULT(F1:F5)

Fill in the blank: To find the median of the range G1:G10, you would use the formula ______.

• =MEDIAN(G1:G10)

• =MIDDLE(G1:G10)

• =MED(G1:G10)

• =MID(G1:G10)

What formula would you use to find the sum of squares of the range L1:L5?

• =SUMSQ(L1:L5)

• =SQUARESUM(L1:L5)

• =SUMSQUARES(L1:L5)

• =SQUARESUMS(L1:L5)

Fill in the blank: To find the logarithm of the values in the range M1:M10, you would use the formula ______.

• =LOG(M1:M10)

• =LOGARITHM(M1:M10)

• =LN(M1:M10)

• =LOG10(M1:M10)

What is the item in CELL D:12?

• Repair Service

• Accessories

• Software

• 150 GB Hard Drive