CS001 Final Term Short Notes

Q1. In excel the intersection of a row and a column is called: (1 marks)

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

Q2. The cell labeled F5 refers to (1 marks)

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 marks)

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 marks)

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

Q5. Which one is a relative address? (1 marks)

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

Q6. What do you use to create a chart? (1 marks)

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