01. What Function does the ‘Compare Side by Side With’ command on the window menu perform?
Ans: It allows you to scroll through two or more workbooks simultaneously
02. Which of the following functions would return a value of 8?
Ans: round(8.4999,0)
03. 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
Ans: 0
04. How can you select all the blank cells in your worksheet?
Ans: Choose blank in the Edit->Go to->special Menu option
The question is based upon the figure shown
05. The figure shows a view of the standard Toolbar. What function is performed by the button Marked by the letter Y?
Ans: Its adds up the values in the selected cells
06. You have entered test in a cell which is too big for the cell. You want the text to appear in multiple lines inside the same cell. What will you do?
Ans: Use the wrap txt option in the Format->Cells>Alignment Menu
07. Which of the following errors appears when an invalid argument is passed while converting a number from one number system to another system?
Ans: It allows you to scroll through two or more workbooks simultaneously
02. Which of the following functions would return a value of 8?
Ans: round(8.4999,0)
03. 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
Ans: 0
04. How can you select all the blank cells in your worksheet?
Ans: Choose blank in the Edit->Go to->special Menu option
The question is based upon the figure shown
05. The figure shows a view of the standard Toolbar. What function is performed by the button Marked by the letter Y?
Ans: Its adds up the values in the selected cells
06. You have entered test in a cell which is too big for the cell. You want the text to appear in multiple lines inside the same cell. What will you do?
Ans: Use the wrap txt option in the Format->Cells>Alignment Menu
07. Which of the following errors appears when an invalid argument is passed while converting a number from one number system to another system?
