NEW
Font size
WorksheetsGoogle sheets Basic -2025 - J2I-2
Total questions: 32
Worksheet time: 25mins
Which is the operator for multiplication?
^
/
*
=
Which is the operator for Division?
^
/
*
=
Which is the operator for Subtration?
+
/
*
-
Which is the operator for Addition?
+
/
*
-
Select ______________ from the functions drop-down menu to add a set of numbers together.
average
count
max
sum
min
Mr. Esker wanted to see how the class did as a whole on the most recent test. Using spreadsheets he used the ______________ function to calculate the classes score as a whole.
average
count
max
sum
min
Mr. Tone wanted to see which student received the highest score on the last Quizizz. In his spread sheet he used the ______________ function to identify the highest score.
average
count
max
sum
min
Betty has a spreadsheet of sales for her bakery for a month. In one column she lists the amount of donuts sold each day. If she wanted to find out what day she sold the LEAST amount of donuts she would use the _________________ function.
average
count
max
sum
min
Mr. Esker is looking over his quiz data again in his spreadsheet. He wanted to know how many students received an 80% on his latest quiz. In his spreadsheet he would use the ___________________ function.
average
count
max
sum
min
按照试算表，D2可以写成怎么样的直接运算格式 (formulea)
=A2+B2+C2
=B2+C2+D2
=A3+B3+C3
=A1+B1+C2
按照试算表，E3 可以写成怎么样的直接运算格式 (formulea)
=(A2+B2+C2)/3
=(B2+C2+D2)/3
=(A3+B3+C3)/3
=AVGRARE(A3:C3)
按照试算表，F2 可以写成怎么样的直接运算格式 (formulea)
=A3+C3
=A2+C2
=A2+B2
=SUM(A2:C3)
按照试算表，G2 可以写成怎么样的直接运算格式 (formulea)
=(C2-A2)/2
=C2*A2
=C2-A2
=C3-A3
按照试算表，H3 可以写成怎么样的直接运算格式 (formulea)
=(A2+C2)/2
=(C3-A3)/B3
=(C2+A2)/B3
=(C3-A3)/B2
按照试算表，i2 可以写成怎么样的直接运算格式 (formulea)
=(A2-B2)*20%
=(A3-(B3*20%)
=(A2*20%)-B2
=A2-(B2*20%)
按照试算表，J3 可以写成怎么样的直接运算格式 (formulea)
=B3*3%
=B2*3%
=B2*3
=B3*3
