spreadsheets

Learn to work with data in a spreadsheet and to create engaging charts, maps and graphs in the kdmcBerkeley Data Visualization Workshop.

With a spreadsheet you can insert a formula that will instantly add, subtract, multiply or divide numbers in columns or rows.

To do this you select a cell in a new column or row and then type in a formula.

A formula starts with an equals sign (=) that tells the spreadsheet you want to do a calculation.

A formula then has a symbol for what kind of calculation you want to perform (add, subtract, multiply, divide, etc.). The symbols a spreadsheet uses for calculations are:

• plus sign (+) for adding one number to another
• minus sign (-) for subtracting one number from another
• asterisk (*) for multiplying one number by another
• backslash (/) for dividing one number by another

Then you type in the letters/numbers for the cells (A1, A2, B1, B2, etc.) to which you want to apply the calculation, separated by the symbol for the type of calculation.