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 代碼
刪除
恢復自動保存:
?