A-4,- (a) The following functions are used in a spreadsheet program:
AND, Average, OR, TRUE, IF, AveragelF
Classify them as either Statistical or Logical functions. (3 marks)November 2022
JemshahEnlightened
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please briefly explain why you feel this question should be reported.
Please briefly explain why you feel this answer should be reported.
Please briefly explain why you feel this user should be reported.
A-4,- (a) The following functions are used in a spreadsheet program:
AND, Average, OR, TRUE, IF, AveragelF
Classify them as either Statistical or Logical functions. (3 marks)November 2022
AND, OR, and IF are Logical functions. They are used to evaluate conditions and return a Boolean value (True or False) based on the outcome of the evaluation. AVERAGE and AVERAGEIF are Statistical functions. They are used to calculate the average value of a set of numbers.