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

a rule that states each foreign key value must match a primary key value in the other relation is called the

makvit [3.9K]

Answer:

Referencial Integrity Contraint

Explanation:

The referential integrity constraint states that the customer ID i.e (CustID) in the Order table must match a valid CustID in the Customer table. Most relational databases have declarative referential integrity. That is to say, when the tables are created the referential integrity constraints are set up so as to maintain the quality of information.

3 0

3 years ago

Consider a company that needs to sort an array of structures of type Customer by balance, with the largest balance first. Here i

8090 [49]

Answer:

#include <iostream>

#include <string>

#include <cstring>

#include <cstdlib>

using namespace std;

struct Person

{

string name;

int age;

};

int main()

{

struct Person data[10];

struct Person *pData[10],*temp;

string names[] = {"a","b","c","g","z","l","p","q","r","w"};

int num[] = {4,6,34,8,13,90,33,22,18,23};

for(int i=0;i<9;i++)

{

data[i].name = names[i];

data[i].age = num[i];

pData[i] = &data[i];

}

for(int i=0;i<9;i++)

{

for(int j=i+1;j<9;j++)

{

if(pData[i]->name.compare(pData[j]->name)>0)

{

temp = pData[i];

pData[i] = pData[j];

pData[j] = temp;

}

for(int i=0;i<9;i++)

{

cout<<pData[i]->name<<" "<<pData[i]->age<<endl;

}

Explanation:

The line #include <iostream> initializes the program.

This program created an array of only 10 structures, Customer data. Also defined an auxiliary array Customer *pData.

The program uses these parameters to sorts the array of pointers so that when you go through pData in increasing order of index k, the entries pData[k] point to Customer objects in decreasing order by balance, meaning that pdata[0] now points to the customer with the highest balance, and pData[9] points to the customer with the smallest balance.

4 0

3 years ago

Put these operating systems in order according to the date they were released. (The first to be released would be

uysha [10]

1. ms-dos 1981
2. windows 2.0 1987
3. windows xp 2001
4. mac os 2001
5. windows 7 2009

8 0

3 years ago

At the beginning of Section 5.2, it is stated that multiprogramming and multiprocessing present the same problems, with respect

QveST [7]

Answer:

By definition, multiprocessing refers to the processing of multiple processes at the same time by multiple CPUs.

By definition, multiprogramming keeps programs in main memory at the same time and execute them concurrently utilizing a single CPU doing a context switch.

The first difference is that multiprocessing uses multiple CPUs and multiprogramming to utilize context switch to do concurrency in one CPU. Another difference is that multiprocessing is more expensive but more efficient than multiprogramming due that it allows parallel processing.

6 0

3 years ago

Write the simplest statement that prints the following on a single line: 3 2 1 Go! Note: Whitespace (blank spaces / blank lines)

Olin [163]

Answer:

//here is the statement in java.

import java.util.*;

//class definition

class Solution

{

// main method of the class

public static void main (String[] args) throws java.lang.Exception

{

try{

// this statement will print the 3 2 1 Go! and go to newline

System.out.println("3 2 1 Go!");

}catch(Exception ex){

return;}

}

Explanation:

We can use "System.out.println()" to print the required output same as it required. After printing this, it will go to newline.

Output:

3 2 1 Go!

4 0

3 years ago