All categories

3 years ago

I am bad with excell pleasee heelp

Computers and Technology

1 answer:

Tamiku [17]3 years ago

3 0

Answer:

1. Ascending
2. 6
3. 9
4. identifies how many cells with data were in the range
5. =A2+B3

Explanation:

1. Ordering numbers in ascending way is ranking them from least to greatest.

The first number is the smallest, the next larger follows, and so the sequence continues until the last number, which will be the largest of the entire sequence:

In the sequence, 10 < 20 < 30 < 40; hence, the numbers are sorted in ascending way.

2. The range function

The first cell in the range A2:B4 is A2 (column A, row 2).

The last cell in the rage A2:B4 is B4 (column B, row 2).

Then, the range comprises two columns (A and B) and three rows (2, 3, and 4).

That is a total of 2 × 3 = 6 cells. They are A2, B2, A3, B3, A4, and B4:

A B

2 A2 B2

3 A3 B3

4 A4 B4

3. The range function with one column.

The first cell in the range A2:A10 is A2.

The last cell in the range A2:A10 is A10.

The column is the same for all the range. Only column A is in the range.

On the other hand, the range includes 9 rows: 2, 3, 4, 5, 6, 7, 8, 9, and 10.

Then, the number of cells is the product of the number of columns by the number of rows:

1 × 9 = 9.

The cells are A2, A3, A4, A5, A6, A7, A8, A9, and A10.

Therefore, the range A2:A10 has 9 cells.

4. The function =COUNT identifies how many cells with are were in the range.

The format of the function is:

=COUNT(RANGE)

For example, =COUNT(A2:B4) shall count the number of cells in the range that contain data. If all the cells contain data, then the output shall be 9, but if, for instance, two cells are empty then the function shall return 7.

There are some variations of the function such as =COUNTBLANK(RANGE). This function returns the number of cells that are empty.

5. If you copy a formula

When you copy a formula in Excel or other worksheets, the references to cells are relative. Thus, the column and row references in the formula will change in the same extent as the the cell that will contain the copied formula is away from the cell from which the formula comes from.

In this case, the formula that you are copying is in the cell D8 and you are copying it in the cell D9. That means that you moved 0 columns (keeping the column D) and 1 row down (moving from row 8 to row 9).

Then, when you paste the formula the references will be changed: 0 in the columns (same column) and the rows will increase in 1.

Therefore, A1 will be transformed into A2 (same column, 1 row more), and B2 will be transformed into B3 (same column, 1 row more).

In conclusion, the new formula in D9 is =A2+B3.

You might be interested in

Consider two different implementations, M1 and M2, of the same instruction set. There are three classes of instructions (A, B, a

ANTONII [103]

Answer:

a) the average CPI for machine M1 = 1.6

the average CPI for machine M2 = 2.5

b) M1 implementation is faster.

c) the clock cycles required for both processors.52.6*10^6.

Explanation:

(a)

The average CPI for M1 = 0.6 x 1 + 0.3 x 2 + 0.1 x 4

= 1.6

The average CPI for M2 = 0.6 x 2 + 0.3 x 3 + 0.1 x 4

= 2.5

(b)

The average MIPS rate is calculated as: Clock Rate/ averageCPI x 10^6

Given 80MHz = 80 * 10^6

The average MIPS ratings for M1 = 80 x 10^6 / 1.6 x 10^6

= 50

Given 100MHz = 100 * 10^6

The average MIPS ratings for M2 = 100 x 10^6 / 2.5 x 10^6

= 40

Machine M2 has a smaller MIPS rating

Changing instruction set A from 2 to 1

The CPI will be increased to 1.9 (1*.6+3*.3+4*.1)

and hence MIPS Rating will now be (100/1.9)*10^6 = 52.6*10^6.

7 0

2 years ago

Well I am having trouble and I feel really bad because I helped RandomGuy1 who rubs it in my face that I gave him the wrong answ

yawa3891 [41]

Hey dude don't leave tell a mod bout it they'll fix everything up for you.

8 0

3 years ago

As a compositional mode for electronic? media, __________ help people find their way through an unfamiliar system or? subject; t

maks197457 [2]

The answer that fills in the blank is orientation. It is because orientation does not provide all the details of what they are doing but a guideline of what they must do, in order for them to be guided on the things that they need to learn as they start. They require proper guidance which is the orientation before performing before hand. Especially when they are not familiar on what they need to do.

3 0

2 years ago

Suppose a program is operating with execution-time binding and the physical address generated is 300. the relocation register is

maria [59]

The corresponding logical address is 200.

If a program is operating with execution-time binding, the physical address generated will be 300. However, if the relocation register is set to 100, the corresponding logical address will be 200.

This is because the relocation register is used to offset the physical address, so that it can be used to calculate the logical address.

Learn more here:

brainly.com/question/20355023

#SPJ4

7 0

1 year ago

Please answer questions in complete sentences!

Troyanec [42]

i need help on that too :cc

7 0

2 years ago