Thursday Test Flashcards

1
Q

cyberspace is defined as:

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

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

A

For Profit

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

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

A

A website

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Another name for a home page is an:

A

Index page

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

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

A

HTML

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

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

A

UNIX

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

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

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

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

A

Safari

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

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

A

Domain Name

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

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

A

classroom

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

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

A

spider

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

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?

A

Portal

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

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

A

Aggregators

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

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

A

Bot herder

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

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

A

*

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

____ 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?

A

paypal

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

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

A

malware

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

social networking is a way to

A

All of the above

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

____ involves businesses that use the internet to supply consumers

A

B2C

20
Q

Which of the following is not a network communications device?

A

LAN

21
Q

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

A

Internet

22
Q

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

A

Node

23
Q

Which of the following is NOT a disadvantage of networks?

A

Sharing important information

24
Q

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

A

Peer to Peer

25
Q

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

A

Internet

26
Q

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

A

Flash drive

27
Q

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

A

Satellites

28
Q

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

A

25%

29
Q

Which of the following statements is TRUE:

A

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

30
Q

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

A

Smartphone

31
Q

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

A

Text, numbers, and formulas

32
Q

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

A

.gov

33
Q

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

A

Absolute

34
Q

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

A

Pie Chart

35
Q

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:

A

May, Jun, Jul

36
Q

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

A

The formula will automatically recalculate to reflect the changed data.

37
Q

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

A

=sum(b3:b6)

38
Q

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

A

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

39
Q

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

A

add javascript

40
Q

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

A

computes the average of cells H4 to H6

41
Q

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

A

double clicl on the border between columns b and c

42
Q

The macro recorder in Excel will record:

A

all of the above

43
Q

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

A

all of the above

44
Q

Which is the programming language used to create excel macros?

A

Visual basic for Applications (VBA)

45
Q

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

A

a range name

46
Q

Which best illustrates the formula for PMT in excel?

A

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