All categories

4 years ago

I am bad with excell pleasee heelp

Computers and Technology

1 answer:

Tamiku [17]4 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

The use of computer hardware and software to analyze biological data, such as dna sequence comparison data, is known as ________

Natali [406]

I believe this is called bioinformatics, using computers to quickly compute or search various databases for info.

4 0

3 years ago

A TV game show Jeopardy! contestant who uses a strategy to seek out the hidden Daily Double questions, which are usually the thr

jek_recluse [69]

Answer:

Game theory.

Explanation:

In the TV game show Jeopardy! Game theory allows contestant to use a strategy to seek out the hidden Daily Double questions, instead of the more common approach of selecting a single category and selecting questions gradually increasing in the degree of difficulty.

Game theory is the process of using mathematical model in the study of strategic interaction between two or more players in a game or situation having laid down rules and outcomes.

8 0

3 years ago

Which key on the keyboard do you use when you copy using Drag and Drop? The Alt key. The Ctrl key. The Shift key. None of the ab

tamaranim1 [39]

CTRL key is used indeed

6 0

3 years ago

Read 2 more answers

Due to the wildfires in Australia, the Red Cross has asked for assistance in determining how many trees were destroyed per hecta

kobusy [5.1K]

Answer:

1.trees_destroyed_per_hectare = 456/2.47

2. input(no_of_hectares)

3. no_of_trees_destroyed =no_of_hectares * trees_destroyed_per_hectare

4. print(no_of_trees_destroyed)

Explanation:

1.trees_destroyed_per_hectare = 456/2.47 //conversion of tress destroyed per acres to hectare

2. input(no_of_hectares) // get input from user in hectares that how many hectares are destroyed

3. no_of_trees_destroyed =no_of_hectares * trees_destroyed_per_hectare // total number of trees destroyed by fire on given day and given area

4. print(no_of_trees_destroyed)

7 0

3 years ago

You need to install an operating system on a computer that will be sharing files for the company employees. You estimate there w

TiliK225 [7]

The operating system that is ideally suited for this machine that will be sharing files for the company employees with an estimated of as many as 15 users accessing these files at one time is Windows Server 2003 Standard Edition.

This operating system is best suited to handle the load of 15 concurrent users.

3 0

4 years ago