CS001 Final Term Past Paper 2

CS001

A constant is another name for this type of data:

1. number
2. Equation
3. Formula
4. Description

Correct answer: number

Which is an absolute address?

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

Correct answer: $C$4

What program do you use to create a spreadsheet?

1. Word
2. Excel
3. Access
4. PowerPoint

Correct answer: Excel

Which button on the standard toolbar gives you quick access to the Sum, Average, Count, Min, and Max functions?

CS001

1. AutoSum
2. Insert Function
3. AutoFill
4. Paste

Correct answer: AutoSum

What do you use to create a chart?

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

Correct answer: Chart Wizard

Which type of chart shows the pattern or relationships between sets of data points?

1. Line
2. Pie
3. Area
4. XY (Scatter)

Correct answer: Pie

On an Excel sheet the active cell is indicated by ____.

1. A dark wide border

CS001

1. A dotted border
2. A blinking border
3. All of these

Correct answer: All of these

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

1. Go to FILE - SAVE AS - SAVE AS TYPE - Excel 4.0 Work Sheet
2. Right click on the spreadsheet tab and select DELETE
3. Right click on the spreadsheet and select INSERT - ENTIRE COLUMN
4. None of these

Correct answer: Right click on the spreadsheet tab and select DELETE

The World Wide Web (WWW) is...

1. a part of the Internet
2. The internet
3. Not a part of the Internet
4. All of these

Correct answer: a part of the Internet

Uniform Resource Locator (URL) is

1. The same as Search Engines
2. the addresses of specific documents and resources on the WWW

Correct answer: the addresses of specific documents and resources on the WWW