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. <=20
1. All of this are the standard features of presentation software except:
a. On screen slide shows
b. East preparation of slides
c. Slides animation
d. Preparation of speaker notes and handouts
e. Outline view
2. Which one on the following is the popular DBMS system:
a. Netscape
b. Microsoft Power Point
c. Microsoft Access
d. Excel
3. What is thread?
a. Open communication forum
b. Send opinion (everyone can read this)