1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
fenix001 [56]
3 years ago
15

I am bad with excell pleasee heelp

Computers and Technology
1 answer:
Tamiku [17]3 years ago
3 0

Answer:

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

Explanation:

<em>1. Ordering numbers in ascending way</em> 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, <em>10 < 20 < 30 < 40</em>; hence, the numbers are sorted in ascending way.

<em>2. The range function</em>

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.

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

The format of the function is:

  • <em>=COUNT</em>(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.

<em>5. If you copy a formula</em>

When you <em>copy a formula</em> 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 <em>new formula in D9 is =A2+B3.</em>

You might be interested in
Brenda's working on improving a Google Search Ads quality score so it potentially gets a better ad rank and performs better in t
Alchen [17]

Answer:

use Search terms as keywords

Explanation:

Based on the information provided within the question it can be said that one of the best ways that Brenda can improve her Ad Rank would be to use Search terms as keywords. Using terms that are searched extremely frequently by the world drastically increases the amount of visitors that your ad can receive and thus boosts your Ad Rank.

7 0
3 years ago
1. why is manufacturing considered the biggest contributor to progress
34kurt

Answer:

A vibrant manufacturing base leads to more research and development, innovation, productivity, exports, and middle-class jobs. Manufacturing helps raise living standards more than any other sector. Manufacturing generates more economic activity than other sectors.

3 0
2 years ago
Your help will help me understand my answers by comparing to yours. Your kind contribution is very much appreciated.
OLEGan [10]
4. B
for # 5 what illustration are u talking about
6. D
7. D
8. don't understand that question

sorry these questions might be wrong

6 0
2 years ago
Explain the steps in starting the MS Access from the Start Menu.​
blondinia [14]

Explanation:

<em>As</em><em> </em><em>with</em><em> </em><em>most</em><em> </em><em>windows</em><em> </em><em>programs</em><em> </em><em>Access</em><em> </em><em>can</em><em> </em><em>be</em><em> </em><em>executed</em><em> </em><em>by</em><em> </em><em>navigation</em><em> </em><em>the</em><em> </em><em>start</em><em> </em><em>menu</em><em> </em><em>in</em><em> </em><em>the</em><em> </em><em>lower</em><em> </em><em>left</em><em> </em><em>hand</em><em> </em><em>corner</em><em> </em><em>of</em><em> </em><em>the</em><em> </em><em>windows</em><em> </em><em>desktop</em><em>. </em><em>To</em><em> </em><em> </em><em>Acess</em><em>,</em><em> </em><em>click</em><em> </em><em>on</em><em> </em><em>the</em><em> </em><em>start</em><em> </em><em>button</em><em>,</em><em> </em><em>then</em><em> </em><em>the</em><em> </em><em>programs</em><em> </em><em>menu</em><em> </em><em>then</em><em> </em><em>move</em><em> </em><em>to</em><em> </em><em>the</em><em> </em><em>Microsoft</em><em> </em><em>Office</em><em> </em><em>m</em><em>enu</em><em> </em><em>a.d</em><em> </em><em>finally</em><em> </em><em>click</em><em> </em><em>on</em><em> </em><em>the</em><em> </em><em>Microsoft</em><em> </em><em>Access</em><em> </em><em>menu</em><em> </em><em>item</em><em>. </em>

6 0
2 years ago
Select the three careers in the creative side of digital media.
MrRa [10]

Answer:

I would pick A B and D to be my answer

6 0
2 years ago
Other questions:
  • HELP AS SOON IS A UNIT TEST WILL GIVE BRAINLIEST
    9·2 answers
  • Which of the following are types of home internet service? Check all that apply
    7·1 answer
  • Write the definition of a function printAttitude , which hasan int parameter and returns nothing. The function prints amessage t
    13·1 answer
  • A(n) _______________ is a collection of configuration and security settings that an administrator has created in order to apply
    14·1 answer
  • Why is data processing done in computer?​
    14·1 answer
  • List all the components of a computer
    14·2 answers
  • When you call a method with a parameter list, the arguments in the argument list Select one: a. must be coded in the same sequen
    15·1 answer
  • Describe how data is transmitted using half-duplex serial data transmission.
    9·1 answer
  • So I tried asking for help with my code on stackoverflow but the people there were very condescending and mean plus my questions
    7·1 answer
  • Thirty percent of a magazine's subscribers are female. A random sample of 50 subscribers Answer the following questions using Ex
    6·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!