Show:
cells and charts
definitions
Functions
more definitons
everything
100

every cell reference is made up of 2 parts a________ followed by a _________

What is a letter and then number

100
software most popularly used for spreadsheets
What is excel
100

What ever calculation begins with

What is equal symbol

100
the box that is created when a row and coloumn meet
What is cell
100

This can be used to let the spreadsheet know the type of data you will be entered into a cell

What is cell format

200

to copy the contents of one cell into other cells

What is autofill

200
company that created excel
What is microsoft
200

The function used to add all the data in the cells and then divide that number by the total number of cells

What is AVERAGE

200

What is the symbol for multiple on a Spreadsheet

What is *

200

funtion to find the largest amount

What is =max

300
type of graph that displays numeric data as a set of points along a line , used to show overtime
What is line graph
300

the boxes on a spreadsheet that the data is entered into

What is a cell reference?

300

The function on a Spreadsheet to add values in cells

What is SUM function

300

What is the symbol for divide on a spreadsheet

What is /

300

funtion to find the smallest amount

What is =min

400
graph that displays numeric data as columns
What is bar graph
400

To change many cells into one and place the title in the middle of the cell

What is centre and merge

400

The function that will only count the number of cells between A1 and A10

What is COUNT

400

Data in Spreadsheet can be displayed in this easy to read, coloured format

What is a graph/chart

400
a bar that has every formula on it
What is formula bar
500
displays numeric data as a section of a pie . used to show parts of a whole
What is pie chart
500

The symbol that separates cell references in a formula

What is a colon :

500

The function that counts how many cells meet a criteria

What is COUNTIF

500

The function that allows the cell show one of two values depending if the data in that cell meets the criteria.

IF Function

500

cells from A1 to A10 are known as a cell _______

What is a cell range