CS001 Midterm Past Paper 2016 Part 2

Rana Abubakar Khan

If you want to learn computer programming then contact with me

JOIN FB GROUP FOR VU HELP

CS001

MIDTERMS PAST PAPER

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)

Q8. On an Excel sheet the active cell in indicated by ------? (1 marks)

A dark wide border A dotted border A blinking border

Q9. A user wishes to remove a spreadsheet from a workbook. Which is the correct sequence of events that will do this? (1 marks)

Do to FILE - SAVE AS – SAVE AS TYPE – Excel. Work sheet

Right click on the spreadsheet tab and select DELETE

Right click on the spreadsheet and select INSERT – ENTIRE COLUMN

Q10. The Word Wide Web (WWW) is…. (1 marks)

A part off the Internet

The Internet Not a part of internet

Q11. Uniform Resource Locator (URL) is…. (1 marks)

The same as search engines