CS001 Final Term Past Paper 1

CS001

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

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

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

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

What is the format of a spreadsheet?

1. Round
2. Rows and Columns
3. Square

CS001

1. Wide

Which one is a relative address?

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

What do you use to create a chart?

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

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

News Groups are...

1. provided only by large international news services
2. are online discussions about various topics

CS001

1. are only available from 9am to 5pm EST
2. All of these

A(n) ____ line has transfer rates of 128 Kbps to 8.45 Mbps.

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

____ 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

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

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

To safeguard personal information, ____