2. Make a chart of formulas and functions in Ms. Excel. Explain how we can use them in MS. Excel. Write on chart.
Answers
Answered by
2
Function/FormulaResult=SUM(A1:A5)Returns the sum of the values in the range A1:A5. This is an
example of a function serving as the whole formula.=SUM(A1:A5) /B5Returns the sum of the values in the range A1:A5 divided by the
value in cell B5. This is an example of mixing a function’s
result with other data.=SUM(A1:A5)+AVERAGE(B1:B5)Returns the sum of the range A1:A5 added with the average of
the range B1:B5. This is an example of a formula that combines the
result of two functions.
Ready to write a formula with a function in it? Follow these steps to create a function that calculates an average:
Enter some numbers in a column’s cells.
Click an empty cell where you want to see the result.
Enter =AVERAGE( to start the function.
Excel presents a list of functions that begin with the same spelling as the function name you type. The more letters you type, the shorter the list becomes. The advantage is, for example, typing the letter A, using the down arrow to select the AVERAGE function, and then pressing the Tab key.
Click the first cell with an entered value and, while holding the mouse button, drag the mouse pointer over the other cells that have values.
An alternative is to type the range of those cells.
Type a ).
Press Enter.
In the following figure, cell B10 has the calculated result, but look up at the Formula Bar and you can see the actual function as it was entered.
example of a function serving as the whole formula.=SUM(A1:A5) /B5Returns the sum of the values in the range A1:A5 divided by the
value in cell B5. This is an example of mixing a function’s
result with other data.=SUM(A1:A5)+AVERAGE(B1:B5)Returns the sum of the range A1:A5 added with the average of
the range B1:B5. This is an example of a formula that combines the
result of two functions.
Ready to write a formula with a function in it? Follow these steps to create a function that calculates an average:
Enter some numbers in a column’s cells.
Click an empty cell where you want to see the result.
Enter =AVERAGE( to start the function.
Excel presents a list of functions that begin with the same spelling as the function name you type. The more letters you type, the shorter the list becomes. The advantage is, for example, typing the letter A, using the down arrow to select the AVERAGE function, and then pressing the Tab key.
Click the first cell with an entered value and, while holding the mouse button, drag the mouse pointer over the other cells that have values.
An alternative is to type the range of those cells.
Type a ).
Press Enter.
In the following figure, cell B10 has the calculated result, but look up at the Formula Bar and you can see the actual function as it was entered.
Similar questions