computing revision-spreadsheets

what is the symbol we must use at the beginning of a cell

=

what is the function that tells you the maximum value

MAX

what is the function that tells you the minimum value

MIN

what is the function that tells you the non-blank cells

COUNTA

what is the function used to add values together in a spreadsheet

SUM function

What is a function?

a formula that performs a calculation

What does the AVERAGE function do?

finds the average value

what is data

raw facts and figures

what is the difference between data and information?

Data is raw facts and figures, while information is created when the data has been processed and becomes meaningful

what are cells?

spaces that hold data

what does the cell reference do?

tells you the location of the cell

what is each cell made up of

the column name and the row number

what does the MIN function do?

finds the smallest value

what does a chart do?

represents data visually

provide the cell reference for the range: the first ten cells of column B

B1:B10

provide the cell reference ranges: in rows 15-20 in column A

A15:A20

provide the cell reference ranges: in rows 15-20 in column A,B and C

A15:C20

provide the cell ranges: all of the cells from column A from row 2 to the end

A2:A

what does the COUNTIF function do

counts how many cells meet your criteria

provide the function if i wanted cells from B2:B15 that are less than 10

=COUNTIF(B2:B15, “<10”)

provide the function if i wanted cells from B2:B15 that are blue

=COUNTIF(B2:B15, “Blue”)

what does the IF function do?

have cells show different things depending on the criteria

provide the function if the cell C2 is more than 10- if so say Hooray!, if not say Too low.

=IF(C2>10, “Hooray!”, “Too low”)

What is a spreadsheet?

a tool that is used to store, manipulate and analyse data

what do the letters in a spreadsheet reference to?

the columns

what do the numbers in a spreadsheet reference to?

the rows

What does the cell reference tell you?

The location of the cell

which way do rows go?

across

Which way do columns go?

downwards

what does filtering data do?

lets you see the data you would like to, whilst hiding the others

what does the COUNT function do?

only counts cells containing numbers

what needs to be wrapped around text?

““

what defines a range

:

cell reference

the location of a cell

what do absolute cell references do?

locks a cell when dragging a formula

what is the symbol used to lock a row

$

How is locking a row or column useful

because it keeps part of a cell reference constant when copying a formula

what does $A1 mean

that the column stays the same

what does A$1 mean

that the row stays the same

what does $A$1 mean

that the whole cell reference is kept the same

what is the difference between relative and absolute cell references

relative reference changes automatically,whilst absolute is fixed throughout

what is used to find the exact match when referencing to VLOOKUP

False

what is used to find the approximate match when referencing to VLOOKUP

true

what does the function of VLOOKUP do?

searches for a specific value in the left column of a table and returns corresponding data from another column in the same row

what does the V stand for in VLOOKUP?

Vertical

what does VERTICAL mean in VLOOKUP?

the function always searches down the first column of your table

what are the pieces of information needed in a VLOOK UP called?

arguments

conditional formatting

a tool that automatically changes how a cell looks based on its content.

filtering

A tool that hides any rows that don't match your criteria

what does COUNT do

only counts cells with numbers

function

a formula that performs a calculation

database

an organised collection of data and the software tool used to manage it

what are the arguments inputted in VLOOKUP to find your specified data (type in the VLOOKUP function)

VLOOKUP(search key, Range, answer column, Exact Match?)

what is the first argument in VLOOKUP?

search Key

why do we use vertical in VLOOKUP

Because it searches by going down a column — vertically — one row at a time until it finds your value

what is the ‘search key’ in VLOOKUP

the thing that you want to find

what is the second argument in VLOOKUP

range

what does the ‘range’ do in ‘VLOOKUP’

defines the specific group of cells

what is the 3rd argument in VLOOKUP?

answer column

what does the answer colum do in VLOOKUP

Once the match is found, it tells it how many columns to move until the info is found

what is the 4th argument in ‘VLOOKUP’?

Exact match?

what does ‘Exact Match?’ do in VLOOKUP?

determines whether you want an approximate(true) or exact (false)