Question

how do formulate work in a spread sheet?​

Answer 1

Answer:

hey..

Explanation:

Select cell 2

Type = ( equal to )

Select A2 in the worksheet using mouse or key board

This places the cell reference A2 in the formula of the cell

Type ( shift +8)

Select cell B2 in the worksheet..

and press enter...

HOPE HELPES U...

BRAINLIEST PLSSSS

Answer 2

Explanation:

This tutorial uses Google spreadsheets to analyse data. Other spreadsheet programs work in a similar way - play around and see how they differ.

There is sample data for this tutorial here:

A quick introduction to common spreadsheet symbols

Now that you have a sense of how spreadsheet formula work, here’s a quick introduction to some of the most common formula symbols that you are likely to come across.

The symbols

These are all ‘basic maths functions’ - the kind of things you would find on a simple calculator.

=: Tells your spreadsheet that you are writing a formula. This is the first thing that should go in your formula cell. (NOTE: A spreadsheet assumes that everything that begins with an ‘=’ is a formula… so be careful how you use it!)

+: Add

-: Subtract

*: Multiply (this would be ‘x’ on a calculator)

/: Divide (this would be ‘÷’ on a calculator)

Tip: Get your symbols in the right order

It is worth remembering that basic maths rules about the order of functions apply. For example, the formula =3+5*2 will give you 13, NOT 16. If you’re not sure why or can’t quite remember the rules, check out this basic introduction. If you want to change the order of function you’ll need parentheses: Formulas inside parentheses will be evaluated before any other formula. If you want the formula above to result in 16 you’ll need to type: =(3+5)*2

Have a go at using these formula in the ‘play sheet’ of your spreadsheet until you feel comfortable with them. You should find that they work pretty much as you would expect them to.

What if you wanted to add more numbers? You could always add them manually using + or you could use SUM a formula to sum up all the values in the given range. Let’s try to calculate how many apples, plums and total fruit we sold during the week: Go to cell B7 and type =SUM(A2:A6) this will add the numbers of apples.

Walkthrough: Using spreadsheets to add up values.

Let’s calculate the total of fruits sold.

Get the example data and create a copy.

To start, move to the first row.

Each formula in a spreadsheet starts with =

Enter = and select the first cell you want to add. Notice how the cell reference appears in the formula? image

now type + and select the second cell you want to add image

Press Enter or tab .

The formula disappears and is replaced by the value.