Year 7- Spreadsheets

Spreadsheet/worksheet

a table of data arranged in rows and columns.

Spreadsheet cell

single box in a spreadsheet, eg cell A1 is top left

Spreadsheet column

a list of cells going down the page, has a letter, eg column A is first

Spreadsheet row

a list of cells running across the page, has a number, eg row 1 is at the top

=SUM(A1:A10)

adds the values in a row or column e.g.

=SUM(A1:A10) will add up everything in cells A1, A2, A3 ... all the way to A10

=COUNT(B1:B16)

counts the non-empty cells in a row or column

e.g. =COUNT(B1:B16) will count all cells which have something in them from B1 all the way to B16

=MAX(range)

finds the largest value in a range

e.g. =MAX(C1:C100)

=MIN(range)

Finds the smallest value in a range.

e.g. =MIN(C1:C100)

AutoSum

A function that automatically identifies and adds ranges of cells in your worksheet.

Sort

To arrange data alphabetically, numerically, or chronologically.

Filter

A set of rules for determining which records will be displayed.

=COUNTIF(range, criteria)

Counts the number of cells within a range that meet the given criteria.

e.g. =COUNTIF(C1:C10, "A") The criteria is A so if the cell has an A in it this will add one to the counter.

=VLOOKUP

Looks for the value in the leftmost column of a table, and then returns a value in the same row from a column you specify.

=vlookup(B2, A1:C10, 2, TRUE)

This will look for whatever is in B2
In the range (table) of A1:C10
Returns the value in Column 2 of the range
Needs to be exat