Studied by 1 person
Looks like no one added any tags here yet for you.
cell
the intersection of a column and a row (where a column and a cell meet)
column
a group of vertical cells, they are labelled with letters
formula
a mathematical operation like +,-,*,/
function
predefined formula that performs a specific task
range
a group of adjacent/connected cells
row
a group of horizontal cells. they are labelled with numbers
sheet
a page in a spread sheet
what can each cell hold
date in the form of numbers, symbols, letters, or formulas
active cell
the cell that you are currently on, with a blue outline
toolbar
used to format the appearance of cells, rows, or columns.
wrap text
breaking a long line of text into more than one line
make format easier
the most common formats are included on the tooldbar
how can spreadsheets be used
used to sort data quickly and easily, and makes the data easier to read and understand
sort column
to sort a column of data into order, go to the letter at the top of the column. click on the downwards pointing arrow and a menu will appear.
sort A-Z
select sort sheet A to Z
sort Z-A
select sort sheet Z to A
functions
formulas that are built into the spreadsheets ready for us to use
2 most common functions
sum and average
sum
adding up the range of cells
average
finding the average of a range of cells
how to get a chart
on the tool bar, insert, and select chart. you can then chose your chart type
