What is the correct way to enter a function in calc?
Answers
Explanation:
Entering the Data
The following example creates a basic formula. The steps used to create this formula are the same ones to follow when writing more complex formulas. The formula will add the numbers 3 + 2. The final formula will look like this:
= C1 + C2
Select the cell C1 and enter 3, then press Enter.
Enter a 3 in a cell in OpenOffice Calc.
Select the cell C2 and enter 2, then press Enter.
Entering a 2 in a cell in OpenOffice Calc.
Now select cell C3. This is where we'll enter the basic addition formula.
Selecting a cell to enter a formula in OpenOffice Calc.
When creating formulas in Open Office Calc, you always start by typing the equal sign. You type it in the cell where you want the answer to appear.
Entering the equal sign for a new formula in OpenOffice Calc.
Following the equal sign, we add in the cell references of the cells containing our data.
By using the cell references of our data in the formula, the formula will automatically update the answer if the data in cells C1 and C2 changes.
The best way of adding cell references is by using the mouse to select the correct cell. This method allows you to select with your mouse the cell containing your data to add its cell reference to the formula.
Selecting cell C1 in OpenOffice Calc.
For basic addition, enter the + after the C1.
Enter a plus sign in a cell in OpenOffice Calc.
Now we'll add the second cell to the formula. Select the cell C2 to add the second number.
Selecting the C2 cell in OpenOffice Calc.
Press Enter to complete the formula. You should see in the Formula bar above the worksheet the newly created formula, but in cell C3 will be the result of this formula.
The results of an addition formula in OpenOffice Calc.
Mathematical Operators in OpenOffice Calc Formulas
Creating formulas in OpenOffice Calc is not difficult. Just combine the cell references of your data with the correct mathematical operator.
B.E.D.M.A.S.
The Order of Operations is:
Brackets
Exponents
Division
Multiplication
Addition
Subtraction
How the Order of Operations Works
Any operation(s) contained in brackets will be carried out first followed by any exponents.
After that, Calc considers division or multiplication operations to be of equal importance, and carries out these operations in the order they occur left to right in the equation.
The same goes for the next two operations — addition and subtraction. They are considered equal in the order of operations. Whichever one appears first in an equation, either addition or subtraction, is the operation carried out first.
mark my answer as brainliest and don't forget to follow me
Answer:
u mean libre office calc
Explanation:
application-->office--> libre office calc-->file-->new