All categories

3 years ago

What is the purpose of lookup tables in spreadsheet software

Computers and Technology

2 answers:

MrRissso [65]3 years ago

8 0

Answer:

they allow the user to retrieve information form another location in a table

Explanation:

garik1379 [7]3 years ago

7 0

You can easily find and changed the data by using lookup table. You can also find the data within few seconds.

You might be interested in

When creating a spreadsheet, there's no need to worry about design and how it will be organized; the program will take care of t

Rainbow [258]

False: a computer program do many things, but it can't read your mind. It doesn't know what kind of formatting you need for your spreadsheet. There are so many potential layouts of a spreadsheet, that the computer couldn't decide what to lay it out for you. Eventually the computer can see what you're trying to lay it out as and can help that way, but it needs to e started first. Having a uniform sheet that is well organized by you, is much easier to read than gobbledegook that has been spewed everywhere.

I hope this was helpful!

3 0

3 years ago

Read 2 more answers

The master system database stores a database template that is used as a blueprint when creating a new user database.

Novay_Z [31]

An attribute in a relation of a database that serves as the primary key of another relation in the same database is called a

6 0

3 years ago

A computer retail store has 15 personal computers in stock. A buyer wants to purchase 3 of them. Unknown to either the retail st

Dima020 [189]

Answer:

a. 1365 ways

b. Probability = 0.4096

c. Probability = 0.5904

Explanation:

Given

PCs = 15

Purchase = 3

Solving (a): Ways to select 4 computers out of 15, we make use of Combination formula as follows;

$^nC_r = \frac{n!}{(n-r)!r!}$

Where $n = 15\ and\ r = 4$

$^{15}C_4 = \frac{15!}{(15-4)!4!}$

$^{15}C_4 = \frac{15!}{11!4!}$

$^{15}C_4 = \frac{15 * 14 * 13 * 12 * 11!}{11! * 4 * 3 * 2 * 1}$

$^{15}C_4 = \frac{15 * 14 * 13 * 12}{4 * 3 * 2 * 1}$

$^{15}C_4 = \frac{32760}{24}$

$^{15}C_4 = 1365$

Hence, there are 1365 ways 

Solving (b): The probability that exactly 1 will be defective (from the selected 4)

First, we calculate the probability of a PC being defective (p) and probability of a PC not being defective (q)

From the given parameters; 3 out of 15 is detective;

So;

$p = 3/15$

$p = 0.2$

$q = 1 - p$

$q = 1 - 0.2$

$q = 0.8$

Solving further using binomial;

$(p + q)^n = p^n + ^nC_1p^{n-1}q + ^nC_2p^{n-2}q^2 + .....+q^n$

Where n = 4

For the probability that exactly 1 out of 4 will be defective, we make use of

$Probability = ^nC_3pq^3$

Substitute 4 for n, 0.2 for p and 0.8 for q

$Probability = ^4C_3 * 0.2 * 0.8^3$

$Probability = \frac{4!}{3!1!} * 0.2 * 0.8^3$

$Probability = 4 * 0.2 * 0.8^3$

$Probability = 0.4096$

Solving (c): Probability that at least one is defective;

In probability, opposite probability sums to 1;

Hence;

Probability that at least one is defective + Probability that at none is defective = 1

Probability that none is defective is calculated as thus;

$Probability = q^n$

Substitute 4 for n and 0.8 for q

$Probability = 0.8^4$

$Probability = 0.4096$

Substitute 0.4096 for Probability that at none is defective

Probability that at least one is defective + 0.4096= 1

Collect Like Terms

Probability = 1 - 0.4096

Probability = 0.5904

8 0

3 years ago

The help desk received a call from a user who cannot get any print jobs to print on the locally shared printer. While questionin

erma4kov [3.2K]

Answer:

a. Power cycle the printer.

Explanation:

Power Cycle: To unplug the printer and restart it, is called power cycling. The peripheral devices often tend to stop working and the cause of this is not always easily figured out. So the first and easiest way that can be done to fix this issue is to run a power cycle. For this, you have to turn off the printer and unplug it. Then wait for a few seconds (at least 30) and plug in the printer again. Turn the printer on. Power cycle helps to resolve many basic issues. It is the easiest step to take before checking the printer cable, reinstalling printer or resetting the print spooler.

4 0

3 years ago

Help me plz What character must always be used when a formula is enter in a cell? (on a spreadsheet)

lara [203]

Answer:

The equal sign "=" must be used.

Most, if not all, spreadsheet programs support formulas, but you must start them with an equal sign.

8 0

3 years ago