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?

Excel Formula Errors

הדפסה
הטבעה

לוח תוצאות מובילות

סגנון חזותי

אפשרויות

החלף תבנית

האם לשחזר את הנתונים שנשמרו באופן אוטומטי: ?