加工薪资管理表课堂测试
Authored by 'la'vida viva
Computers
7th Grade
Used 9+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
5 questions
Show all answers
1.
MULTIPLE SELECT QUESTION
30 sec • 1 pt
下列选项中使用函数的公式有哪些
=A2*B5/B6+100
=C2*B7-B6+100^2
=SUM(A2:G2)
=AVERRAGE(J2:B7)*2/6
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
图中属于什么类型的运算符？
比较运算符
算术运算符
文本运算符
引用运算符
3.
FILL IN THE BLANKS QUESTION
30 sec • 1 pt
引用运算符的作用是对单元格区域中的数据进行合并计算，其中冒号“：”为区域运算符，逗号“，”为联合运算符， (a) ("冒号" , "逗号")运算符用于引用多个单元格区域？
4.
MULTIPLE CHOICE QUESTION
30 sec • Ungraded
在公式中引用$B$6单元格，则不论将公式复制或移动到什么位置，引用的单元格地址的行和列都不会变化。
对
错
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
公式中引用G$6单元格，用了什么单元格引用方式？如公式所在单元格的位置改变，行列变化如何？
用了混合引用，行变列不变
用了混合引用，列变行不变
用了相对引用，行列都变
用了绝对引用，行列都不变
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports
Continue with Google
Continue with Email
Continue with Microsoft
or continue with
%20(1).png)
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?
