Ask question

Ask question

All categories

2 years ago

9

Charles is having a lot of problems with errors in a very complicated spreadsheet that he inherited from a colleague, and he tur

ns to another co-worker, Seymour, for tips on how to trace errors in the sheet. If Charles sees which of the following, Seymour explains, there is a mistyped function name in the sheet.
a.#FORM?
b.#NAME?
c.#####
d.#FNCT?

1 answer:

grin007 [14]2 years ago

3 0

Answer:

<u>b.#NAME?</u>

Explanation:

Remember, in Spreadsheet programs like Ms Excel several types of errors can occur such as value error.

However, since Seymour explains that there is a mistyped function name in the sheet it is more likely to display on the affected cell as #NAME?.

For example the function =SUM is wrongly spelled =SOM.

Therefore it is important to make sure the function name is spelled correctly.

You might be interested in

You are designing a 108 cm3 right circular cylindrical can whose manufacture will take waste into account. There is no waste in

FinnZ [79.3K]

Explanation:

It is given that,

The volume of a right circular cylindrical, $V=108\ cm^3$

We know that the volume of the cylinder is given by :

$V=\pi r^2 h$

$108=\pi r^2 h$

$h=\dfrac{108}{\pi r^2}$ ............(1)

The upper area is given by :

$A=32r^2+2\pi rh$

$A=32r^2+2\pi r\times \dfrac{108}{\pi r^2}$

$A=32r^2+\dfrac{216}{r}$

For maximum area, differentiate above equation wrt r such that, we get :

$\dfrac{dA}{dr}=64r-\dfrac{216}{r^2}$

$64r-\dfrac{216}{r^2}=0$

$r^3=\dfrac{216}{64}$

r = 1.83 m

Dividing equation (1) with r such that,

$\dfrac{h}{r}=\dfrac{108}{\pi r}$

$\dfrac{h}{r}=\dfrac{108}{\pi 1.83}$

$\dfrac{h}{r}=59 \pi$

Hence, this is the required solution.

8 0

2 years ago

The vapor pressure of diethyl ether (ether) is 463.57 mm Hg at 25°C. How many grams of chlorophyll, C55H72MgN4O5, a nonvolatile,

mixer [17]

Answer:

29.4855 grams of chlorophyll

Explanation:

From Raoult's law

Mole fraction of solvent = vapor pressure of solution ÷ vapor pressure of solvent = 457.45 mmHg ÷ 463.57 mmHg = 0.987

Mass of solvent (diethyl ether) = 187.4 g

MW of diethyl ether (C2H5OC2H5) = 74 g/mol

Number of moles of solvent = mass/MW = 187.4/74 = 2.532 mol

Let the moles of solute (chlorophyll) be y

Total moles of solution = moles of solute + moles of solvent = (y + 2.532) mol

Mole fraction of solvent = moles of solvent/total moles of solution

0.987 = 2.532/(y + 2.532)

y + 2.532 = 2.532/0.987

y + 2.532 = 2.565

y = 2.565 - 2.532 = 0.033

Moles of solute (chlorophyll) = 0.033 mol

Mass of chlorophyll = moles of chlorophyll × MW = 0.033 × 893.5 = 29.4855 grams

8 0

2 years ago

A watermelon is dropped from the top of a 80m tall building. We want to find the velocity of the watermelon after it falls for 1

White raven [17]

Answer:

$v_f = v_i + at$

$v_f = 13.23 m/s$

Explanation:

Height Of the watermelon when it is dropped is given as

$h = 80 m$

time of fall under gravity

$t = 1.35 s$

now if water melon start from rest then we have

$v_i = 0$

acceleration due to gravity for watermelon

$a = 9.81 m/s^2$

now we need to find the final speed of watermelon

$v_f = v_i + at$

so we will have

$v_f = 0 + (9.81)(1.35)$

$v_f = 13.23 m/s$

7 0

3 years ago

grigory [225]

Answer:

Both AC and DC describe types of current flow in a circuit. In direct current (DC), the electric charge (current) only flows in one direction. Electric charge in alternating current (AC), on the other hand, changes direction periodically.

7 0

2 years ago

A force of 14 lb is required to hold a spring stretched 4 in. beyond its natural length. How much work W is done in stretching i

enyata [817]

Answer:

$W = 19.8 J$

Explanation:

14 lb force is required to stretch the spring by 4 inch distance

So we have

$F = 14 lbf$

$F = 6.35 \times 9.8 N$

$F = 62.3 N$

stretch in the spring is given as

$x = 4 in = 0.1016 m$

now we will have

$F = kx$

$62.3 = k(0.1016)$

$k = 613.125 N/m$

Now we need to find the work to stretch it by x = 10 in = 0.254 m

so we have

$W = \frac{1}{2}kx^2$

$W = \frac{1}{2}(613.125)(0.254)^2$

$W = 19.8 J$

7 0

3 years ago