EA2 Ch4 Definition Some Formula

What is the formula to calculate the sum of cells A1 and B1 in Google Sheets?

• =A1*B1

• =SUM(A1,B1)

• =A1+B1

• =A1-B1

Which formula can be used to find the average of a range of cells in Google Sheets?

• AVERAGE

• MAX

• MIN

• SUM

What formula should be used to calculate the product of cells A1 and B1 in Google Sheets?

• =A1*B1

• =A1+B1

• =A1/B1

• =A1-B1

In Google Sheets, what formula can be used to calculate the maximum value in a range of cells?

• MAXIMUM

• SUM

• AVERAGE

• MAX

Which formula should be used to calculate the minimum value in a range of cells in Google Sheets?

• MINIMUM

• AVERAGE

• SUM

• MIN

What formula can be used to calculate the square root of a number in Google Sheets?

• =SQUARE(number)

• =ROOT(number)

• =SQRT(number)

• =POWER(number, 0.5)

In Google Sheets, what formula should be used to calculate the percentage of a number?

• =number - percentage/100

• =number / percentage

• =number * percentage/100

• =number + percentage/100

Which formula can be used to calculate the exponential value of a number in Google Sheets?

• EXP

• POW

• LOG

• SIN

What formula should be used to calculate the logarithm of a number in Google Sheets?

• =LOG(number)

• =LOG(number, base)

• =LOG10(number)

• =LN(number)

In Google Sheets, what formula can be used to calculate the absolute value of a number?

• SUM

• ABS

• AVERAGE

• MAX