CPA 3NT SST 3b

What would the output be? =LEN("x y z")

• 1

• 3

• 5

• 7

What would the output of =LEN(ABCDE) ?

What would the output of =LEN("ABCDE") ?

What would the output be? =LEN("")

• 1

• 2

• 4

• 0

Mode is the number

• that occurs most frequently in a set of data

• is in the middle position of a set of data in ascending order

• is the average of the set of data

Which formula can be used to return data which appears most frequently?

• =DATA()
• =MEDIAN()
• =MODE.SNGL()
• =SUM()

What would the output be? =MODE.SNGL(A1:G1)

• 1

• 4

What would the output be? =MODE.SNGL(A1:E1)

• 1

• 2

• 3

• 4

What would the output be? =MEDIAN(A1:D1)

• 1

• 1.5

• 2

• 2.5

• 3

What would the output be? =MEDIAN(B1:D1)