Handling Data 6 starter

1.Which function will tell you the largest value in cells A1 to A10?

• =Max(A1:A10)

• =Min(A1:A10)

• =Sum(A1:A10)

• =Average(A1:A10)

1.Which function will add up the values of the numbers in cells A1 to A10?

• =Max(A1:A10)

• =Min(A1:A10)

• =Sum(A1:A10)

• =Average(A1:A10)

1.If 5 is typed into every cell from A1 to A10 which of the functions will give the highest answer?

• =Max(A1:A10)

• =Min(A1:A10)

• =Sum(A1:A10)

• =Average(A1:A10)

True or False: 1.If 'True' is typed into every cell from A1 to A10 will these 2 functions: =Counta(A1:A10)

=Countif(A1:A10,"True")

give the same answer?

• True

• False

What do all formulae and functions in EXCEL begin with?

• =

• +

• *

• /

You acknowledging where you have got facts or information by including the address of the website where it is from is also known as what?

• Plagiarism

• Citation

• Paraphrasing

• Copyright

Is the content of this email respectful or not respectful? “Hi Sir, I really didn’t like the lesson today and you should make it more fun tomorrow.”

• Respectful

• Not respectful