1) If I copied the formula in cell C2 down the column, which error message would I get in C4? a) None (0) b) #DIV/0! c) #VALUE! d) #REF! e) #NAME? 2) If I cleared the contents of cells A2:A6, which error message would I get in C2:C6? a) None (0) b) #DIV/0! c) #VALUE! d) #REF! e) #NAME? 3) If I entered this formula into C9, which error message would I get? a) None (0) b) #DIV/0! c) #VALUE! d) #REF! e) #NAME? 4) If I entered this formula into B2, which error message would I get? a) None (0) b) #DIV/0! c) #VALUE! d) #REF! e) #NAME? 5) Which error message would appear if you copied the contents of B7 into D1? a) None (0) b) #DIV/0! c) #VALUE! d) #REF! e) #NAME? 6) Which error message would appear if you entered the formula into F2? a) None (0) b) #DIV/0! c) #VALUE! d) #REF! e) #NAME? 7) Which error message would appear if you entered this formula into F2? a) None (0) b) #DIV/0! c) #VALUE! d) #REF! e) #NAME? 8) Which error message would appear if you entered this formula into F9? a) None (0) b) #DIV/0! c) #VALUE! d) #REF! e) #NAME? 9) Which error message would appear if you entered this formula into E7? a) None (0) b) #DIV/0! c) #VALUE! d) #REF! e) #NAME? 10) Which error message would appear if you entered this formula into E3? a) None (0) b) #DIV/0! c) #VALUE! d) #REF! e) #NAME?
0%
Excel Formula Errors
共享
共享
共享
由
Katiehibner
编辑内容
打印
嵌入
更多
作业
排行榜
显示更多
显示更少
此排行榜当前是私人享有。单击
，共享
使其公开。
资源所有者已禁用此排行榜。
此排行榜被禁用，因为您的选择与资源所有者不同。
还原选项
随堂测验
是一个开放式模板。它不会为排行榜生成分数。
需要登录
视觉风格
字体
需要订阅
选项
切换模板
显示所有
播放活动时将显示更多格式。
打开成绩
复制链接
QR 代码
删除
恢复自动保存：
？
Katiehibner