CS001 Midterm Past Paper 2016 Part 1

Rana Abubakar Khan If you want to learn computer programming then contact with me

JOIN FB GROUP FOR VU HELP

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

Data, words, numbers Equations, data, numbers Words, numbers, labels

Numbers, formulas, labels

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

Number

Equations Formula Description

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

$C$4

10700-105 Ave. C4

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

Word

Excel

Access PowerPoint

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

AutoSume

Insert Function AutoFill Paste

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

Chart Wizard

Pie Wizard Excel Wizard Data Wizard

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

Line

Pie

Area XY (scatter)