Planilha do Google: Fórmulas Básicas

Which formula should you use to sum the values of cells A1 to A5 in a Google spreadsheet?

• =SUM(A1:A5)

• =SOMAR(A1:A5)

• =ADD(A1:A5)

• =TOTAL(A1:A5)

If you want to calculate the average of the values contained in cells B1 to B10, which formula would be the most appropriate?

• =AVERAGE(B1:B10)

• =MÉDIA.É(B1:B10)

• =MÉDIA.B1:B10

• =AVERAGE(B1:B10)

To multiply the value of A1 by the value of B1 in a cell, which formula should be used?

• =A1*B1

• =MULT(A1,B1)

• =MULTIPLY(A1:B1)

• =A1*B1*

If you have the following values in cells A1 to A5: 2, 4, 6, 8, and 10, what will be the result of the formula =SUM(A1:A5)?

• 30

• 25

• 50

• 40

Which formula should be used to calculate the average of the values in cells C1 to C5?

• =AVERAGE.C1:C5

• =AVERAGE(C1:C5)

• =AVERAGE(C1:C5)

• =MEDIA(C1:C5)

If you have the following values in cells B1 to B4: 3, 6, 9, and 12, what will be the result of the formula =AVERAGE(B1:B4)?

• 10

• 7.5

• 9

• 8

In a spreadsheet cell, you use the formula =A1*B1. The value of A1 is 5 and B1 is 3. What will be the result of this operation?

• 15

• 8

• 30

• 12

Which formula should you use to calculate the sum of A1, A2, A3, and A4 and then multiply the result by 2?

• =SUM(A1:A4)*2

• =A1+A2+A3+A4*2

• =MULT(SUM(A1:A4),2)

• =SUM(A1:A4)*2*

What is the result of =SUM(10, 20, 30, 40) in a Google spreadsheet?

• 100

• 90

• 80

• 70

If you use the formula =AVERAGE(A1:A3) and the cells A1, A2, and A3 contain 4, 6, and 8, respectively, what value will be displayed?

• 6

• 7

• 5

• 4