All categories

2 years ago

Suppose you are developing an Excel spreadsheet that finds the unit price of any

Mathematics

1 answer:

larisa86 [58]2 years ago

3 0

Excel formulas are expressions used to perform computation.

The Excel formula to calculate the unit price of any object is = (D2/E2)

From the question, we have:

Cell E2 represents the number of units
Cell D2 represents the price of the object

The unit price of an item is the quotient of the price and the quantity.

i.e.

$Unit\ Price = \frac{Price}{Quantity}$

Replace the variables with the cell names

$Unit\ Price = \frac{D2}{E2}$

Rewrite as:

$Unit\ Price = D2/E2$

Remove "Unit Price" from the formula

So, we have:

= D2/E2

This means that the Excel formula to calculate the unit price of any object is = (D2/E2)

You might be interested in

Jason is pulling a box across the room. He is pulling with a force of 11 newtons and his arm is making a 37 angle with the horiz

MissTica

Force=10N

Angle=37

Vertical componenets:-

$\\ \sf\longmapsto Fsin\theta$

$\\ \sf\longmapsto 10sin38$

$\\ \sf\longmapsto 10(0.6)$

$\\ \sf\longmapsto 6N$

4 0

3 years ago

Which is the graph of the linear equation y = –one-fourthx + 3?

Aleksandr-060686 [28]

Step-by-step explanation:

need the graph

but, it will cross y axis at 3 and line will be going down

7 0

4 years ago

Hello, i need help! <br> 5/2 multiplied by what equals 1? <br> equation: 5/2×?=1

prisoha [69]

Answer:

$\large\boxed{\dfrac{2}{5}}$

Step-by-step explanation:

$\text{The product of the number and its reciprocal gives us 1.}\\\text{Reciprocal of }\ \dfrac{5}{2}\ \text{is equal}\ \dfrac{2}{5}.\\\\\dfrac{5}{2}\times\dfrac{2}{5}=\dfrac{5\!\!\!\!\diagup}{2\!\!\!\!\diagup}\times\dfrac{2\!\!\!\!\diagup}{5\!\!\!\!\diagup}=\dfrac{1}{1}\times\dfrac{1}{1}=1\times1=1$

4 0

3 years ago

If x=-7 is a root of the equation x^2+kx+49=0, then k=

aleksley [76]

Answer:

$k=14$

Step-by-step explanation:

Given:

$x^{2}+kx+49 = 0$

$x = -7$

Substitution can be used to find the value of $k$ :

$(-7)^{2}+(-7)k+49 = 0$

$49-7k+49 = 0$

$98 -7k = 0$

$k = 14$

Hope this helps :)

8 0

3 years ago

Mike is giving roses to some children at a carnival. He has 7 red roses, 8 yellow roses, and 9 white roses. If Mike selects a ro

Kaylis [27]

7 red, 8 yellow, 9 white......total = 24 roses

probability first pick is white : 9/24
probability second pick is yellow : 8/23

probability of both : 9/24 * 8/23 = 72/552 reduces 3/23 <====

7 0

4 years ago

Read 2 more answers