CS001 Midterm Solved Papers Complete

CS001 Computer Proficiency All Midterm Solved Objective and Subjective Papers in One File for Preparation of Midterm Exam

Q1. There are three types of data found in a spreadsheet. (1 marks)

1. data, words, numbers
2. equations, data, numbers
3. words, numbers, labels

•  numbers, formulas, labels

Q2. A constant is another name for this type of data: (1 marks)

number

1. equation
2. formula
3. description

Q3. Which is an absolute address? (1 marks)

$C$4

1. 10700 - 105 Ave.
2. C4
3. None of these

Q4. What program do you use to create a spreadsheet? (1 marks)

1. Word

Excel

1. Access
2. PowerPoint

Q5. Which button on the standard toolbar gives you quick access to the Sum, Average, Count, Min, and Max functions? (1 marks)

AutoSum

1. Insert Function
2. AutoFill
3. Paste

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

Chart Wizard

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

Q7. Which type of chart shows the pattern or relationships between sets of data points? (1 marks)

1. Line

Pie

1. Area
2. XY (Scatter)

Q8. On an Excel sheet the active cell is indicated by ____. (1 marks)

1. a dark wide border
2. a dotted border