Learn to REFERENCE your data from other parts of the spreadsheet.

–When entering your selection you may use the keyboard or the mouse.

–Select cells together by specifying a starting-celland a stopping-cell.

This will select ALL the cells within this specified BLOCK of cells.

–When cells are not together use the comma to separate the cells or by holding down the control-key and selecting cells or blocks of cells (the comma will be inserted automatically to separate these chunks of data.)

E.g., the ‘SUM’ function

The Sum function takes all of the values in each of the specified cells and totals their

values. The syntax is: =SUM(first value, second value, etc.)

–In the first and second spots you can enter constants, cells, range of cells.

–Blank cells will return a value of zero to be added to the total.

–Text cells can not be added to a number and will produce an error.

Sum Example

= sum (B2:B8)

Note: text values will cause errors,.. And empty values are counted as ‘0’

Other Functions

· Average (ignores text& blanks)

· Max

Returns the largest value in a range

• Min

Returns the smallest value in a range

• Count

Returns the number number-data cells

• CountA

Returns the number of non-empty cells

• The ‘IF’function

check the logical condition of a statement and return one value if true and a different value if false. The syntax is

– =IF (condition; value-if-true; value-if-false)

– value returned may be either a number or text

– if value returned is text, it must be in quotes

=IF(B2>755;"yes";"no")

Note: Other logical functions can also be used (NOT, OR, AND, TRUE, FALSE)

Making a Graph

Insert > chart   • Using the Wizard use select the chart type, data-range, and labels • You can always CHANGE these values afterwards by double-clicking on your graphic.

Copy-Paste into Word/Powerpoint

You can always copy paste from Excel into Word or powerpoint files.

Excel cursors

There are four different types of cursors in Excel. Understanding these cursors will make using Excel a lot easier. The cursor is the way your mouse looks on the screen.

SELECT

You can click to select one cell or click and drag to highlight many cells.

DRAG CELL

You will see this cursor when you put the mouse on the black line of a selected cell.

You can click and drag the whole cell to a different place on the sheet.

AUTO FILL

You will see this cursor when you put the mouse on the bottom-right corner of a selected cell.

You can click and drag to complete a list.

CHANGE SIZE (columns and rows)

You will see this cursor when you put the mouse between the column labels.

You can click and drag to make the columns and rows bigger or smaller.

Date: 2015-12-17; view: 846