Chapter Four Flashcards
What is a spreadsheet
its one or more worksheets. Its presented in a grid in the form of rows and columns. this allows applications to perform calculations and recalculations quickly
what are cells
cells store data in a variety of forms and can be formatted. for example numbers, dates or currency
what is a formula
a mathematical expression that’s used to define a particular cell is linked to other cells in a worksheet
what does =A1+B1mean
adding the content
What does =D1-C1 mean
subtracting the content
what does =A2*B2 mean
multiplying the content
what does =A3/A4 mean
dividing content
how do you find the auto sum of cells
=SUM(A1:A10)
How do you find the avg or cells
=AVERAGE(A1:A10)
How do you find the highest value of a range of cells
=MAX(A1:A10)
How do you find the lowest value of a range of cells
=MIN(A1:A10)
What’s conditioning format
its used to change the appearance or format of cells. this would be used if a teacher used a spreadsheet to record test results and they wanted every score over 60 to go green and every score below go red
what is a template
it refers to a document that has been performed using a predetermined layout for the user
what is importing data
data that can be imported into a spreadsheet from other software sources such as a database
what are headers and footers
this improves the presentation of worksheets. headers are placed at the top. footers are placed at the bottom. you can add titles, names and page numbers to these.
what is the if statement equation
=IF(CONDITION,TRUE,FALSE)
What does the VLOOKUP function do
it uses the value in a selected cell to look up a match in a column of a look table. it returns the value from a specified column from the same row of the look up table
what’s a relative cell reference
it adjusts and changes the formula and makes sure it refers to the to the correct cell
what’s an absolute cell reference
when you want a cell reference in a formula to always stay the same so when you copy or drag the formula the cell reference doesn’t change.
how is using charts helpful
can assist in the communication of info when an organisations doing a presentation for clients. there are three different types of charts: bar, line and pie.
what is a macro
a small program written to preform a repetitive task automatically.
It can eliminate the need for the user to repeat steps of common preformed tasks.
what is data modelling
this uses mathematical formulas on data to help predict outcomes for given situations
