Thursday Test Flashcards
cyberspace is defined as:
territory that isn’t actual physical space and that is accessible…
AOL is an example of an online service provider & is consider an organization that provides a proprietary network offering services to subscribers.
For Profit
A ____ is a location that is accessible from the internet and makes web pages available.
A website
Another name for a home page is an:
Index page
The information on a web page is in _____ or XTML format.
HTML
Which of the following is not an example of a web browser?
UNIX
In newer browsers, if a web site requires a plug in to function:
A pop up will appear indicating which plug in is needed.
_____, which was originally an apple browser , and now is available for PCS
Safari
A complete URL has four parts: protocol, _______, path, and resource name.
Domain Name
Which of the following names the path that houses the web page in the fictious URL given below? http://univ.edu…
classroom
A ____ is a computer program used by search engines to roam the World wide web via the internet, visit sites & data sites….
spider
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?
Portal
____ are gaining in popularity- Websites that provide quick access to information from many sources in one locations.
Aggregators
A ____ controls a set of computers by infecting them with a malicious program.
Bot herder
Which of the following wildcard characters can be used as a substitute for any number of characters in a keyword?
*
____ 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?
paypal
____ refers to software programs designed and written to damage a computer system such as deleting files from a hard.
malware
social networking is a way to
All of the above
____ involves businesses that use the internet to supply consumers
B2C
Which of the following is not a network communications device?
LAN
Which of the following is the largest wide area network (WAN)?
Internet
When a computer is connected to a network it is called a:
Node
Which of the following is NOT a disadvantage of networks?
Sharing important information
A local area network in which all the computers are equals is called a
Peer to Peer
A VPN operates as a private network over which larger type of network?
Internet
Which of the following devices does not use radio waves to transmit its signal?
Flash drive
___ transmit data by sending and receiving microwave signals to and from earth based stations.
Satellites
Approximately what percentage of U.S. households has opted to disconnected their conventional landline telephones and rely on cellular service only.
25%
Which of the following statements is TRUE:
Important internet applications existed before the world wide web was invented.
A ____ is a handheld device that integrated mobile phone capabilities, computing power, and web access.
Smartphone
The 3 kinds of information you can put in a spreadsheet cell are:
Text, numbers, and formulas
The URL for the IRS would most likely end in which domain name?
.gov
dollar signs used in the cell reference of formulas created in Excel indicate what type of cell reference?
Absolute
What chart type would BEST display each of three stores’ sales as a percentages of total sales?
Pie Chart
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:
May, Jun, Jul
If you change the data in a cell referenced by a formula, what will happen?
The formula will automatically recalculate to reflect the changed data.
The best formula for calculating the total of the range B3 through B6 would be:
=sum(b3:b6)
When ### appears in a spreadsheet, it means:
A formated number is too wide to fit in the columns.
When formatting cells in an excel worksheet, you can do all of the following except:
add javascript
In and excel worksheet, the entry =average(h4:h6)
computes the average of cells H4 to H6
Which of the following sections will increase the width of column B to best fir?
double clicl on the border between columns b and c
The macro recorder in Excel will record:
all of the above
Which of the following describes a benefit of an excel macro?
all of the above
Which is the programming language used to create excel macros?
Visual basic for Applications (VBA)
Create and use ____ to make it easier to refer to a specific rectangular lock of cells in a formula, functions, data table, etc.
a range name
Which best illustrates the formula for PMT in excel?
=PMT(B6/12,B7*12,-B5)
