CS001 Midterm Past Paper 2017

Rana Abubakar Khan

If you want to learn computer programming then contact with me

JOIN FB GROUP FOR VU HELP

CS001 MIDTERM 2017

There are three types of data found in a spreadsheet.

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

A Constant is another name for this type of data:

Number Equations Formula Description

Which is an absolute address?

$C$4 10700-105 Ave. C4

What Program do you use to create a spreadsheet?

Word Excel Access PowerPoint

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

AutoSume Insert Function Auto Fill Paste

What do you use to create a chart?

Chart Wizard Pie Wizard Excel Wizard Data Wizard

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

Line Pie Area XY (scatter)

On an Excel sheet the active cell in indicated by ------?

A dark wide border A dotted border A blinking border

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

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

The Word Wide Web (WWW) is….

A part off the Internet The Internet Not a part of internet

Uniform Resource Locator (URL) is….

The same as search engines The addresses of specific documents and resources on the WWW Never more that 11 characters long

The-----standard defines how data transmits across telephone lines or other means.

TCO/IP EDI (Electronic Data Interchange) Electronic funds transfer (EFT) Ethernet

A (n) ------line typically costs $1,000 or more per month.

ISDN T3 ATM T1

A----------is a Web site that uses encryption techniques to secure its data.