SST 3 COUNT Randbetween Mode.SNGL

Type in the following.

RANDBETWEEN(bottom,top)

Bottom is the smallest integer the function will return.

Top is the largest integer the function will return.

(a)  

Use a function in spreadsheet to generate a number between 200 to 800 randomly.

• RAND(200,800)

• RANDOM(200,800)

• BETWEEN(200,800)

• RANDBETWEEN(200,800)

Mode is the number that occurs most frequently in a given set of data. The MODE.SNGL function allows us to find the single mode in a data set. When there is more than one mode, the output will be the value that occurs first within the set of data. Type the following,

MODE.SNGL(number1,number2,...) MODE.SNGL(number1,number2,...) MODE.SNGL(number1,number2,...)

(a)  

Which of the following is not a feature of a vector graphic?

• Created using mathematical equations.

• Created using nodes and paths.

• Formed by small coloured pixels.

• Resizing the graphic will not affect the quality.

What will be displayed if the formula =ROUNDUP(23.1, 0) is used?

• 22

• 23

• 23.3

• 24

Which of the following file size is small due to data loss after file compression?

• bmp

• gif

• png

• tiff

State the cell address of the underlined text.

(a)  

What function could be used in cell A5 to generate a 3 digit random number between 100 and 999?

(a)  

What function involving relational operator could be used in cell D5?

D5 = (a)  

What will be the output if the formula =RIGHT(B5, 4) is entered?

(a)