Q1. To change the cell reference C4:C9 to an absolute row and column reference, we would enter it as ?
A. C4:C9
B. C$4:C$9
C. $C$4:$C$9
D. $C4:$C9
Q2. How many characters can be typed in a single cell in Excel ?
A. 256
B. 1024
C. 32,000
D. 65,536
Q3. Which of the following is not a valid data type in Excel ?
A. Number
B. Label
C. Character
D. Date/Time
Q4. Which type of command in Ms-DOS needs additional files for their execution ?
A. Internal commands
B. External commands
C. Batch commands
D. Redirectors
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 ?
A. listing
B. organizer
C. sequencer
D. list
Q8. How many types of drawing objects are available in drawing toolbar ?
A. 4
B. 5
C. 10
D. 12
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 ?
A. position
B. cell address
C. cell values
D. Any of these
Q13. Excel can display up to ______ fields of a data form ?
A. 16
B. 32
C. 64
D. 128
Q14. __________ of a file is the full traceable listing of drive, folder, subfolders and all subfolders till the destined file ?
A. Route
B. Gate
C. Path
D. Search
Q15. It is a secret word which is used to prevent access to a file system or network. It is called ?
A. Login
B. Password
C. Account No
D. Net ID
Post a Comment