Answer:
1. E.eid ,E.hobby, E.sal, E.did
2.E.eid , E.sal, E.hobby ,E.did , D.did, D.floor ,D.dname , D.budget.
3.E.eid , E.sal, E.hobby ,E.did , D.did, D.floor ,D.dname , D.budget.
4.E.eid , D.dname
Explanation:
The attributes that are examined for the query are the attributes of the table that are mentioned in the select statement and where clause.
So according to first query we are working on all attribues of Emp table so all of the attributes of Emp table are examined.In second query we selecting all attributes of both the tables hence all attributes of both the table and same in the next query.
In fourth query though the query is not complete where clause is missing but we have eid from Emp and dname from Dept tables for sure and the attributes mentioned in where clause will also be present.
Answer:
1. VLOOKUP function.
2. SUMIF function.
3. COUNT function.
4. IF function.
5. HLOOKUP function.
Explanation:
Microsoft Excel is a software application or program designed and developed by Microsoft Inc., for analyzing and visualizing spreadsheet documents. There are different types of functions used in Microsoft Excel to perform specific tasks and these includes;
1. VLOOKUP function: it's an Excel function that avails end users the ability to lookup data in a table organized vertically. Thus, it's typically used for searching values in a column.
2. SUMIF function: it is an Excel function to sum cells that meet criteria such as text, dates and numbers. This function can be used with the following logical operators; <, >, and =.
3. COUNT function: it's an Excel function to find the total number of entries in a column. For example, to count the number of entries in B1:B15; COUNT(B2:B15).
4. IF function: runs a logical test and returns one value for a TRUE result, and another for a FALSE result. For example, to fail scores that are below 40; IF (A1 < 40, "Fail", "Pass").
5. HLOOKUP function: it's an Excel function that avails end users the ability to lookup data in a table organized horizontally. Thus, it's typically used for searching values in a column.
Answer:
Cause they are trying to be annoying
Explanation:
Something is wrong with them :)
Answer:
The answer to this question is "Media Richness".
Explanation:
Media Richness is a theory, that says Media has the power to convey the information that is needed in communication. This depends on whether uncertain times which type of data will be used, which is explained by the Mass Communication.
- Media Richness is the amount in which two social members make audio, visual and private interaction.
- It provides face to face communication that was released in 1987 which ranks this as the richest channel for mediated communication.
Answer:
CJ is developing a new website blogging about cutting-edge technologies for people with special needs. He wants to make the site accessible and user friendly. CJ wants to link to articles in his website. He has assigned specific values for each ID attribute. To link to that ID attribute, CJ must use an # before the ID value in his href statement.
Explanation:
In order to create an internal link, a link's href element must be assigned to a hash symbol #, including the value of the id attribute for the element that is to be to internally linked to, usually further down the page. Then, there is also a need to add the same id attribute to the element to be linked to.
An id refers to an attribute that uniquely describes an element. Below is an example of an internal anchor link and its target element:
<a href="#contacts-header">Contacts</a>
