Question

In: Computer Science

For your main post, Yolanda wants you to explain the following; (formula) How we add four...

For your main post, Yolanda wants you to explain the following;

(formula) How we add four cells together using a cell reference and the + operator.

(function) How we add four cells together without using the + operator. Discuss two functions we find using the Insert function button found on the formula bar.

Describe what they do and how we would create them in a spreadsheet. List the three methods we can use to create a function from chapter two, and describe which method you feel the most comfortable using, and why.

Solutions

Expert Solution

Let me explain each points:

Addition of four cells together using a cell reference and the + operator in spreadsheet

This is the simplest type of Excel/Spreadsheet addition: Suppose A1, A2, A3, A4 contains the values: 10,11,12,13 and we need the sum in A5, then enter the formula =A1+A2+A3+A4 in cell A5 . Now we get the result 46 in A5.

Addition of four cells together without using the + operator in spreadsheet

The syntax of this function is: =SUM( number1, [number2], ... ).

Suppose A1, A2, A3, A4 contains the values: 10,11,12,13 and we need the sum in A5, then enter the formula =SUM(A1,A2,A3,A4) in cell A5 . Now we get the result 46 in A5.

There are several ways to insert a function but the easiest method is to use the "Insert Function" dialog box.
Select the Formulas tab and select "Insert Function" dialog box. This dialog box can also be used to insert your functions whether you want to insert them at the beginning or in the middle of a formula.This dialog box is designed to try and help you find the correct function. Using the "Insert Function" dialog box will insert an equal sign (=) at the start of the formula automatically.

Type a brief description of what you want to do and press Go.
You can obtain more information a particular function by selecting it and pressing the "Help on this function" button at the bottom. Every time you select a function name in the list, a description of the function and any corresponding arguments will be displayed. If you do not know the name of the function then you can filter the list of available functions by selecting a specific category from the drop-down list. After you have chosen a function and pressed OK, the "Function Arguments" dialog box will automatically appear to indicate the arguments that are required by that function.

An alternative way to display the "Insert Function" dialog box is to press the Insert Function button on the formula bar. This button is a shortcut and will display the (Insert > Function) dialog box. I feel this method is the most comfortable. Because, it is easy to type by looking the cell names and result will show without taking any other boxes.

You can also just type a function name directly into a cell.You can type functions directly into a formula, assuming you know the correct syntax.When you enter functions, type the function name in lowercase letters. When you press Enter any valid function names are automatically converted to uppercase verifying that you have typed them correctly.Whenever you type the name of a function directly into a formula a yellow tool tip text appears indicating the arguments that are required by that function.

Please refer all the methods mentioned above.

Best wishes !! Thankyou !!


Related Solutions

For your main Discussion post, address the following questions/topics: Explain the differences between permanent and temporary...
For your main Discussion post, address the following questions/topics: Explain the differences between permanent and temporary accounts and identify which types of accounts must be closed at the end of a company’s fiscal year. Additionally, recall your Week 1 Discussion in which you brainstormed a business you would like to start. For your type of business, identify at least three permanent and at least three temporary accounts your business would have and explain why each account is classified as such....
Explain your thoughts and add any new findings to the main objective assigned to the accounting...
Explain your thoughts and add any new findings to the main objective assigned to the accounting information: Taking as a point of comparison the IFRS (based on an approach favoring fair values ​​and giving priority to the balance sheet), the accounting regulator echoes the increasingly strong demands which express to privilege what concerns the representation of the performances of the economic activity in long term, by rehabilitating the role of the profit and loss accounts and by counting in these...
For your main post, select two of the following types of organizations and describe what at...
For your main post, select two of the following types of organizations and describe what at least 2 standard costs they might use: Hospitals Law firms Accounting firms Auto repair shops Additionally, explain the types of direct and overhead variances each of your selected organizations might encounter. Provide an example of each.
Fundamentals of Statistics Answer the following 3 questions in your main post: In your experience, what...
Fundamentals of Statistics Answer the following 3 questions in your main post: In your experience, what types of research have you experienced? Would qualitative or quantitative variables be better to use in research? Explain. Distinguishing between applied and basic research—why should managers know something about research?
my question is in python. My question is how to add post users to post gres...
my question is in python. My question is how to add post users to post gres in python
How are the four main structural components of a computer and the four main structural components...
How are the four main structural components of a computer and the four main structural components of a central processing unit (CPU) similar or different?
Address all of the following as your Main Post, using at least 250 words: What is...
Address all of the following as your Main Post, using at least 250 words: What is a job order cost system? Describe how you think a job order cost system might be used for professional service businesses. Describe factory overhead costs and give one example of an overhead cost. Lastly, write about one definition or additional concept related to job order costing
3. Explain how you envision your studies in Leadership would bring a “value-add” component to the...
3. Explain how you envision your studies in Leadership would bring a “value-add” component to the business, organization, and/or marketplace that this occupation operates in.
For your main Discussion post, share your understanding of bonds as a form of financing a...
For your main Discussion post, share your understanding of bonds as a form of financing a corporation. Discuss how the price of a bond is determined and provide an example of each of the following: •              A bond issued at a premium, •              A bond issued at par, •              A bond issued at a discount. Additionally, provide the journal entry that would be made to record each of your bond examples as well as the first journal entry that would...
There are FOUR main components of GDP. Explain the components.
There are FOUR main components of GDP. Explain the components.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT