={SUM(IFERROR(Data,"")) }this only searches for errors in Datathis sums the value of Datathis returns an error if Data has errorsthis returns a zero for an error and then counts it

function sum(data1: number, data2?: number) {    if(data2){        const data3: number = 10;        return data1 + data2 + data3;    }    else {        return data1 + data3;    }}const myAnswer1: number = sum(5);const myAnswer2: number = sum(10,15);console.log(myAnswer2);console.log(myAnswer1);*1 point15, 3535, 15

What is the output of the below code snippet? x=0for y in range(21):x+=yprint xSelect one:a.None of the Aboveb.Errorc.Sum of numbers up to 21(including)d.Sum of numbers up to 20(including)

COUNTIF cannot be used in an array formula, since by default it processes data as an array True False

At the beginning of an Excel spreadsheet formula, the function of the word '=SUM' is

At the beginning of an Excel spreadsheet formula, the function of the word '=SUM' is*3 pointsTo tell the person viewing that this is a function and it should be added together.To inform the computer that an arithmetic function will occur.To add all the data together using addition only.To calculate all the data correctly without any mistakes.