Q1. To change the cell reference C4:C9 to an absolute row and column reference, we would enter it as ?
Q2. How many characters can be typed in a single cell in Excel ?
Q3. Which of the following is not a valid data type in Excel ?
Q4. Which type of command in Ms-DOS needs additional files for their execution ?
A. Internal commands
B. External commands
C. Batch commands
Q5. Data can be arranged in a worksheet in an easy to understand manner using ?
A. Auto Formatting
B. Applying Styles
C. Changing Fonts
D. All of the above
Q6. When we create a chart on the same sheet as our data, we can view both the data and the chart is called as ?
A. chart sheet
B. embedded chart
C. view sheet
D. view chart
Q7. Excel uses another name for database. It is called as ?
Q8. How many types of drawing objects are available in drawing toolbar ?
Q9. We can convert existing worksheet data and charts to an HTML document by using the ?
A. Linking Assistant Wizard
B. HTML Assistant Wizard
C. Internet Assistant Wizard
D. Intranet Assistant Wizard
Q10. The comparsion operators used in Excel to compute criteria's are ?
A. =, >, <, > =, < = and <>
B. only =
C. only =, > and <
D. None of the above
Q11. When we create a chart on a separate sheet in the same workbook, it is called a ?
A. view chart
B. view sheet
C. embedded chart
D. chart sheet
Q12. When excel copies a formula from one cell to another it identifies the number it needs by ?
B. cell address
C. cell values
D. Any of these
Q13. Excel can display up to ______ fields of a data form ?
Q14. __________ of a file is the full traceable listing of drive, folder, subfolders and all subfolders till the destined file ?
Q15. It is a secret word which is used to prevent access to a file system or network. It is called ?
C. Account No
D. Net ID