Answer:
A. VLOOKUP
Explanation:
VLOOKUP is an Excel function to look up data in a table organized vertically. VLOOKUP supports approximate and exact matching, and wildcards (* ?) for partial matches. Lookup values must appear in the first column of the table passed into VLOOKUP.
Purpose
Lookup a value in a table by matching on the first column
Return value
The matched value from a table.
Syntax
=VLOOKUP (value, table, col_index, [range_lookup])
Arguments
value - The value to look for in the first column of a table.
table - The table from which to retrieve a value.
col_index - The column in the table from which to retrieve a value.
range_lookup - [optional] TRUE = approximate match (default). FALSE = exact match.
Answer:
1) the wireless standards that can be implemented are; IEEE 802.11a, IEEE 802.11b, IEEE 802.11g and IEEE 802.11n. The pros and cons are in the attachment
2) 802.11g can be implemented in alice's restaurant. This is because it provides the fastest speed and has a wide range which will not be easily disturbed by other devices
3) Please check the attachment
4) Please check the attachment.
Explanation:
Answer:
Explanation: search engine uses system algorithm to search out items or information as required by the user. Example is google, chrome.
Data base are archives where information could be retrieve. Its contain information such as publications, abstract,journals.
Search engine provides wide range of information depending on you request while database are mostly for academics related materials.
Data base- A good place to generate this information is library, archivals while journal, publiications are kept while search engine can be used anywhere you have an internet facilities.
In a data base, information is searched in an organized way. The collections are already well arranged in different cubicle search engine provides wide range of information not organized.
Data base may contain more complex information not easily understood, search engine provides more elaborate answers.
Similarity of the two is that they both provide information.
They are both reliable.
School library is an example of where journals and publication are kept and can be retrived.
The SQL is used to change a table's structure by:
The use of the SQL ALTER TABLE command.
<h3>How is it done?</h3>
The SQL ALTER TABLE command is known to be that which is often used to alter the structure of an existing table.
It is known to help one to be able to add or delete columns, make or destroy indexes, alter the kinds of existing columns, rename columns or the table itself.
Note that It can also be used to alter the comment for any kind of table and type of the table therein.
Learn more about SQL from
brainly.com/question/25694408
#SPJ1