Computer Science and Engineering



1. CPU can do which of the following?

a. Decode the instruction.

b. Store the program to be executed.

c. Facilitate document writing.

d. Numerical manipulation of data.

2. What does Netscape Communicator feature?

a. Reading and Posting to Newsgroups

b. Store commonly used web addresses

c. Access and display web pages from the internet

d. Use search engines to find specific sites

3. Application software pertains to which of the following?

a. Windows

b. Unix

c. Word

d. MS Dos

4. A Megabyte is

a. 8 bits

b. 1000 bytes

c. 100,000,000 bytes

d. 1,000,000 bytes

> 1.)Which of the following is not related to the internet?

> A.)HTTP

> B.)IXP

> C.)IPP

> D.)HTML

> E.)FTP

> the answer is letter B

> 2.)Which of the following is not a "object" of a database?

> A.)Query

> B.)Form

> C.)Field

> D.)Report

> E.)Table

> the answer is letter C

> 3.)All of the following are components of a Microsoft excel financial

> function except:

> A.)Past value

> B.)Future value

> C.)Present value

> D.)Rate

> E.)Payment

> the answer is A

> 4.)The correct way to absolute reference the cell C5 so that only the column

> will move and not the row is:

> A.)C5

> B.)$C5

> C.)C$5

> D.)$C$5

> the answer is C

> 5.)Which is not a Boolean logic operator?

> A.)And

> B.)Vlookup

> C.)Or

> D.)Not

> the answer is B

1. The rules of communication observed between the peices is called _________.

A. Architecture

B. Protacol

C. Networks

D. Protocol

2. Internet Architecture consists of ___________.

A. FTP

B. IPP

C. ISP

D. B and C

E. All of the above

4. Which memory allows for memory to be stored after the computer is turned off?

A. RAM C. Auxillary memory

B. ROM D. Teporal memory

1. A primary key

a. Is a field which identifies a record in a table

b. Is a field which uniquely identifies a record in a table

c. Defines the relationship between tables

d. Defines the relationship between 2 or more tables

2. Which of these are modes of communication?

a. E-mail

b. World Wide Web (WWW)

c. Newsgroups

d. All of the above

3. What is the language used to write web pages?

a. http

b. html

c. TCP

d. .jpg

4. Windows is an example of

a. Application software

b. Memory

c. Compiler

d. System Software

Answers:

1) B

2) D

3) B

4) D

1. Referential date integrity will be violated in a database if...

a.) a foreign key value is the same as other foreign key values within the database.

b.) information within the primary key is not unique

c.) there is a foreign key value that does not exist in the primary key value

d.) the foreign key is connected to other primary keys

2. To specify a criteria in the total row, what aggregate function would be used within a query?

a.) sum

b.) group by

c.) total

d.) where

3. The role of an Internet Presence Provider is to...

a.) give a location for a website

b.) control and eliminate illegal use within the internet

c.) provide service of access to internet

d.) handle individual accounts of internet users

4. What function allows us to determine an input value that would be needed to get a given output?

a.) IF

b.) goal seek

c.) or

d.)Vlookup

2. An example of an Input Device is

a. speakers

b. monitor

c. touch screen

d. printer

3. RAM memory is

a. not erased when you turn off the computer

b. large and slow

c. measured in kilobytes

d. measured in megabytes

4. Databases

a. store and retrieve data

b. store and analyze data

c. provide support for complex calculations

d. can do simple data organizing and selecting

Answer Key:

2. C

3. D

4. A

In an Access query: when you place two expressions in the same row of the criteria:

a. It is treated as an “AND” function

b. It is treated as an “OR” function

c. You have to place all expressions in a different cell

d. The first expression has a higher priority

If you change your data after making a pivot table in Excel do you:

a. Refresh the table

b. The table changes automatically

c. The table is now obsolete

d. Make a new table

Special effects that control how a bulleted point appears to fly onto the screen are called:

a. Transitions

b. Graphics

c. GUI

d. animations

In Microsoft Word the Autotext feature:

a. Includes commonly used phrases

b. Will insert the date

c. Will insert the time

d. All of the above

1. A(n) ______ is a collection of conditions.

a. query c.) aggregate function

b. criterion d.) report

2. What is an example(s) of a boolean operator?

a. AND c.) OR

b. SUM d.) a, c

3. ________ is a field, or combination of fields, which uniquely identifies a record in a database.

a. primary key c.) query

b. foreign key d.) criterion

4. What is NOT an input device?

a. keyboard c.) printer

b. mouse d.) touch screen

Answers: 1.) B 2.) D 3.) A 4.) C

1) The ________ fetches data, fetches, decodes and executes instructions,

and writes back results.

a) Secondary Memory

B*) CPU

c) RAM

d) a or b

e) a or c

2) If you invested $5000 two years ago at 10% per year compounded

quarterly and you want to determine the current value, your formula

would be:

a) FV(.10/4,2*4,5000) b) FV(.10/12,2*12,0,-5000)

C*) FV(.10/4,2*4,0,-5000) c) FV(.10/4,2,5000)

3) Pick the true statement

a) A foreign key uniquely identifies a record in a

database.

B*) In Excel, the default for reference funtions is

true, if not otherwise specified.

4) When you want to show a functional relationship between

two or more variables you should use a:

a) Line chart B*)XY chart

c) Bar/Column Chart d) Pie chart

1. Which of the following can shut down without effecting it's entire

system?

A. A node in a backbone LAN architecture

B. A node in a ring LAN architecture

C. A NODE IN A WAN ARCHITECTURE

D. A server in a WAN architecture

2. Which of the following is not true of a browser tag?

A. It can show a graphic

B. A tag tells the browser what to do

C. TAGS ALWAYS COME IN PAIRS

D. The tags you write are not visible, but their effects are.

3. Which of the following is not a transfer protocol?

A. smtp

B. HTML

C. http

D. ftp

4. Which of these is not a predefined Excel worksheet function?

A. sum

B. ARGUMENT

C. sumif

D. countif

1.) UNIX, DOS and Windows are example of: (B. Operating Systems)

a. Application Software

b. Operating Systems

c. Auxiliary Memory

d. Primary Memory

2.) Sorting allows the user to order the records by a specific field. (B. Temporarily)

a. permanently

b. temporarily

c. numerically

d. uniquely

3.) Inserts a copy of the original object which can be modified separately from the source file. (A. Embedding)

a. embedding

b. linking

c. copying

d. pasting

4.) Allows us to see the change in outcome if we change the input values.

(C. What-if Analysis)

a. Nested IF's

b. Goal Seeking

c. What-if Analysis

d. V-Lookup

. A Web Spider:

A. Populates a search engine's database.

B. Retrieves the searched for websites from the internet.

C. Scours the internet for specific search words or phrases.

D. None of the above

ANS=A.

2. Data Precision in the Excel program is:

A. The number that appears in the cell.

B. Is a formula to calculate percent.

C. The number of decimal places used in calculations and stored in the computer.

D. Both A and C

ANS=C

3. A Bar/Column chart is best used when:

A. One wants to show a trend over time that is plotted at equal intervals.

B. One wants to display parts that make up a whole.

C. One wants to plot two sets of data at scaled intervals.

D. One wants to show and compare discreet objects.

ANS=D

4. The Boolean Operator in this equation (5-4+3)>(1*4)/2 is:

A. +

B. >

C. *

D. 2

ANS=B

1. What is the definition of a filter?

A. an association that tells access how data between table is related

B. printed output you generate from tables

C. A restriction you place on records in the open datasheet or form to

temporarily isolate and display a subset of records

D. text objects

Answer: C

2. One-to-many, many-to-many and one-to-one are different types of?

A.filters

B.queries

C. Relationships

D.Formats

Answer: C

3. A ---------- is a association that tells Access how data between

tables is related.

A. inquiry

B. Join

C.form

D. object

Answer: B

4. Design View is used to?

A. Link Objects

B. sequence

C. create vertical columns or horizontal rows

D. Creat new database objects and modify the design of existing objects

Answer: D

1.) This is a field which uniquely identifies a record in a table

a.) Primary Key

b.) Foreign Key

c.) Inner join

d.) Both a and b

e.) None of the above

2.) The following is NOT a Boolean Operator

a.) AND

b.) NOT

c.) IF

d.) OR

e.) Both b and c

3.) Forms can be created in the following ways except

a.) Auto Forms

b.) Data Sorting Forms

c.) Forms Design View

d.) Forms Wizard

4.) Following are part of Form Component except

a.) Form Header

b.) Detail

c.) Page Header

d.) Page Footer

e.) Both b and c

f.) Both c and d

ANSWERS:

1.) A 2.) C 3.)B 4.) F

1. Word, excel, and access are examples of:

A. Systems Software

B. Applications Software

C. Communications Channels

D. Local Area Networks

2. Which of the following is the file externsion for excel?

A. .doc

B. .xls

C. .exe

D. html

3. Vlookup and hlookup are examples of ____ functions.

A. Logical

B. Statistical

C. Reference

D. Boolean

4. In the file path C:\mydocuments\1999\cis200\lab1.doc which of the following is the root directory?

A. 1999

B. lab1.doc

C. C

D. mydocuments

1. In a query with aggregate functions, if a certain field specifies a criteria, this field uses the aggregate function of:

a. Expression

b. Group By

c. Where

d. Var

e. When

2. In Microsoft Excel, the Goal Seeking tool:

a. allows you to change the input value to see the affected output

b. allows you to set up a workbook page to set goals using boolean values

c. finds the needed input for the output value that you specify

d. allows you to set up a pivot table

3. An example of presentation software is:

a. Microsoft PowerPoint

b. Microsoft Access

c. Microsoft Excel

d. Microsoft Word

4. TCP/IP stands for:

a. Transfer computer protocol/internet protocol

b. Transfer control protocol/internet protocol

c. Tangent control protocol/internet protocol

d. Transmitting control protocol/internet protocol

answers:

1. c

2. c

3. a

4. b

1. A database can be used for all of the following except:

*a. storing and analyzing data

b. performing simple calculations

c. organizing and selecting data

d. creating rep!orts for data output

2. All of the following are examples of Power Point presentation views except for this one:

a. Slide View

b. Outline View

*c. Design View

d. Slide Show

3. When using the lookup function in Excel, specifying the type as “false” will return values:

* a. that are exact matches of the criteria

b. the highest value that does not exceed the criteria

c. the lowest value exceeding the criteria

d. the value closest to the criteria

4. This type of chart is used to compare discrete objects:

a. XY chart

b. line chart

c. pie chart

*d. column chart

1. When you receive a #ref! Error in excel, you know that:(B)

A. You have a problem with a B. Cell reference not valid

number in a formula or function

C. wrong type of argument or D. Numeric value too wide too display

operand in a formula

2. Excel uses: (B)

A. Simple Interest B. Compound Interest

C. Flat Rate Interest D. None of the above

3. The primary key: (D)

A. Is a unique number B. Is a field

C. Connects to the Foreign Key D. All of the above

4. When sorting fields in a query, you put the field that you want sorted first, (A)

A. In the first column B. In the last column

C. In the middle column D. A or B

1. If an outer join is established between tables A and B in access (relative to Table B), the resulting dynaset will have:

a. only items that are on both tables

b. all records from A, only related records from B

c. only items in table B

d. all records from B, only related records from A

2. .doc, .ppt, .html are all known as:

a. subdirectories

b. main directories

c. file extensions

d. drives

3. A strategy in excel that allows us to see the change in outcome if we change the input values is:

a. an IF function

b. What-if Analysis

c. A reference function

d. Goal Seeking

4. Which of the following views in Powerpoint allows you to concentrate on entering and editing the presentation's content?

a. outline view

b. slide view

c. slide sorter view

d. normal view

5. Which of the following is a wild card criteria?

a. >#1/1/01#

b. "M" OR "N"

c. ="M*"

d. <

c)

d)

1. What is netscape navigator?

a. A graphical user interface.

b. An application software package for browsing the world wide web.

c. A tool designed to help find what you want on the web.

d. A program that automatically follows web page links and reports details to the search engine database.

2. Which of the following is NOT a boolean operator?

a. AND

b. OR

c. IF

d. NOT

3. What is NOT true about primary memory(RAM)?

a. is erased when the computer is turned off

b. stores the programs that are to be executed

c. larger, slower, and cheaper

d. it typically runs on a system of 64 megabytes

4. What is the most popular form of internet communication?

a. e-mail

b. world wide web

c. newsgroups

e. chatrooms

1. When speaking about Excel, the number of decimal places used in calculations and

stored in the computer is the:

a. precision

b. formatted display

c. operand

d. value

2. Which is NOT a function of the Central Processing Unit (CPU)?

a. decode the instruction

b. execute an instruction

c. store data and the program to be executed

d. fetch data from specific memory location

3. America Online (AOL) is an example of a(n):

a. Internet Presence Provider

b. Internet Service Provider

c. Wide Area Network

d. Local Area Network

4. Which is NOT a transfer protocol?

a. smtp

b. http

c. ahtp

d. ftp

_______ 1. Which of the following is not an example of a Boolean logic operator in Excel? ***A***

A) AVERAGE C) OR

B) AND D) NOT

_______ 2. What does the “http” in a web address stand for? ***C***

A) help trial training product C) hypertext transfer protocol

B) hypertension transfer protocol D) hypertext transfer protection

_______ 3. In Access, which of the following uniquely identifies a record in a database? ***D***

A) foreign key C) unique key

B) primary query D) primary key

_______ 4. Which Microsoft Office program is primarily used for storing and looking up data, but has a weakness in making advanced calculations? ***C***

A) Word C) Access

B) Power Point D) Excel

1) Which is NOT a program of Operating Systems?

A) MS DOS

B) Unix

C) Word

D) Windows

2) Which is the correct order for a Universal Resource Locator (URL)?

A)

B)

C)

D)

3) What type of error would return if you have used the wrong type of argument or operand in a formula?

A) #DIV/0

B) #NAME

C) #####

D) #VALUE

4) Which of the following must be true in order to have a Foreign Key?

A) The field names on each table must match

B) The related fields must be the same data type

C) There must be a Primary Key in at least one of the tables

D) Both A and B

E) Both B and C

1.) Cell C3 contains the formula = A$2+$B2. What is the excel formula which

will result if you copy the contents of cell C3 into cell D3?

A.) $B2+$B2

B.) B$2+$B3

C.) A$2+$B2

D.) B$2+$C3

E.) none of the above

Answer: B

2.) The function Sum(A1:A3, D5, C7, 22) is the same as.

A.) A1+B3+D5+C7+22

B.) A1+ A2+A3+D5+D7/22

C.) A1+A2+A3+D5+C7+22

D.) A1+A3+D5+C7/22

Answer: C

3.) Goal seek allows us to do all of the following except...

A.) Allows us to work backward in a worksheet

B.) Lets us vary only one input variable

C.) What if analysis in the reverse direction

D.) none of the above

E.) all of the above

Answer: E

4.) A_______ is a line or several lines of text that appears at the bottom

of each page just above the bottom margin.

A.) footer

B.) header

C.) footing

D.) heading

Answer: A

1.)Smtp has what format?

A. Drive/Main Directory/Sub directory/File name

B. Username@domain.code

C. host.domain.code/path

D. http:// host.domain.code/path

2.)Which is not an input device?

A. Mouse

B. Optical scanners

C. Touch Screen

D. Monitor

3.)If you were to copy the formula A$2+$B2 from cell A1 to cell B2, what would be the resulting formula?

A. A2+B$2

B. A$3+B4

C. B$2+$B3

D. $B3+C$2

4.)Typing in ‘Like “Q?”’ into access would produce which results?

A. Query

B. QA

C. Compaq

D. QUE

Answers:

1.)B

2.)D

3.)C

4.)B

Question 1:

I. Fetch an instruction

II. Execute an instruction

III. Decode the instruction

IV. Fetch data

______ is an operation done by the CPU at an extremely fast speed.

A. I, II, and IV

B. II, III, and IV

C. I, II, and III

D. All of the above

Question 2:

Which statement is false concerning conditions in Access?

A. If a criteria is on the same line it is automatically considered an AND.

B. The Boolean Operators are only AND and OR.

C. If criteria are on a separate line it is automatically considered an OR.

D. The computer will apply sort precedence for sorting fields listed on query from left to right.

Question 3:

Which statement is false about the following web page protocols?

A. .htm and .html are browser file standards.

B. .gif and .jpg are graphical file standards.

C. .wav is the sound file standard.

D. None above, they are all true.

Question 4:

In Power Point which is true about object linking?

A. The object will be displayed in the target document but that is just a “linked copy” of the original object.

B. A “link” to the object in the source document is inserted in the target document.

C. All changes made to the original object are dynamically reflected on the “linked copy”.

D. The “linked copy” can not be modified independent of the original object.

E. All of the above.

1) When using Microsoft Acess to create a relationship between tables one should go to ___________ on the menu bar.

A) file

B) insert

C) view

D) tools

E) edit

answer: D

2) Objects used for viewing, editing, and entering fatra for a single record in Access are ___________.

A) queries

B) forms

C) tables

D) databases

E) program modules

answer: B

3) A Universal Resources Locator is made up of:

A) username, domain, and code.

B) host, code, newsgroup, and path.

C) host, domain, code, and path.

D) username, host, code, and type.

E) domain, code, and path.

answer: C

4) In Microsoft Excel, the cell display of the row and column can be located:

A) in the mailbox.

B) on the sheet tab.

C) in the formula bar.

D) on the toolbar.

E) under view from the menu bar.

answer: A

1. How many logical arguments can be used in the AND and OR functions?

a. 10

b. 15

c. 20

d. 30

2. Which Excel function allows you to determine an input value that would be needed to get a given output?

a. What-if analysis

b. Goal Searching

c. Plug-n-Chug method

d. Goal Seeking

3. Which of the following is an example of Application Software?

a. Microsoft Windows

b. Microsoft Word

c. MS DOS

d. Compilers

4. What are the four stages of database development?

a. plan, create, enter and edit data, preview and print

b. enter, edit, test, format

c. format, preview data, enter, revise

e. plan, create, edit data, test

Question #1

When it is necessary to use data stored in multiple tables, we combine the

records in the two tables using a(n)______________.(answer D)

A)outer join

B)query

C)inner join

D)both A and C

Question #2

When dealing with the spreadsheet layout, the worksheet or part of a

worksheet area where the results are displayed is called the

______________.(answer B)

A)Calculation area

B)Output area

C)Title bar

D)Input area

Question #3

The internet is comprised of a collection of ____________, each composed of

a collection of smaller ____________.(answer C)

A)newsgroups

B)operating systems

C)networks

D)protocols

Question #4

What is NOT one of characteristics of the Database Management System of

Access compared to Spreadsheets in Excel?(answer D)

A)store and retreive data

B)provide support for data organizing and selecting

C)efficient data handling

D)provide support for complex calculations

1. America Online would be considered a:

a. LAN

b. WAN

c. ISP

d. IPP

2. The first web browsers were introduced in what year?

a. 1982

b. 1986

c. 1989

d. 1990

3. The LAN architecture, Backbone, is also known by what name?

a. Log

b. Vertebrae

c. Trunk

d. Ring

4. When moving a database from one file into another in Microsft

Access in the computer labs, you must first?

a. Open My Computer and manually move the file.

b. Open the file in Access, then select Compact &

Repair

c. Open Access, select Compact & Repair, then open

the database

d. Contact a consultant because you are not allowed

to move databases in the computer labs

Answers

1.c

2.d

3.c

4.c

1) Which is NOT a program of Operating Systems?

A) MS DOS

B) Unix

C) Word

D) Windows

2) Which is the correct order for a Universal Resource Locator (URL)?

A)

B)

C)

D)

3) What type of error would return if you have used the wrong type of argument or operand in a formula?

A) #DIV/0

B) #NAME

C) #####

D) #VALUE

4) Which of the following must be true in order to have a Foreign Key?

A) The field names on each table must match

B) The related fields must be the same data type

C) There must be a Primary Key in at least one of the tables

D) Both A and B

E) Both B and C

1. When you want to build a numerical or boolean value you use

a) Num Lock key

b) Expression Builder

c) Aggregate Functions

d) Nz

2. What is the default join type?

a) Inner Join

b) Outer Join

c) Multiple Join

d) None of the Above, you have to specify the join type

3. When using Excel, what allows you to vary one input variable and allows

you to work backward in a worksheet?

a) Range Lookup

b) Reference Functions

c) Goal Seek

d) Boolean Logic Operators

4. Which microsoft program do you want to use to keep track of a company's

employees record.

a) Excel

b) Word

c) PowerPoint

d) Access

e) None of the Above

5. What is considered to be the "Virtual Real Estate Landlord"?

a) IPP (Internet Presence Provider)

b) ISP (Internet Service Provider)

c) FTP (File Transfer Protocol)

d) WAN (Wide Area Network)

Answer:

1. b

2. a

3. c

4. d

5. a

1) What function would you use to substitute

for the formula

=B1+B2+B3+B4+B5=B6

A)Count(B1,B6)

B)Sum(B1:B6) THIS IS THE CORRECT ANSWER

C)Add(B1:B6)

D)Sum(B1-B6)

2) What would be the appropriate "tags" for a

graphical file

standards

A) Pic.

B) GIF.,JPG THIS IS THE CORRECT ANSWER

C) WAV.

D) HTM.,HTML.

3) What is object embedding

A) It is when you insert a copy of an object

which

which can be modified separately from the

source file. THIS IS THE CORRECT ANSWER

B) It is a linked copy which cannot be

modified

C) A function in excel that allows you to

change

the way a worksheet looks

D) It is another way to say "CUT and Paste"

4) When dealing with the "type" argument in

excel,

What does type 0 mean

A) The payments are made at end of the

period.CORRECT

ANSWER

B) The payments are made at the beginning of

the

period

C) This has nothing to do financial functions

D) THe payments are made during the middle of

the

period

1. What type of chart is used to compare items?

A. pie chart

B. line chart

C. Area chart

D. bar chart

2. Cascade up delete can only be used if ____ is enforced?

A. GUI

B. RDI

C. the primary key

D. an inner join

3. What software is used to retrieve and store related data?

A. word

B. excel

C. access

D. powerpoint

4. What suffix is used for federal agenies websites?

A. gov

B. org

C. com

E. edu

1. TCP/IP stands for:

a. Temporary control protocol, internet protocol

b. Transfer control positioning, internet protocol

c. Temporary control positioning, internet protocol

d. Transfer control protocol, internet protocol

1. Which of the following is not true?

a. ISP and IPP hook the user up to the internet.

b. A one to one query is a straight line when you set it up in Access.

c. In Access if you have a many to many relationship and more than 2 tables you can never do just 1 query.

d. Aggregate functions in Access always show up in the total line.

2. Which of the following is true?

a. Line /area charts compare discrete objects.

b. Line/area charts show changes/trends.

c. Line/area charts display parts that make up a whole.

d. Line/area charts show standard deviation.

3. Which type of network architecture is most effective?

a. Backbone architecture.

b. Trunk architecture.

c. Ring architecture.

d. Fishnet architecture.

4. Which is not an example of a popular DBMS?

a. Access

b. Oracle

c. SoftPro

d. FoxPro

Answers are as following:

1. d

2. a

3. b

4. d

5. c

1. What would result in a cell if data being referenced in a formula is not

available?

A. #NAME?

B. #REF!

C. #####

D. #VALUE!

**E. #N/A

2. A(n) _______ is a special tag that links one page to another page or

resource.

A. HTML Code

**B. Hypertext Link

C. ISP

D. Search Engine

3. You borrow $20,000 at 7.5% annual interest rate compounded yearly and

you pay the loan off in 6 years. Which of the following financial functions

is correct to use to find the payment needed to make every year?

=PMT(rate, nper, pv, fv,type)

**A. =PMT(0.075,6,20000)

B. =PMT(0.075,6*12,20000)

C. =PMT(0.075,6,-20000)/12

D. =PMT(0.075,6,0,20000)

E. =PMT(0.075,6*12,-20000,0)

4. Suppose you have a STUDENTS table with the PK as studentID and a CLASSES

table with the PK as class# and a FK as studentID. Which of the following

operations is not valid?

A. Outer joing relative to STUDENTS table.

B. Inner join of STUDENTS and CLASSES table.

**C. Outer join relative to STUDENTS and CLASSES table.

E. Inner join on studentID.

1) Another name of Web Address is:

a) HTML

b) URL

c) LAN

d) PROTOCOL

answer:B

2)”at least one condition must be true to get a TRUE” is a Boolean operators using:

a) AND

b) OR

c) NOT

d) IF

answer:B

3) A field name is used to identify the_____ stored in a field.

a) Characters

b) Keys

c) Data

d) Graphics

answer:C

4) The_____ key uniquely identifies each record

a) Primary

b) Database

c) Object

d) Premier

answer:A

1> the .edu code in email stands for:

a) US university

b) Government

c) Commercial

d) US organizations

e) Education organization

2> In Microsoft Word, The mail merge features can be found in which menu bar?

a) File menu

b) Edit menu

c) Format menu

d) Tools menu

e) Help menu

3> Which one of these software is application software?

a) DOS

b) Unix

c) Microsoft Windows NT

d) Microsoft word

4> Which one of these website serve as IPP?

a) AOL

b) MSN

c) Yahoo

d) CNN

e) Angelfire

1) What is the name for a row in a data table?

a) row

b) field

c) data row

d) record

2) Which of the following collects and switches internet traffic during data transfers between terminals?

a) IPP

b) LAN

c) WAN

d) ISP

3) Which of the follow are output devices?

a) Optical Scanners

b) Touch Screens

c) Monitors

d) Mouse

e) B and C

4) Which of the following is NOT a transfer protocol?

a) SMTP

b) HTML

c) HTTP

d) FTP

1) 1 Megabyte stands for

a) 1000 bytes

b) 8 bits

c) 1,000,000 bytes

d) 1,000,000,000 bytes

2) #VALUE! means

a) numeric value too wide to display

b) wrong type of argument or operand in a formula

c) problem with a number in a formula

d) text in formula is not recognized

3) Which one of the following is NOT a boolean operator?

a) NOT

b) IF

c) AND

d) OR

4) TCP/IP was designed to

a) allow people to communicate with others that have different computers

b) provide service to the internet

c) allow people to create webpages

d) none of the above

ANSWERS: 1-C 2-B 3-B 4-A

1) Which is not an example of an aggregate function?

A) average

B) group by

C) product

D) sum

2) In joining more than two tables, what term(s) is/are used to describe the relationship on the

tables?

A) many to one

B) one to many

C) many to many

D) one to one

E) both C and D

3) Which provider gives users a hookup to the Internet?

A) FTP

B) ISP

C) IPP

D) HTTP

4) What is not an example of a logical function from Microsoft Excel?

A) IF

B) AND

C) NOT

D) OR

Answers: 1)C, 2)E, 3)B, 4)A

1) All of the following are functions performed by the CPU except: (d)

a) execute an instruction

b) write back the result

c) decode the instruction

d) create an instruction

2) Which of the following is NOT an example of transmission media: (b)

a) twisted pair wire

b) a modem

c) fiber optic cable

d) microwave transmission

3) What is the root directory in this path: (a) k:\cis200\class_files\office2000

a) cis200

b) k:

c) class_files

d) office2000

4) What chart would best serve your purposes if you wanted to graph a range with discreet objects: (c)

a) Line Chart

b) Pie Chart

c) Bar/Column Chart

d) XY Chart

1. Which of the following is not related to the characteristics of System Software?

a. Diagnostic routines stored in the computer’s electronic circuitry

b. Designed to help its users to accomplish specific tasks

c. Provide interface between the user and the computer

d. Controls computer system resources and coordinates the flow of data

2. The feature most helpful for copying an object into any other windows application over and over?

a. Drag and drop

b. Move and place

c. Drag and place

d. Clipboard

3. What formula will result if you copy the formula in cell H8 into cell A1?

| |B |C |D |

|5 | |Marry |Jane |

|6 |Bananas | $ 2.80 | $ 2.30 |

|7 |Strawberries | $ 5.00 | $ 8.00 |

|8 |Plums | $ 4.00 | $ 6.00 |

a. ####

b. #N/A

c. #REF!

d. #VALUE!

4. Which of the following is an inappropriate use of Boolean operators in Access?

a. “PA” And “OH”

b. >8 And =”O”

1. Programs to control computer operations are called (answer c)

A. applications software

B. database software

C. system software

D. spreadsheet software

2. This agency was created in response to the Soviet launch of Sputnik in

1957(d)

A. WWW

B. NSFNet

C. APCD

D. ARPA

3. How many items can be placed temporary on the clipboard(a)

A. 12

B. 8

C. 16

D. 14

4. What is the correct tree structure for file management(a)

A. drive, root directory, subdirectory paths, file name.extension

B. file name.extension, drive, subdirectory, root directory

C. root directory, file name.extension, subdirectory

D. drive, subdirectory paths, root directory, file name.extension

1). In the following URL, which part of the address is the code? cis.ohio-state.edu/cis200

A. cis

B. ohio-state

C. edu

D. cis200

2). Which of the following is not one of the 3 basic Boolean Operators?

A. AND

B. IF

C. OR

D. NOT

3). How many primary keys should be assigned in any given table in Microsoft Access (assume that more than one table makes up

your database)?

A. There is no limit

B. Exactly one

C. None

D. Either B or C

E. None of the Above

4). Which of the following statements is true about Microsoft Excel Goal Seek

A. It allows users to work backward in a worksheet

B. Lets users vary only one input variable

C. It is what-if analysis in the reverse direction

D. Answers A,B,and C are correct

E. Neither answers A,B,nor C are correct.

1) To add the values in a field or do other computations with

the data use this feature.

a) AutoSum

b) Group By

c) Add

d) Countif

2.) When joining tables in a query, this join type will allow you to select all records that have a matching value in the the foreign key

field plus any unmatched records.

a) inner join

b) outer join

c) full join

d) group join

3.) A _________ is a collection of cells used to store and analyze data.

a) workbook

b) record sheet

c) worksheet

d) timeline

4.) A set of instructions specifying how specific records or combination of records should be extracted is a

a) Report

b) Query

c) Form

d) Spreadsheet

1.) URL in computer terminology stands for

a. Universal Resource Link b.) Unit Restricted Limit c.) Universal Resource Locator d.) Underwriters Rite Label

2.) What are the three key areas of Spreadsheet Layout?

b. ---------------------- b.) ------------------------- c.) -----------------------------

3.)

|  |a |

2 |  |lap 1 |lap 2 |lap 3 |Totals |Final Heat Qualifiers |  | |3 |  |  |  |  |  |  |  | |4 |  |  |  |  |  |  |  | |5 |Red Car |32.6 |29.4 |33.9 |95.9 | False |  | |6 |Blue Car |33.9 |28.3 |28.6 |90.8 | True |  | |7 |Green Car |30.2 |31.5 |30.5 |92.2 | False |  | |8 |  |  |  |  |  |  |  | |

The cars racing in the heat above need to run a 91.00 second total to advance to the Final Heat. How can we determine if only Blue Car is a Final Heat Qualifier?

4.)(Two part question) Essay Question -What is the difference between an Inner Joined and an Outer Joined in Access, and what are the indicators to know which one to use?

Answers to the homework

1. c. Universal Resource Locator

2. a. Input Area b. Calculation Area (workspace) c. Output Area

3. And(F6,Not(Or(F5,F7)))

An Inter Joined is the default join type, the result using it will be only those values in the Table that have matching values in their fields. The Inter Joined creates a new data set each time it is used. The Outer Joined is used when you want to show a value that doesn’t have matches in the tables that are available to you. This is the indicator that indicates which Join you will use. The Outer Join creates a data set that results from all records that have matching values in the foreign key fields plus any unmatched records in the table with the Primary key.

1) All of the following are examples of application software except?

a) Microsoft Word

b) Microsoft Front Page

c) Microsoft Windows 95

d) Unix

2) When using excel, the function =SUM(B3:B7)/4 means

a) (B3+B4+B5+B6+B7)/4

b) B3+B4+B5+B6+B7/4

c) B3+B7/4

d) (B3+B7)/4

3) Web Browsers retrieve information by doing which of the following

a) Using Web Site Owner Submissions

b) Populating their database with spiders

c) Prioritizing hits from a certain web page

d) a and b

4) In Excel, when reducing the decimal place by two, and formatting the cell for a percent, the number .098756 reads

a) 10%

b) 9.87%

c).0987

d) none of the above

answers: c, a, d, a

1. __A.__ Protocol on the internet refers to

a.) rules on communication

b.)backbone of a WAN

c.) HTML syntax

d.) none of the above

2. __B._ What chart is appropriate when graphing a percentage cost of each

food item of a meal for a given group size?

a.) Column/ Bar Chart

b.) Pie Chart

c.) Line/ Area Chart

d.) Any of the above

3.) _A.__ Microsoft Windows is an example of a(n)

a.) Applications Software

b.) Hardware

c.) Slide View

d.) Operating System

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download