Spreadsheet Skills Quiz

What is the first step in entering data into a spreadsheet cell?

• Double-click the cell

• Right-click the cell

• Click the cell and start typing

• Press the 'Enter' key on the cell

How do you write a formula in a spreadsheet that adds the values in cells A1 and A2?

• A1 + A2

• =ADD(A1, A2)

• =A1 + A2

• =SUM(A1, A2)

Which function would you use to find the average of the numbers in cells B1 through B10?

• =AVERAGE(B1:B10)

• =AVG(B1-B10)

• =SUM(B1:B10)/10

• =MEAN(B1:B10)

What is the correct syntax to multiply two cells (C1 and C2) in a spreadsheet?

• =C1 * C2

• =MULTIPLY(C1, C2)

• =C1xC2

• =PRODUCT(C1, C2)

Which of the following is NOT a valid function in spreadsheets?

• =MAX()

• =MIN()

• =TOTAL()

• =SUM()

How do you reference a cell located in column D and row 5?

• D5

• 5D

• Column D, Row 5

• D-5

What does the function =COUNT(A1:A10) do?

• Adds all numbers in cells A1 through A10

• Divides the first cell by the last cell

• Counts all cells that contain numbers in the range A1 to A10

• Multiplies all values from A1 to A10

To apply a formula to an entire column in a spreadsheet, what feature should you use?

• Drag the fill handle

• Copy and paste

• Insert function

• Manual entry

What is the result of the formula =MOD(10, 3)?

• 3.33

• 1

• 3

• 10

Which function would you use to count only the cells with text in a range A1:A10?

• =COUNTA(A1:A10)

• =COUNTTEXT(A1:A10)

• =TEXTCOUNT(A1:A10)

• =COUNTSTRINGS(A1:A10)