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)

Business   Operations-Management   
0 0
Add a commentTranscribed image text
Next >

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.

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

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 a SYMLINK and a HARDLINK? 2) What is the difference between...
1)What is the difference between a SYMLINK and a HARDLINK? 2) What is the difference between a DAEMON and a SERVICE? 3) What is the difference between a DAEMON and a PROCESS?
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...
What is the difference between the composition and the product of two functions?
What is the difference between the composition and the product of two functions?
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?
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT