In: Computer Science
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.
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 !!