1. | Which of the following functions are correct syntactically? |
A. |
B. |
C. |
D. |
2. | Which of the following function syntax is correct? |
A. |
B. |
C. |
D. |
3. | The formula present in cell D7 of book1, sheet2, is =sum(A2:A5). The same formula is copied to another workbook, book2 and pasted in sheet2, cell C7. Select the most appropriate outcome? |
A. |
B. |
C. |
D. |
4. | Is addition of rows and columns is possible beyond defined limit |
A. |
B. |
C. |
5. | When you first create a comment, what appears in the comment text box? |
A. |
B. |
C. |
D. |
6. | The Name box |
A. |
B. |
C. |
D. |
7. | Cell formatted as ";;;" will result in |
A. |
B. |
C. |
D. |
8. | Which amongst the following is ideal methods is ideal to work with a workbook which has the huge data and takes lot of time to do the calculations |
A. |
B. |
C. |
D. |
9. | The number 32002 formatted as a date would be: |
A. |
B. |
C. |
D. |
10. | What is the keyboard short cut for ‘Save-As’? |
A. |
B. |
C. |
D. |
11. | You open a worksheet, you received in an email with cells D6:D9 containing the formula {=a6:A9*C6:C9}. Which feature of excel can help us design formulae like this |
A. |
B. |
C. |
D. |
12. | A column chart is made out of data present in A1:B5. For a new data added in A6 and B6, the chart has to be redesigned to include the new record |
A. |
B. |
C. |
D. |
13. | Excel allows users to be able to protect each cell with a different password |
A. |
B. |
C. |
D. |
14. | Control + Enter shortcut is used .... |
A. |
B. |
C. |
D. |
15. | Select the most appropriate amongst the following |
A. |
B. |
C. |
D. |