Describe the difference between a formula and a function explaining where you can use each, how you can test them, and t...

Question

Question

Describe the difference between a formula and a function explaining where you can use each, how you can test them, and t...

Describe the difference between a formula and a function explaining where you can use each, how you can test them, and their use in a linked spreadsheet. Use specific examples.

business accounting

Add a comment Improve this question Transcribed image text

Answer 1

Answer #1

A formula is a expression which calculates the value of a cell.It is basically what you write for a task

Functions are pre defined formulas that exist already in the spreadsheet.

To enter a formulae:

1. enter a cell

2.enter= to start or let the spreadsheet you are about to type

3. enter the cells cells you are about to add for eg: =A1+A2+A3, which gives you the sum of A1 to A3

Whereas the function already present in excel is =Sum(A1:A3)

Add a comment

Answer 2

Similar Homework Help Questions

from your own experience, describe three spreadsheet functions that you have used and found them useful....

from your own experience, describe three spreadsheet functions that you have used and found them useful. In your answers: Describe how each function is designed or formulated Use Excel spreadsheet to provide examples for each function. Show your demonstration in both normal and formula views with row and column headings. Explain why they are useful to you.
Briefly describe the difference between respiratory and metabolic pH imbalance. Describe a specific pH imbalance explaining...

Briefly describe the difference between respiratory and metabolic pH imbalance. Describe a specific pH imbalance explaining how it is either metabolic or respiratory in nature. Discuss physiological compensation of the disorder.
(pleasseeee do not take a picture, need this typed out) What is the difference between a relation and function? Discuss how to find the domain and range of a function. What test can you use to identi...

(pleasseeee do not take a picture, need this typed out) What is the difference between a relation and function? Discuss how to find the domain and range of a function. What test can you use to identify a function on a graph? Explain how to use it. Create one function and ask your peers to find the domain and range. Ask them to discuss the shape of the graph. Return to the Discussion to check your peers’ understanding and offer...

In your own words, describe the difference between Between-Treatments (Groups) and Within-Treatments (Groups) variation. Explain how...

In your own words, describe the difference between Between-Treatments (Groups) and Within-Treatments (Groups) variation. Explain how you would evaluate the variation and other methods to ensure that the data are appropriate to use for the test. Illustrate your ideas using a specific example. In replies to peers, provide additional examples to support the ideas presented.
Define each of the following suffixes and and describe the difference between them: -gram, -graph, -graphy.

Define each of the following suffixes and and describe the difference between them: -gram, -graph, -graphy.
What is the difference between a One sample t-test, Unpooled t-test, Pooled t-test, Paired t-test...

What is the difference between a One sample t-test, Unpooled t-test, Pooled t-test, Paired t-test, and Mann Whitney U test? How do you know when to use each test?

Describe the differences between correlations and regressions. Can you describe situations where you would use one...

Describe the differences between correlations and regressions. Can you describe situations where you would use one of these over the over, and why you would do so?
Option 1: Explain in your own words the difference between the domain of a function and...

Option 1: Explain in your own words the difference between the domain of a function and the range of a function. Provide an example for explaining how to find domain of an equation (use equation editor). Provide a visual example of a graph using the "insert image" feature and explain how to find the domain and range from the graph. Last, present a problem for your peers so they may practice identifying domain and range. Make sure to check on...
Describe the difference between descriptive and inferential statistics Identify the level of measurement of a variety...

Describe the difference between descriptive and inferential statistics Identify the level of measurement of a variety of variables Describe the difference between measures of central tendency and variability Explain the difference between correlation and causation Describe measurement validity and reliability and name the statistics used to test them Explain the difference between a population and a sample Describe what correlations are and how they are used only answer if you know these. Thanks.

13. When discussing multiple comparison tests, what is the difference between an a priori test and a post hoc test? Basically, you need to state when you use each and how many different compariso...

13. When discussing multiple comparison tests, what is the difference between an a priori test and a post hoc test? Basically, you need to state when you use each and how many different comparisons you make for each. 14. Some multiple comparison tests are called pairwise tests. What is meant by pairwise? 13. When discussing multiple comparison tests, what is the difference between an a priori test and a post hoc test? Basically, you need to state when you use...

Describe the difference between a formula and a function explaining where you can use each, how you can test them, and t...

Homework Answers

Add Answer to:
Describe the difference between a formula and a function explaining where you can use each, how you can test them, and t...

Post as a guest

Earn Coins

from your own experience, describe three spreadsheet functions that you have used and found them useful....

Briefly describe the difference between respiratory and metabolic pH imbalance. Describe a specific pH imbalance explaining...

(pleasseeee do not take a picture, need this typed out) What is the difference between a relation and function? Discuss how to find the domain and range of a function. What test can you use to identi...

In your own words, describe the difference between Between-Treatments (Groups) and Within-Treatments (Groups) variation. Explain how...

Define each of the following suffixes and and describe the difference between them: -gram, -graph, -graphy.

What is the difference between a One sample t-test, Unpooled t-test, Pooled t-test, Paired t-test...

Describe the differences between correlations and regressions. Can you describe situations where you would use one...

Option 1: Explain in your own words the difference between the domain of a function and...

Describe the difference between descriptive and inferential statistics Identify the level of measurement of a variety...

13. When discussing multiple comparison tests, what is the difference between an a priori test and a post hoc test? Basically, you need to state when you use each and how many different compariso...

Describe the difference between a formula and a function explaining where you can use each, how you can test them, and t...

Homework Answers

Add Answer to: Describe the difference between a formula and a function explaining where you can use each, how you can test them, and t...

Post as a guest

Earn Coins

Add Answer to:
Describe the difference between a formula and a function explaining where you can use each, how you can test them, and t...