Thursday Test

Question 1

cyberspace is defined as:

Answer 1

territory that isn’t actual physical space and that is accessible…

Question 2

AOL is an example of an online service provider & is consider an organization that provides a proprietary network offering services to subscribers.

Answer 2

For Profit

Question 3

A ____ is a location that is accessible from the internet and makes web pages available.

Answer 3

A website

Question 4

Another name for a home page is an:

Answer 4

Index page

Question 5

The information on a web page is in _____ or XTML format.

Answer 5

HTML

Question 6

Which of the following is not an example of a web browser?

Answer 6

UNIX

Question 7

In newer browsers, if a web site requires a plug in to function:

Answer 7

A pop up will appear indicating which plug in is needed.

Question 8

_____, which was originally an apple browser , and now is available for PCS

Answer 8

Safari

Question 9

A complete URL has four parts: protocol, _______, path, and resource name.

Answer 9

Domain Name

Question 10

Which of the following names the path that houses the web page in the fictious URL given below? http://univ.edu…

Answer 10

classroom

Question 11

A ____ is a computer program used by search engines to roam the World wide web via the internet, visit sites & data sites….

Answer 11

spider

Question 12

Which of the following is the term for a gateway that provides a structured guide to internet material such as news, weather, sports, or email?

Answer 12

Portal

Question 13

____ are gaining in popularity- Websites that provide quick access to information from many sources in one locations.

Answer 13

Aggregators

Question 14

A ____ controls a set of computers by infecting them with a malicious program.

Answer 14

Bot herder

Question 15

Which of the following wildcard characters can be used as a substitute for any number of characters in a keyword?

Answer 15

*

Question 16

____ acts as a secure intermediary offering users the ability to make payments from their bank account or credit card without revealing a persons financial information to the seller?

Answer 16

paypal

Question 17

____ refers to software programs designed and written to damage a computer system such as deleting files from a hard.

Answer 17

malware

Question 18

social networking is a way to

Answer 18

All of the above

Question 19

____ involves businesses that use the internet to supply consumers

Answer 19

B2C

Question 20

Which of the following is not a network communications device?

Answer 20

LAN

Question 21

Which of the following is the largest wide area network (WAN)?

Answer 21

Internet

Question 22

When a computer is connected to a network it is called a:

Answer 22

Node

Question 23

Which of the following is NOT a disadvantage of networks?

Answer 23

Sharing important information

Question 24

A local area network in which all the computers are equals is called a

Answer 24

Peer to Peer

Question 25

A VPN operates as a private network over which larger type of network?

Answer 25

Internet

Question 26

Which of the following devices does not use radio waves to transmit its signal?

Answer 26

Flash drive

Question 27

___ transmit data by sending and receiving microwave signals to and from earth based stations.

Answer 27

Satellites

Question 28

Approximately what percentage of U.S. households has opted to disconnected their conventional landline telephones and rely on cellular service only.

Answer 28

25%

Question 29

Which of the following statements is TRUE:

Answer 29

Important internet applications existed before the world wide web was invented.

Question 30

A ____ is a handheld device that integrated mobile phone capabilities, computing power, and web access.

Answer 30

Smartphone

Question 31

The 3 kinds of information you can put in a spreadsheet cell are:

Answer 31

Text, numbers, and formulas

Question 32

The URL for the IRS would most likely end in which domain name?

Answer 32

.gov

Question 33

dollar signs used in the cell reference of formulas created in Excel indicate what type of cell reference?

Answer 33

Absolute

Question 34

What chart type would BEST display each of three stores' sales as a percentages of total sales?

Answer 34

Pie Chart

Question 35

Suppose cell A1 contains the text entry "Apr". If you use the fill handle to copy the contents of cell A1 to the range A2, A3 and A4 will contain:

Answer 35

May, Jun, Jul

Question 36

If you change the data in a cell referenced by a formula, what will happen?

Answer 36

The formula will automatically recalculate to reflect the changed data.

Question 37

The best formula for calculating the total of the range B3 through B6 would be:

Answer 37

=sum(b3:b6)

Question 38

When ### appears in a spreadsheet, it means:

Answer 38

A formated number is too wide to fit in the columns.

Question 39

When formatting cells in an excel worksheet, you can do all of the following except:

Answer 39

add javascript

Question 40

In and excel worksheet, the entry =average(h4:h6)

Answer 40

computes the average of cells H4 to H6

Question 41

Which of the following sections will increase the width of column B to best fir?

Answer 41

double clicl on the border between columns b and c

Question 42

The macro recorder in Excel will record:

Answer 42

all of the above

Question 43

Which of the following describes a benefit of an excel macro?

Answer 43

all of the above

Question 44

Which is the programming language used to create excel macros?

Answer 44

Visual basic for Applications (VBA)

Question 45

Create and use ____ to make it easier to refer to a specific rectangular lock of cells in a formula, functions, data table, etc.

Answer 45

a range name

Question 46

Which best illustrates the formula for PMT in excel?

Answer 46

=PMT(B6/12,B7*12,-B5)