Question

·         What is the difference between these functions: 1.      =ROUND(B2,0) 2.      =ROUND(B2,1) 3.      =ROUNDUP(B2,0) 4.  &nb

·         What is the difference between these functions:

1.      =ROUND(B2,0)

2.      =ROUND(B2,1)

3.      =ROUNDUP(B2,0)

4.      =ROUNDDOWN(B2,0)

·         What does this statement do: =COUNT(K2:K10)

Homework Answers

Answer #1

The difference between the syntax are defined as follows:

1. =ROUND(B2,0)

The number in Cell B2 needs to be round to 0 digits, which means that the number is rounded to the nearest integer.

2. =ROUND(B2,1)

The number in Cell B2 needs to be rounded to 1 decimal place.

3. =ROUNDUP(B2,0)

Thr number in Cell B2 is rounded up to the nearest integer.

4. =ROUNDDOWN(B2,0)

The number in Cell B2 is rounded down down to the nearest integer.

=COUNT(K2:K10)

The numbers in cell K2 to K10 are counted.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
1.what is the difference between a period and a product cost? 2.What is the difference between...
1.what is the difference between a period and a product cost? 2.What is the difference between a fixed cost and a variable cost? 3.What is the definition of the relevant range? 4.What are the 3 costs that are considered to be product costs? 5.How do fixed and variable costs behave within the relevant range? 6.How do we calculate the pre-determined over head rate? 7.What is the pre-determined rate used for ? 8.What is the difference between over and under applied?...
Consider functions f : {1, 2, 3, 4} → {−1, 0,1, 2, 3, 4}. (a) How...
Consider functions f : {1, 2, 3, 4} → {−1, 0,1, 2, 3, 4}. (a) How many functions are there total? Explain your reasoning. (b) How many functions are injective? Explain your reasoning.
1.What is the difference between Minority status and Culture? 2.What is the difference between Western and...
1.What is the difference between Minority status and Culture? 2.What is the difference between Western and Eastern culture? 3.What is the difference between a stigma vs misdiagnosing a mental illness?4. What are 3 norms of etiquette in across cultures?5. What is somatization?6 What are three specific types of cultural concepts?7. What are 3 ways immigrants face when arriving to a United States?8. What is the difference between acculturation and assimilation?9. What are some ways you feel like a Nurse is...
Consider the functions ?(?) = 5? + 3 and ?(?) = 3?^2 − 4? + 7....
Consider the functions ?(?) = 5? + 3 and ?(?) = 3?^2 − 4? + 7. i. Conjecture which is increasing faster. ii. Calculate: ??? ?→∞ 5 ? + 3 iii. Calculate: ??? ?→∞ 3 ?^2 − 4? + 7 iv. By themselves do these two limits answer the question about which is increasing faster? v. Evaluate using L’Hôpital’s Rule: ??? ?→∞ 5?+3 / 3?^2−4?+7 vi. What does the result of this finished limit calculation tell us about which function...
Between seconds 0 and 3 the acceleration is 9.8 m/s^2. Between seconds 3 and 4 acceleration...
Between seconds 0 and 3 the acceleration is 9.8 m/s^2. Between seconds 3 and 4 acceleration is -29.4 m/s^2. Between seconds 4 and 5 the acceleration does not change (it remains constant). What is the significance of this difference (what does it tell us)?
1)    What is the difference between "Accrual" Accounting and "Cash" basis accounting? 2)    What is the...
1)    What is the difference between "Accrual" Accounting and "Cash" basis accounting? 2)    What is the Accounting "Principle" that supports "Accrual" Accounting? 3)    Does the cash basis of accounting reflect future liabilities? 4)    Which method provides more consistent information? 5)    Which method is considered to be part of "GAAP"?
These are questions of Business Law. 1: What is the difference between an employee and an...
These are questions of Business Law. 1: What is the difference between an employee and an independent contractor? 2: What is the “employment-at-will” doctrine? Explain the exceptions. 3: What difference does it make if one or both parties to a sales contract is a merchant? Explain. 4: What employees are exempt from overtime? What test is used to determine if an employee is exempt? 5: What are the buyer's remedies when the seller delivers nonconforming goods? 6: What can the...
Leading digit Count Actual Distribution Expected Distribution Cumulative difference 1 38 31.1% 2 17 13.9% 3...
Leading digit Count Actual Distribution Expected Distribution Cumulative difference 1 38 31.1% 2 17 13.9% 3 25 20.5% 4 9 7.4% 5 9 7.4% 6 3 2.5% 7 11 9.0% 8 5 4.1% 9 5 4.1% Total 122 100.0% KS Cut-off How to find Expected Distribution and Cumulative Difference using Excel functions?
1. What is the major difference between simple transposons and retrotransposons? 2. How can simple transposition...
1. What is the major difference between simple transposons and retrotransposons? 2. How can simple transposition lead to copy number increase? 3. Briefly explain the role of reverse transcriptase and integrase in retrotransposition. 4. What damage does UV do to DNA? 5. UV damage to DNA is repaired by the Nucleotide Excision Repair Pathway. Briefly explain how UvrB and UvrC repair UV damage in E.coli.
1. What psychological and drug-related factors contribute to substance? 2. What is the difference between physical...
1. What psychological and drug-related factors contribute to substance? 2. What is the difference between physical and psychological dependence? 3. How does tolerance develop? SUBJECT: PHARMACOLOGY
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT