Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Handling Data 6 starter

Total questions: 7

Worksheet time: 4mins

Name
Class
Date
1.

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

a)

=Max(A1:A10)

b)

=Min(A1:A10)

c)

=Sum(A1:A10)

d)

=Average(A1:A10)

2.

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

a)

=Max(A1:A10)

b)

=Min(A1:A10)

c)

=Sum(A1:A10)

d)

=Average(A1:A10)

3.

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

a)

=Max(A1:A10)

b)

=Min(A1:A10)

c)

=Sum(A1:A10)

d)

=Average(A1:A10)

4.

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?

a)

True

b)

False

5.

What do all formulae and functions in EXCEL begin with?

a)

=

b)

+

c)

*

d)

/

6.

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?

a)

Plagiarism

b)

Citation

c)

Paraphrasing

d)

Copyright

7.

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.”

a)

Respectful

b)

Not respectful