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

A lack of financial literacy can cause you to lose your

Marianna [84]

Answer:

Financial literacy of someone's ability to understand and apply financial skills, including budgeting, financial management, investing and risk calculation. However, lack of financial literacy may result in opposite of having financial literacy.

Explanation:

Financial literacy of someone's ability to understand and apply financial skills, including budgeting, financial management, investing and risk calculation. Financial literacy helps individuals in taking financial decisions in achieving self-sufficient financial stability. Financial literacy is the skill of someone about making financial decisions. This skill can help a person to develop a financial roadmap about what he earns, how he will earn, what he spends and what he saves and owes.

Lack of financial literacy can cause to loose your:

making effective financial planning
making the right decision about budgeting
ability to calculate interest
understanding the time value of money.

Financial illiteracy can cause you to lose your money or become victims of predatory lending, fraud, subprime mortgages, paying high-interest rates, bankruptcy or potentially resulting in bad credit.

The lack of financial literacy can lead to owing large amounts of debt and making poor financial decisions. For example, the advantages or disadvantages of fixed and variable interest rates are concepts that are easier to understand and make informed decisions about if you possess financial literacy skills.

4 0

4 years ago

You need to install an RODC in a new branch office and want to use an existing workgroup server running Windows Server 2012 R2.

klio [65]

Answer:

You should do the following:

Create an account of computer for RODC in the domain controller OU (Organizational unit) as well as allow the Micheal's account to join the computer to the domain.

Explanation:

RODC:

It is called as Read only domain controller that is used to ensure the protection of the servers at remote offices of an organizations.

In this case, you are installing an RODC in a new branch office that is remote. For installation of RODC on windows server 2012 R2, we need to create an account for the computer in the domain controller organizational unit for the installation of RODC.
We also need to create an account for Micheal's with the privilege to join that computer to the domain.

5 0

3 years ago

Is a list of instructions an arguments? Yes or No

Bingel [31]

Answer: yes

Explanation:

5 0

3 years ago

Read 2 more answers

You've been asked to design a soho network on a work place. the other offices in the building also have wireless networks. while

Kipish [7]

In the scenario in which you should to design a SOHO network on a work place. the other offices in the building also have wireless networks. while setting up a wireless network for the SOHO, your initial step should be to run a wireless site survey.

This survey will help you to know which access points (AP) are in the most optimal locations.

5 0

3 years ago

Given two integers as user inputs that represent the number of drinks to buy and the number of bottles to restock, create a Vend

Zanzabum

Answer:

import java.util.Scanner;

class Main {

public static void main (String args[])

{

Scanner input = new Scanner(System.in);

VendingMachine machine = new VendingMachine(20);

System.out.print("Enter nr to purchase: ");

int nrPurchased = input.nextInt();

System.out.print("Enter nr to re-stock: ");

int nrRestock = input.nextInt();

machine.Transaction(nrPurchased, nrRestock);

input.close();

}

class VendingMachine {

private int inventory;

public VendingMachine(int initialInventory) {

inventory = initialInventory;

}

public void Transaction(int nrToBuy, int nrToRestock) {

inventory += nrToRestock - nrToBuy;

System.out.printf("Inventory: %d bottles.\n", inventory);

}

7 0

3 years ago