ICT - Internet, WWW, Excel
An absolute reference is designated in the formula by the addition of a/an
$
Which of the following is a mixed cell reference with an absolute column and row address?
$F$8
Which of the following is an absolute cell reference?
$F$8
One of the top level domain name which refers to group of non-profit organizations.
.org
In what year arpanet experiment was formally initiated?
1969
Which of the following symbols that is used to begin a Formula entry in a cell?
=
In an internet e-mail address, what symbols separates the username from the domain name?
@
The cell range that starts in cell A1 and goes over to column J and down to row 15 is _____
A1 : J15
What will be the formula you will type in cell D10, if you were to find the average of all numbers from the range of cells D1 to D7?
AVERAGE(D1:D7)
What is the meaning of the acronym ARPANET?
Advanced Research Projects Agency Network
Which of the following is a correct cell address?
C5
The most common service in the net that allows you to communicate with other people located anywhere in the world through electronic letter.
It refers to the internet standard that permits file uploading and downloading to and from other computers on the internet.
FTP
A Web page is a collection of related Web sites.
False
A Web server can store only a single Web site.
False
Although none of the networks on the Internet is owned by a public or private organization, a single organization owns and controls the Internet.
False
Spreadsheet software allows users to create visual aids for presentations to communicate ideas, messages, and other information to a group.
False
The World Wide Web is the only service available on the Internet.
False
What is the meaning of the acronym http?
Hypertext Transfer Protocol
It refers to the sequence of numbers that uniquely identifies each computer or device connected to the internet.
IP address
A company that provides you connectivity to the internet.
ISP
A collection of computer networks that link millions of different computers around the world.
Internet
A standard collection of rules and conventions so that computers can exchange information regardless of their hype or brand.
Internet Protocol
Who pioneered the mathematical theory of packet networks and was recognized as the "Father of the Internet"?
Leonard Kleinrock
Who developed the first graphical browser in 1993?
Marc Andressen
The name of the active cell appears in the _________.
Name box
Which of the following is a relative cell reference? Select one: a. G$9 b. $K356 c. $F$8 d. P72
P72
Which formula can add the all the numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell?
SUM
What is the type of protocol used when accessing the internet?
TCP/IP
How will Excel evaluate this Formula: =B1+C2 * D3 a. The formula will generate an error message b. The formula will add the values in B1 to C2 and multiply by the value in D3 c. The Formula will multiply the values in C2 by D3 and then add it to B1 d. The Formula will multiply the values in B1 by D3 and then add it to C2
The Formula will multiply the values in C2 by D3 and then add it to B1(?)
What does the following error mean - #REF! ? a. The REF! error value occurs when a cell contains a number with two decimal separators (points) present. b. The REF! error value occurs when a cell has been formatted as a currency but contains text. c. None of the above d. The REF! error value occurs when a cell reference is not valid.
The REF! error value occurs when a cell reference is not valid.(?)
When number signs (#####) are displayed in the cell, it means
There are too many characters in the cell to be displayed with the current cell width
Who is the founder of the world wide web and is currently the Director of the WWW Consortium?
Tim Berners-Lee
A home page provides information about a Web site's purpose and content.
True
An IP address consists of four groups of numbers, each separated by a period.
True
An Internet service provider (ISP) is a business that has a permanent Internet connection and provides temporary connections to individuals and companies for free or for a fee.
True
Data sent over the Internet travels via networks and communications channels owned and operated by many companies.
True
Each of the electronic documents on the Web is called a Web site.
True
To browse the Web, a Web browser and a computer that is connected to the Internet are needed.
True
It is one of the internet service that enables user to speak to other users over the internet.
VoIP
What does www stands for?
World Wide Web
Once data is entered into a cell, can it be edited?
Yes, even after saving a file, double-clicking on a cell where data is to be changed allows editing.
An arithmetic formula can contain all of the following except __________
a label
The symbols B2:E3 refers to_______ a cell address. b. a range. c. a mathematical formula. d. the display value of a function.
a range or mathematical value(?)
During the cold war between Russia and U.S., what is the term that is used to call a network that would be operational even one part of the network shut down?
apranet
In a spreadsheet, columns are labeled ________
by letters in alphabetical order.
The intersection between a row and a column is called a(n)_______
cell
The vertical dimension of a spreadsheet is called a ______
column
It refers to a text-based name that correspond to the IP address.
domain name
It refers to the technology for bringing high-bandwidth information to homes over ordinary copper telephone lines.
dsl
It is considered as the fastest form broadband technology.
fiber optics
The first page of a website is called a ________.
home page
A wireless network that provides internet connections to mobile computers and devices.
hot spot
It refers to the global of network that connects millions of computers communicating with each other.
internet
A ________ is a software that finds websites, web pages, images, videos, newsmaps. and other information.
search engines
The cell that contains a formula or function will show _____
the resulting display value.
It refers to the unique address of a web page.
url
A software program that allows you to view web pages.
web browser
A ______ is a computer that delivers requested webpages to your computer.
web server
A collection of related web pages is called a _______.
website
The popular term for wireless connection is called___.
wi-fi
Which of the following does not belong to the group? a. wiki b. chrome c. opera d. safari
wiki
The active cell is the one that _________ a. automatically recalculates when data changes in other cells. b. will receive the input that is typed by the user. c. contains a formula or function. d. is referenced by other cells in the spreadsheet.
will receive the input that is typed by the user.(?)
The line that runs horizontally along the bottom of a graph is called a(n): a. plot line. b. x-axis. c. y-axis. d. line graph.
x-axis(?)
