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

HELP ME ILL GIVE BRAINLY Input 50 numbers and then output the average of the negative numbers only. Write in pseudocode!

Mumz [18]

Answer:

The explanation is for 10 inputs though. You'd have to follow these steps to find input 50 numbers.

Explanation:

This is how I wrote it in the Plain English programming language which looks like pseudo-code but compiles and runs (to save you all the rest of the steps):

To run:

Start up.

Write "Enter 10 numbers separated by spaces: " on the console.

Read a reply from the console.

Loop.

If the reply is blank, break.

Get a number from the reply.

Add 1 to a count.

Add the number to a total.

Repeat.

Write "The total is: " then the total on the console.

Put the total divided by the count into an average.

Write "The average is: " then the average on the console.

Refresh the screen.

Wait for the escape key.

Shut down.

3 0

3 years ago

Suppose that we have a set of activities to schedule among a large number of lecture halls, where any activity can take place in

laiz [17]

Answer:

By Using the Greedy- Activity- Selection algorithm

Explanation:

The Greedy- Activity- Selection algorithm in this case involves

First finding a maximum size set S1, of compatible activities from S for the first lecture hall.

Then using it again to find a maximum size set S2 of compatible activities from S - S1 for the second hall.

This is repeated till all the activities are assigned.

It requires θ(n2) time in its worse .

8 0

3 years ago

Which of the following would allow for the QUICKEST restoration of a server into a warm recovery site in a case in which server

adelina 88 [10]

Answer: C. Differential backup

Explanation: There are several ways od ensuring the preservation and storage of data even cases of disaster, one of such ways is data data mirroring which allows data to be replicated or copied in real time and several backup options. In cases where there there is need to restore a server, the warm recovery site provides a data or disaster recovery option used to mitigate the effect of data loss on organization. In the absence of data mirroring, differential backup option, provides the quickest recovery option as it only requires changes in the data stored after the last full backup. These speed experieced should be expected due to the relatively low data been dealt with rather than the entire data.

5 0

3 years ago

What is the recommended size for bulleted text? 12–22 24–40 44–66 54–80

algol [13]

44–66

According to sources, the most probable answer to this query is 44–66 point size.
This is because the eyes and the illustration should match the proportion of distance and height factors.
Thank you for your question. Please don't hesitate to ask in Brainly your queries.

5 0

3 years ago

Input 10 integers and display the following:

LekaFEV [45]

Answer:

// code in C++

#include <bits/stdc++.h>

using namespace std;

// main function

int main()

{

// variables

int sum_even=0,sum_odd=0,eve_count=0,odd_count=0;

int largest=INT_MIN;

int smallest=INT_MAX;

int n;

cout<<"Enter 10 Integers:";

// read 10 Integers

for(int a=0;a<10;a++)

{

cin>>n;

// find largest

if(n>largest)

largest=n;

// find smallest

if(n<smallest)

smallest=n;

// if input is even

if(n%2==0)

{

// sum of even

sum_even+=n;

// even count

eve_count++;

}

else

{

// sum of odd

sum_odd+=n;

// odd count

odd_count++;

}

// print sum of even

cout<<"Sum of all even numbers is: "<<sum_even<<endl;

// print sum of odd

cout<<"Sum of all odd numbers is: "<<sum_odd<<endl;

// print largest

cout<<"largest Integer is: "<<largest<<endl;

// print smallest

cout<<"smallest Integer is: "<<smallest<<endl;

// print even count

cout<<"count of even number is: "<<eve_count<<endl;

// print odd cout

cout<<"count of odd number is: "<<odd_count<<endl;

return 0;

}

Explanation:

Read an integer from user.If the input is greater that largest then update the largest.If the input is smaller than smallest then update the smallest.Then check if input is even then add it to sum_even and increment the eve_count.If the input is odd then add it to sum_odd and increment the odd_count.Repeat this for 10 inputs. Then print sum of all even inputs, sum of all odd inputs, largest among all, smallest among all, count of even inputs and count of odd inputs.

Output:

Enter 10 Integers:1 3 4 2 10 11 12 44 5 20

Sum of all even numbers is: 92

Sum of all odd numbers is: 20

largest Integer is: 44

smallest Integer is: 1

count of even number is: 6

count of odd number is: 4

3 0

3 years ago