# data[].attributes.attachment_link.readable_text
:TYPE:MC:1:0:C
:TITLE:Excel Functions (1)
:CAT:Excel Functions
:QUESTION:H
What is the formula for count?
:ANSWER1:0:H
=COUNT
:REASON1:H

:ANSWER2:0:H
=COUNTIF
:REASON2:H

:ANSWER3:100:H
A and B are correct
:REASON3:H

:ANSWER4:0:H
=COUNTMAX
:REASON4:H

:TYPE:MC:1:0:C
:TITLE:Excel Functions (2)
:CAT:Excel Functions
:QUESTION:H
What is the formula for sum of values?
:ANSWER1:0:H
=Sumif
:REASON1:H

:ANSWER2:0:H
=if
:REASON2:H

:ANSWER3:100:H
=sum
:REASON3:H

:ANSWER4:0:H
=rand values
:REASON4:H

:TYPE:MC:1:0:C
:TITLE:Excel Functions (3)
:CAT:Excel Functions
:QUESTION:H
What is the function for average?
:ANSWER1:0:H
=min
:REASON1:H

:ANSWER2:0:H
=max
:REASON2:H

:ANSWER3:0:H
=averagevalue
:REASON3:H

:ANSWER4:100:H
=average
:REASON4:H


# data[].attributes.body
=AVERAGE(B5:B6)

# data[].attributes.headline
Inclusive Education in Computers Applications Technology

# data[].attributes.subject
Inclusive Education in Computers Applications Technology

# data[].attributes.body
Counts the numbers and data in an excel sheet

Formula: =COUNT

# data[].attributes.headline
As a unique learner you should never think that your not able to try new things, use this quote:

# data[].attributes.subject
As a unique learner you should never think that your not able to try new things, use this quote:

# data[].attributes.body
"Always desire to learn something useful"

Sophocles

# data[].attributes.headline
The calculation to work out an excel function for sum is

# data[].attributes.subject
The calculation to work out an excel function for sum is

# data[].attributes.body
=sum(A2:A5)

Another example is shown below:

# data[].attributes.headline
Excel functions are short functions that you can use to work out data in an excel sheet 

# data[].attributes.subject
Excel functions are short functions that you can use to work out data in an excel sheet 