CS001 Final Term Solved Paper

CS001 - VU-Computer Proficiency License

Q1. In excel the intersection of a row and a column is called:

1. data
2. a field.
3. a cell.
4. an equation.

Q2. The cell labeled F5 refers to

1. row F column 5
2. column F row 5
3. functions available in cells
4. Function key F4

Q3. Which of the following describes how to select all the cells in a single column

1. Right click on column and select Pick From List
2. Use the Data - Text to Columns menu item
3. Left click on the gray column title button
4. Pressing CTRL + A on the keyboard

Q4. What is the format of a spreadsheet?

1. Round
2. Rows and Columns
3. Square
4. Wide

Q5. Which one is a relative address?

1. $C$4
2. 256
3. C4
4. None of these

Q6. What do you use to create a chart?

1. Chart Wizard
2. Pie Wizard
3. Excel Wizard
4. Data Wizard

Q7. On an Excel sheet the active cell is indicated by

1. a dark wide border
2. a dotted border
3. a blinking border
4. All of these

Q8. News Groups are...

1. provided only by large international news services
2. are online discussions about various topics
3. are only available from 9am to 5pm EST
4. All of these

Q9. A(n)

line has transfer rates of 128 Kbps to 8.45 Mbps.

1. DSL
2. ISDN
3. ATM
4. Fractional T1

Q10. refers to the amount of data, instructions, and information that can travel over a communications channel.

1. Latency
2. Transfer rate
3. Bandwidth
4. Broadband

Q11. The process of converting readable data into unreadable characters to prevent unauthorized use is called

1. normalization
2. decryption
3. validation
4. encryption

Q12. To safeguard personal information,

1. write your telephone number on credit receipts
2. use shopping club and buyer cards
3. do not reply to spam for any reason
4. complete all requested information on registration forms

Q13. Storage is also referred as

1. Data
2. Instructions
3. Files
4. Memory

Q14. To enter capital characters use

1. Num lock
2. Pause lock
3. Caps lock
4. Scroll lock

Q15. Windows is software developed by

1. Sun
2. Java
3. Html
4. Microsoft

Q16. Desktop Icon is a link to

1. Hardware
2. Software
3. Storage
4. None of these

Q17. What is the keyboard shortcut (button or buttons to be pressed) for creating a Chart from the selected cells ?

1. F3
2. F4
3. F5
4. F6