What feature of excel allows you to automatically calculate common formulas with selected data

The questions are in the pictures, i basically have to create a web page, drop the html code and files below thank you.

matrenka [14]

This contains pretty much what you need:

<!DOCTYPE html>

<html>

<head>

<title>The Page Title</title>

</head>

<body>

<h1>First paragraph</h1>

<p>This is a paragraph of text.</p>

<h2>Second level paragraph</h2>

<p>

Here is an unordered list of options:

<ul>

<li>First</li>

<li>Second</li>

<li>Third</li>

</ul>

Here is another unordered list of options:

<ul>

<li>First</li>

<li>Second</li>

<li>Third</li>

</ul>

Here is an ordered list of options:

<ol>

<li>First</li>

<li>Second</li>

<li>Third</li>

</ol>

</p>

<h4>Third level</h4>

</body>

</html>

3 0

4 years ago

Consider the following relation: CAR_SALE (Car#, Date_sold, Salesman#, Commision%, Discount_amt Assume that a car may be sold by

Nady [450]

Answer:

See explaination

Explanation:

The given relation is:

CAR_SALE(Car#, Date_sold, Salesperson#, Commission%, Discount_amt)

Primary key: {Car#,Salesperson#}

We will first check whether the relation is in 1NF.

A relation is said to be in the 1st Normal form(1NF) if all the columns in the relation have atomic values. In this case, the relation is in 1NF.

A relation is said to be in the second normal form(2NF) if it satisfies the condition that all non keys are completely dependent on the primary key and just a part of the primary key.

In the case of the CAR_SALE relation, the Commission% depends only on the Salesperson# and not on the combination of Car# and Salesperson#. This means that the given relation is not in 2NF. To satisfy 2NF, we make two relationships as given below:

SALE_DETAIL(Salesperson#, Commission%)

and CAR_SALE(Car#, Date_sold, Salesperson#, Discount_amt)

Now both the relations are in 2NF.

For a relation to be in 3NF, no non-key should be functionally dependent on another non key.

In the case of the CAR_SALE relation, it is specified that the Date_sold field determines the Discount_amt. Therefore the modified CAR_SALE is not in 3NF.

To satisfy 3NF, we seperate the non key and the dependent non key and create a different table.

Final Relations:

SALE_DETAIL(Salesperson#, Commission%)

Discount_Detail(Date_Sold, Discount_Amt)

CAR_SALE(Car#, Date_sold, Salesperson#)

7 0

3 years ago

Using the physical mail analogy, what part of an address on an envelope is most like the ip address?

Slav-nsk [51]

The recipient IP address would would be the recipient home address.

8 0

3 years ago

(choose one) Which is the proper means to decrement the integer variable, myScore, by one?

kakasveta [241]

Answer

Explanation

its too short please add more characters

7 0

4 years ago

The numbers, text, or cell references used by the function to return a value are called ____.

Alenkasestr [34]

The numbers, text or cell references used by the function to return a value are called ARGUMENTS. In computers and technology, arguments is referred to as a value that is assigned to something that returns when it is stated in a code.

8 0

4 years ago