Odesk Test Answers "Excel 2003"
1. Question: What Function does the
‘Compare Side by Side With’ command on the window menu perform?
Answer: It allows you to scroll through two or more workbooks simultaneously
Answer: It allows you to scroll through two or more workbooks simultaneously
2. Question: Which of the following
functions would return a value of 8?
Answer: round(8.4999,0)
Answer: round(8.4999,0)
3. Question: What will be the output
of the function IF(ISNA(MODE(B1:B4)),0,MODE(B1:B4)) when it is applied to the
data series given bellow?
B1:27
B2:22
B3:28
B4:21
Answer: 0
B1:27
B2:22
B3:28
B4:21
Answer: 0


